RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA909412 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28698437 28698437 PRJNA909412_P_NODE_16627_length_151_cov_3.750000_g16486_i0 PRJNA909412 16627 151 3.75 5.6625 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 79 1.75e-15   NR GAX11153.1 1519565 g16486 i0 69.4 0.973509933774834 49 15 97.4 0 3 149 504 552 GAX11153.1 arginyl-tRNA synthetase [Fistulifera solaris] diamond 147 79 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30245821 30245821 PRJNA909412_P_NODE_17892_length_150_cov_1.513514_g17751_i0 PRJNA909412 17892 150 1.513514 2.270271 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.66e-6   NR GFH60747.1 426638 g17751 i0 50 1.98 48 24 96 0 7 150 142 189 GFH60747.1 hypothetical protein CTEN210_17223 [Chaetoceros tenuissimus] diamond 297 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30435462 30435462 PRJNA909412_P_NODE_9693_length_173_cov_1.238806_g9552_i0 PRJNA909412 9693 173 1.238806 2.14313438 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.81e-8   NR KAI2504394.1 210448 g9552 i0 57.5 2.04624277456647 40 17 69.4 0 122 3 370 409 KAI2504394.1 FACT complex subunit ctc-1 [Fragilaria crotonensis] diamond 354 58.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31509933 31509933 PRJNA909412_P_NODE_11836_length_166_cov_1.543307_g11695_i0 PRJNA909412 11836 166 1.543307 2.56188962 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.58e-11   NR CAB9514815.1 568900 g11695 i0 56.4 10.210843373494 55 24 99.4 0 166 2 58 112 CAB9514815.1 Pepsin A [Seminavis robusta] diamond 1695 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32308419 32308419 PRJNA909412_P_NODE_13759_length_159_cov_3.300000_g13618_i0 PRJNA909412 13759 159 3.3 5.247 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 83.6 4.74e-17   NR CAB9516067.1 568900 g13618 i0 61.1 12.2264150943396 72 8 98.1 1 3 158 307 378 CAB9516067.1 Sulfite reductase [NADPH] hemoprotein beta-component [Seminavis robusta] diamond 1944 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32711216 32711216 PRJNA909412_P_NODE_17260_length_151_cov_1.482143_g17119_i0 PRJNA909412 17260 151 1.482143 2.23803593 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.03e-14   NR CAB9497662.1 568900 g17119 i0 64 2.98013245033113 50 18 99.3 0 151 2 526 575 CAB9497662.1 Lon protease [Seminavis robusta] diamond 450 75.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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