RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1146029" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1146029 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26647755 26647755 PRJNA1146029_P_NODE_22301_length_241_cov_0.916667_g22020_i0 PRJNA1146029 22301 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 56.2 5.03e-8   NR KJR99241.1 1629713 g22020 i0 62.9 0.921161825726141 35 13 43.6 0 137 241 5 39 KJR99241.1 MAG: hypothetical protein VR65_17770 [Desulfobulbaceae bacterium BRH_c16a] diamond 222 56.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium BRH_c16a
26995959 26995959 PRJNA1146029_P_NODE_18142_length_248_cov_0.880000_g17861_i0 PRJNA1146029 18142 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 52.8 1.16e-5   NR OGR05534.1 1797908 g17861 i0 66.7 6.50806451612903 39 13 47.2 0 118 2 342 380 OGR05534.1 MAG: hypothetical protein A3K23_03625 [Desulfobacca sp. RBG_16_58_9] diamond 1614 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobaccia Desulfobaccales Desulfobaccaceae Desulfobacca Desulfobacca sp. RBG_16_58_9
27828737 27828737 PRJNA1146029_P_NODE_20404_length_244_cov_0.900585_g20123_i0 PRJNA1146029 20404 244 0.900585 2.1974274 Geobacter sp. AOG2 1566347 Bacteria Bacteria 85.1 3.23e-17   NR WP_223923840.1 1566347 g20123 i0 62.5 0.885245901639344 72 26 88.5 1 221 6 223 293 WP_223923840.1 DUF3443 domain-containing protein [Geobacter sp. AOG2] diamond 216 85.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. AOG2
28302289 28302289 PRJNA1146029_P_NODE_9906_length_290_cov_1.847926_g9625_i0 PRJNA1146029 9906 290 1.847926 5.3589854 Geobacterales bacterium 3069300 Bacteria Bacteria 80.5 8.89e-17   NR HWJ18406.1 3069300 g9625 i0 52.1 1.5 73 30 71.4 2 82 288 73 144 HWJ18406.1 NAD(P)H-dependent oxidoreductase [Geobacterales bacterium] diamond 435 80.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales     Geobacterales bacterium
28681376 28681376 PRJNA1146029_P_NODE_21987_length_241_cov_0.916667_g21706_i0 PRJNA1146029 21987 241 0.916667 2.20916747 Desulfuromonadaceae bacterium 2099677 Bacteria Bacteria 116 1.82e-28   NR MDD2735105.1 2099677 g21706 i0 70.9 4.91701244813278 79 23 98.3 0 3 239 246 324 MDD2735105.1 glucose-6-phosphate dehydrogenase [Desulfuromonadaceae bacterium] diamond 1185 116 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae   Desulfuromonadaceae bacterium
28827790 28827790 PRJNA1146029_P_NODE_10408_length_288_cov_1.102326_g10127_i0 PRJNA1146029 10408 288 1.102326 3.17469888 Pseudomonadati 3379134 Bacteria Bacteria 103 1.8899999999999994e-23   NR WP_066722783.1 1823759 g10127 i0 53.2 4.78125 94 44 97.9 0 282 1 333 426 WP_066722783.1 OprO/OprP family phosphate-selective porin [Desulfuromonas sp. DDH964] diamond 1377 104 0.990384615384615 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964
30544549 30544549 PRJNA1146029_P_NODE_18173_length_248_cov_0.880000_g17892_i0 PRJNA1146029 18173 248 0.88 2.1824 Geomonas propionica 2798582 Bacteria Bacteria 71.2 3.6e-12   NR WP_199397193.1 2798582 g17892 i0 46.3 2.9758064516129 82 40 94.4 1 15 248 191 272 WP_199397193.1 protease pro-enzyme activation domain-containing protein [Geomonas propionica] diamond 738 71.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas propionica
30797181 30797181 PRJNA1146029_P_NODE_11754_length_280_cov_1.009662_g11473_i0 PRJNA1146029 11754 280 1.009662 2.8270536 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.5 0.0296   NR MCP4692261.1 2044940 g11473 i0 35 0.857142857142857 80 52 85.7 0 41 280 269 348 MCP4692261.1 DUF4401 domain-containing protein [Desulfobacterales bacterium] diamond 240 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;