RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1146029" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA1146029 · 9 ✖

analysis 1

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
26742553 26742553 PRJNA1146029_P_NODE_22361_length_239_cov_2.771084_g22080_i0 PRJNA1146029 22361 239 2.771084 6.62289076 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.9 4.05e-6   NR VEU42683.1 183589 g22080 i0 33.8 1.92050209205021 77 51 96.7 0 4 234 126 202 VEU42683.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 459 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27228548 27228548 PRJNA1146029_P_NODE_7923_length_320_cov_1.246964_g7644_i0 PRJNA1146029 7923 320 1.246964 3.9902848 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.69e-5   NR KAK1735154.1 267567 g7644 i0 44.6 0.525 56 30 51.6 1 27 191 500 555 KAK1735154.1 hypothetical protein QTG54_014220 [Skeletonema marinoi] diamond 168 52.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28333848 28333848 PRJNA1146029_P_NODE_15126_length_256_cov_2.142077_g14845_i0 PRJNA1146029 15126 256 2.142077 5.48371712 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0132   NR KAG7361646.1 303405 g14845 i0 33.3 0.94921875 81 51 94.9 1 252 10 2941 3018 KAG7361646.1 vacuolar sorting-associated protein 13, N-terminal domain containing protein [Nitzschia inconspicua] diamond 243 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28712843 28712843 PRJNA1146029_P_NODE_20387_length_244_cov_0.900585_g20106_i0 PRJNA1146029 20387 244 0.900585 2.1974274 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 56.6 4.59e-7   NR XP_002178470.1 556484 g20106 i0 40 2.95081967213115 80 35 98.4 1 242 3 74 140 XP_002178470.1 det3-like protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 720 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29344339 29344339 PRJNA1146029_P_NODE_16929_length_250_cov_0.870056_g16648_i0 PRJNA1146029 16929 250 0.870056 2.17514 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.46e-9   NR XP_002183657.1 556484 g16648 i0 57.1 0.504 42 18 50.4 0 250 125 273 314 XP_002183657.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 126 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29901637 29901637 PRJNA1146029_P_NODE_4911_length_391_cov_1.210692_g4633_i0 PRJNA1146029 4911 391 1.210692 4.73380572 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 97.8 9.15e-21   NR GFH52213.1 426638 g4633 i0 52.2 5.15601023017903 90 43 69.1 0 2 271 218 307 GFH52213.1 hypothetical protein CTEN210_08689 [Chaetoceros tenuissimus] diamond 2016 98.6 0.991886409736308 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30028026 30028026 PRJNA1146029_P_NODE_16711_length_250_cov_0.870056_g16430_i0 PRJNA1146029 16711 250 0.870056 2.17514 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 108 3.78e-25   NR CAB9520445.1 568900 g16430 i0 63.2 2.736 76 27 91.2 1 1 228 591 665 CAB9520445.1 Inherit from NOG: fad dependent oxidoreductase [Seminavis robusta] diamond 684 108 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30028028 30028028 PRJNA1146029_P_NODE_18811_length_247_cov_0.885057_g18530_i0 PRJNA1146029 18811 247 0.885057 2.18609079 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 129 4.85e-33   NR CAB9519451.1 568900 g18530 i0 72.8 1.91902834008097 81 21 97.2 1 241 2 15 95 CAB9519451.1 Vacuolar-sorting receptor 1 [Seminavis robusta] diamond 474 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31196522 31196522 PRJNA1146029_P_NODE_20955_length_243_cov_0.905882_g20674_i0 PRJNA1146029 20955 243 0.905882 2.20129326 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 84 1.08e-16   NR KAL3760713.1 259834 g20674 i0 46.9 2 81 43 100 0 1 243 309 389 KAL3760713.1 hypothetical protein ACHAWU_000033 [Discostella pseudostelligera] diamond 486 84.3 0.99644128113879 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera

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