contig_metadata
14 rows where bioproject = "PRJEB75230", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5239449 | 5239449 | PRJEB75230_P_NODE_23025_length_372_cov_1.030100_g22843_i0 | PRJEB75230 | 23025 | 372 | 1.0301 | 3.831972 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2874253689|emb|OY969415.1| | 157466 | g22843 | i0 | 100 | 0.0806451612903226 | 30 | 0 | 8 | 0 | 254 | 283 | 1138177 | 1138206 | MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 9063432 | 9063432 | PRJEB75230_P_NODE_133028_length_249_cov_0.875000_g132846_i0 | PRJEB75230 | 133028 | 249 | 0.875 | 2.17875 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 243 | 1.25e-59 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g132846 | i0 | 85 | 0.963855421686747 | 240 | 34 | 96 | 2 | 2 | 240 | 1566009 | 1565771 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 240 | 243 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 24362264 | 24362264 | PRJEB75230_P_NODE_158220_length_245_cov_0.895349_g158038_i0 | PRJEB75230 | 158220 | 245 | 0.895349 | 2.19360505 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 63.9 | 1.02e-5 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g158038 | i0 | 93.023 | 0.436734693877551 | 43 | 3 | 18 | 0 | 196 | 238 | 953203 | 953161 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 107 | 63.9 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 26654060 | 26654060 | PRJEB75230_P_NODE_1041_length_1213_cov_3.368421_g933_i0 | PRJEB75230 | 1041 | 1213 | 3.368421 | 40.85894673 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 67 | 8.14e-8 | NR | MBS1718041.1 | 2033014 | g933 | i0 | 29.8 | 0.638087386644683 | 258 | 142 | 62.3 | 8 | 1183 | 428 | 14 | 238 | MBS1718041.1 hypothetical protein [Armatimonadota bacterium] | diamond | 774 | 67 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27097349 | 27097349 | PRJEB75230_P_NODE_180542_length_241_cov_0.916667_g180360_i0 | PRJEB75230 | 180542 | 241 | 0.916667 | 2.20916747 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 41.2 | 0.0188 | NR | MBI5832915.1 | 2033014 | g180360 | i0 | 39.1 | 0.572614107883817 | 46 | 26 | 57.3 | 1 | 46 | 183 | 12 | 55 | MBI5832915.1 hypothetical protein [Armatimonadota bacterium] | diamond | 138 | 41.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27279908 | 27279908 | PRJEB75230_P_NODE_149023_length_246_cov_0.890173_g148841_i0 | PRJEB75230 | 149023 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0375 | NR | PJB61401.1 | 1973914 | g148841 | i0 | 43.2 | 1.60975609756098 | 44 | 25 | 53.7 | 0 | 23 | 154 | 21 | 64 | PJB61401.1 MAG: hypothetical protein CO096_28990 [Armatimonadetes bacterium CG_4_9_14_3_um_filter_66_14] | diamond | 396 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_9_14_3_um_filter_66_14 | ||||||
| 27381985 | 27381985 | PRJEB75230_P_NODE_111543_length_255_cov_1.269231_g111361_i0 | PRJEB75230 | 111543 | 255 | 1.269231 | 3.23653905 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.1 | 0.0271 | NR | MCL6534386.1 | 2033014 | g111361 | i0 | 35.3 | 0.6 | 51 | 33 | 60 | 0 | 182 | 30 | 142 | 192 | MCL6534386.1 hypothetical protein [Armatimonadota bacterium] | diamond | 153 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27382001 | 27382001 | PRJEB75230_P_NODE_5163_length_608_cov_2.478505_g4982_i0 | PRJEB75230 | 5163 | 608 | 2.478505 | 15.0693104 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 56.6 | 1.21e-6 | NR | HEY3378629.1 | 2033014 | g4982 | i0 | 45.9 | 0.300986842105263 | 61 | 33 | 30.1 | 0 | 89 | 271 | 25 | 85 | HEY3378629.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 183 | 56.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29118737 | 29118737 | PRJEB75230_P_NODE_94829_length_267_cov_1.850515_g94647_i0 | PRJEB75230 | 94829 | 267 | 1.850515 | 4.94087505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.3 | 0.0145 | NR | MBI2252960.1 | 2033014 | g94647 | i0 | 31.8 | 0.741573033707865 | 66 | 44 | 74.2 | 1 | 255 | 58 | 365 | 429 | MBI2252960.1 alpha-amylase [Armatimonadota bacterium] | diamond | 198 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29591686 | 29591686 | PRJEB75230_P_NODE_171910_length_242_cov_1.822485_g171728_i0 | PRJEB75230 | 171910 | 242 | 1.822485 | 4.4104137 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 43.1 | 0.0268 | NR | MCC6730835.1 | 2282151 | g171728 | i0 | 46.8 | 0.582644628099174 | 47 | 24 | 58.3 | 1 | 190 | 50 | 197 | 242 | MCC6730835.1 glycosyltransferase family 39 protein [Chthonomonadales bacterium] | diamond | 141 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 30571124 | 30571124 | PRJEB75230_P_NODE_99673_length_264_cov_1.151832_g99491_i0 | PRJEB75230 | 99673 | 264 | 1.151832 | 3.04083648 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.1 | 0.0331 | NR | NPV46541.1 | 2033014 | g99491 | i0 | 38 | 0.568181818181818 | 50 | 31 | 56.8 | 0 | 90 | 239 | 212 | 261 | NPV46541.1 hypothetical protein [Armatimonadota bacterium] | diamond | 150 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30602813 | 30602813 | PRJEB75230_P_NODE_8133_length_506_cov_2.669746_g7951_i0 | PRJEB75230 | 8133 | 506 | 2.669746 | 13.50891476 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 66.2 | 3.35e-9 | NR | MBM3471926.1 | 2033014 | g7951 | i0 | 50 | 1.35770750988142 | 60 | 29 | 35 | 1 | 307 | 483 | 355 | 414 | MBM3471926.1 hypothetical protein [Armatimonadota bacterium] | diamond | 687 | 66.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31709328 | 31709328 | PRJEB75230_P_NODE_124057_length_250_cov_0.870056_g123875_i0 | PRJEB75230 | 124057 | 250 | 0.870056 | 2.17514 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 42.4 | 0.0205 | NR | MEJ5169884.1 | 2682145 | g123875 | i0 | 35.4 | 0.78 | 65 | 38 | 78 | 1 | 228 | 34 | 55 | 115 | MEJ5169884.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 195 | 42.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 32500488 | 32500488 | PRJEB75230_P_NODE_178519_length_241_cov_1.803571_g178337_i0 | PRJEB75230 | 178519 | 241 | 1.803571 | 4.34660611 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 40.4 | 0.0444 | NR | MBM3459352.1 | 2033014 | g178337 | i0 | 43.5 | 0.572614107883817 | 46 | 20 | 49.8 | 1 | 177 | 58 | 24 | 69 | MBM3459352.1 hypothetical protein [Armatimonadota bacterium] | diamond | 138 | 40.4 | 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);;