RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA597223", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 2 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 2 ✖

bioproject 1

  • PRJNA597223 · 2 ✖
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
3120137 3120137 PRJNA597223_P_NODE_42903_length_216_cov_2.817680_g41057_i0 PRJNA597223 42903 216 2.81768 6.0861888 Roseithermus sacchariphilus 2893045 Bacteria Bacteria 211 2.97e-50   NTclustered gi|1417721500|gb|CP030158.1| 2893045 g41057 i0 86.207 135.092592592593 203 19 92 9 2 200 1399658 1399461 Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome blastn 29180 211 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salisaetaceae Roseithermus Roseithermus sacchariphilus
31723269 31723269 PRJNA597223_P_NODE_45217_length_209_cov_2.741379_g43371_i0 PRJNA597223 45217 209 2.741379 5.72948211 Rubrivirga sp. SAORIC476 1961794 Bacteria Bacteria 40.8 0.0348   NR WP_095516179.1 1961794 g43371 i0 95 0.287081339712919 20 1 28.7 0 72 13 4 23 WP_095516179.1 30S ribosomal protein S10 [Rubrivirga sp. SAORIC476] diamond 60 40.8 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. SAORIC476

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