RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA493632" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA493632 · 15 ✖

tax_kingdom 0

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
1101205 1101205 PRJNA493632_P_NODE_227061_length_327_cov_3.196850_g223625_i0 PRJNA493632 227061 327 3.19685 10.4536995 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 582 8.819999999999998e-162   NTclustered gi|725650481|ref|NC_025311.1| 216768 g223625 i0 98.777 198.036697247706 327 4 100 0 1 327 67283 67609 Rhizosolenia imbricata chloroplast, complete genome blastn 64758 582 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Rhizosolenia Rhizosolenia imbricata
6205400 6205400 PRJNA493632_P_NODE_360525_length_280_cov_3.946860_g357086_i0 PRJNA493632 360525 280 3.94686 11.051208 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 442 1.3099999999999994e-119   NTclustered gi|146762526|gb|EF553458.1| 2850 g357086 i0 95.341 96.0464285714286 279 12 99 1 2 280 4212 3935 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 26893 442 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
9394730 9394730 PRJNA493632_P_NODE_600568_length_245_cov_0.895349_g597127_i0 PRJNA493632 600568 245 0.895349 2.19360505 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 233 7.36e-57   NTclustered gi|223995628|ref|XM_002287452.1| 296543 g597127 i0 85.333 1.7469387755102 225 33 92 0 1 225 624 400 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 428 233 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
11306715 11306715 PRJNA493632_P_NODE_599629_length_245_cov_0.895349_g596188_i0 PRJNA493632 599629 245 0.895349 2.19360505 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|2415735739|gb|OM927983.1| 2854 g596188 i0 100 0.571428571428571 28 0 11 0 43 70 455 428 Cylindrotheca sp. ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 140 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca sp.
15132003 15132003 PRJNA493632_P_NODE_673892_length_237_cov_2.079268_g670451_i0 PRJNA493632 673892 237 2.079268 4.92786516 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 372 1.44e-98   NTclustered gi|2733059045|gb|PP801224.1| 195935 g670451 i0 94.937 61.4683544303797 237 12 100 0 1 237 361 597 Pseudo-nitzschia brasiliana strain MC7496 large subunit ribosomal RNA gene, partial sequence blastn 14568 372 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia brasiliana
15769829 15769829 PRJNA493632_P_NODE_629613_length_243_cov_0.905882_g626172_i0 PRJNA493632 629613 243 0.905882 2.20129326 Navicula cryptocephala 138538 SAR_Eukaryotes SAR_Eukaryotes 433 6.69e-117   NTclustered gi|329342903|gb|HQ912296.1| 138538 g626172 i0 98.765 99.6337448559671 243 3 100 0 1 243 304 546 Navicula cryptocephala strain UTEX FD109 PsbC (psbC) gene, partial cds; chloroplast blastn 24211 433 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cryptocephala
17040569 17040569 PRJNA493632_P_NODE_403394_length_271_cov_2.565657_g399955_i0 PRJNA493632 403394 271 2.565657 6.95293047 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 119 2.42e-22   NTclustered gi|223995802|ref|XM_002287539.1| 296543 g399955 i0 82.482 5.13653136531365 137 23 50 1 59 194 186 50 Thalassiosira pseudonana CCMP1335 RL17A, ribosomal protein 27A 60S large ribosomal subunit (RL27A), partial mRNA blastn 1392 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18311981 18311981 PRJNA493632_P_NODE_248995_length_315_cov_1.272727_g245559_i0 PRJNA493632 248995 315 1.272727 4.00909005 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 556 5.13e-154   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g245559 i0 98.423 91.4571428571429 317 3 100 2 1 315 5126 4810 Odontella aurita var. minima small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 28809 556 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima
24686173 24686173 PRJNA493632_P_NODE_241200_length_319_cov_1.975610_g237764_i0 PRJNA493632 241200 319 1.97561 6.3021959 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 551 2.4199999999999995e-152   NTclustered gi|1735236684|ref|NC_044465.1| 1487565 g237764 i0 97.806 199 319 7 100 0 1 319 69773 69455 Halamphora coffeaeformis chloroplast, complete genome blastn 63481 551 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
26918346 26918346 PRJNA493632_P_NODE_157922_length_379_cov_1.003268_g154498_i0 PRJNA493632 157922 379 1.003268 3.80238572 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 122 8.439999999999998e-30   NR CAB9518259.1 568900 g154498 i0 44.9 4.02110817941953 127 63 98.9 2 2 376 90 211 CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta] diamond 1524 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27108055 27108055 PRJNA493632_P_NODE_523042_length_250_cov_0.870056_g519603_i0 PRJNA493632 523042 250 0.870056 2.17514 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.13e-15   NR CAB9529003.1 568900 g519603 i0 51.9 2.916 81 32 96 2 246 7 23 97 CAB9529003.1 MAP kinase-activated protein kinase 2 (Fragment) [Seminavis robusta] diamond 729 81.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28181777 28181777 PRJNA493632_P_NODE_477066_length_256_cov_2.956284_g473627_i0 PRJNA493632 477066 256 2.956284 7.56808704 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0122   NR KAG7346722.1 303405 g473627 i0 39.6 0.5625 48 29 56.3 0 190 47 155 202 KAG7346722.1 EamA-like transporter family protein [Nitzschia inconspicua] diamond 144 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28766092 28766092 PRJNA493632_P_NODE_361967_length_280_cov_2.014493_g358528_i0 PRJNA493632 361967 280 2.014493 5.6405804 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 113 1.02e-26   NR CAJ1937934.1 2856 g358528 i0 54.3 3.33214285714286 105 36 99.6 1 2 280 225 329 CAJ1937934.1 unnamed protein product [Cylindrotheca closterium] diamond 933 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29381841 29381841 PRJNA493632_P_NODE_428929_length_266_cov_1.595855_g425490_i0 PRJNA493632 428929 266 1.595855 4.2449743 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.019   NR EJK63077.1 159749 g425490 i0 38.6 0.789473684210526 70 41 77.8 2 211 5 185 253 EJK63077.1 hypothetical protein THAOC_16285 [Thalassiosira oceanica] diamond 210 43.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31562048 31562048 PRJNA493632_P_NODE_147076_length_389_cov_2.433544_g143654_i0 PRJNA493632 147076 389 2.433544 9.46648616 Psammodictyon constrictum 515483 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.61e-16   NR YP_010283277.1 515483 g143654 i0 57 1.32647814910026 79 33 60.9 1 148 384 10 87 YP_010283277.1 hypothetical protein MKU01_pgp097 [Psammodictyon constrictum] diamond 516 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;