RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA330616", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA330616 · 9 ✖

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
7447252 7447252 PRJNA330616_P_NODE_25526_length_167_cov_1.000000_g25117_i0 PRJNA330616 25526 167 1 1.67 Bacillariales 33851 SAR_Eukaryotes SAR_Eukaryotes 303 3.5e-78   NTclustered gi|2127877266|ref|NC_058784.1| 183589 g25117 i0 99.401 194.97005988024 167 1 100 0 1 167 46908 47074 Pseudo-nitzschia multistriata isolate CNS00142 chloroplast, complete genome blastn 32560 303 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
23341759 23341759 PRJNA330616_P_NODE_4759_length_389_cov_1.200000_g4350_i0 PRJNA330616 4759 389 1.2 4.668 Lithodesmioides sp. mgcode 4 2914905 SAR_Eukaryotes SAR_Eukaryotes 252 3.4099999999999998e-62   NTclustered gi|2073953334|gb|MW849271.1| 2914905 g4350 i0 78.571 60.681233933162 392 76 99 8 2 389 21370 21757 Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 23605 252 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmioides Lithodesmioides sp. mgcode 4
26853341 26853341 PRJNA330616_P_NODE_33101_length_152_cov_2.970874_g32692_i0 PRJNA330616 33101 152 2.970874 4.51572848 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 45.8 8.83e-4   NR KAL3770988.1 259834 g32692 i0 53.1 0.967105263157895 49 23 96.7 0 152 6 43 91 KAL3770988.1 hypothetical protein ACHAWU_008941 [Discostella pseudostelligera] diamond 147 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27439861 27439861 PRJNA330616_P_NODE_28343_length_165_cov_0.879310_g27934_i0 PRJNA330616 28343 165 0.87931 1.4508615 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.7 4.25e-21   NR GFH60760.1 426638 g27934 i0 77.8 3.92727272727273 54 12 98.2 0 164 3 4 57 GFH60760.1 nucleoside-diphosphate kinase [Chaetoceros tenuissimus] diamond 648 89.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27454027 27454027 PRJNA330616_P_NODE_21083_length_184_cov_1.511111_g20674_i0 PRJNA330616 21083 184 1.511111 2.78044424 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0438   NR KAL3768605.1 382360 g20674 i0 38.6 0.717391304347826 44 27 71.7 0 149 18 4143 4186 KAL3768605.1 hypothetical protein ACHAWO_009624 [Cyclotella atomus] diamond 132 41.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
28355118 28355118 PRJNA330616_P_NODE_24646_length_170_cov_1.264463_g24237_i0 PRJNA330616 24646 170 1.264463 2.1495871 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.27e-4   NR KAG7352108.1 303405 g24237 i0 43.8 5.62941176470588 48 27 84.7 0 3 146 862 909 KAG7352108.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Nitzschia inconspicua] diamond 957 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28590653 28590653 PRJNA330616_P_NODE_29007_length_164_cov_0.886957_g28598_i0 PRJNA330616 29007 164 0.886957 1.45460948 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 51.6 6.72e-6   NR OEU09742.1 635003 g28598 i0 86.4 1.64634146341463 22 3 40.2 0 1 66 196 217 OEU09742.1 methionine-S-sulfoxide reductase [Fragilariopsis cylindrus CCMP1102] diamond 270 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
31433372 31433372 PRJNA330616_P_NODE_22216_length_179_cov_1.569231_g21807_i0 PRJNA330616 22216 179 1.569231 2.80892349 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89.7 4.39e-19   NR GKY92196.1 2872254 g21807 i0 79.7 0.988826815642458 59 12 98.9 0 3 179 656 714 GKY92196.1 hypothetical protein MPSEU_000190800 [Mayamaea pseudoterrestris] diamond 177 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32509379 32509379 PRJNA330616_P_NODE_19419_length_191_cov_1.436620_g19010_i0 PRJNA330616 19419 191 1.43662 2.7439442 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 63.2 1.16e-9   NR GAX28520.1 1519565 g19010 i0 62.3 1.64921465968586 53 19 81.7 1 35 190 33 85 GAX28520.1 fumarylacetoacetase [Fistulifera solaris] diamond 315 63.2 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);;