contig_metadata
12 rows where bioproject = "PRJNA674050", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1920538 | 1920538 | PRJNA674050_P_NODE_5662_length_341_cov_0.962687_g5459_i0 | PRJNA674050 | 5662 | 341 | 0.962687 | 3.28276267 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 225 | 2.19e-71 | NR | MBF0235920.1 | 2006184 | g5459 | i0 | 93.8 | 7.95307917888563 | 113 | 7 | 99.4 | 0 | 341 | 3 | 129 | 241 | MBF0235920.1 site-specific DNA-methyltransferase [Desulfamplus sp.] | diamond | 2712 | 225 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfamplus | Desulfamplus sp. | ||
| 3194593 | 3194593 | PRJNA674050_P_NODE_2443_length_439_cov_3.002732_g2240_i0 | PRJNA674050 | 2443 | 439 | 3.002732 | 13.18199348 | Thermodesulfobacterium commune | 1741 | Bacteria | Bacteria | 298 | 4.94e-76 | NTclustered | gi|668351138|gb|CP008796.1| | 289377 | g2240 | i0 | 86.594 | 57.8382687927107 | 276 | 30 | 63 | 5 | 165 | 439 | 1298589 | 1298858 | Thermodesulfobacterium commune DSM 2178, complete genome | blastn | 25391 | 298 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Thermodesulfobacterium | Thermodesulfobacterium commune | ||
| 8297273 | 8297273 | PRJNA674050_P_NODE_30827_length_247_cov_0.890805_g30624_i0 | PRJNA674050 | 30827 | 247 | 0.890805 | 2.20028835 | Nitratidesulfovibrio liaohensis | 2604158 | Bacteria | Bacteria | 412 | 8.89e-111 | NTclustered | gi|2575677524|gb|CP133659.1| | 2604158 | g30624 | i0 | 96.761 | 1.80566801619433 | 247 | 8 | 100 | 0 | 1 | 247 | 2830168 | 2829922 | Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome | blastn | 446 | 412 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio liaohensis | ||
| 12122947 | 12122947 | PRJNA674050_P_NODE_22830_length_252_cov_0.871508_g22627_i0 | PRJNA674050 | 22830 | 252 | 0.871508 | 2.19620016 | Nitratidesulfovibrio liaohensis | 2604158 | Bacteria | Bacteria | 346 | 9.36e-91 | NTclustered | gi|2575677524|gb|CP133659.1| | 2604158 | g22627 | i0 | 92.857 | 1.85714285714286 | 238 | 17 | 94 | 0 | 1 | 238 | 3414109 | 3413872 | Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome | blastn | 468 | 346 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio liaohensis | ||
| 18496689 | 18496689 | PRJNA674050_P_NODE_39895_length_242_cov_0.911243_g39692_i0 | PRJNA674050 | 39895 | 242 | 0.911243 | 2.20520806 | Nitratidesulfovibrio liaohensis | 2604158 | Bacteria | Bacteria | 281 | 2.55e-71 | NTclustered | gi|2575677524|gb|CP133659.1| | 2604158 | g39692 | i0 | 91.262 | 1.71900826446281 | 206 | 18 | 85 | 0 | 1 | 206 | 1455146 | 1455351 | Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome | blastn | 416 | 281 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio liaohensis | ||
| 27030386 | 27030386 | PRJNA674050_P_NODE_3462_length_388_cov_3.269841_g3259_i0 | PRJNA674050 | 3462 | 388 | 3.269841 | 12.68698308 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 0.0037 | NR | WP_092161253.1 | 246191 | g3259 | i0 | 37.3 | 2.61340206185567 | 75 | 44 | 55.7 | 1 | 221 | 6 | 74 | 148 | WP_092161253.1 PhoH family protein [Maridesulfovibrio ferrireducens] | diamond | 1014 | 47.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Maridesulfovibrio | Maridesulfovibrio ferrireducens | ||
| 27524127 | 27524127 | PRJNA674050_P_NODE_24063_length_251_cov_0.876404_g23860_i0 | PRJNA674050 | 24063 | 251 | 0.876404 | 2.19977404 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 94.7 | 1.7400000000000003e-21 | NR | MEF8942476.1 | 2683721 | g23860 | i0 | 86.5 | 0.621513944223108 | 52 | 7 | 62.2 | 0 | 3 | 158 | 43 | 94 | MEF8942476.1 1-deoxy-D-xylulose-5-phosphate synthase N-terminal domain-containing protein [Desulfohalobiaceae bacterium] | diamond | 156 | 94.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 27808532 | 27808532 | PRJNA674050_P_NODE_824_length_762_cov_5.088534_g646_i0 | PRJNA674050 | 824 | 762 | 5.088534 | 38.77462908 | Smithella sp. | 2053614 | Bacteria | Bacteria | 76.3 | 7.68e-14 | NR | MFA5323714.1 | 2053614 | g646 | i0 | 42.3 | 0.755905511811024 | 97 | 49 | 37 | 4 | 536 | 255 | 5 | 97 | MFA5323714.1 hypothetical protein [Smithella sp.] | diamond | 576 | 76.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 28945232 | 28945232 | PRJNA674050_P_NODE_12168_length_288_cov_0.911628_g11965_i0 | PRJNA674050 | 12168 | 288 | 0.911628 | 2.62548864 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 70.5 | 9.7e-12 | NR | MCF8030237.1 | 2683721 | g11965 | i0 | 84.2 | 0.395833333333333 | 38 | 6 | 39.6 | 0 | 283 | 170 | 352 | 389 | MCF8030237.1 alanine transaminase [Desulfohalobiaceae bacterium] | diamond | 114 | 70.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 29197709 | 29197709 | PRJNA674050_P_NODE_26349_length_250_cov_0.870056_g26146_i0 | PRJNA674050 | 26349 | 250 | 0.870056 | 2.17514 | Geobacter sp. | 46610 | Bacteria | Bacteria | 45.4 | 0.00444 | NR | MSM40314.1 | 46610 | g26146 | i0 | 35.7 | 0.84 | 70 | 35 | 81.6 | 2 | 10 | 213 | 165 | 226 | MSM40314.1 methyltransferase domain-containing protein [Geobacter sp.] | diamond | 210 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. | ||
| 29765722 | 29765722 | PRJNA674050_P_NODE_2351_length_445_cov_2.680108_g2148_i0 | PRJNA674050 | 2351 | 445 | 2.680108 | 11.9264806 | Desulfobulbus sp. | 895 | Bacteria | Bacteria | 77.8 | 6.46e-15 | NR | MDD2462441.1 | 895 | g2148 | i0 | 50.6 | 0.546067415730337 | 81 | 39 | 54.6 | 1 | 72 | 314 | 74 | 153 | MDD2462441.1 hypothetical protein [Desulfobulbus sp.] | diamond | 243 | 77.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 32622743 | 32622743 | PRJNA674050_P_NODE_24020_length_251_cov_0.876404_g23817_i0 | PRJNA674050 | 24020 | 251 | 0.876404 | 2.19977404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 119 | 6.41e-29 | NR | WP_196772829.1 | 2661613 | g23817 | i0 | 69.5 | 2.96414342629482 | 82 | 25 | 98 | 0 | 249 | 4 | 204 | 285 | WP_196772829.1 TonB-dependent receptor domain-containing protein [Pseudodesulfovibrio alkaliphilus] | diamond | 744 | 119 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio alkaliphilus |
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);;