contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4490402 | 4490402 | PRJNA682078_P_NODE_298724_length_218_cov_4.248276_g296947_i0 | PRJNA682078 | 298724 | 218 | 4.248276 | 9.26124168 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 276 | 1.05e-69 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g296947 | i0 | 89.954 | 105.247706422018 | 219 | 15 | 99 | 6 | 1 | 215 | 343220 | 343005 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 22944 | 276 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 5763996 | 5763996 | PRJNA682078_P_NODE_215025_length_254_cov_2.127072_g213248_i0 | PRJNA682078 | 215025 | 254 | 2.127072 | 5.40276288 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 296 | 9.65e-76 | NTclustered | gi|2107953857|gb|CP070792.1| | 2026742 | g213248 | i0 | 88.048 | 123.287401574803 | 251 | 29 | 98 | 1 | 1 | 250 | 1095731 | 1095481 | MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome | blastn | 31315 | 296 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 8311810 | 8311810 | PRJNA682078_P_NODE_145347_length_299_cov_1.022124_g143570_i0 | PRJNA682078 | 145347 | 299 | 1.022124 | 3.05615076 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 411 | 3.979999999999999e-110 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g143570 | i0 | 93.478 | 73.2073578595318 | 276 | 18 | 92 | 0 | 24 | 299 | 1903839 | 1903564 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 21889 | 411 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 12653221 | 12653221 | PRJNA682078_P_NODE_47750_length_495_cov_3.943128_g45985_i0 | PRJNA682078 | 47750 | 495 | 3.943128 | 19.5184836 | Gemmatimonas | 173479 | Bacteria | Bacteria | 579 | 1.7899999999999993e-160 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g45985 | i0 | 87.897 | 44.769696969697 | 504 | 45 | 100 | 15 | 1 | 495 | 24 | 520 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 22161 | 579 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 14688259 | 14688259 | PRJNA682078_P_NODE_167932_length_282_cov_1.291866_g166155_i0 | PRJNA682078 | 167932 | 282 | 1.291866 | 3.64306212 | Gemmatimonas aurantiaca | 173480 | Bacteria | Bacteria | 516 | 7.67e-142 | NTclustered | gi|226088597|dbj|AP009153.1| | 379066 | g166155 | i0 | 99.645 | 1 | 282 | 1 | 100 | 0 | 1 | 282 | 2745747 | 2745466 | Gemmatimonas aurantiaca T-27 DNA, complete genome | blastn | 282 | 516 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 17235614 | 17235614 | PRJNA682078_P_NODE_102574_length_348_cov_1.120000_g100798_i0 | PRJNA682078 | 102574 | 348 | 1.12 | 3.8976 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 411 | 4.719999999999999e-110 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g100798 | i0 | 88.136 | 244.011494252874 | 354 | 31 | 100 | 10 | 1 | 348 | 3486204 | 3485856 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 84916 | 411 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18510138 | 18510138 | PRJNA682078_P_NODE_120715_length_324_cov_2.338645_g118938_i0 | PRJNA682078 | 120715 | 324 | 2.338645 | 7.5772098 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 453 | 7.140000000000001e-123 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g118938 | i0 | 92 | 53.6759259259259 | 325 | 23 | 100 | 3 | 1 | 324 | 3043117 | 3043439 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 17391 | 453 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 24885181 | 24885181 | PRJNA682078_P_NODE_158460_length_288_cov_1.339535_g156683_i0 | PRJNA682078 | 158460 | 288 | 1.339535 | 3.8578608 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 359 | 1.4e-94 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g156683 | i0 | 89.31 | 297.086805555556 | 290 | 26 | 100 | 4 | 1 | 288 | 1902431 | 1902717 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 85561 | 359 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales 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);;