contig_metadata
6 rows where bioproject = "PRJNA495917", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17054922 | 17054922 | PRJNA495917_S_NODE_7954_length_188_cov_48.300654_g7760_i0 | PRJNA495917 | 7954 | 188 | 48.300654 | 90.80522952 | Geomonas subterranea | 2847989 | Bacteria | Bacteria | 174 | 3.3e-39 | NTclustered | gi|2060227305|gb|CP077683.1| | 2847989 | g7760 | i0 | 86.335 | 241.712765957447 | 161 | 20 | 85 | 1 | 29 | 187 | 2777185 | 2777345 | Geomonas subterranea strain RG2 chromosome, complete genome | blastn | 45442 | 174 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas subterranea | ||
| 18329145 | 18329145 | PRJNA495917_S_NODE_295_length_780_cov_29.989262_g185_i0 | PRJNA495917 | 295 | 780 | 29.989262 | 233.9162436 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 309 | 4.2e-79 | NTclustered | gi|2556892445|gb|CP129479.1| | 2202153 | g185 | i0 | 77.449 | 106.338461538462 | 541 | 106 | 69 | 14 | 246 | 780 | 886705 | 887235 | MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome | blastn | 82944 | 309 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 19603419 | 19603419 | PRJNA495917_S_NODE_15956_length_152_cov_1.367521_g15762_i0 | PRJNA495917 | 15956 | 152 | 1.367521 | 2.07863192 | Geobacter sp. SVR | 2495594 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|1976315905|dbj|AP024469.1| | 2495594 | g15762 | i0 | 83.333 | 0.434210526315789 | 66 | 5 | 41 | 4 | 75 | 137 | 831769 | 831707 | Geobacter sp. SVR DNA, complete genome | blastn | 66 | 56.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. SVR | ||
| 22785086 | 22785086 | PRJNA495917_S_NODE_898_length_494_cov_25.071895_g16_i2 | PRJNA495917 | 898 | 494 | 25.071895 | 123.8551613 | Desulfobulbaceae | 213121 | Bacteria | Bacteria | 339 | 3.3099999999999997e-88 | NTclustered | gi|2621704320|emb|OY760916.1| | 239745 | g16 | i2 | 79.762 | 551.609311740891 | 504 | 73 | 99 | 26 | 1 | 492 | 394853 | 395339 | MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1 | blastn | 272495 | 339 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | uncultured Desulfobulbus sp. | ||
| 27266673 | 27266673 | PRJNA495917_S_NODE_6563_length_202_cov_1.197605_g6369_i0 | PRJNA495917 | 6563 | 202 | 1.197605 | 2.4191621 | Megalodesulfovibrio gigas | 879 | Bacteria | Bacteria | 67.4 | 4.27e-11 | NR | WP_051286656.1 | 879 | g6369 | i0 | 55.6 | 0.935643564356436 | 63 | 28 | 93.6 | 0 | 200 | 12 | 131 | 193 | WP_051286656.1 FkbM family methyltransferase [Megalodesulfovibrio gigas] | diamond | 189 | 67.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Megalodesulfovibrio | Megalodesulfovibrio gigas | ||
| 28040156 | 28040156 | PRJNA495917_S_NODE_8245_length_186_cov_1.589404_g8051_i0 | PRJNA495917 | 8245 | 186 | 1.589404 | 2.95629144 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 2.68e-6 | NR | MBI5519820.1 | 885 | g8051 | i0 | 49.2 | 3.46774193548387 | 61 | 28 | 95.2 | 2 | 6 | 182 | 627 | 686 | MBI5519820.1 DNA polymerase I [Desulfovibrio sp.] | diamond | 645 | 53.9 | 0.992578849721707 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio 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);;