contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA352850" 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 | |
| 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 |
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);;