contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830919 | 830919 | PRJNA841653_P_NODE_57861_length_243_cov_0.905882_g57187_i0 | PRJNA841653 | 57861 | 243 | 0.905882 | 2.20129326 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 195 | 3.4399999999999997e-45 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g57187 | i0 | 82.949 | 1.0082304526749 | 217 | 35 | 89 | 2 | 27 | 242 | 2346004 | 2346219 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 245 | 195 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 9758609 | 9758609 | PRJNA841653_P_NODE_39868_length_261_cov_1.595745_g39194_i0 | PRJNA841653 | 39868 | 261 | 1.595745 | 4.16489445 | Candidatus Chlorohelix allophototropha | 3003348 | Bacteria | Bacteria | 196 | 1.04e-45 | NTclustered | gi|2530750984|gb|CP128400.1| | 3003348 | g39194 | i0 | 81.853 | 50.7432950191571 | 259 | 23 | 99 | 8 | 3 | 261 | 320892 | 320658 | Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence | blastn | 13244 | 196 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Chloroheliales | Candidatus Chloroheliaceae | Candidatus Chlorohelix | Candidatus Chlorohelix allophototropha | ||
| 11034073 | 11034073 | PRJNA841653_P_NODE_26669_length_316_cov_0.938272_g25995_i0 | PRJNA841653 | 26669 | 316 | 0.938272 | 2.96493952 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 462 | 1.15e-125 | NTclustered | gi|1188269816|gb|MF002242.1| | 166587 | g25995 | i0 | 94.098 | 92.1930379746835 | 305 | 16 | 97 | 2 | 12 | 316 | 100 | 402 | Uncultured Chloroflexota bacterium clone 716_53 16S ribosomal RNA gene, partial sequence | blastn | 29133 | 462 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota bacterium | ||||||
| 13584589 | 13584589 | PRJNA841653_P_NODE_58031_length_243_cov_0.905882_g57357_i0 | PRJNA841653 | 58031 | 243 | 0.905882 | 2.20129326 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 148 | 2.72e-31 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g57357 | i0 | 83.974 | 6.66255144032922 | 156 | 23 | 64 | 2 | 5 | 159 | 746977 | 747131 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 1619 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 16133105 | 16133105 | PRJNA841653_P_NODE_29493_length_300_cov_1.334802_g28819_i0 | PRJNA841653 | 29493 | 300 | 1.334802 | 4.004406 | uncultured Longilinea sp. | 527666 | Bacteria | Bacteria | 172 | 2.05e-38 | NTclustered | gi|310350678|gb|HQ058438.1| | 527666 | g28819 | i0 | 83.784 | 59.3133333333333 | 185 | 27 | 61 | 2 | 105 | 286 | 111 | 295 | Uncultured Longilinea sp. clone F5OHPNU07H37CV 16S ribosomal RNA gene, partial sequence | blastn | 17794 | 172 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Longilinea | uncultured Longilinea sp. | ||
| 17408857 | 17408857 | PRJNA841653_P_NODE_42814_length_252_cov_1.636872_g42140_i0 | PRJNA841653 | 42814 | 252 | 1.636872 | 4.12491744 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 159 | 1.31e-34 | NTclustered | gi|2893356072|emb|OZ220495.1| | 2026734 | g42140 | i0 | 80.087 | 7.51190476190476 | 231 | 32 | 88 | 12 | 31 | 252 | 616023 | 615798 | MAG: Dehalococcoidia bacterium isolate 23c5d8d9-c01e-4714-bf51-3e77b66f12ef genome assembly, chromosome: 1 | blastn | 1893 | 159 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 17409210 | 17409210 | PRJNA841653_P_NODE_63514_length_232_cov_2.767296_g62840_i0 | PRJNA841653 | 63514 | 232 | 2.767296 | 6.42012672 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 279 | 8.74e-71 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g62840 | i0 | 88.987 | 17.5387931034483 | 227 | 23 | 97 | 2 | 2 | 227 | 275999 | 275774 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 4069 | 279 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18681735 | 18681735 | PRJNA841653_P_NODE_32735_length_286_cov_0.985915_g32061_i0 | PRJNA841653 | 32735 | 286 | 0.985915 | 2.8197169 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 285 | 2.39e-72 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g32061 | i0 | 87.451 | 7.37762237762238 | 255 | 22 | 89 | 6 | 27 | 280 | 1401 | 1156 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 2110 | 285 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 19957142 | 19957142 | PRJNA841653_P_NODE_45836_length_250_cov_0.870056_g45162_i0 | PRJNA841653 | 45836 | 250 | 0.870056 | 2.17514 | Roseiflexus castenholzii | 120962 | Bacteria | Bacteria | 69.4 | 2.25e-7 | NTclustered | gi|156231356|gb|CP000804.1| | 383372 | g45162 | i0 | 93.617 | 6.784 | 47 | 1 | 19 | 2 | 169 | 215 | 4888816 | 4888860 | Roseiflexus castenholzii DSM 13941, complete genome | blastn | 1696 | 69.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus castenholzii | ||
| 21632980 | 21632980 | PRJNA841653_P_NODE_63157_length_236_cov_3.208589_g62483_i0 | PRJNA841653 | 63157 | 236 | 3.208589 | 7.57227004 | Chloroflexota | 200795 | Bacteria | Bacteria | 198 | 2.57e-46 | NTclustered | gi|2874253882|emb|OY969938.1| | 1672391 | g62483 | i0 | 86.022 | 6.72457627118644 | 186 | 25 | 78 | 1 | 43 | 227 | 2063918 | 2063733 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1 | blastn | 1587 | 198 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 25056994 | 25056994 | PRJNA841653_P_NODE_53120_length_246_cov_0.890173_g52446_i0 | PRJNA841653 | 53120 | 246 | 0.890173 | 2.18982558 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 207 | 4.48e-49 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g52446 | i0 | 82.231 | 0.983739837398374 | 242 | 41 | 98 | 2 | 6 | 246 | 1889847 | 1889607 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 242 | 207 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia 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);;