contig_metadata
8 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13131702 | 13131702 | PRJNA312615_P_NODE_20531_length_269_cov_1.181818_g20380_i0 | PRJNA312615 | 20531 | 269 | 1.181818 | 3.17909042 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 147 | 1.3799999999999999e-43 | NR | GJM17621.1 | 2202153 | g20380 | i0 | 77.4 | 0.936802973977695 | 84 | 19 | 93.7 | 0 | 2 | 253 | 52 | 135 | GJM17621.1 MAG: hypothetical protein DHS20C13_29480 [Thermodesulfobacteriota bacterium] | diamond | 252 | 147 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 25289919 | 25289919 | PRJNA312615_P_NODE_21580_length_262_cov_2.136150_g21429_i0 | PRJNA312615 | 21580 | 262 | 2.13615 | 5.596713 | Desulfobulbaceae bacterium BRH_c16a | 1629713 | Bacteria | Bacteria | 119 | 6.349999999999999e-30 | NR | KJS02832.1 | 1629713 | g21429 | i0 | 60.9 | 0.99618320610687 | 87 | 34 | 99.6 | 0 | 2 | 262 | 7 | 93 | KJS02832.1 MAG: hypothetical protein VR65_03850 [Desulfobulbaceae bacterium BRH_c16a] | diamond | 261 | 119 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium BRH_c16a | |||
| 26599119 | 26599119 | PRJNA312615_P_NODE_32421_length_215_cov_1.222892_g32270_i0 | PRJNA312615 | 32421 | 215 | 1.222892 | 2.6292178 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 86.3 | 6.4e-19 | NR | MBG0776896.1 | 2049043 | g32270 | i0 | 59.2 | 8.91627906976744 | 71 | 29 | 99.1 | 0 | 214 | 2 | 100 | 170 | MBG0776896.1 NAD(P)H:quinone oxidoreductase [Desulfovibrionaceae bacterium] | diamond | 1917 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 26789545 | 26789545 | PRJNA312615_P_NODE_12101_length_355_cov_4.535948_g11951_i0 | PRJNA312615 | 12101 | 355 | 4.535948 | 16.1026154 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 46.6 | 0.00387 | NR | GJM17643.1 | 2202153 | g11951 | i0 | 33.8 | 0.650704225352113 | 77 | 50 | 64.2 | 1 | 351 | 124 | 137 | 213 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 231 | 46.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27895421 | 27895421 | PRJNA312615_P_NODE_20365_length_270_cov_1.361991_g20214_i0 | PRJNA312615 | 20365 | 270 | 1.361991 | 3.6773757 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 61.6 | 4.29e-9 | NR | GJM17643.1 | 2202153 | g20214 | i0 | 35 | 0.888888888888889 | 80 | 51 | 87.8 | 1 | 239 | 3 | 133 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 240 | 61.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 28558734 | 28558734 | PRJNA312615_P_NODE_22847_length_255_cov_1.368932_g22696_i0 | PRJNA312615 | 22847 | 255 | 1.368932 | 3.4907766 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 54.7 | 1.85e-7 | NR | MDH3360097.1 | 2053307 | g22696 | i0 | 44.4 | 0.847058823529412 | 72 | 32 | 82.4 | 3 | 45 | 254 | 4 | 69 | MDH3360097.1 helix-turn-helix domain-containing protein [Desulfobulbaceae bacterium] | diamond | 216 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 30516577 | 30516577 | PRJNA312615_P_NODE_34253_length_209_cov_2.118750_g34102_i0 | PRJNA312615 | 34253 | 209 | 2.11875 | 4.4281875 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 68.6 | 1.88e-11 | NR | HAO22905.1 | 2049433 | g34102 | i0 | 46.5 | 1.01913875598086 | 71 | 35 | 97.6 | 1 | 3 | 206 | 286 | 356 | HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 213 | 68.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 32002510 | 32002510 | PRJNA312615_P_NODE_24438_length_247_cov_1.545455_g24287_i0 | PRJNA312615 | 24438 | 247 | 1.545455 | 3.81727385 | Syntrophorhabdus sp. PtaU1.Bin | 2699756 | Bacteria | Bacteria | 49.7 | 1.47e-4 | NR | OPY76594.1 | 1811703 | g24287 | i0 | 32.9 | 0.923076923076923 | 76 | 31 | 92.3 | 2 | 11 | 238 | 1369 | 1424 | OPY76594.1 MAG: tRNA nuclease WapA precursor [Syntrophorhabdus sp. PtaU1.Bin050] | diamond | 228 | 49.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdus | Syntrophorhabdus sp. PtaU1.Bin050 |
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);;