contig_metadata
18 rows where bioproject = "PRJNA565584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17712191 | 17712191 | PRJNA565584_P_NODE_168454_length_251_cov_0.865169_g167302_i0 | PRJNA565584 | 168454 | 251 | 0.865169 | 2.17157419 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 137 | 1.59e-35 | NR | MCW3101380.1 | 2739509 | g167302 | i0 | 73.5 | 1.9840637450199201 | 83 | 22 | 99.2 | 0 | 2 | 250 | 1041 | 1123 | MCW3101380.1 putative nucleotidyltransferase, Ribonuclease [Chthonomonadaceae bacterium] | diamond | 498 | 137 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 26636227 | 26636227 | PRJNA565584_P_NODE_75521_length_342_cov_1.118959_g74370_i0 | PRJNA565584 | 75521 | 342 | 1.118959 | 3.82683978 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 87.8 | 1.21e-17 | NR | HTQ11989.1 | 2682144 | g74370 | i0 | 44.2 | 0.991228070175439 | 113 | 61 | 98.2 | 2 | 3 | 338 | 257 | 368 | HTQ11989.1 cysteine desulfurase-like protein [Fimbriimonadaceae bacterium] | diamond | 339 | 87.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26699382 | 26699382 | PRJNA565584_P_NODE_25841_length_610_cov_1.324022_g24703_i0 | PRJNA565584 | 25841 | 610 | 1.324022 | 8.0765342 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 75.9 | 3.06e-13 | NR | ARU44643.1 | 2004468 | g24703 | i0 | 43.8 | 2.03114754098361 | 137 | 68 | 65.4 | 4 | 1 | 399 | 32 | 163 | ARU44643.1 hypothetical protein CCB81_11015 [Armatimonadetes bacterium Uphvl-Ar2] | diamond | 1239 | 75.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 26744565 | 26744565 | PRJNA565584_P_NODE_97401_length_303_cov_1.334783_g96249_i0 | PRJNA565584 | 97401 | 303 | 1.334783 | 4.04439249 | FCB group | 1783270 | Bacteria | Bacteria | 63.2 | 4.47e-9 | NR | HIE08551.1 | 2033014 | g96249 | i0 | 50.9 | 4.92079207920792 | 55 | 27 | 54.5 | 0 | 303 | 139 | 213 | 267 | HIE08551.1 class A beta-lactamase-related serine hydrolase [Armatimonadota bacterium] | diamond | 1491 | 63.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27047835 | 27047835 | PRJNA565584_P_NODE_31202_length_546_cov_2.985201_g30054_i0 | PRJNA565584 | 31202 | 546 | 2.985201 | 16.29919746 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 145 | 1.83e-37 | NR | MFI5385076.1 | 2682145 | g30054 | i0 | 52.3 | 1.43406593406593 | 132 | 60 | 72.5 | 1 | 533 | 138 | 407 | 535 | MFI5385076.1 MmgE/PrpD family protein [Fimbriimonadales bacterium] | diamond | 783 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27490321 | 27490321 | PRJNA565584_P_NODE_69683_length_356_cov_1.272085_g68532_i0 | PRJNA565584 | 69683 | 356 | 1.272085 | 4.5286226 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 80.9 | 2.91e-15 | NR | MEJ5170112.1 | 2682145 | g68532 | i0 | 40.2 | 3.33707865168539 | 102 | 58 | 86 | 2 | 8 | 313 | 236 | 334 | MEJ5170112.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 1188 | 80.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29163884 | 29163884 | PRJNA565584_P_NODE_217629_length_237_cov_3.286585_g216477_i0 | PRJNA565584 | 217629 | 237 | 3.286585 | 7.78920645 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 147 | 1.55e-39 | NR | PIY44557.1 | 1973909 | g216477 | i0 | 100 | 1 | 79 | 0 | 100 | 0 | 1 | 237 | 395 | 473 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 237 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 29447555 | 29447555 | PRJNA565584_P_NODE_185930_length_247_cov_0.885057_g184778_i0 | PRJNA565584 | 185930 | 247 | 0.885057 | 2.18609079 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 152 | 3.1299999999999996e-45 | NR | MBX3115693.1 | 2682144 | g184778 | i0 | 100 | 0.97165991902834 | 80 | 0 | 97.2 | 0 | 6 | 245 | 1 | 80 | MBX3115693.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 240 | 152 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29826601 | 29826601 | PRJNA565584_P_NODE_220711_length_230_cov_2.528662_g219559_i0 | PRJNA565584 | 220711 | 230 | 2.528662 | 5.8159226 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0313 | NR | GIV17465.1 | 2033014 | g219559 | i0 | 43.2 | 0.573913043478261 | 44 | 24 | 56.1 | 1 | 174 | 46 | 412 | 455 | GIV17465.1 MAG: hypothetical protein KatS3mg022_2900 [Armatimonadota bacterium] | diamond | 132 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29921546 | 29921546 | PRJNA565584_P_NODE_113231_length_286_cov_1.446009_g112079_i0 | PRJNA565584 | 113231 | 286 | 1.446009 | 4.13558574 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 67.8 | 1.37e-11 | NR | MCE9557640.1 | 2033014 | g112079 | i0 | 65.3 | 0.513986013986014 | 49 | 17 | 51.4 | 0 | 2 | 148 | 125 | 173 | MCE9557640.1 hypothetical protein [Armatimonadota bacterium] | diamond | 147 | 67.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30647810 | 30647810 | PRJNA565584_P_NODE_147953_length_263_cov_2.478947_g146801_i0 | PRJNA565584 | 147953 | 263 | 2.478947 | 6.51963061 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 97.1 | 2.26e-23 | NR | HXG24844.1 | 2282151 | g146801 | i0 | 55.2 | 1.98479087452471 | 87 | 38 | 98.1 | 1 | 4 | 261 | 23 | 109 | HXG24844.1 hypothetical protein [Chthonomonadales bacterium] | diamond | 522 | 97.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 30742922 | 30742922 | PRJNA565584_P_NODE_34574_length_515_cov_2.769231_g33423_i0 | PRJNA565584 | 34574 | 515 | 2.769231 | 14.26153965 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 1.79e-23 | NR | MBC8139864.1 | 2033014 | g33423 | i0 | 54.1 | 0.978640776699029 | 85 | 38 | 48.9 | 1 | 506 | 255 | 91 | 175 | MBC8139864.1 pyridoxamine 5'-phosphate oxidase family protein [Armatimonadota bacterium] | diamond | 504 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30837670 | 30837670 | PRJNA565584_P_NODE_174734_length_250_cov_0.870056_g173582_i0 | PRJNA565584 | 174734 | 250 | 0.870056 | 2.17514 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 142 | 3.66e-37 | NR | MCW3101545.1 | 2739509 | g173582 | i0 | 84.1 | 2.952 | 82 | 13 | 98.4 | 0 | 3 | 248 | 236 | 317 | MCW3101545.1 uncharacterized protein [Chthonomonadaceae bacterium] | diamond | 738 | 142 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31027366 | 31027366 | PRJNA565584_P_NODE_136235_length_271_cov_1.717172_g135083_i0 | PRJNA565584 | 136235 | 271 | 1.717172 | 4.65353612 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 68.9 | 1.27e-11 | NR | MDQ2730513.1 | 2033014 | g135083 | i0 | 44.4 | 0.896678966789668 | 81 | 44 | 89.7 | 1 | 11 | 253 | 22 | 101 | MDQ2730513.1 phytanoyl-CoA dioxygenase family protein [Armatimonadota bacterium] | diamond | 243 | 68.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31059230 | 31059230 | PRJNA565584_P_NODE_51375_length_415_cov_1.590643_g50224_i0 | PRJNA565584 | 51375 | 415 | 1.590643 | 6.60116845 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 60.8 | 8.83e-9 | NR | RMG22824.1 | 2033014 | g50224 | i0 | 41.9 | 0.874698795180723 | 62 | 36 | 44.8 | 0 | 224 | 409 | 3 | 64 | RMG22824.1 MAG: 30S ribosomal protein S13 [Armatimonadota bacterium] | diamond | 363 | 60.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32261001 | 32261001 | PRJNA565584_P_NODE_132278_length_274_cov_1.263682_g131126_i0 | PRJNA565584 | 132278 | 274 | 1.263682 | 3.46248868 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 84 | 1.11e-16 | NR | MEA3401974.1 | 2033014 | g131126 | i0 | 58.6 | 0.766423357664234 | 70 | 29 | 76.6 | 0 | 3 | 212 | 271 | 340 | MEA3401974.1 hypothetical protein [Armatimonadota bacterium] | diamond | 210 | 84 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32450793 | 32450793 | PRJNA565584_P_NODE_130019_length_275_cov_1.905941_g128867_i0 | PRJNA565584 | 130019 | 275 | 1.905941 | 5.24133775 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 59.7 | 5.07e-8 | NR | MBS1713247.1 | 2033014 | g128867 | i0 | 41.6 | 0.84 | 77 | 39 | 82.9 | 3 | 275 | 48 | 247 | 318 | MBS1713247.1 trypsin-like serine protease [Armatimonadota bacterium] | diamond | 231 | 59.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32671535 | 32671535 | PRJNA565584_P_NODE_66180_length_365_cov_1.582192_g65029_i0 | PRJNA565584 | 66180 | 365 | 1.582192 | 5.7750008 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 230 | 1.92e-70 | NR | PIY44557.1 | 1973909 | g65029 | i0 | 100 | 0.994520547945206 | 121 | 0 | 99.5 | 0 | 3 | 365 | 203 | 323 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 363 | 230 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 |
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);;