contig_metadata
7 rows where bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5555589 | 5555589 | PRJNA492280_P_NODE_26025_length_164_cov_2.251969_g25918_i0 | PRJNA492280 | 26025 | 164 | 2.251969 | 3.69322916 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 111 | 2.23e-20 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g25918 | i0 | 94.444 | 15.7012195121951 | 72 | 4 | 44 | 0 | 90 | 161 | 1305243 | 1305314 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 2575 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8751736 | 8751736 | PRJNA492280_P_NODE_11567_length_164_cov_9.716535_g11460_i0 | PRJNA492280 | 11567 | 164 | 9.716535 | 15.9351174 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 95.3 | 2.24e-15 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g11460 | i0 | 93.651 | 0.810975609756098 | 63 | 4 | 38 | 0 | 2 | 64 | 28971 | 29033 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 133 | 95.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 11930492 | 11930492 | PRJNA492280_P_NODE_12530_length_164_cov_6.370079_g12423_i0 | PRJNA492280 | 12530 | 164 | 6.370079 | 10.44692956 | Armatimonadetes bacterium Uphvl-Ar1 | 2004467 | Bacteria | Bacteria | 91.6 | 2.9e-14 | NTclustered | gi|1199098093|gb|CP021423.1| | 2004467 | g12423 | i0 | 89.333 | 0.914634146341463 | 75 | 4 | 45 | 3 | 4 | 76 | 1548802 | 1548730 | Armatimonadetes bacterium Uphvl-Ar1 genome | blastn | 150 | 91.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar1 | ||||||
| 15754472 | 15754472 | PRJNA492280_P_NODE_11633_length_164_cov_9.196850_g11526_i0 | PRJNA492280 | 11633 | 164 | 9.19685 | 15.082834 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 163 | 6.06e-36 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g11526 | i0 | 84.615 | 60.9756097560976 | 182 | 8 | 99 | 9 | 2 | 163 | 1687675 | 1687856 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 10000 | 163 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 17676712 | 17676712 | PRJNA492280_P_NODE_3534_length_259_cov_16.018018_g3427_i0 | PRJNA492280 | 3534 | 259 | 16.018018 | 41.48666662 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 195 | 3.7e-45 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g3427 | i0 | 95.122 | 136.667953667954 | 123 | 6 | 79 | 0 | 48 | 170 | 29519 | 29641 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 35397 | 195 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 22128524 | 22128524 | PRJNA492280_P_NODE_6478_length_204_cov_3.502994_g6371_i0 | PRJNA492280 | 6478 | 204 | 3.502994 | 7.14610776 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 180 | 7.819999999999998e-41 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g6371 | i0 | 96.33 | 51.9362745098039 | 109 | 4 | 97 | 0 | 4 | 112 | 1688644 | 1688536 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 10595 | 180 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 28812962 | 28812962 | PRJNA492280_P_NODE_33328_length_150_cov_4.141593_g33221_i0 | PRJNA492280 | 33328 | 150 | 4.141593 | 6.2123895 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 70.1 | 2.4e-12 | NR | MES2462405.1 | 2033014 | g33221 | i0 | 66.7 | 1.08 | 54 | 13 | 98 | 1 | 4 | 150 | 297 | 350 | MES2462405.1 hypothetical protein [Armatimonadota bacterium] | diamond | 162 | 70.1 | 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);;