contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA352610" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1668336 | 1668336 | PRJNA352610_P_NODE_15922_length_309_cov_1.283898_g15861_i0 | PRJNA352610 | 15922 | 309 | 1.283898 | 3.96724482 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 3.71e-6 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g15861 | i0 | 97.368 | 0.122977346278317 | 38 | 1 | 12 | 0 | 259 | 296 | 8749034 | 8749071 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 38 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2944723 | 2944723 | PRJNA352610_P_NODE_523_length_1079_cov_84.370775_g501_i0 | PRJNA352610 | 523 | 1079 | 84.370775 | 910.36066225 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 359 | 5.77e-94 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g501 | i0 | 81.21 | 17.5291936978684 | 463 | 72 | 42 | 10 | 535 | 986 | 14 | 472 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18914 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 4221046 | 4221046 | PRJNA352610_P_NODE_21224_length_273_cov_1.420000_g21163_i0 | PRJNA352610 | 21224 | 273 | 1.42 | 3.8766 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 78.7 | 4.13e-10 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g21163 | i0 | 81.633 | 0.358974358974359 | 98 | 14 | 35 | 3 | 127 | 222 | 17560269 | 17560364 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 98 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4221199 | 4221199 | PRJNA352610_P_NODE_28384_length_246_cov_1.052023_g28323_i0 | PRJNA352610 | 28384 | 246 | 1.052023 | 2.58797658 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g28323 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 147 | 174 | 25705992 | 25705965 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5497666 | 5497666 | PRJNA352610_P_NODE_3205_length_566_cov_1.411765_g3144_i0 | PRJNA352610 | 3205 | 566 | 1.411765 | 7.9905899 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g3144 | i0 | 100 | 0.312720848056537 | 30 | 0 | 5 | 0 | 235 | 264 | 429933 | 429962 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 177 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13147697 | 13147697 | PRJNA352610_P_NODE_5451_length_463_cov_1.400000_g5390_i0 | PRJNA352610 | 5451 | 463 | 1.4 | 6.482 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 222 | 3.24e-53 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g5390 | i0 | 84.581 | 2.16846652267819 | 227 | 31 | 49 | 4 | 2 | 226 | 2104789 | 2105013 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 1004 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14422784 | 14422784 | PRJNA352610_P_NODE_3632_length_541_cov_1.709402_g3571_i0 | PRJNA352610 | 3632 | 541 | 1.709402 | 9.24786482 | Hydroides elegans | 216498 | Annelida | Annelida | 320 | 1.32e-82 | NTclustered | gi|92430140|gb|DQ463963.1| | 216498 | g3571 | i0 | 82.961 | 30.9556377079482 | 358 | 58 | 66 | 3 | 3 | 359 | 44 | 399 | Hydroides elegans histone variant H2A.Z mRNA, partial cds | blastn | 16747 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Hydroides | Hydroides elegans | |
| 15098324 | 15098324 | PRJNA352610_P_NODE_26972_length_248_cov_1.280000_g26911_i0 | PRJNA352610 | 26972 | 248 | 1.28 | 3.1744 | Opisthokonta | 33154 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g26911 | i0 | 92.5 | 1.08064516129032 | 40 | 0 | 16 | 2 | 63 | 102 | 1075150 | 1075114 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 268 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15696770 | 15696770 | PRJNA352610_P_NODE_7793_length_405_cov_5.045181_g7732_i0 | PRJNA352610 | 7793 | 405 | 5.045181 | 20.43298305 | Aeolosoma viride | 394736 | Annelida | Annelida | 438 | 2.55e-118 | NTclustered | gi|1151119859|gb|KY079093.1| | 394736 | g7732 | i0 | 90.606 | 82.0543209876543 | 330 | 31 | 81 | 0 | 5 | 334 | 398 | 69 | Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds | blastn | 33232 | 438 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma viride | |
| 18245486 | 18245486 | PRJNA352610_P_NODE_24775_length_252_cov_1.279330_g24714_i0 | PRJNA352610 | 24775 | 252 | 1.27933 | 3.2239116 | Eurythoe complanata | 167815 | Annelida | Annelida | 196 | 9.98e-46 | NTclustered | gi|158187893|gb|EU125031.1| | 167815 | g24714 | i0 | 82.096 | 80.6071428571429 | 229 | 37 | 90 | 4 | 26 | 252 | 417 | 191 | Eurythoe complanata ribosomal protein rpl40 mRNA, complete cds | blastn | 20313 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 19519474 | 19519474 | PRJNA352610_P_NODE_1576_length_736_cov_2.986425_g1522_i0 | PRJNA352610 | 1576 | 736 | 2.986425 | 21.980088 | Eurythoe complanata | 167815 | Annelida | Annelida | 401 | 6.349999999999998e-107 | NTclustered | gi|158187819|gb|EU124994.1| | 167815 | g1522 | i0 | 79.31 | 3.90217391304348 | 580 | 113 | 78 | 7 | 1 | 576 | 140 | 716 | Eurythoe complanata ribosomal protein rps3a mRNA, complete cds | blastn | 2872 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 20795294 | 20795294 | PRJNA352610_P_NODE_257_length_1348_cov_7.547451_g243_i0 | PRJNA352610 | 257 | 1348 | 7.547451 | 101.73963948 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 828 | 0 | NTclustered | gi|112144441|gb|DQ813345.1| | 397537 | g243 | i0 | 82.9 | 81.709940652819 | 924 | 153 | 68 | 3 | 1 | 920 | 52 | 974 | Aeolosoma sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 110145 | 828 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 22070522 | 22070522 | PRJNA352610_P_NODE_4478_length_501_cov_1.985981_g4417_i0 | PRJNA352610 | 4478 | 501 | 1.985981 | 9.94976481 | Enchytraeus cf. crypticus SL-2017 | 2052677 | Annelida | Annelida | 156 | 3.63e-33 | NTclustered | gi|1068288308|gb|KU728746.1| | 2052677 | g4417 | i0 | 79.039 | 0.457085828343313 | 229 | 46 | 46 | 2 | 260 | 487 | 238 | 465 | Enchytraeus cf. crypticus SL-2017 mitochondrial ATP synthase subunit 9 precursor, mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 229 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus cf. crypticus SL-2017 | |
| 24022324 | 24022324 | PRJNA352610_P_NODE_4179_length_514_cov_4.249433_g4118_i0 | PRJNA352610 | 4179 | 514 | 4.249433 | 21.84208562 | Metazoa | 33208 | Annelida | Annelida | 255 | 3.57e-63 | NTclustered | gi|158187785|gb|EU124977.1| | 6344 | g4118 | i0 | 79.775 | 49.8035019455253 | 356 | 68 | 69 | 4 | 99 | 452 | 3 | 356 | Arenicola marina ribosomal protein rpl27a mRNA, partial cds | blastn | 25599 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina |
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);;