contig_metadata
22 rows where bioproject = "PRJNA716463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3259340 | 3259340 | PRJNA716463_P_NODE_47663_length_292_cov_2.534247_g47246_i0 | PRJNA716463 | 47663 | 292 | 2.534247 | 7.40000124 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 239 | 1.94e-58 | NTclustered | gi|2893358400|emb|OZ220691.1| | 2026742 | g47246 | i0 | 82.034 | 135.116438356164 | 295 | 40 | 100 | 8 | 1 | 292 | 2520154 | 2519870 | MAG: Gemmatimonadota bacterium isolate 1766b9ea-3269-4cc1-97f5-695b05480569 genome assembly, chromosome: 1 | blastn | 39454 | 239 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 3259366 | 3259366 | PRJNA716463_P_NODE_49383_length_291_cov_2.004587_g48966_i0 | PRJNA716463 | 49383 | 291 | 2.004587 | 5.83334817 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 394 | 3.89e-105 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g48966 | i0 | 91.156 | 217.103092783505 | 294 | 20 | 100 | 5 | 1 | 291 | 1592832 | 1592542 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 63177 | 394 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 5810912 | 5810912 | PRJNA716463_P_NODE_112985_length_240_cov_2.143713_g112567_i0 | PRJNA716463 | 112985 | 240 | 2.143713 | 5.1449112 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 220 | 5.59e-53 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g112567 | i0 | 84.348 | 168.5125 | 230 | 30 | 95 | 6 | 7 | 234 | 3042471 | 3042696 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 40443 | 220 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 7086453 | 7086453 | PRJNA716463_P_NODE_29746_length_310_cov_2.485232_g29329_i0 | PRJNA716463 | 29746 | 310 | 2.485232 | 7.7042192 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 195 | 4.5499999999999995e-45 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g29329 | i0 | 92.143 | 53.4322580645161 | 140 | 7 | 45 | 3 | 1 | 138 | 803621 | 803484 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 16564 | 195 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7086470 | 7086470 | PRJNA716463_P_NODE_3046_length_552_cov_3.256785_g2653_i0 | PRJNA716463 | 3046 | 552 | 3.256785 | 17.9774532 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 555 | 3.399999999999999e-153 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g2653 | i0 | 87.103 | 118.896739130435 | 504 | 48 | 91 | 12 | 23 | 524 | 3043758 | 3043270 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 65631 | 555 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 8360886 | 8360886 | PRJNA716463_P_NODE_16907_length_310_cov_5.523207_g16490_i0 | PRJNA716463 | 16907 | 310 | 5.523207 | 17.1219417 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 230 | 1.2499999999999995e-55 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g16490 | i0 | 94.079 | 33.3903225806452 | 152 | 7 | 97 | 2 | 161 | 310 | 801318 | 801167 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 10351 | 230 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 8361400 | 8361400 | PRJNA716463_P_NODE_4967_length_469_cov_4.156566_g4561_i0 | PRJNA716463 | 4967 | 469 | 4.156566 | 19.49429454 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 361 | 6.669999999999999e-95 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g4561 | i0 | 80.882 | 89.319829424307 | 476 | 76 | 100 | 14 | 1 | 469 | 1594472 | 1594939 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 41891 | 361 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 12187892 | 12187892 | PRJNA716463_P_NODE_83730_length_265_cov_3.645833_g83313_i0 | PRJNA716463 | 83730 | 265 | 3.645833 | 9.66145745 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 250 | 8e-62 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g83313 | i0 | 84.191 | 29.0679245283019 | 272 | 28 | 100 | 12 | 1 | 265 | 3042752 | 3042489 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 7703 | 250 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 15221174 | 15221174 | PRJNA716463_P_NODE_110292_length_242_cov_3.437870_g109874_i0 | PRJNA716463 | 110292 | 242 | 3.43787 | 8.3196454 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 79 | 1.94e-15 | NR | MDP1861294.1 | 2026741 | g109874 | i0 | 67.9 | 3.60743801652893 | 56 | 18 | 69.4 | 0 | 75 | 242 | 2 | 57 | MDP1861294.1 ATP-binding cassette domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 873 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 16010369 | 16010369 | PRJNA716463_P_NODE_30853_length_309_cov_2.627119_g30436_i0 | PRJNA716463 | 30853 | 309 | 2.627119 | 8.11779771 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 187 | 7.58e-43 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g30436 | i0 | 89.726 | 0.954692556634304 | 146 | 15 | 47 | 0 | 162 | 307 | 902974 | 903119 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 295 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 17285626 | 17285626 | PRJNA716463_P_NODE_15814_length_311_cov_3.508403_g15397_i0 | PRJNA716463 | 15814 | 311 | 3.508403 | 10.91113333 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 318 | 2.6e-82 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g15397 | i0 | 85.185 | 160.813504823151 | 297 | 38 | 95 | 5 | 18 | 311 | 802731 | 803024 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 50013 | 318 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18559197 | 18559197 | PRJNA716463_P_NODE_11535_length_350_cov_3.877256_g11120_i0 | PRJNA716463 | 11535 | 350 | 3.877256 | 13.570396 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 204 | 2.32e-61 | NR | HEU5170203.1 | 2448054 | g11120 | i0 | 81.4 | 1.93714285714286 | 113 | 21 | 96.9 | 0 | 341 | 3 | 240 | 352 | HEU5170203.1 acetyl ornithine aminotransferase family protein [Gemmatimonadales bacterium] | diamond | 678 | 206 | 0.990291262135922 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 23660577 | 23660577 | PRJNA716463_P_NODE_13539_length_327_cov_4.102362_g13123_i0 | PRJNA716463 | 13539 | 327 | 4.102362 | 13.41472374 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 497 | 3.29e-136 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g13123 | i0 | 94.969 | 219.605504587156 | 318 | 14 | 97 | 2 | 10 | 327 | 801715 | 802030 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 71811 | 497 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 27178265 | 27178265 | PRJNA716463_P_NODE_97582_length_253_cov_3.022222_g97165_i0 | PRJNA716463 | 97582 | 253 | 3.022222 | 7.64622166 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 122 | 2.07e-30 | NR | MEX0911858.1 | 2026742 | g97165 | i0 | 74.4 | 0.972332015810277 | 82 | 21 | 97.2 | 0 | 253 | 8 | 87 | 168 | MEX0911858.1 HD domain-containing phosphohydrolase [Gemmatimonadota bacterium] | diamond | 246 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27778725 | 27778725 | PRJNA716463_P_NODE_36044_length_299_cov_3.367257_g35627_i0 | PRJNA716463 | 36044 | 299 | 3.367257 | 10.06809843 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 60.5 | 4.35e-8 | NR | HEU0013141.1 | 2029185 | g35627 | i0 | 69.4 | 0.491638795986622 | 49 | 15 | 49.2 | 0 | 146 | 292 | 75 | 123 | HEU0013141.1 SusC/RagA family TonB-linked outer membrane protein [Longimicrobium sp.] | diamond | 147 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28325681 | 28325681 | PRJNA716463_P_NODE_46646_length_293_cov_2.872727_g46229_i0 | PRJNA716463 | 46646 | 293 | 2.872727 | 8.41709011 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.9 | 4.8e-10 | NR | MDH3272042.1 | 2026742 | g46229 | i0 | 56.8 | 1.37201365187713 | 44 | 19 | 45.1 | 0 | 2 | 133 | 385 | 428 | MDH3272042.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadota bacterium] | diamond | 402 | 65.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29073309 | 29073309 | PRJNA716463_P_NODE_97928_length_253_cov_2.172222_g97511_i0 | PRJNA716463 | 97928 | 253 | 2.172222 | 5.49572166 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 55.1 | 4.23e-7 | NR | HXG45260.1 | 2448054 | g97511 | i0 | 48.2 | 0.66403162055336 | 56 | 29 | 66.4 | 0 | 207 | 40 | 93 | 148 | HXG45260.1 DUF2380 domain-containing protein [Gemmatimonadales bacterium] | diamond | 168 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29894195 | 29894195 | PRJNA716463_P_NODE_123491_length_215_cov_4.070423_g123073_i0 | PRJNA716463 | 123491 | 215 | 4.070423 | 8.75140945 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 127 | 2.42e-34 | NR | HEX9755445.1 | 2448054 | g123073 | i0 | 85.9 | 2.97209302325581 | 71 | 10 | 99.1 | 0 | 2 | 214 | 171 | 241 | HEX9755445.1 ABC transporter substrate-binding protein [Gemmatimonadales bacterium] | diamond | 639 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30178296 | 30178296 | PRJNA716463_P_NODE_122332_length_221_cov_5.587838_g121914_i0 | PRJNA716463 | 122332 | 221 | 5.587838 | 12.34912198 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 44.7 | 4.54e-4 | NR | HZB28403.1 | 2448054 | g121914 | i0 | 51.1 | 0.963800904977376 | 45 | 21 | 61.1 | 1 | 85 | 219 | 7 | 50 | HZB28403.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 213 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30525895 | 30525895 | PRJNA716463_P_NODE_81893_length_267_cov_1.922680_g81476_i0 | PRJNA716463 | 81893 | 267 | 1.92268 | 5.1335556 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 122 | 1.78e-32 | NR | MDQ4079748.1 | 2026742 | g81476 | i0 | 86.8 | 1.51685393258427 | 68 | 9 | 76.4 | 0 | 267 | 64 | 158 | 225 | MDQ4079748.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 405 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30620632 | 30620632 | PRJNA716463_P_NODE_20053_length_310_cov_3.717300_g19636_i0 | PRJNA716463 | 20053 | 310 | 3.7173 | 11.52363 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 89.4 | 2.66e-18 | NR | HET7250889.1 | 2448054 | g19636 | i0 | 87.2 | 0.454838709677419 | 47 | 6 | 45.5 | 0 | 164 | 304 | 31 | 77 | HET7250889.1 acetyl ornithine aminotransferase family protein [Gemmatimonadales bacterium] | diamond | 141 | 89.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31790210 | 31790210 | PRJNA716463_P_NODE_90557_length_260_cov_1.395722_g90140_i0 | PRJNA716463 | 90557 | 260 | 1.395722 | 3.6288772 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 122 | 4.48e-30 | NR | HEU4630550.1 | 2026741 | g90140 | i0 | 77.9 | 0.992307692307692 | 86 | 18 | 99.2 | 1 | 260 | 3 | 593 | 677 | HEU4630550.1 ABC transporter permease [Gemmatimonadaceae bacterium] | diamond | 258 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;