contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA929924" and tax_phylum = "Rotifera"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909082 | 909082 | PRJNA929924_P_NODE_9901_length_248_cov_1.306533_g9738_i0 | PRJNA929924 | 9901 | 248 | 1.306533 | 3.24020184 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 237 | 5.77e-58 | NTclustered | gi|421999039|emb|HE662874.1| | 249248 | g9738 | i0 | 92.216 | 1 | 167 | 13 | 100 | 0 | 1 | 167 | 5371 | 5205 | Adineta ricciae alien gene expression region, clone Ar_7 | blastn | 248 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 1254336 | 1254336 | PRJNA929924_P_NODE_6941_length_408_cov_11.757660_g6778_i0 | PRJNA929924 | 6941 | 408 | 11.75766 | 47.9712528 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 749 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g6778 | i0 | 99.755 | 50.5220588235294 | 408 | 1 | 100 | 0 | 1 | 408 | 1921 | 1514 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 20613 | 749 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2184173 | 2184173 | PRJNA929924_P_NODE_10122_length_242_cov_1.077720_g9959_i0 | PRJNA929924 | 10122 | 242 | 1.07772 | 2.6080824 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 311 | 3.26e-80 | NTclustered | gi|189313895|gb|EU637017.1| | 104782 | g9959 | i0 | 90.295 | 19.7066115702479 | 237 | 23 | 98 | 0 | 6 | 242 | 34854 | 34618 | Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds | blastn | 4769 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 8907189 | 8907189 | PRJNA929924_P_NODE_7247_length_384_cov_2.400000_g7084_i0 | PRJNA929924 | 7247 | 384 | 2.4 | 9.216 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 497 | 3.92e-136 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g7084 | i0 | 90.263 | 89.5260416666667 | 380 | 37 | 99 | 0 | 5 | 384 | 631 | 1010 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 34378 | 497 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 9836929 | 9836929 | PRJNA929924_P_NODE_3088_length_1087_cov_35.907514_g2999_i0 | PRJNA929924 | 3088 | 1087 | 35.907514 | 390.31467718 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 1836 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g2999 | i0 | 97.151 | 86.4645814167433 | 1088 | 29 | 100 | 2 | 1 | 1087 | 7731 | 6645 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 93987 | 1836 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 9837081 | 9837081 | PRJNA929924_S_NODE_5148_length_186_cov_1.570470_g5104_i0 | PRJNA929924 | 5148 | 186 | 1.57047 | 2.9210742 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 124 | 3.32e-24 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g5104 | i0 | 79.365 | 1.01612903225806 | 189 | 29 | 99 | 9 | 2 | 186 | 1973 | 1791 | Philodina citrina complete mitochondrial genome | blastn | 189 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 9837087 | 9837087 | PRJNA929924_S_NODE_7148_length_159_cov_1.508197_g7104_i0 | PRJNA929924 | 7148 | 159 | 1.508197 | 2.39803323 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 259 | 7.23e-65 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g7104 | i0 | 98.63 | 2.58490566037736 | 146 | 2 | 92 | 0 | 14 | 159 | 10398 | 10253 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 411 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 11112478 | 11112478 | PRJNA929924_P_NODE_11129_length_219_cov_2.288235_g10966_i0 | PRJNA929924 | 11129 | 219 | 2.288235 | 5.01123465 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 335 | 1.7199999999999992e-87 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g10966 | i0 | 94.144 | 22.4109589041096 | 222 | 10 | 100 | 2 | 1 | 219 | 26970 | 26749 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 4908 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 12388045 | 12388045 | PRJNA929924_P_NODE_15710_length_167_cov_1.762712_g15547_i0 | PRJNA929924 | 15710 | 167 | 1.762712 | 2.94372904 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 298 | 1.63e-76 | NTclustered | gi|62362195|gb|AY942837.1| | 249248 | g15547 | i0 | 98.802 | 1 | 167 | 2 | 100 | 0 | 1 | 167 | 107 | 273 | Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds | blastn | 167 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 12388210 | 12388210 | PRJNA929924_P_NODE_9210_length_270_cov_11.343891_g9047_i0 | PRJNA929924 | 9210 | 270 | 11.343891 | 30.6285057 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 455 | 1.6100000000000002e-123 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g9047 | i0 | 99.598 | 3.18148148148148 | 249 | 1 | 92 | 0 | 22 | 270 | 10398 | 10150 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 859 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14936947 | 14936947 | PRJNA929924_P_NODE_5232_length_622_cov_1.617801_g5077_i0 | PRJNA929924 | 5232 | 622 | 1.617801 | 10.06272222 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 869 | 0 | NTclustered | gi|37675448|gb|AY394701.1| | 249248 | g5077 | i0 | 91.961 | 67.9823151125402 | 622 | 47 | 100 | 1 | 1 | 622 | 306 | 924 | Adineta ricciae 82kD heat-shock protein gene (hsp82), partial sequence | blastn | 42285 | 869 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 16211986 | 16211986 | PRJNA929924_P_NODE_7013_length_403_cov_3.257062_g6850_i0 | PRJNA929924 | 7013 | 403 | 3.257062 | 13.12595986 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 350 | 1.22e-91 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g6850 | i0 | 95.434 | 64.1116625310174 | 219 | 10 | 100 | 0 | 185 | 403 | 28388 | 28606 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 25837 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 16212015 | 16212015 | PRJNA929924_P_NODE_9433_length_262_cov_5.845070_g9270_i0 | PRJNA929924 | 9433 | 262 | 5.84507 | 15.3140834 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g9270 | i0 | 100 | 74.9312977099237 | 262 | 0 | 100 | 0 | 1 | 262 | 4432 | 4171 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 19632 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 17487276 | 17487276 | PRJNA929924_P_NODE_5374_length_597_cov_3.908759_g5218_i0 | PRJNA929924 | 5374 | 597 | 3.908759 | 23.33529123 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 654 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g5218 | i0 | 86.789 | 32.3484087102178 | 598 | 66 | 99 | 12 | 1 | 592 | 2390 | 1800 | Philodina citrina complete mitochondrial genome | blastn | 19312 | 654 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 18760493 | 18760493 | PRJNA929924_P_NODE_13895_length_180_cov_1.587786_g13732_i0 | PRJNA929924 | 13895 | 180 | 1.587786 | 2.8580148 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 261 | 2.33e-65 | NTclustered | gi|197321819|gb|EU853695.1| | 96448 | g13732 | i0 | 96.226 | 64.6666666666667 | 159 | 6 | 88 | 0 | 1 | 159 | 159 | 1 | Philodina roseola histone H2A variant H2Av1 copy 1a (H2Av1) gene, partial cds | blastn | 11640 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 18760637 | 18760637 | PRJNA929924_P_NODE_7875_length_340_cov_2.109966_g7712_i0 | PRJNA929924 | 7875 | 340 | 2.109966 | 7.1738844 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 399 | 9.959999999999998e-107 | NTclustered | gi|187936070|gb|EU652317.1| | 96448 | g7712 | i0 | 94.253 | 84.8911764705882 | 261 | 15 | 77 | 0 | 2 | 262 | 20434 | 20694 | Philodina roseola GTP binding protein, beta prime coatomer protein complex subunit, GPCR, beta-transducin repeat containing protein, speckle-type POZ protein, adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane protein, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, and filament protein genes, complete cds | blastn | 28863 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 20035488 | 20035488 | PRJNA929924_P_NODE_13696_length_182_cov_1.421053_g13533_i0 | PRJNA929924 | 13696 | 182 | 1.421053 | 2.58631646 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 300 | 5.01e-77 | NTclustered | gi|403492564|gb|JX193021.1| | 249248 | g13533 | i0 | 96.667 | 78.6318681318681 | 180 | 6 | 99 | 0 | 3 | 182 | 1014 | 835 | Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds | blastn | 14311 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 21310988 | 21310988 | PRJNA929924_P_NODE_14717_length_171_cov_1.311475_g14554_i0 | PRJNA929924 | 14717 | 171 | 1.311475 | 2.24262225 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 150 | 4.939999999999999e-32 | NTclustered | gi|189313895|gb|EU637017.1| | 104782 | g14554 | i0 | 86.232 | 1.5906432748538 | 138 | 19 | 81 | 0 | 1 | 138 | 27045 | 27182 | Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds | blastn | 272 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 23861165 | 23861165 | PRJNA929924_P_NODE_10359_length_236_cov_1.598930_g10196_i0 | PRJNA929924 | 10359 | 236 | 1.59893 | 3.7734748 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 329 | 8.73e-86 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g10196 | i0 | 91.949 | 17.4025423728814 | 236 | 17 | 100 | 2 | 1 | 236 | 26273 | 26040 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 4107 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;