RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA1067370 · 4 ✖

analysis 1

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
7833633 7833633 PRJNA1067370_P_NODE_79907_length_251_cov_0.865169_g79358_i0 PRJNA1067370 79907 251 0.865169 2.17157419 Salinibacter grassmerensis 3040353 Bacteria Bacteria 75.9 1.09e-14   NR WP_263786762.1 3040353 g79358 i0 67.3 0.585657370517928 49 16 58.6 0 245 99 154 202 WP_263786762.1 RdgB/HAM1 family non-canonical purine NTP pyrophosphatase [Salinibacter grassmerensis] diamond 147 75.9 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter grassmerensis
9108186 9108186 PRJNA1067370_P_NODE_111508_length_242_cov_0.911243_g110959_i0 PRJNA1067370 111508 242 0.911243 2.20520806 FCB group 1783270 Bacteria Bacteria 80.1 3.06e-17   NR WP_281253282.1 1850348 g110959 i0 61.9 2.34297520661157 63 24 78.1 0 240 52 50 112 WP_281253282.1 type II toxin-antitoxin system death-on-curing family toxin [Longibacter salinarum] diamond 567 80.1 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salisaetaceae Longibacter Longibacter salinarum
10384373 10384373 PRJNA1067370_P_NODE_78029_length_253_cov_0.905556_g77480_i0 PRJNA1067370 78029 253 0.905556 2.29105668 Rhodothermales bacterium 2306054 Bacteria Bacteria 162 3.83e-44   NR HYE56907.1 2306054 g77480 i0 90.5 0.99604743083004 84 8 99.6 0 2 253 241 324 HYE56907.1 maltose alpha-D-glucosyltransferase [Rhodothermales bacterium] diamond 252 162 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales bacterium
32027134 32027134 PRJNA1067370_P_NODE_56838_length_285_cov_1.028302_g56289_i0 PRJNA1067370 56838 285 1.028302 2.9306607 Rhodothermales bacterium 2306054 Bacteria Bacteria 99.8 1.13e-23   NR MBE2186093.1 2306054 g56289 i0 76.6 0.673684210526316 64 15 67.4 0 93 284 1 64 MBE2186093.1 50S ribosomal protein L3 [Rhodothermales bacterium] diamond 192 99.8 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales 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);;