contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4104766 | 4104766 | PRJNA1122875_P_NODE_36544_length_274_cov_1.940299_g36320_i0 | PRJNA1122875 | 36544 | 274 | 1.940299 | 5.31641926 | Candidatus Chlorohelix allophototropha | 3003348 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2530748470|gb|CP128399.1| | 3003348 | g36320 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 133 | 160 | 2729585 | 2729558 | Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 1, complete sequence | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Chloroheliales | Candidatus Chloroheliaceae | Candidatus Chlorohelix | Candidatus Chlorohelix allophototropha | ||
| 4856853 | 4856853 | PRJNA1122875_P_NODE_804_length_1284_cov_2.706854_g724_i0 | PRJNA1122875 | 804 | 1284 | 2.706854 | 34.75600536 | root | 1 | Root_unresolved | Root_unresolved | 496 | 5.05e-135 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g724 | i0 | 75.155 | 40.6783489096573 | 1127 | 227 | 85 | 38 | 145 | 1237 | 938611 | 939718 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 52231 | 497 | 0.997987927565392 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 10481388 | 10481388 | PRJNA1122875_P_NODE_41089_length_258_cov_1.302703_g40865_i0 | PRJNA1122875 | 41089 | 258 | 1.302703 | 3.36097374 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2076445013|gb|CP075367.1| | 2073117 | g40865 | i0 | 100 | 0.441860465116279 | 30 | 0 | 12 | 0 | 35 | 64 | 79288 | 79259 | MAG: Anaerolineales bacterium isolate ACE_CHL1 chromosome | blastn | 114 | 56.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 10481395 | 10481395 | PRJNA1122875_P_NODE_42289_length_253_cov_1.838889_g42065_i0 | PRJNA1122875 | 42289 | 253 | 1.838889 | 4.65238917 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2621702192|emb|OY760183.1| | 2026724 | g42065 | i0 | 92.105 | 0.150197628458498 | 38 | 3 | 15 | 0 | 82 | 119 | 88629 | 88592 | MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1 | blastn | 38 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 14306520 | 14306520 | PRJNA1122875_P_NODE_3212_length_828_cov_2.871523_g3030_i0 | PRJNA1122875 | 3212 | 828 | 2.871523 | 23.77621044 | Tepidiforma bonchosmolovskayae | 2601677 | Bacteria | Bacteria | 329 | 3.44e-85 | NTclustered | gi|1756502384|gb|CP042829.1| | 2601677 | g3030 | i0 | 78.723 | 19.4903381642512 | 517 | 93 | 62 | 14 | 80 | 590 | 946275 | 945770 | Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome | blastn | 16138 | 329 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiforma | Tepidiforma bonchosmolovskayae | ||
| 15580471 | 15580471 | PRJNA1122875_P_NODE_29393_length_302_cov_1.650655_g29169_i0 | PRJNA1122875 | 29393 | 302 | 1.650655 | 4.9849781 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 246 | 1.2e-60 | NTclustered | gi|2621704692|emb|OY762063.1| | 2026734 | g29169 | i0 | 86.147 | 56.7119205298013 | 231 | 28 | 76 | 2 | 1 | 229 | 1369100 | 1368872 | MAG: Dehalococcoidia bacterium isolate 5405c63e-44e1-4988-9b68-fe709a885d54 genome assembly, chromosome: 1 | blastn | 17127 | 246 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 20679081 | 20679081 | PRJNA1122875_P_NODE_3197_length_830_cov_2.931308_g3016_i0 | PRJNA1122875 | 3197 | 830 | 2.931308 | 24.3298564 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 54.7 | 0.023 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g3016 | i0 | 100 | 0.0349397590361446 | 29 | 0 | 3 | 0 | 473 | 501 | 1614483 | 1614455 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 23230233 | 23230233 | PRJNA1122875_P_NODE_54419_length_233_cov_2.362500_g54195_i0 | PRJNA1122875 | 54419 | 233 | 2.3625 | 5.504625 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 76.8 | 1.24e-9 | NTclustered | gi|2621703348|emb|OY760647.1| | 2614250 | g54195 | i0 | 91.228 | 3.72961373390558 | 57 | 3 | 24 | 2 | 83 | 138 | 2816913 | 2816968 | MAG: Caldilineaceae bacterium isolate dd18155e-cfc5-4d95-bdad-01b25ac4382b genome assembly, chromosome: 1 | blastn | 869 | 76.8 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae 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);;