contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1269268 | 1269268 | PRJNA980585_P_NODE_11701_length_396_cov_2.619195_g11447_i0 | PRJNA980585 | 11701 | 396 | 2.619195 | 10.3720122 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 604 | 2.319999999999999e-168 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g11447 | i0 | 94.192 | 226.265151515152 | 396 | 23 | 100 | 0 | 1 | 396 | 28897 | 28502 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 89601 | 604 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 7332381 | 7332381 | PRJNA980585_P_NODE_24866_length_296_cov_2.753363_g24612_i0 | PRJNA980585 | 24866 | 296 | 2.753363 | 8.14995448 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 298 | 3.2e-76 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g24612 | i0 | 86.842 | 547.466216216216 | 266 | 35 | 90 | 0 | 1 | 266 | 3407185 | 3407450 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 162050 | 298 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 7647403 | 7647403 | PRJNA980585_P_NODE_35946_length_263_cov_1.457895_g35692_i0 | PRJNA980585 | 35946 | 263 | 1.457895 | 3.83426385 | Capsulimonas | 2494209 | Bacteria | Bacteria | 252 | 2.21e-62 | NTclustered | gi|2621703062|emb|OY760504.1| | 2033014 | g35692 | i0 | 87.054 | 496.897338403042 | 224 | 28 | 85 | 1 | 39 | 261 | 2410171 | 2409948 | MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1 | blastn | 130684 | 252 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 8922275 | 8922275 | PRJNA980585_P_NODE_37467_length_259_cov_1.241935_g37213_i0 | PRJNA980585 | 37467 | 259 | 1.241935 | 3.21661165 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 340 | 4.5e-89 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g37213 | i0 | 90.347 | 31.6486486486486 | 259 | 25 | 100 | 0 | 1 | 259 | 28916 | 29174 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 8197 | 340 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 12433607 | 12433607 | PRJNA980585_P_NODE_14290_length_366_cov_2.631399_g14036_i0 | PRJNA980585 | 14290 | 366 | 2.631399 | 9.63092034 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 202 | 3.259999999999999e-47 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g14036 | i0 | 91.333 | 240.901639344262 | 150 | 9 | 40 | 3 | 41 | 188 | 1305218 | 1305365 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 88170 | 202 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 13708845 | 13708845 | PRJNA980585_P_NODE_61791_length_232_cov_2.421384_g61537_i0 | PRJNA980585 | 61791 | 232 | 2.421384 | 5.61761088 | uncultured Fimbriimonas sp. | 1936177 | Bacteria | Bacteria | 429 | 8.2e-116 | NTclustered | gi|2363421043|gb|OP915165.1| | 1936177 | g61537 | i0 | 100 | 99.5775862068966 | 232 | 0 | 100 | 0 | 1 | 232 | 354 | 123 | Uncultured Fimbriimonas sp. clone 1104864 16S ribosomal RNA gene, partial sequence | blastn | 23102 | 429 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | uncultured Fimbriimonas sp. | ||
| 17846935 | 17846935 | PRJNA980585_P_NODE_33574_length_270_cov_1.040609_g33320_i0 | PRJNA980585 | 33574 | 270 | 1.040609 | 2.8096443 | Bacteria | 2 | Bacteria | Bacteria | 147 | 1.1000000000000001e-30 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g33320 | i0 | 86.232 | 203.17037037037 | 138 | 15 | 50 | 4 | 93 | 228 | 1306859 | 1306724 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 54856 | 148 | 0.993243243243243 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 20395750 | 20395750 | PRJNA980585_P_NODE_34676_length_267_cov_1.015464_g34422_i0 | PRJNA980585 | 34676 | 267 | 1.015464 | 2.71128888 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 355 | 1.66e-93 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g34422 | i0 | 90.672 | 178.52808988764 | 268 | 23 | 99 | 2 | 1 | 266 | 29757 | 29490 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 47667 | 355 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 23907196 | 23907196 | PRJNA980585_P_NODE_28439_length_284_cov_1.236967_g28185_i0 | PRJNA980585 | 28439 | 284 | 1.236967 | 3.51298628 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 206 | 1.8999999999999997e-48 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g28185 | i0 | 81.89 | 152.577464788732 | 254 | 36 | 88 | 9 | 1 | 250 | 594377 | 594130 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 43332 | 206 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 24221055 | 24221055 | PRJNA980585_P_NODE_46379_length_248_cov_0.880000_g46125_i0 | PRJNA980585 | 46379 | 248 | 0.88 | 2.1824 | PVC group | 1783257 | Bacteria | Bacteria | 78.7 | 3.7e-10 | NTclustered | gi|2314718026|dbj|AP024674.1| | 2033014 | g46125 | i0 | 94.118 | 3.57258064516129 | 51 | 3 | 21 | 0 | 181 | 231 | 1419458 | 1419508 | MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome | blastn | 886 | 78.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;