RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 2 ✖

bioproject 1

  • PRJNA560029 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
23496183 23496183 PRJNA560029_S_NODE_17499_length_315_cov_8.863636_g17275_i0 PRJNA560029 17499 315 8.863636 27.9204534 Oceanotoga sp. 2108366 Bacteria Bacteria 62.8 7.66e-9   NR WP_308644899.1 2108366 g17275 i0 38 0.952380952380952 100 60 93.3 1 312 19 109 208 WP_308644899.1 hypothetical protein [Oceanotoga sp.] diamond 300 62.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Oceanotoga Oceanotoga sp.
26762398 26762398 PRJNA560029_S_NODE_3481_length_486_cov_6.602906_g3259_i0 PRJNA560029 3481 486 6.602906 32.09012316 Calidithermus terrae 1408545 Bacteria Bacteria 89.4 8.45e-18   NR WP_119313806.1 1408545 g3259 i0 71.7 0.648148148148148 53 15 32.7 0 3 161 277 329 WP_119313806.1 class 1b ribonucleoside-diphosphate reductase subunit beta [Calidithermus terrae] diamond 315 89.4 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus terrae

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