contig_metadata
12 rows where bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2426205 | 2426205 | PRJNA627467_P_NODE_902_length_378_cov_4.787234_g835_i0 | PRJNA627467 | 902 | 378 | 4.787234 | 18.09574452 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 484 | 2.9999999999999993e-132 | NTclustered | gi|2045533567|gb|CP074693.1| | 35554 | g835 | i0 | 99.623 | 50.6031746031746 | 265 | 1 | 80 | 0 | 114 | 378 | 81527 | 81791 | Geobacter sulfurreducens strain YM35 chromosome, complete genome | blastn | 19128 | 484 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 7528642 | 7528642 | PRJNA627467_P_NODE_20486_length_156_cov_3.074766_g20417_i0 | PRJNA627467 | 20486 | 156 | 3.074766 | 4.79663496 | Geobacter | 28231 | Bacteria | Bacteria | 60.2 | 7.68e-5 | NTclustered | gi|470477521|ref|NR_076389.1| | 28232 | g20417 | i0 | 100 | 0.615384615384615 | 32 | 0 | 21 | 0 | 17 | 48 | 1184 | 1215 | Geobacter metallireducens strain GS-15 23S ribosomal RNA gene, complete sequence | blastn | 96 | 60.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter metallireducens | ||
| 8252329 | 8252329 | PRJNA627467_P_NODE_17587_length_164_cov_2.878261_g17518_i0 | PRJNA627467 | 17587 | 164 | 2.878261 | 4.72034804 | Desulfonema limicola | 45656 | Bacteria | Bacteria | 241 | 2.72e-59 | NTclustered | gi|2007129425|gb|CP061799.1| | 45656 | g17518 | i0 | 94.268 | 163.310975609756 | 157 | 9 | 98 | 0 | 5 | 161 | 1685519 | 1685675 | Desulfonema limicola strain 5ac10 chromosome, complete genome | blastn | 26783 | 241 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfonema | Desulfonema limicola | ||
| 21552617 | 21552617 | PRJNA627467_P_NODE_10577_length_185_cov_6.227941_g10508_i0 | PRJNA627467 | 10577 | 185 | 6.227941 | 11.52169085 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 326 | 8.430000000000001e-85 | NTclustered | gi|2045533567|gb|CP074693.1| | 35554 | g10508 | i0 | 99.441 | 54.0432432432432 | 179 | 1 | 97 | 0 | 5 | 183 | 81563 | 81385 | Geobacter sulfurreducens strain YM35 chromosome, complete genome | blastn | 9998 | 326 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 27901669 | 27901669 | PRJNA627467_P_NODE_3905_length_316_cov_1.898876_g3837_i0 | PRJNA627467 | 3905 | 316 | 1.898876 | 6.00044816 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 62.8 | 3.53e-9 | NR | MCP3898609.1 | 2049433 | g3837 | i0 | 84.4 | 0.607594936708861 | 32 | 5 | 30.4 | 0 | 312 | 217 | 178 | 209 | MCP3898609.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 192 | 62.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29101738 | 29101738 | PRJNA627467_P_NODE_12028_length_181_cov_1.424242_g11959_i0 | PRJNA627467 | 12028 | 181 | 1.424242 | 2.57787802 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 109 | 5.870000000000001e-29 | NR | KPA10458.1 | 1509431 | g11959 | i0 | 94.4 | 0.895027624309392 | 54 | 3 | 89.5 | 0 | 179 | 18 | 22 | 75 | KPA10458.1 hypothetical protein MHK_009337, partial [Candidatus Magnetomorum sp. HK-1] | diamond | 162 | 109 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 29606442 | 29606442 | PRJNA627467_P_NODE_10450_length_186_cov_1.875912_g10381_i0 | PRJNA627467 | 10450 | 186 | 1.875912 | 3.48919632 | Desulfoplanes sp. | 3018273 | Bacteria | Bacteria | 89 | 8.83e-19 | NR | MFA7166296.1 | 3018273 | g10381 | i0 | 70.7 | 0.935483870967742 | 58 | 17 | 93.5 | 0 | 184 | 11 | 83 | 140 | MFA7166296.1 DEAD/DEAH box helicase [Desulfoplanes sp.] | diamond | 174 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfoplanaceae | Desulfoplanes | Desulfoplanes sp. | ||
| 30112102 | 30112102 | PRJNA627467_P_NODE_9632_length_189_cov_1.450000_g9563_i0 | PRJNA627467 | 9632 | 189 | 1.45 | 2.7405 | Geomonas sp. | 2651584 | Bacteria | Bacteria | 56.2 | 3.16e-7 | NR | HEY5514549.1 | 2651584 | g9563 | i0 | 44.3 | 1.95238095238095 | 61 | 34 | 96.8 | 0 | 4 | 186 | 269 | 329 | HEY5514549.1 hypothetical protein [Geomonas sp.] | diamond | 369 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas sp. | ||
| 30238591 | 30238591 | PRJNA627467_P_NODE_5532_length_316_cov_1.539326_g5464_i0 | PRJNA627467 | 5532 | 316 | 1.539326 | 4.86427016 | Syntrophobacter fumaroxidans | 119484 | Bacteria | Bacteria | 58.5 | 8.43e-8 | NR | WP_011698751.1 | 119484 | g5464 | i0 | 75.8 | 0.626582278481013 | 33 | 8 | 31.3 | 0 | 315 | 217 | 97 | 129 | WP_011698751.1 hypothetical protein [Syntrophobacter fumaroxidans] | diamond | 198 | 58.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter fumaroxidans | ||
| 30680684 | 30680684 | PRJNA627467_P_NODE_1053_length_359_cov_4.916129_g986_i0 | PRJNA627467 | 1053 | 359 | 4.916129 | 17.64890311 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 54.7 | 1.75e-6 | NR | KPA10458.1 | 1509431 | g986 | i0 | 73.5 | 0.284122562674095 | 34 | 9 | 28.4 | 0 | 102 | 1 | 1 | 34 | KPA10458.1 hypothetical protein MHK_009337, partial [Candidatus Magnetomorum sp. HK-1] | diamond | 102 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 30902144 | 30902144 | PRJNA627467_P_NODE_19554_length_160_cov_3.711712_g19485_i0 | PRJNA627467 | 19554 | 160 | 3.711712 | 5.9387392 | Trichloromonas sp. | 3069249 | Bacteria | Bacteria | 59.3 | 1.66e-8 | NR | MDY0269059.1 | 3069249 | g19485 | i0 | 77.1 | 0.65625 | 35 | 8 | 65.6 | 0 | 158 | 54 | 1202 | 1236 | MDY0269059.1 hypothetical protein [Trichloromonas sp.] | diamond | 105 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Trichloromonadaceae | Trichloromonas | Trichloromonas sp. | ||
| 31249612 | 31249612 | PRJNA627467_P_NODE_7975_length_218_cov_2.071006_g7906_i0 | PRJNA627467 | 7975 | 218 | 2.071006 | 4.51479308 | Smithella sp. | 2053614 | Bacteria | Bacteria | 97.8 | 1.49e-22 | NR | MEN6420691.1 | 2053614 | g7906 | i0 | 68.1 | 0.94954128440367 | 69 | 22 | 95 | 0 | 216 | 10 | 101 | 169 | MEN6420691.1 MT-A70 family methyltransferase [Smithella sp.] | diamond | 207 | 97.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. |
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);;