contig_metadata
11 rows where bioproject = "PRJNA1146029", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6136442 | 6136442 | PRJNA1146029_P_NODE_10265_length_289_cov_0.856481_g9984_i0 | PRJNA1146029 | 10265 | 289 | 0.856481 | 2.47523009 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 518 | 2.19e-142 | NTclustered | gi|779731694|gb|CP010430.1| | 35554 | g9984 | i0 | 98.962 | 17 | 289 | 3 | 100 | 0 | 1 | 289 | 3978777 | 3978489 | Geobacter sulfurreducens strain AM-1 genome | blastn | 4913 | 523 | 0.990439770554493 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 14318960 | 14318960 | PRJNA1146029_P_NODE_14792_length_259_cov_1.241935_g14511_i0 | PRJNA1146029 | 14792 | 259 | 1.241935 | 3.21661165 | Geoalkalibacter subterraneus | 483547 | Bacteria | Bacteria | 329 | 9.73e-86 | NTclustered | gi|749207097|gb|CP010311.1| | 483547 | g14511 | i0 | 89.575 | 2.94208494208494 | 259 | 27 | 100 | 0 | 1 | 259 | 968691 | 968949 | Geoalkalibacter subterraneus strain Red1, complete genome | blastn | 762 | 329 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geoalkalibacteraceae | Geoalkalibacter | Geoalkalibacter subterraneus | ||
| 20691693 | 20691693 | PRJNA1146029_P_NODE_3537_length_454_cov_1.503937_g3259_i0 | PRJNA1146029 | 3537 | 454 | 1.503937 | 6.82787398 | Desulfosediminicola ganghwensis | 2569540 | Bacteria | Bacteria | 54.7 | 0.012 | NTclustered | gi|1861338669|gb|CP050699.1| | 2569540 | g3259 | i0 | 100 | 0.0638766519823789 | 29 | 0 | 6 | 0 | 327 | 355 | 4734436 | 4734464 | Desulfosediminicola ganghwensis strain IMCC35004 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfosediminicola | Desulfosediminicola ganghwensis | ||
| 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
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);;