contig_metadata
23 rows where bioproject = "PRJNA1031674", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166548 | 166548 | PRJNA1031674_P_NODE_12641_length_285_cov_0.886792_g12430_i0 | PRJNA1031674 | 12641 | 285 | 0.886792 | 2.5273572 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 196 | 1.15e-45 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g12430 | i0 | 80.303 | 3.71578947368421 | 264 | 48 | 92 | 4 | 1 | 262 | 7523335 | 7523074 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 1059 | 196 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 5269571 | 5269571 | PRJNA1031674_P_NODE_21905_length_251_cov_1.719101_g21694_i0 | PRJNA1031674 | 21905 | 251 | 1.719101 | 4.31494351 | Gemmatimonas groenlandica | 2732249 | Bacteria | Bacteria | 154 | 6.06e-33 | NTclustered | gi|1839994010|gb|CP053085.1| | 2732249 | g21694 | i0 | 78.295 | 55.8804780876494 | 258 | 42 | 100 | 13 | 1 | 251 | 1103161 | 1102911 | Gemmatimonas groenlandica strain TET16 chromosome, complete genome | blastn | 14026 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas groenlandica | |
| 7819169 | 7819169 | PRJNA1031674_P_NODE_10187_length_295_cov_1.387387_g9976_i0 | PRJNA1031674 | 10187 | 295 | 1.387387 | 4.09279165 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 363 | 1.1099999999999999e-95 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g9976 | i0 | 88.851 | 23.5152542372881 | 296 | 31 | 100 | 2 | 1 | 295 | 421895 | 422189 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 6937 | 363 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 11645151 | 11645151 | PRJNA1031674_P_NODE_13330_length_282_cov_2.349282_g13119_i0 | PRJNA1031674 | 13330 | 282 | 2.349282 | 6.62497524 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 162 | 1.26e-49 | NR | HVX89611.1 | 2448054 | g13119 | i0 | 80.4 | 0.978723404255319 | 92 | 18 | 97.9 | 0 | 2 | 277 | 7 | 98 | HVX89611.1 nuclear transport factor 2 family protein [Gemmatimonadales bacterium] | diamond | 276 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 14195325 | 14195325 | PRJNA1031674_P_NODE_21912_length_251_cov_1.702247_g21701_i0 | PRJNA1031674 | 21912 | 251 | 1.702247 | 4.27263997 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 414 | 2.52e-111 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g21701 | i0 | 96.414 | 130.828685258964 | 251 | 9 | 100 | 0 | 1 | 251 | 422765 | 423015 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 32838 | 414 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 15469489 | 15469489 | PRJNA1031674_P_NODE_18553_length_264_cov_2.151832_g18342_i0 | PRJNA1031674 | 18553 | 264 | 2.151832 | 5.68083648 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 169 | 1.1799999999999998e-47 | NR | HEX5818182.1 | 2448054 | g18342 | i0 | 100 | 3.95454545454545 | 87 | 0 | 98.9 | 0 | 2 | 262 | 374 | 460 | HEX5818182.1 3-deoxy-7-phosphoheptulonate synthase [Gemmatimonadales bacterium] | diamond | 1044 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 18018526 | 18018526 | PRJNA1031674_P_NODE_19875_length_259_cov_1.747312_g19664_i0 | PRJNA1031674 | 19875 | 259 | 1.747312 | 4.52553808 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 207 | 4.76e-49 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g19664 | i0 | 81.679 | 6.44787644787645 | 262 | 36 | 98 | 9 | 6 | 259 | 802589 | 802846 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 1670 | 207 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 20567801 | 20567801 | PRJNA1031674_P_NODE_18997_length_263_cov_1.268421_g18786_i0 | PRJNA1031674 | 18997 | 263 | 1.268421 | 3.33594723 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 363 | 9.769999999999999e-96 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g18786 | i0 | 91.667 | 454.669201520913 | 264 | 19 | 100 | 2 | 1 | 263 | 173507 | 173768 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 119578 | 363 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 21408804 | 21408804 | PRJNA1031674_P_NODE_15577_length_275_cov_1.698020_g15366_i0 | PRJNA1031674 | 15577 | 275 | 1.69802 | 4.669555 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 184 | 1.7e-55 | NR | MFL5521146.1 | 2448054 | g15366 | i0 | 100 | 1.98545454545455 | 91 | 0 | 99.3 | 0 | 1 | 273 | 29 | 119 | MFL5521146.1 L-threonylcarbamoyladenylate synthase [Gemmatimonadales bacterium] | diamond | 546 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 21843500 | 21843500 | PRJNA1031674_P_NODE_15698_length_275_cov_1.272277_g15487_i0 | PRJNA1031674 | 15698 | 275 | 1.272277 | 3.49876175 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 146 | 1.24e-41 | NR | HSR92993.1 | 2448054 | g15487 | i0 | 96.3 | 0.872727272727273 | 80 | 3 | 87.3 | 0 | 275 | 36 | 160 | 239 | HSR92993.1 alpha/beta hydrolase [Gemmatimonadales bacterium] | diamond | 240 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 24392677 | 24392677 | PRJNA1031674_P_NODE_15480_length_275_cov_2.900990_g15269_i0 | PRJNA1031674 | 15480 | 275 | 2.90099 | 7.9777225 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 94.7 | 4.0500000000000005e-21 | NR | MFL5521744.1 | 2448054 | g15269 | i0 | 94.1 | 0.556363636363636 | 51 | 3 | 55.6 | 0 | 122 | 274 | 111 | 161 | MFL5521744.1 F0F1 ATP synthase subunit A [Gemmatimonadales bacterium] | diamond | 153 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 24392842 | 24392842 | PRJNA1031674_P_NODE_27080_length_242_cov_1.822485_g26869_i0 | PRJNA1031674 | 27080 | 242 | 1.822485 | 4.4104137 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 157 | 7.78e-45 | NR | WP_331123660.1 | 2029185 | g26869 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 1 | 240 | 188 | 267 | WP_331123660.1 phosphotransferase family protein [Longimicrobium sp.] | diamond | 240 | 157 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 27224584 | 27224584 | PRJNA1031674_P_NODE_11323_length_289_cov_1.245370_g11112_i0 | PRJNA1031674 | 11323 | 289 | 1.24537 | 3.5991193 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 55.5 | 2.03e-6 | NR | HET7274654.1 | 3047548 | g11112 | i0 | 38 | 0.737024221453287 | 71 | 44 | 73.7 | 0 | 76 | 288 | 13 | 83 | HET7274654.1 HAMP domain-containing sensor histidine kinase [Longimicrobiaceae bacterium] | diamond | 213 | 55.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 27919494 | 27919494 | PRJNA1031674_P_NODE_19465_length_261_cov_1.452128_g19254_i0 | PRJNA1031674 | 19465 | 261 | 1.452128 | 3.79005408 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 100 | 2.76e-24 | NR | MFL5505549.1 | 2448054 | g19254 | i0 | 94 | 0.574712643678161 | 50 | 3 | 57.5 | 0 | 3 | 152 | 145 | 194 | MFL5505549.1 DUF4136 domain-containing protein [Gemmatimonadales bacterium] | diamond | 150 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29024994 | 29024994 | PRJNA1031674_P_NODE_25288_length_245_cov_3.197674_g25077_i0 | PRJNA1031674 | 25288 | 245 | 3.197674 | 7.8343013 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 43.9 | 0.0141 | NR | MEJ2540240.1 | 2026742 | g25077 | i0 | 40.8 | 0.6 | 49 | 28 | 58.8 | 1 | 24 | 167 | 101 | 149 | MEJ2540240.1 class I SAM-dependent methyltransferase [Gemmatimonadota bacterium] | diamond | 147 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29372027 | 29372027 | PRJNA1031674_P_NODE_16889_length_271_cov_1.131313_g16678_i0 | PRJNA1031674 | 16889 | 271 | 1.131313 | 3.06585823 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 141 | 1.12e-41 | NR | HEX3233048.1 | 2448054 | g16678 | i0 | 89.3 | 0.830258302583026 | 75 | 8 | 83 | 0 | 47 | 271 | 1 | 75 | HEX3233048.1 DUF4062 domain-containing protein [Gemmatimonadales bacterium] | diamond | 225 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29403574 | 29403574 | PRJNA1031674_P_NODE_17429_length_269_cov_1.255102_g17218_i0 | PRJNA1031674 | 17429 | 269 | 1.255102 | 3.37622438 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 42.7 | 0.0389 | NR | MEO8227240.1 | 2026742 | g17218 | i0 | 43.3 | 0.669144981412639 | 60 | 32 | 66.9 | 2 | 69 | 248 | 116 | 173 | MEO8227240.1 carbonic anhydrase [Gemmatimonadota bacterium] | diamond | 180 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30035214 | 30035214 | PRJNA1031674_P_NODE_5831_length_356_cov_1.586572_g5620_i0 | PRJNA1031674 | 5831 | 356 | 1.586572 | 5.64819632 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 47.4 | 0.00308 | NR | MDQ2668021.1 | 2026742 | g5620 | i0 | 34.5 | 0.926966292134832 | 110 | 64 | 86 | 3 | 307 | 2 | 409 | 518 | MDQ2668021.1 IPT/TIG domain-containing protein [Gemmatimonadota bacterium] | diamond | 330 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30288273 | 30288273 | PRJNA1031674_P_NODE_8852_length_309_cov_2.580508_g8641_i0 | PRJNA1031674 | 8852 | 309 | 2.580508 | 7.97376972 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 68.6 | 3.56e-11 | NR | MFL5519812.1 | 2448054 | g8641 | i0 | 96.9 | 0.310679611650485 | 32 | 1 | 31.1 | 0 | 212 | 307 | 1 | 32 | MFL5519812.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 96 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30793323 | 30793323 | PRJNA1031674_P_NODE_20414_length_257_cov_1.673913_g20203_i0 | PRJNA1031674 | 20414 | 257 | 1.673913 | 4.30195641 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 169 | 3.13e-52 | NR | MFL5520024.1 | 2448054 | g20203 | i0 | 100 | 1.98443579766537 | 85 | 0 | 99.2 | 0 | 1 | 255 | 49 | 133 | MFL5520024.1 glycosyltransferase [Gemmatimonadales bacterium] | diamond | 510 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30880204 | 30880204 | PRJNA1031674_P_NODE_14334_length_279_cov_1.966019_g14123_i0 | PRJNA1031674 | 14334 | 279 | 1.966019 | 5.48519301 | Longimicrobium | 1804994 | Bacteria | Bacteria | 45.8 | 0.00455 | NR | MBD0319931.1 | 2026742 | g14123 | i0 | 65.5 | 0.56989247311828 | 29 | 10 | 31.2 | 0 | 87 | 1 | 1 | 29 | MBD0319931.1 metallophosphoesterase [Gemmatimonadota bacterium] | diamond | 159 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31741722 | 31741722 | PRJNA1031674_P_NODE_12617_length_285_cov_1.146226_g12406_i0 | PRJNA1031674 | 12617 | 285 | 1.146226 | 3.2667441 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 134 | 3.38e-35 | NR | HUL04500.1 | 2448054 | g12406 | i0 | 65.3 | 2 | 95 | 33 | 100 | 0 | 1 | 285 | 61 | 155 | HUL04500.1 PepSY-associated TM helix domain-containing protein [Gemmatimonadales bacterium] | diamond | 570 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32847818 | 32847818 | PRJNA1031674_P_NODE_15860_length_274_cov_1.532338_g15649_i0 | PRJNA1031674 | 15860 | 274 | 1.532338 | 4.19860612 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 65.5 | 5.31e-10 | NR | WP_025411073.1 | 861299 | g15649 | i0 | 51.3 | 0.875912408759124 | 80 | 38 | 86.5 | 1 | 240 | 4 | 265 | 344 | WP_025411073.1 carboxypeptidase-like regulatory domain-containing protein [Gemmatirosa kalamazoonensis] | diamond | 240 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis |
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);;