contig_metadata
17 rows where bioproject = "PRJNA352850", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 394948 | 394948 | PRJNA352850_P_NODE_17741_length_708_cov_15.927162_g15035_i0 | PRJNA352850 | 17741 | 708 | 15.927162 | 112.76430696 | Pristina longiseta | 188231 | Annelida | Annelida | 902 | 0 | NTclustered | gi|2169792353|gb|OM001222.1| | 188231 | g15035 | i0 | 97.533 | 77.5056497175141 | 527 | 13 | 74 | 0 | 62 | 588 | 1 | 527 | Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 54874 | 902 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 6773390 | 6773390 | PRJNA352850_P_NODE_45426_length_365_cov_1.882911_g42593_i0 | PRJNA352850 | 45426 | 365 | 1.882911 | 6.87262515 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 7.45e-4 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g42593 | i0 | 92.683 | 0.112328767123288 | 41 | 1 | 11 | 2 | 4 | 42 | 20601298 | 20601258 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 41 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9323040 | 9323040 | PRJNA352850_P_NODE_21308_length_621_cov_6.909091_g18526_i0 | PRJNA352850 | 21308 | 621 | 6.909091 | 42.90545511 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 353 | 1.51e-92 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g18526 | i0 | 80.952 | 29.7423510466989 | 462 | 74 | 73 | 10 | 115 | 565 | 472 | 14 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18470 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 9324713 | 9324713 | PRJNA352850_P_NODE_74288_length_260_cov_1.232227_g71455_i0 | PRJNA352850 | 74288 | 260 | 1.232227 | 3.2037902 | Stylaria sp. CD-2019 | 2691009 | Annelida | Annelida | 453 | 5.5600000000000005e-123 | NTclustered | gi|1789777849|gb|MK965654.1| | 2691009 | g71455 | i0 | 98.077 | 97.6846153846154 | 260 | 5 | 100 | 0 | 1 | 260 | 417 | 676 | Stylaria sp. CD-2019 actin mRNA, partial cds | blastn | 25398 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. CD-2019 | |
| 14423740 | 14423740 | PRJNA352850_P_NODE_19712_length_656_cov_4.542010_g16956_i0 | PRJNA352850 | 19712 | 656 | 4.54201 | 29.7955856 | Slavina appendiculata | 188233 | Annelida | Annelida | 222 | 4.7e-53 | NTclustered | gi|2741723584|gb|PP893275.1| | 188233 | g16956 | i0 | 75.047 | 2.47103658536585 | 537 | 105 | 80 | 27 | 6 | 529 | 14516 | 13996 | Slavina appendiculata mitochondrion, partial genome | blastn | 1621 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 14424746 | 14424746 | PRJNA352850_P_NODE_52852_length_328_cov_2.086022_g50019_i0 | PRJNA352850 | 52852 | 328 | 2.086022 | 6.84215216 | Amynthas omeimontis | 1388897 | Annelida | Annelida | 207 | 6.22e-49 | NTclustered | gi|575426931|gb|KF205573.1| | 1388897 | g50019 | i0 | 81.673 | 58.8292682926829 | 251 | 44 | 76 | 2 | 8 | 257 | 638 | 389 | Amynthas omeimontis isolate CO18K cytochrome oxidase subunit II (CO2) gene, complete cds; mitochondrial | blastn | 19296 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Megascolecidae | Amynthas | Amynthas omeimontis | |
| 15698846 | 15698846 | PRJNA352850_P_NODE_58993_length_304_cov_1.019608_g56160_i0 | PRJNA352850 | 58993 | 304 | 1.019608 | 3.09960832 | Clitellata | 42113 | Annelida | Annelida | 139 | 2.23e-38 | NR | QUJ10057.1 | 6386 | g56160 | i0 | 75.9 | 5.97039473684211 | 87 | 21 | 85.9 | 0 | 263 | 3 | 145 | 231 | QUJ10057.1 cytochrome c oxidase subunit III [Tubifex tubifex] | diamond | 1815 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Tubifex | Tubifex tubifex | |
| 15698977 | 15698977 | PRJNA352850_P_NODE_63253_length_288_cov_13.531381_g60420_i0 | PRJNA352850 | 63253 | 288 | 13.531381 | 38.97037728 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 342 | 1.4099999999999996e-89 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g60420 | i0 | 88.356 | 53.0034722222222 | 292 | 24 | 100 | 9 | 1 | 288 | 3255 | 3540 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 15265 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 18246365 | 18246365 | PRJNA352850_P_NODE_12615_length_912_cov_3.320973_g10132_i0 | PRJNA352850 | 12615 | 912 | 3.320973 | 30.28727376 | Stylaria sp. THS-2006 | 397589 | Annelida | Annelida | 521 | 5.839999999999998e-143 | NTclustered | gi|112144557|gb|DQ813403.1| | 397589 | g10132 | i0 | 97.386 | 44.6436403508772 | 306 | 8 | 34 | 0 | 1 | 306 | 747 | 1052 | Stylaria sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 40715 | 521 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. THS-2006 | |
| 19522384 | 19522384 | PRJNA352850_P_NODE_71236_length_266_cov_1.230415_g68403_i0 | PRJNA352850 | 71236 | 266 | 1.230415 | 3.2729039 | Clitellata | 42113 | Annelida | Annelida | 111 | 2.84e-28 | NR | XBQ63458.1 | 188233 | g68403 | i0 | 69.7 | 5.0187969924812 | 89 | 26 | 99.2 | 1 | 265 | 2 | 5 | 93 | XBQ63458.1 cytochrome c oxidase subunit 2 [Slavina appendiculata] | diamond | 1335 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Slavina | Slavina appendiculata | |
| 22071368 | 22071368 | PRJNA352850_P_NODE_16898_length_734_cov_3.074453_g14226_i0 | PRJNA352850 | 16898 | 734 | 3.074453 | 22.56648502 | Metazoa | 33208 | Annelida | Annelida | 318 | 6.419999999999997e-106 | NR | KAK2169243.1 | 27915 | g14226 | i0 | 77.6 | 4.63896457765668 | 201 | 45 | 82.2 | 0 | 3 | 605 | 78 | 278 | KAK2169243.1 hypothetical protein NP493_1199g02001 [Ridgeia piscesae] | diamond | 3405 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 23347594 | 23347594 | PRJNA352850_P_NODE_42719_length_381_cov_2.819277_g39886_i0 | PRJNA352850 | 42719 | 381 | 2.819277 | 10.74144537 | Metazoa | 33208 | Annelida | Annelida | 213 | 1.01e-67 | NR | ADY18390.1 | 104710 | g39886 | i0 | 81.1 | 7.96850393700787 | 127 | 24 | 100 | 0 | 381 | 1 | 43 | 169 | ADY18390.1 ribosomal protein rpl6, partial [Glycera tridactyla] | diamond | 3036 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Glyceridae | Glycera | Glycera tridactyla | |
| 30422764 | 30422764 | PRJNA352850_P_NODE_83853_length_243_cov_1.051546_g81020_i0 | PRJNA352850 | 83853 | 243 | 1.051546 | 2.55525678 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 61.2 | 1.02e-8 | NR | KAI0213502.1 | 104711 | g81020 | i0 | 42.4 | 0.814814814814815 | 66 | 36 | 79 | 1 | 216 | 25 | 79 | 144 | KAI0213502.1 hypothetical protein LSAT2_001469 [Lamellibrachia satsuma] | diamond | 198 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31370648 | 31370648 | PRJNA352850_P_NODE_41256_length_391_cov_2.207602_g38424_i0 | PRJNA352850 | 41256 | 391 | 2.207602 | 8.63172382 | Glossoscolex paulistus | 1046353 | Annelida | Annelida | 72.8 | 3.06e-13 | NR | 4U8U_C | 1046353 | g38424 | i0 | 71.1 | 0.705882352941177 | 45 | 13 | 34.5 | 0 | 4 | 138 | 105 | 149 | 4U8U_C Chain C, Globin c Chain [Glossoscolex paulistus] | diamond | 276 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Glossoscolecidae | Glossoscolex | Glossoscolex paulistus | |
| 31971362 | 31971362 | PRJNA352850_P_NODE_61218_length_295_cov_3.865854_g58385_i0 | PRJNA352850 | 61218 | 295 | 3.865854 | 11.4042693 | Dendrobaena mrazeki | 2839887 | Annelida | Annelida | 74.3 | 2.65e-13 | NR | UWX39416.1 | 2839887 | g58385 | i0 | 51.1 | 2.5728813559322 | 90 | 42 | 89.5 | 1 | 295 | 32 | 206 | 295 | UWX39416.1 NADH-ubiquinone oxidoreductase chain 1, partial [Dendrobaena mrazeki] | diamond | 759 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Dendrobaena | Dendrobaena mrazeki | |
| 32083469 | 32083469 | PRJNA352850_P_NODE_50798_length_337_cov_2.708333_g47965_i0 | PRJNA352850 | 50798 | 337 | 2.708333 | 9.12708221 | Siboglinidae | 41324 | Annelida | Annelida | 140 | 1.38e-39 | NR | AAG16892.1 | 6426 | g47965 | i0 | 82.5 | 2.13649851632047 | 80 | 14 | 71.2 | 0 | 3 | 242 | 113 | 192 | AAG16892.1 myosin regulatory light chain [Riftia pachyptila] | diamond | 720 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Riftia | Riftia pachyptila | |
| 32792693 | 32792693 | PRJNA352850_P_NODE_14400_length_826_cov_3.576577_g11814_i0 | PRJNA352850 | 14400 | 826 | 3.576577 | 29.54252602 | Helobdella robusta | 6412 | Annelida | Annelida | 73.9 | 2.31e-11 | NR | XP_009023098.1 | 6412 | g11814 | i0 | 64.9 | 0.207021791767554 | 57 | 20 | 20.7 | 0 | 822 | 652 | 180 | 236 | XP_009023098.1 hypothetical protein HELRODRAFT_155963 [Helobdella robusta] | diamond | 171 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;