RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA681822", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA681822 · 4 ✖

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
27682582 27682582 PRJNA681822_P_NODE_268704_length_282_cov_1.349282_g267215_i0 PRJNA681822 268704 282 1.349282 3.80497524 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 89.4 4.76e-19   NR GAX14334.1 1519565 g267215 i0 49.5 0.968085106382979 91 46 96.8 0 282 10 131 221 GAX14334.1 hypothetical protein FisN_1Hh534 [Fistulifera solaris] diamond 273 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30587410 30587410 PRJNA681822_P_NODE_485533_length_239_cov_2.259036_g484043_i0 PRJNA681822 485533 239 2.259036 5.39909604 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 68.9 2.1e-11   NR KAG7366701.1 303405 g484043 i0 39.7 7.26778242677824 78 47 97.9 0 234 1 543 620 KAG7366701.1 2-oxoglutarate dehydrogenase E1 component [Nitzschia inconspicua] diamond 1737 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31377760 31377760 PRJNA681822_P_NODE_432696_length_246_cov_0.890173_g431207_i0 PRJNA681822 432696 246 0.890173 2.18982558 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 104 2.7300000000000003e-27   NR KAL3811331.1 382380 g431207 i0 88.5 0.74390243902439 61 5 74.4 1 246 64 16 74 KAL3811331.1 hypothetical protein ACHAXA_007396 [Cyclostephanos tholiformis] diamond 183 104 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32168670 32168670 PRJNA681822_P_NODE_332858_length_265_cov_1.604167_g331369_i0 PRJNA681822 332858 265 1.604167 4.25104255 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 172 5.22e-53   NR KAL3762734.1 259834 g331369 i0 100 3.98490566037736 88 0 99.6 0 1 264 36 123 KAL3762734.1 hypothetical protein ACHAWU_001679 [Discostella pseudostelligera] diamond 1056 172 1 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);;