RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB36940", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJEB36940 · 7 ✖

analysis 1

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
19182358 19182358 PRJEB36940_P_NODE_8136_length_304_cov_1.004329_g8007_i0 PRJEB36940 8136 304 1.004329 3.05316016 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 89 4.63e-18   NR MCP4021495.1 2049433 g8007 i0 45.5 3.88815789473684 99 47 96.7 2 11 304 905 997 MCP4021495.1 PAS domain S-box protein [Desulfobacteraceae bacterium] diamond 1182 89 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
24282590 24282590 PRJEB36940_P_NODE_3520_length_453_cov_1.618421_g3392_i0 PRJEB36940 3520 453 1.618421 7.33144713 root 1 Root_unresolved Root_unresolved 202 1.56e-58   NR WP_073041514.1 35837 g3392 i0 63.3 6.86092715231788 147 54 97.4 0 13 453 66 212 WP_073041514.1 acetate--CoA ligase [Desulfacinum infernum] diamond 3108 204 0.990196078431373 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Desulfacinum Desulfacinum infernum
26716384 26716384 PRJEB36940_P_NODE_8181_length_303_cov_1.265217_g8052_i0 PRJEB36940 8181 303 1.265217 3.83360751 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 53.1 1.63e-5   NR HAO22905.1 2049433 g8052 i0 30.1 0.722772277227723 73 51 72.3 0 220 2 359 431 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 219 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28991603 28991603 PRJEB36940_P_NODE_12908_length_250_cov_1.745763_g12779_i0 PRJEB36940 12908 250 1.745763 4.3644075 Desulfobacteraceae bacterium 4572_88 1972444 Bacteria Bacteria 43.1 0.026   NR OQY57558.1 1972444 g12779 i0 28.8 1.74 80 57 96 0 10 249 121 200 OQY57558.1 MAG: hypothetical protein B6245_16380 [Desulfobacteraceae bacterium 4572_88] diamond 435 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium 4572_88
30823199 30823199 PRJEB36940_P_NODE_6614_length_335_cov_1.580153_g6485_i0 PRJEB36940 6614 335 1.580153 5.29351255 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 88.2 1.22e-17   NR HAO22905.1 2049433 g6485 i0 36.9 0.994029850746269 111 69 98.5 1 334 5 338 448 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 333 88.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31866417 31866417 PRJEB36940_P_NODE_97_length_1921_cov_2.182359_g72_i0 PRJEB36940 97 1921 2.182359 41.92311639 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 54.7 2.73e-4   NR GJM17643.1 2202153 g72 i0 24.6 0.356064549713691 228 143 34 9 1084 431 4 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 684 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31898201 31898201 PRJEB36940_P_NODE_12137_length_253_cov_1.722222_g12008_i0 PRJEB36940 12137 253 1.722222 4.35722166 Geobacteraceae bacterium 2282154 Bacteria Bacteria 42.7 0.0444   NR NVN99922.1 2282154 g12008 i0 32.6 1.09090909090909 92 50 94.9 3 246 7 300 391 NVN99922.1 CxxxxCH/CxxCH domain-containing protein [Geobacteraceae bacterium] diamond 276 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae 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);;