RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA638138 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
11358668 11358668 PRJNA638138_P_NODE_29989_length_244_cov_0.900585_g29774_i0 PRJNA638138 29989 244 0.900585 2.1974274 Bacteria 2 Bacteria Bacteria 96.3 3.64e-21   NR MDQ3458455.1 1913990 g29774 i0 64.7 2.09016393442623 85 22 94.7 2 240 10 244 328 MDQ3458455.1 cytochrome P450 [Deinococcota bacterium] diamond 510 96.3 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
28754764 28754764 PRJNA638138_P_NODE_17787_length_261_cov_1.042553_g17572_i0 PRJNA638138 17787 261 1.042553 2.72106333 Deinococcus antarcticus 1298767 Bacteria Bacteria 180 5.05e-53   NR WP_380078585.1 1298767 g17572 i0 98.9 1 87 1 100 0 261 1 92 178 WP_380078585.1 PQQ-dependent sugar dehydrogenase [Deinococcus antarcticus] diamond 261 180 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
30302607 30302607 PRJNA638138_P_NODE_26832_length_246_cov_0.890173_g26617_i0 PRJNA638138 26832 246 0.890173 2.18982558 uncultured Truepera sp. 543023 Bacteria Bacteria 109 1.4e-25   NR CAA9571108.1 543023 g26617 i0 69.5 1 82 22 98.8 2 244 2 496 575 CAA9571108.1 MAG: Protein translocase subunit SecD / Protein translocase subunit SecF [uncultured Truepera sp.] diamond 246 109 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
30586365 30586365 PRJNA638138_P_NODE_26853_length_246_cov_0.890173_g26638_i0 PRJNA638138 26853 246 0.890173 2.18982558 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 90.9 1.64e-20   NR WP_104990390.1 2080419 g26638 i0 75.9 0.707317073170732 58 13 69.5 1 15 185 148 205 WP_104990390.1 hypothetical protein [Deinococcus sp. NW-56] diamond 174 90.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56

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