RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA515078" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA515078 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 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
27077185 27077185 PRJNA515078_P_NODE_22282_length_184_cov_1.061224_g22049_i0 PRJNA515078 22282 184 1.061224 1.95265216 Synergistales bacterium 2268201 Bacteria Bacteria 85.5 1.08e-18   NR MFA0888825.1 2268201 g22049 i0 65.6 5.96739130434783 61 21 99.5 0 184 2 41 101 MFA0888825.1 NAD(P)H:quinone oxidoreductase [Synergistales bacterium] diamond 1098 85.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales     Synergistales bacterium
29697755 29697755 PRJNA515078_P_NODE_9610_length_293_cov_1.511719_g9377_i0 PRJNA515078 9610 293 1.511719 4.42933667 Deinobacterium chartae 521158 Bacteria Bacteria 81.6 9.21e-17   NR WP_183987292.1 521158 g9377 i0 41.3 0.9419795221843 92 52 94.2 2 17 292 86 175 WP_183987292.1 TerD family protein [Deinobacterium chartae] diamond 276 81.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinobacterium Deinobacterium chartae
31688984 31688984 PRJNA515078_P_NODE_27297_length_167_cov_0.892308_g27064_i0 PRJNA515078 27297 167 0.892308 1.49015436 Synergistaceae bacterium 2053624 Bacteria Bacteria 53.9 6.16e-7   NR MDR2137471.1 2053624 g27064 i0 50.9 0.952095808383233 53 18 80.8 2 30 164 23 75 MDR2137471.1 TerD family protein [Synergistaceae bacterium] diamond 159 53.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium

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