contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1121709 | 1121709 | PRJNA550047_P_NODE_477181_length_238_cov_7.036364_g475208_i0 | PRJNA550047 | 477181 | 238 | 7.036364 | 16.74654632 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 372 | 1.44e-98 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g475208 | i0 | 95.299 | 140.31512605042 | 234 | 11 | 98 | 0 | 5 | 238 | 27837 | 28070 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 33395 | 372 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 6225617 | 6225617 | PRJNA550047_P_NODE_5245_length_800_cov_9.141678_g3683_i0 | PRJNA550047 | 5245 | 800 | 9.141678 | 73.133424 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1020 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g3683 | i0 | 89.987 | 219.56875 | 789 | 69 | 99 | 5 | 5 | 792 | 28225 | 29004 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 175655 | 1020 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 13271896 | 13271896 | PRJNA550047_P_NODE_559151_length_210_cov_17.985401_g557178_i0 | PRJNA550047 | 559151 | 210 | 17.985401 | 37.7693421 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 113 | 8.33e-21 | NTclustered | gi|2621703062|emb|OY760504.1| | 2033014 | g557178 | i0 | 78.378 | 127.619047619048 | 185 | 32 | 87 | 6 | 1 | 182 | 2408953 | 2409132 | MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1 | blastn | 26800 | 113 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 15148542 | 15148542 | PRJNA550047_P_NODE_205732_length_328_cov_7.501961_g203764_i0 | PRJNA550047 | 205732 | 328 | 7.501961 | 24.60643208 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 409 | 1.5899999999999998e-109 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g203764 | i0 | 89.506 | 742.378048780488 | 324 | 32 | 98 | 2 | 6 | 328 | 1687578 | 1687900 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 243500 | 409 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 17093507 | 17093507 | PRJNA550047_P_NODE_400994_length_264_cov_15.759162_g399022_i0 | PRJNA550047 | 400994 | 264 | 15.759162 | 41.60418768 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 316 | 7.75e-82 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g399022 | i0 | 88.506 | 207.356060606061 | 261 | 30 | 99 | 0 | 2 | 262 | 1304648 | 1304388 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 54742 | 316 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 23468830 | 23468830 | PRJNA550047_P_NODE_440319_length_250_cov_7.937853_g438347_i0 | PRJNA550047 | 440319 | 250 | 7.937853 | 19.8446325 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 307 | 4.3800000000000005e-79 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g438347 | i0 | 89.328 | 887.68 | 253 | 16 | 100 | 6 | 1 | 250 | 593812 | 593568 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 221920 | 307 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 23470514 | 23470514 | PRJNA550047_P_NODE_578679_length_204_cov_13.877863_g576706_i0 | PRJNA550047 | 578679 | 204 | 13.877863 | 28.31084052 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 106 | 1.35e-18 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g576706 | i0 | 77.907 | 3.74509803921569 | 172 | 37 | 84 | 1 | 2 | 173 | 594082 | 593912 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 764 | 106 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 25347339 | 25347339 | PRJNA550047_P_NODE_325280_length_293_cov_11.350000_g323310_i0 | PRJNA550047 | 325280 | 293 | 11.35 | 33.2555 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 536 | 6.149999999999998e-148 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g323310 | i0 | 99.659 | 178.20819112628 | 293 | 1 | 100 | 0 | 1 | 293 | 27381 | 27089 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 52215 | 536 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli |
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);;