contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA335774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 390475 | 390475 | PRJNA335774_P_NODE_3221_length_736_cov_2.986425_g3084_i0 | PRJNA335774 | 3221 | 736 | 2.986425 | 21.980088 | Eurythoe complanata | 167815 | Annelida | Annelida | 401 | 6.349999999999998e-107 | NTclustered | gi|158187819|gb|EU124994.1| | 167815 | g3084 | 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 | |
| 4897611 | 4897611 | PRJNA335774_P_NODE_7604_length_514_cov_4.249433_g7452_i0 | PRJNA335774 | 7604 | 514 | 4.249433 | 21.84208562 | Metazoa | 33208 | Annelida | Annelida | 255 | 3.57e-63 | NTclustered | gi|158187785|gb|EU124977.1| | 6344 | g7452 | 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 | ||
| 5494462 | 5494462 | PRJNA335774_P_NODE_6805_length_541_cov_1.709402_g6654_i0 | PRJNA335774 | 6805 | 541 | 1.709402 | 9.24786482 | Hydroides elegans | 216498 | Annelida | Annelida | 320 | 1.32e-82 | NTclustered | gi|92430140|gb|DQ463963.1| | 216498 | g6654 | 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 | |
| 9318867 | 9318867 | PRJNA335774_P_NODE_6108_length_566_cov_1.724138_g5958_i0 | PRJNA335774 | 6108 | 566 | 1.724138 | 9.75862108 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g5958 | i0 | 100 | 0.312720848056537 | 30 | 0 | 5 | 0 | 303 | 332 | 429962 | 429933 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 177 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9997856 | 9997856 | PRJNA335774_P_NODE_41528_length_248_cov_1.280000_g41376_i0 | PRJNA335774 | 41528 | 248 | 1.28 | 3.1744 | Opisthokonta | 33154 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g41376 | 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 | |
| 10593723 | 10593723 | PRJNA335774_P_NODE_13329_length_405_cov_5.045181_g13177_i0 | PRJNA335774 | 13329 | 405 | 5.045181 | 20.43298305 | Aeolosoma viride | 394736 | Annelida | Annelida | 438 | 2.55e-118 | NTclustered | gi|1151119859|gb|KY079093.1| | 394736 | g13177 | 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 | |
| 10594633 | 10594633 | PRJNA335774_P_NODE_8109_length_501_cov_1.985981_g7957_i0 | PRJNA335774 | 8109 | 501 | 1.985981 | 9.94976481 | Enchytraeus cf. crypticus SL-2017 | 2052677 | Annelida | Annelida | 156 | 3.63e-33 | NTclustered | gi|1068288308|gb|KU728746.1| | 2052677 | g7957 | 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 | |
| 11868606 | 11868606 | PRJNA335774_P_NODE_1170_length_1079_cov_84.370775_g1102_i0 | PRJNA335774 | 1170 | 1079 | 84.370775 | 910.36066225 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 359 | 5.77e-94 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g1102 | 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 | |
| 12548082 | 12548082 | PRJNA335774_P_NODE_17470_length_363_cov_0.841379_g17318_i0 | PRJNA335774 | 17470 | 363 | 0.841379 | 3.05420577 | Metazoa | 33208 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|675879942|ref|XM_009027243.1| | 6412 | g17318 | i0 | 100 | 0.925619834710744 | 28 | 0 | 8 | 0 | 225 | 252 | 1373 | 1400 | Helobdella robusta hypothetical protein partial mRNA | blastn | 336 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13144253 | 13144253 | PRJNA335774_P_NODE_43431_length_246_cov_1.052023_g43279_i0 | PRJNA335774 | 43431 | 246 | 1.052023 | 2.58797658 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g43279 | 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 | |
| 13144531 | 13144531 | PRJNA335774_P_NODE_9791_length_463_cov_1.400000_g9639_i0 | PRJNA335774 | 9791 | 463 | 1.4 | 6.482 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 222 | 3.24e-53 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g9639 | 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 | |
| 15692994 | 15692994 | PRJNA335774_P_NODE_25513_length_309_cov_1.283898_g25361_i0 | PRJNA335774 | 25513 | 309 | 1.283898 | 3.96724482 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 3.71e-6 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g25361 | 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 | |
| 18242099 | 18242099 | PRJNA335774_P_NODE_33355_length_273_cov_1.420000_g33203_i0 | PRJNA335774 | 33355 | 273 | 1.42 | 3.8766 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 78.7 | 4.13e-10 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g33203 | 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 | |
| 18242209 | 18242209 | PRJNA335774_P_NODE_38515_length_252_cov_1.279330_g38363_i0 | PRJNA335774 | 38515 | 252 | 1.27933 | 3.2239116 | Eurythoe complanata | 167815 | Annelida | Annelida | 196 | 9.98e-46 | NTclustered | gi|158187893|gb|EU125031.1| | 167815 | g38363 | 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 | |
| 20792279 | 20792279 | PRJNA335774_P_NODE_597_length_1348_cov_7.547451_g553_i0 | PRJNA335774 | 597 | 1348 | 7.547451 | 101.73963948 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 828 | 0 | NTclustered | gi|112144441|gb|DQ813345.1| | 397537 | g553 | 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 |
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);;