contig_metadata
19 rows where bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1428300 | 1428300 | PRJNA1005695_P_NODE_31702_length_265_cov_1.500000_g30850_i0 | PRJNA1005695 | 31702 | 265 | 1.5 | 3.975 | Pristina leidyi | 150440 | Annelida | Annelida | 468 | 2.03e-127 | NTclustered | gi|33330137|gb|AF534853.1| | 150440 | g30850 | i0 | 98.491 | 92.5924528301887 | 265 | 4 | 100 | 0 | 1 | 265 | 808 | 544 | Pristina leidyi isolate PRIlecbc cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial gene for mitochondrial product | blastn | 24537 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina leidyi | |
| 3551608 | 3551608 | PRJNA1005695_P_NODE_12803_length_429_cov_3.988764_g11951_i0 | PRJNA1005695 | 12803 | 429 | 3.988764 | 17.11179756 | Metazoa | 33208 | Annelida | Annelida | 70.1 | 4.37e-11 | NR | KAK2147523.1 | 53620 | g11951 | i0 | 76.9 | 2.93006993006993 | 39 | 9 | 27.3 | 0 | 119 | 3 | 14 | 52 | KAK2147523.1 hypothetical protein LSH36_548g00001 [Paralvinella palmiformis] | diamond | 1257 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 3980117 | 3980117 | PRJNA1005695_P_NODE_9364_length_510_cov_1.151030_g8515_i0 | PRJNA1005695 | 9364 | 510 | 1.15103 | 5.870253 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.014 | NTclustered | gi|675879857|ref|XM_009027202.1| | 6412 | g8515 | i0 | 96.97 | 0.0647058823529412 | 33 | 0 | 6 | 1 | 391 | 422 | 2089 | 2057 | Helobdella robusta hypothetical protein partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 6531802 | 6531802 | PRJNA1005695_P_NODE_39826_length_242_cov_1.846154_g38974_i0 | PRJNA1005695 | 39826 | 242 | 1.846154 | 4.46769268 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g38974 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 28 | 55 | 5858307 | 5858280 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7806216 | 7806216 | PRJNA1005695_P_NODE_4427_length_761_cov_1.690407_g3696_i0 | PRJNA1005695 | 4427 | 761 | 1.690407 | 12.86399727 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 1.27e-4 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g3696 | i0 | 89.583 | 0.0630749014454665 | 48 | 5 | 6 | 0 | 88 | 135 | 6881328 | 6881281 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 48 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9929092 | 9929092 | PRJNA1005695_P_NODE_25848_length_295_cov_1.351351_g24996_i0 | PRJNA1005695 | 25848 | 295 | 1.351351 | 3.98648545 | Pristina | 150439 | Annelida | Annelida | 545 | 1.03e-150 | NTclustered | gi|285029398|gb|GQ355416.1| | 150440 | g24996 | i0 | 100 | 44.9559322033898 | 295 | 0 | 100 | 0 | 1 | 295 | 380 | 86 | Pristina leidyi 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 13262 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina leidyi | |
| 12907329 | 12907329 | PRJNA1005695_P_NODE_37591_length_247_cov_0.896552_g36739_i0 | PRJNA1005695 | 37591 | 247 | 0.896552 | 2.21448344 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g36739 | i0 | 96.875 | 0.129554655870445 | 32 | 0 | 13 | 1 | 206 | 237 | 16912113 | 16912083 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15456084 | 15456084 | PRJNA1005695_P_NODE_18413_length_352_cov_2.236559_g17561_i0 | PRJNA1005695 | 18413 | 352 | 2.236559 | 7.87268768 | Dendrobaena pentheri | 1302597 | Annelida | Annelida | 63.9 | 1.54e-5 | NTclustered | gi|674656596|gb|KJ912407.1| | 1302597 | g17561 | i0 | 72.414 | 1.42045454545455 | 261 | 51 | 71 | 19 | 99 | 347 | 660 | 409 | Dendrobaena pentheri isolate MPL406 12S ribosomal RNA gene, partial sequence; tRNA-Val gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 500 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Dendrobaena | Dendrobaena pentheri | |
| 16303594 | 16303594 | PRJNA1005695_P_NODE_21613_length_323_cov_38.012000_g20761_i0 | PRJNA1005695 | 21613 | 323 | 38.012 | 122.77876 | Haemadipsidae | 27387 | Annelida | Annelida | 222 | 2.18e-53 | NTclustered | gi|316927165|gb|HQ203119.1| | 933824 | g20761 | i0 | 80.061 | 101.195046439628 | 326 | 44 | 100 | 12 | 1 | 323 | 1353 | 1046 | Domanibdella palmyrae isolate APY 28S ribosomal RNA gene, partial sequence | blastn | 32686 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Haemadipsidae | Domanibdella | Domanibdella palmyrae | |
| 18005164 | 18005164 | PRJNA1005695_P_NODE_17255_length_364_cov_1.608247_g16403_i0 | PRJNA1005695 | 17255 | 364 | 1.608247 | 5.85401908 | Metazoa | 33208 | Annelida | Annelida | 117 | 4.97e-29 | NR | XP_009019938.1 | 6412 | g16403 | i0 | 49.2 | 10.771978021978 | 118 | 59 | 96.4 | 1 | 1 | 351 | 191 | 308 | XP_009019938.1 hypothetical protein HELRODRAFT_106700 [Helobdella robusta] | diamond | 3921 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 20554630 | 20554630 | PRJNA1005695_P_NODE_19257_length_344_cov_1.719557_g18405_i0 | PRJNA1005695 | 19257 | 344 | 1.719557 | 5.91527608 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 147 | 1.54e-39 | NR | CAD5116714.1 | 2664684 | g18405 | i0 | 72.7 | 9.19186046511628 | 88 | 24 | 76.7 | 0 | 80 | 343 | 163 | 250 | CAD5116714.1 DgyrCDS5572 [Dimorphilus gyrociliatus] | diamond | 3162 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 26971056 | 26971056 | PRJNA1005695_P_NODE_40862_length_236_cov_2.349693_g40010_i0 | PRJNA1005695 | 40862 | 236 | 2.349693 | 5.54527548 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 125 | 7.98e-32 | NR | CAD5121995.1 | 2664684 | g40010 | i0 | 76.9 | 9.91525423728813 | 78 | 18 | 99.2 | 0 | 235 | 2 | 51 | 128 | CAD5121995.1 DgyrCDS10448 [Dimorphilus gyrociliatus] | diamond | 2340 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27943164 | 27943164 | PRJNA1005695_P_NODE_39385_length_243_cov_1.688235_g38533_i0 | PRJNA1005695 | 39385 | 243 | 1.688235 | 4.10241105 | Metazoa | 33208 | Annelida | Annelida | 135 | 9.83e-36 | NR | CAH1775520.1 | 6347 | g38533 | i0 | 77.8 | 97.6543209876543 | 81 | 18 | 100 | 0 | 243 | 1 | 75 | 155 | CAH1775520.1 unnamed protein product [Owenia fusiformis] | diamond | 23730 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28360830 | 28360830 | PRJNA1005695_P_NODE_30606_length_270_cov_1.187817_g29754_i0 | PRJNA1005695 | 30606 | 270 | 1.187817 | 3.2071059 | Capitella teleta | 283909 | Annelida | Annelida | 98.6 | 1.24e-21 | NR | ELT88700.1 | 283909 | g29754 | i0 | 49.5 | 1.03333333333333 | 93 | 44 | 100 | 1 | 270 | 1 | 362 | 454 | ELT88700.1 hypothetical protein CAPTEDRAFT_175688 [Capitella teleta] | diamond | 279 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29521716 | 29521716 | PRJNA1005695_P_NODE_34690_length_253_cov_0.866667_g33838_i0 | PRJNA1005695 | 34690 | 253 | 0.866667 | 2.19266751 | Metazoa | 33208 | Annelida | Annelida | 94.4 | 2.89e-20 | NR | CAH1778822.1 | 6347 | g33838 | i0 | 56.8 | 13.2569169960474 | 74 | 32 | 87.7 | 0 | 249 | 28 | 444 | 517 | CAH1778822.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 3354 | 94.7 | 0.996832101372756 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30248414 | 30248414 | PRJNA1005695_P_NODE_25772_length_295_cov_2.243243_g24920_i0 | PRJNA1005695 | 25772 | 295 | 2.243243 | 6.61756685 | Metazoa | 33208 | Annelida | Annelida | 68.2 | 7.62e-12 | NR | CAH1793915.1 | 6347 | g24920 | i0 | 45.1 | 1.59661016949153 | 71 | 38 | 71.2 | 1 | 85 | 294 | 28 | 98 | CAH1793915.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 471 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31677849 | 31677849 | PRJNA1005695_P_NODE_17037_length_366_cov_2.129693_g16185_i0 | PRJNA1005695 | 17037 | 366 | 2.129693 | 7.79467638 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 73.2 | 7.62e-13 | NR | KAK2146732.1 | 53620 | g16185 | i0 | 64.4 | 0.811475409836066 | 45 | 16 | 36.9 | 0 | 366 | 232 | 145 | 189 | KAK2146732.1 hypothetical protein LSH36_587g01063 [Paralvinella palmiformis] | diamond | 297 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31804365 | 31804365 | PRJNA1005695_P_NODE_38597_length_245_cov_0.906977_g37745_i0 | PRJNA1005695 | 38597 | 245 | 0.906977 | 2.22209365 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 98.2 | 1.19e-21 | NR | KAI0230464.1 | 104711 | g37745 | i0 | 59 | 1.84897959183673 | 78 | 31 | 95.5 | 1 | 234 | 1 | 819 | 895 | KAI0230464.1 hypothetical protein LSAT2_019211 [Lamellibrachia satsuma] | diamond | 453 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31986698 | 31986698 | PRJNA1005695_P_NODE_16978_length_367_cov_1.557823_g16126_i0 | PRJNA1005695 | 16978 | 367 | 1.557823 | 5.71721041 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 5.519999999999999e-37 | NR | CAH1775312.1 | 6347 | g16126 | i0 | 53.3 | 10.8719346049046 | 122 | 56 | 99.7 | 1 | 1 | 366 | 688 | 808 | CAH1775312.1 unnamed protein product [Owenia fusiformis] | diamond | 3990 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;