contig_metadata
17 rows where bioproject = "PRJNA1156092", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6680651 | 6680651 | PRJNA1156092_P_NODE_23006_length_250_cov_0.870056_g22876_i0 | PRJNA1156092 | 23006 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 157 | 2.7499999999999993e-42 | NR | MDZ7780498.1 | 2026742 | g22876 | i0 | 80.5 | 4.92 | 82 | 16 | 98.4 | 0 | 248 | 3 | 509 | 590 | MDZ7780498.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium] | diamond | 1230 | 158 | 0.993670886075949 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 16879924 | 16879924 | PRJNA1156092_P_NODE_25614_length_248_cov_0.880000_g25484_i0 | PRJNA1156092 | 25614 | 248 | 0.88 | 2.1824 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 183 | 7.62e-42 | NTclustered | gi|2893358392|emb|OZ220683.1| | 2026742 | g25484 | i0 | 80.162 | 2.90322580645161 | 247 | 47 | 99 | 2 | 3 | 248 | 1007055 | 1007300 | MAG: Gemmatimonadota bacterium isolate c4f6f2ca-7934-440c-833b-e1b430e415c5 genome assembly, chromosome: 1 | blastn | 720 | 183 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 19428869 | 19428869 | PRJNA1156092_P_NODE_24196_length_249_cov_0.875000_g24066_i0 | PRJNA1156092 | 24196 | 249 | 0.875 | 2.17875 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 124 | 1.41e-33 | NR | MCL7960903.1 | 2026742 | g24066 | i0 | 74.1 | 1.95180722891566 | 81 | 21 | 97.6 | 0 | 7 | 249 | 37 | 117 | MCL7960903.1 RecX family transcriptional regulator [Gemmatimonadota bacterium] | diamond | 486 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26755169 | 26755169 | PRJNA1156092_P_NODE_27461_length_246_cov_0.890173_g27331_i0 | PRJNA1156092 | 27461 | 246 | 0.890173 | 2.18982558 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 160 | 1.09e-45 | NR | MEJ2203189.1 | 2026742 | g27331 | i0 | 92.7 | 2 | 82 | 6 | 100 | 0 | 1 | 246 | 154 | 235 | MEJ2203189.1 Gfo/Idh/MocA family oxidoreductase [Gemmatimonadota bacterium] | diamond | 492 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28051029 | 28051029 | PRJNA1156092_P_NODE_28685_length_245_cov_0.895349_g28555_i0 | PRJNA1156092 | 28685 | 245 | 0.895349 | 2.19360505 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 62 | 6.06e-9 | NR | HEY5413443.1 | 2026741 | g28555 | i0 | 47.1 | 1.73877551020408 | 70 | 37 | 85.7 | 0 | 240 | 31 | 373 | 442 | HEY5413443.1 sigma-70 family RNA polymerase sigma factor [Gemmatimonadaceae bacterium] | diamond | 426 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28935189 | 28935189 | PRJNA1156092_P_NODE_30428_length_243_cov_0.905882_g30298_i0 | PRJNA1156092 | 30428 | 243 | 0.905882 | 2.20129326 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 144 | 3.35e-41 | NR | MBK5099078.1 | 2026742 | g30298 | i0 | 87.5 | 0.987654320987654 | 80 | 10 | 98.8 | 0 | 3 | 242 | 60 | 139 | MBK5099078.1 ATP-binding cassette domain-containing protein [Gemmatimonadota bacterium] | diamond | 240 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29093142 | 29093142 | PRJNA1156092_P_NODE_24068_length_249_cov_0.875000_g23938_i0 | PRJNA1156092 | 24068 | 249 | 0.875 | 2.17875 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 140 | 1.0699999999999998e-37 | NR | HSM62276.1 | 2910168 | g23938 | i0 | 86.6 | 0.987951807228916 | 82 | 11 | 98.8 | 0 | 2 | 247 | 44 | 125 | HSM62276.1 sugar ABC transporter substrate-binding protein [Longimicrobiales bacterium] | diamond | 246 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 29250681 | 29250681 | PRJNA1156092_P_NODE_31769_length_242_cov_0.905325_g31639_i0 | PRJNA1156092 | 31769 | 242 | 0.905325 | 2.1908865 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 98.2 | 3.84e-23 | NR | UCF41682.1 | 2026742 | g31639 | i0 | 80.4 | 0.694214876033058 | 56 | 11 | 69.4 | 0 | 5 | 172 | 172 | 227 | UCF41682.1 MAG: FKBP-type peptidyl-prolyl cis-trans isomerase [Gemmatimonadota bacterium] | diamond | 168 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29660901 | 29660901 | PRJNA1156092_P_NODE_30710_length_243_cov_0.905882_g30580_i0 | PRJNA1156092 | 30710 | 243 | 0.905882 | 2.20129326 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 147 | 2e-39 | NR | MBK92525.1 | 2026742 | g30580 | i0 | 88.8 | 7.90123456790123 | 80 | 9 | 98.8 | 0 | 242 | 3 | 490 | 569 | MBK92525.1 gamma-glutamyltransferase [Gemmatimonadota bacterium] | diamond | 1920 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30134770 | 30134770 | PRJNA1156092_P_NODE_20492_length_260_cov_1.267380_g20362_i0 | PRJNA1156092 | 20492 | 260 | 1.26738 | 3.295188 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 65.5 | 4.51e-10 | NR | MCE2423439.1 | 2026742 | g20362 | i0 | 44.4 | 1.92692307692308 | 81 | 44 | 93.5 | 1 | 17 | 259 | 39 | 118 | MCE2423439.1 sulfotransferase domain-containing protein [Gemmatimonadota bacterium] | diamond | 501 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30577177 | 30577177 | PRJNA1156092_P_NODE_18013_length_277_cov_1.509804_g17883_i0 | PRJNA1156092 | 18013 | 277 | 1.509804 | 4.18215708 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 181 | 9.119999999999999e-54 | NR | MBL8978092.1 | 2026742 | g17883 | i0 | 98.9 | 0.996389891696751 | 92 | 1 | 99.6 | 0 | 276 | 1 | 246 | 337 | MBL8978092.1 site-2 protease family protein [Gemmatimonadota bacterium] | diamond | 276 | 181 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31482095 | 31482095 | PRJNA1156092_P_NODE_27076_length_246_cov_0.890173_g26946_i0 | PRJNA1156092 | 27076 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 105 | 1.64e-24 | NR | NNF29063.1 | 2026742 | g26946 | i0 | 54.9 | 3.98780487804878 | 82 | 37 | 100 | 0 | 1 | 246 | 150 | 231 | NNF29063.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Gemmatimonadota bacterium] | diamond | 981 | 106 | 0.990566037735849 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31778616 | 31778616 | PRJNA1156092_P_NODE_22057_length_251_cov_0.865169_g21927_i0 | PRJNA1156092 | 22057 | 251 | 0.865169 | 2.17157419 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 112 | 1.7300000000000003e-27 | NR | MDH3290921.1 | 2026742 | g21927 | i0 | 69.9 | 0.872509960159363 | 73 | 22 | 87.3 | 0 | 1 | 219 | 293 | 365 | MDH3290921.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 219 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31905167 | 31905167 | PRJNA1156092_P_NODE_31177_length_242_cov_0.911243_g31047_i0 | PRJNA1156092 | 31177 | 242 | 0.911243 | 2.20520806 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 167 | 2.2e-49 | NR | MBK5097856.1 | 2026742 | g31047 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 3 | 242 | 114 | 193 | MBK5097856.1 2-oxoglutarate oxidoreductase [Gemmatimonadota bacterium] | diamond | 240 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32379929 | 32379929 | PRJNA1156092_P_NODE_25659_length_248_cov_0.880000_g25529_i0 | PRJNA1156092 | 25659 | 248 | 0.88 | 2.1824 | Gemmatimonas sp. SG8_28 | 1703357 | Bacteria | Bacteria | 43.5 | 0.0206 | NR | KPK04954.1 | 1703357 | g25529 | i0 | 35.8 | 0.810483870967742 | 67 | 43 | 81 | 0 | 240 | 40 | 194 | 260 | KPK04954.1 MAG: hypothetical protein AMS20_07720 [Gemmatimonas sp. SG8_28] | diamond | 201 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. SG8_28 | |
| 32569945 | 32569945 | PRJNA1156092_P_NODE_24659_length_249_cov_0.875000_g24529_i0 | PRJNA1156092 | 24659 | 249 | 0.875 | 2.17875 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 109 | 2.04e-26 | NR | MBK5098352.1 | 2026742 | g24529 | i0 | 86.7 | 0.72289156626506 | 60 | 8 | 72.3 | 0 | 3 | 182 | 317 | 376 | MBK5098352.1 alanine racemase [Gemmatimonadota bacterium] | diamond | 180 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32789853 | 32789853 | PRJNA1156092_P_NODE_32340_length_241_cov_0.916667_g32210_i0 | PRJNA1156092 | 32340 | 241 | 0.916667 | 2.20916747 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 114 | 9.88e-28 | NR | RMH21679.1 | 2026742 | g32210 | i0 | 65 | 1.99170124481328 | 80 | 28 | 99.6 | 0 | 241 | 2 | 141 | 220 | RMH21679.1 MAG: transglutaminase domain-containing protein [Gemmatimonadota bacterium] | diamond | 480 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;