RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA983848" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA983848 · 12 ✖

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
967986 967986 PRJNA983848_P_NODE_154621_length_244_cov_2.450292_g148738_i0 PRJNA983848 154621 244 2.450292 5.97871248 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.01e-10   NTclustered gi|1819718724|gb|MN956530.1| 2850 g148738 i0 77.953 1.04098360655738 127 28 52 0 1 127 3449 3575 Phaeodactylum tricornutum strain ICE-H mitochondrion, complete genome blastn 254 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
9897709 9897709 PRJNA983848_P_NODE_47208_length_516_cov_1.302483_g41338_i0 PRJNA983848 47208 516 1.302483 6.72081228 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 411 7.239999999999999e-110   NTclustered gi|657012367|gb|KF302531.1| 2850 g41338 i0 87.088 71.2887596899225 364 45 70 2 16 378 23 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 36785 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14997211 14997211 PRJNA983848_P_NODE_40392_length_595_cov_3.496169_g34562_i0 PRJNA983848 40392 595 3.496169 20.80220555 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 394 8.49e-105   NTclustered gi|657012562|gb|KF302618.1| 2850 g34562 i0 81.874 57.4571428571429 491 68 81 17 12 492 759 280 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 34187 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14997936 14997936 PRJNA983848_P_NODE_59232_length_426_cov_3.019830_g53351_i0 PRJNA983848 59232 426 3.01983 12.8644758 Nitzschia alba 2858 SAR_Eukaryotes SAR_Eukaryotes 202 3.849999999999999e-47   NTclustered gi|1418576962|ref|NC_037729.1| 2858 g53351 i0 82.759 57.2511737089202 232 35 54 5 68 297 33293 33065 Nitzschia alba mitochondrion, complete genome blastn 24389 202 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia alba
17548975 17548975 PRJNA983848_P_NODE_88154_length_326_cov_2.102767_g82271_i0 PRJNA983848 88154 326 2.102767 6.85502042 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 137 8.22e-28   NTclustered gi|2020303798|gb|MW417227.1| 265543 g82271 i0 77.917 1.3159509202454 240 39 72 10 92 325 8715 8484 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 429 137 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
17849201 17849201 PRJNA983848_P_NODE_44914_length_539_cov_4.334764_g39049_i0 PRJNA983848 44914 539 4.334764 23.36437796 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 913 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g39049 i0 97.222 200.029684601113 540 13 100 2 1 539 68685 68147 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 107816 913 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19122844 19122844 PRJNA983848_P_NODE_135955_length_254_cov_3.447514_g130072_i0 PRJNA983848 135955 254 3.447514 8.75668556 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 459 1.1599999999999999e-124   NTclustered gi|1735236539|ref|NC_044464.1| 2133758 g130072 i0 99.213 199 254 2 100 0 1 254 87255 87508 Halamphora calidilacuna chloroplast, complete genome blastn 50546 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
23922797 23922797 PRJNA983848_P_NODE_65599_length_395_cov_2.298137_g59716_i0 PRJNA983848 65599 395 2.298137 9.07764115 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 556 6.57e-154   NTclustered gi|146762526|gb|EF553458.1| 2850 g59716 i0 92.583 99.3113924050633 391 24 98 5 6 394 4102 4489 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 39228 556 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26652206 26652206 PRJNA983848_P_NODE_116161_length_278_cov_2.117073_g110278_i0 PRJNA983848 116161 278 2.117073 5.88546294 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 48.1 7.03e-4   NR KAI2511520.1 210448 g110278 i0 53.7 7.91007194244604 41 19 44.2 0 178 56 199 239 KAI2511520.1 DEAD box helicase-like protein [Fragilaria crotonensis] diamond 2199 48.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28763180 28763180 PRJNA983848_P_NODE_155367_length_244_cov_1.309942_g149484_i0 PRJNA983848 155367 244 1.309942 3.19625848 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 135 1.03e-35   NR EJK57400.1 159749 g149484 i0 72.5 1.9672131147541 80 22 98.4 0 3 242 351 430 EJK57400.1 hypothetical protein THAOC_22555 [Thalassiosira oceanica] diamond 480 135 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30247747 30247747 PRJNA983848_P_NODE_117072_length_277_cov_1.617647_g111189_i0 PRJNA983848 117072 277 1.617647 4.48088219 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0161   NR KAG7337482.1 303405 g111189 i0 27.4 0.790613718411552 73 50 75.8 1 242 33 539 611 KAG7337482.1 kynurenine 3-monooxygenase [Nitzschia inconspicua] diamond 219 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31480337 31480337 PRJNA983848_P_NODE_166316_length_227_cov_2.012987_g160433_i0 PRJNA983848 166316 227 2.012987 4.56948049 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 50.1 7.21e-5   NR GAX25793.1 1519565 g160433 i0 38.6 0.753303964757709 57 35 75.3 0 187 17 190 246 GAX25793.1 translation initiation factor 3 subunit F [Fistulifera solaris] diamond 171 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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