RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA674050 · 4 ✖

analysis 1

  • blastn · 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
3194593 3194593 PRJNA674050_P_NODE_2443_length_439_cov_3.002732_g2240_i0 PRJNA674050 2443 439 3.002732 13.18199348 Thermodesulfobacterium commune 1741 Bacteria Bacteria 298 4.94e-76   NTclustered gi|668351138|gb|CP008796.1| 289377 g2240 i0 86.594 57.8382687927107 276 30 63 5 165 439 1298589 1298858 Thermodesulfobacterium commune DSM 2178, complete genome blastn 25391 298 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium commune
8297273 8297273 PRJNA674050_P_NODE_30827_length_247_cov_0.890805_g30624_i0 PRJNA674050 30827 247 0.890805 2.20028835 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 412 8.89e-111   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g30624 i0 96.761 1.80566801619433 247 8 100 0 1 247 2830168 2829922 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 446 412 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
12122947 12122947 PRJNA674050_P_NODE_22830_length_252_cov_0.871508_g22627_i0 PRJNA674050 22830 252 0.871508 2.19620016 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 346 9.36e-91   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g22627 i0 92.857 1.85714285714286 238 17 94 0 1 238 3414109 3413872 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 468 346 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
18496689 18496689 PRJNA674050_P_NODE_39895_length_242_cov_0.911243_g39692_i0 PRJNA674050 39895 242 0.911243 2.20520806 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 281 2.55e-71   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g39692 i0 91.262 1.71900826446281 206 18 85 0 1 206 1455146 1455351 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 416 281 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis

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