contig_metadata
10 rows where bioproject = "PRJNA1010662", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26781470 | 26781470 | PRJNA1010662_P_NODE_6841_length_213_cov_0.939024_g6782_i0 | PRJNA1010662 | 6841 | 213 | 0.939024 | 2.00012112 | Candidatus Magnetoglobus multicellularis str. Araruama | 890399 | Bacteria | Bacteria | 62 | 4.24e-9 | NR | ETR72215.1 | 890399 | g6782 | i0 | 46.5 | 1 | 71 | 34 | 94.4 | 1 | 213 | 13 | 2585 | 2655 | ETR72215.1 MAG: hypothetical protein OMM_01891 [Candidatus Magnetoglobus multicellularis str. Araruama] | diamond | 213 | 62 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Candidatus Magnetoglobus | Candidatus Magnetoglobus multicellularis | ||
| 28108259 | 28108259 | PRJNA1010662_P_NODE_5805_length_226_cov_1.519774_g5746_i0 | PRJNA1010662 | 5805 | 226 | 1.519774 | 3.43468924 | Solidesulfovibrio carbinoliphilus | 345370 | Bacteria | Bacteria | 42.7 | 0.0294 | NR | WP_009181637.1 | 345370 | g5746 | i0 | 34.4 | 1.63274336283186 | 64 | 41 | 85 | 1 | 209 | 18 | 634 | 696 | WP_009181637.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Solidesulfovibrio carbinoliphilus] | diamond | 369 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio carbinoliphilus | ||
| 28164139 | 28164139 | PRJNA1010662_P_NODE_10085_length_184_cov_1.155556_g10026_i0 | PRJNA1010662 | 10085 | 184 | 1.155556 | 2.12622304 | Pseudodesulfovibrio | 2035811 | Bacteria | Bacteria | 53.5 | 2.66e-6 | NR | WP_151151543.1 | 1721087 | g10026 | i0 | 63.6 | 11.2663043478261 | 33 | 12 | 53.8 | 0 | 100 | 2 | 3 | 35 | WP_151151543.1 molecular chaperone HtpG [Pseudodesulfovibrio senegalensis] | diamond | 2073 | 53.9 | 0.992578849721707 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio senegalensis | ||
| 28424279 | 28424279 | PRJNA1010662_P_NODE_13766_length_167_cov_0.864407_g13707_i0 | PRJNA1010662 | 13766 | 167 | 0.864407 | 1.44355969 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 72 | 6.06e-13 | NR | MDH3956896.1 | 2049433 | g13707 | i0 | 61.1 | 0.970059880239521 | 54 | 21 | 97 | 0 | 163 | 2 | 139 | 192 | MDH3956896.1 aldehyde dehydrogenase family protein [Desulfobacteraceae bacterium] | diamond | 162 | 72 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28448435 | 28448435 | PRJNA1010662_P_NODE_5566_length_230_cov_1.143646_g5507_i0 | PRJNA1010662 | 5566 | 230 | 1.143646 | 2.6303858 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.3 | 1.35e-11 | NR | HIQ37704.1 | 65555 | g5507 | i0 | 66 | 9.31304347826087 | 47 | 16 | 61.3 | 0 | 228 | 88 | 528 | 574 | HIQ37704.1 endopeptidase La [Desulfocapsa sulfexigens] | diamond | 2142 | 69.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfocapsa | Desulfocapsa sulfexigens | ||
| 29497659 | 29497659 | PRJNA1010662_P_NODE_8190_length_199_cov_1.373333_g8131_i0 | PRJNA1010662 | 8190 | 199 | 1.373333 | 2.73293267 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 97.4 | 9.87e-22 | NR | MCG8566149.1 | 2044940 | g8131 | i0 | 64.6 | 9.78391959798995 | 65 | 23 | 98 | 0 | 198 | 4 | 268 | 332 | MCG8566149.1 aldehyde dehydrogenase family protein [Desulfobacterales bacterium] | diamond | 1947 | 97.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30343522 | 30343522 | PRJNA1010662_P_NODE_15572_length_164_cov_0.895652_g15513_i0 | PRJNA1010662 | 15572 | 164 | 0.895652 | 1.46886928 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.2 | 1.3e-5 | NR | SPD73104.1 | 201089 | g15513 | i0 | 48 | 9.65853658536585 | 50 | 26 | 91.5 | 0 | 163 | 14 | 444 | 493 | SPD73104.1 Calcium-transporting ATPase [uncultured Desulfobacterium sp.] | diamond | 1584 | 51.6 | 0.992248062015504 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteriaceae | Desulfobacterium | uncultured Desulfobacterium sp. | ||
| 30666379 | 30666379 | PRJNA1010662_P_NODE_14113_length_166_cov_0.888889_g14054_i0 | PRJNA1010662 | 14113 | 166 | 0.888889 | 1.47555574 | Syntrophorhabdus sp. PtaB.Bin | 2699756 | Bacteria | Bacteria | 61.2 | 3.8e-9 | NR | OPY01682.1 | 1811700 | g14054 | i0 | 56.3 | 1.73493975903614 | 48 | 21 | 86.7 | 0 | 152 | 9 | 638 | 685 | OPY01682.1 MAG: Prenyltransferase and squalene oxidase repeat protein [Syntrophorhabdus sp. PtaB.Bin047] | diamond | 288 | 61.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdus | Syntrophorhabdus sp. PtaB.Bin047 | ||
| 30729609 | 30729609 | PRJNA1010662_P_NODE_4474_length_251_cov_1.004950_g4415_i0 | PRJNA1010662 | 4474 | 251 | 1.00495 | 2.5224245 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 43.1 | 0.0301 | NR | MDR1776801.1 | 885 | g4415 | i0 | 34.2 | 0.944223107569721 | 79 | 44 | 86.1 | 3 | 246 | 31 | 492 | 569 | MDR1776801.1 amylo-alpha-1,6-glucosidase [Desulfovibrio sp.] | diamond | 237 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 31132569 | 31132569 | PRJNA1010662_P_NODE_16615_length_162_cov_0.920354_g16556_i0 | PRJNA1010662 | 16615 | 162 | 0.920354 | 1.49097348 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 49.3 | 4.16e-5 | NR | MBP1752792.1 | 2282154 | g16556 | i0 | 37.7 | 1.90740740740741 | 53 | 33 | 98.1 | 0 | 162 | 4 | 133 | 185 | MBP1752792.1 SCP-like extracellular lipoprotein [Geobacteraceae bacterium] | diamond | 309 | 49.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae 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);;