contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26661735 | 26661735 | PRJNA1240804_P_NODE_90561_length_179_cov_1.830769_g90195_i0 | PRJNA1240804 | 90561 | 179 | 1.830769 | 3.27707651 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 73.6 | 2.14e-13 | NR | MDR3691178.1 | 1936159 | g90195 | i0 | 56.9 | 0.972067039106145 | 58 | 22 | 92.2 | 1 | 177 | 13 | 632 | 689 | MDR3691178.1 hypothetical protein [Fimbriimonas sp.] | diamond | 174 | 73.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 26883789 | 26883789 | PRJNA1240804_P_NODE_129821_length_165_cov_1.224138_g129455_i0 | PRJNA1240804 | 129821 | 165 | 1.224138 | 2.0198277 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 70.1 | 2.94e-12 | NR | MDR3691191.1 | 1936159 | g129455 | i0 | 66.7 | 0.981818181818182 | 54 | 18 | 98.2 | 0 | 165 | 4 | 169 | 222 | MDR3691191.1 hypothetical protein [Fimbriimonas sp.] | diamond | 162 | 70.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 27294731 | 27294731 | PRJNA1240804_P_NODE_152743_length_158_cov_2.110092_g152377_i0 | PRJNA1240804 | 152743 | 158 | 2.110092 | 3.33394536 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 70.1 | 2.22e-13 | NR | MBX7135334.1 | 2682144 | g152377 | i0 | 88.6 | 1.99367088607595 | 35 | 4 | 66.5 | 0 | 145 | 41 | 68 | 102 | MBX7135334.1 dCMP deaminase family protein [Fimbriimonadaceae bacterium] | diamond | 315 | 70.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27452882 | 27452882 | PRJNA1240804_P_NODE_110803_length_169_cov_0.866667_g110437_i0 | PRJNA1240804 | 110803 | 169 | 0.866667 | 1.46466723 | Armatimonadetes bacterium CG | 2033014 | Bacteria | Bacteria | 99.8 | 1.09e-22 | NR | PIU92138.1 | 1973915 | g110437 | i0 | 94.1 | 2.71597633136095 | 51 | 3 | 90.5 | 0 | 168 | 16 | 171 | 221 | PIU92138.1 MAG: hypothetical protein COS65_19440 [Armatimonadetes bacterium CG06_land_8_20_14_3_00_66_21] | diamond | 459 | 99.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG06_land_8_20_14_3_00_66_21 | ||||||
| 27673904 | 27673904 | PRJNA1240804_P_NODE_143024_length_163_cov_0.912281_g142658_i0 | PRJNA1240804 | 143024 | 163 | 0.912281 | 1.48701803 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 50.1 | 3.16e-5 | NR | HVL40058.1 | 2682144 | g142658 | i0 | 48.1 | 2.77914110429448 | 52 | 24 | 95.7 | 1 | 4 | 159 | 46 | 94 | HVL40058.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 453 | 50.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28526398 | 28526398 | PRJNA1240804_P_NODE_127287_length_166_cov_0.888889_g126921_i0 | PRJNA1240804 | 127287 | 166 | 0.888889 | 1.47555574 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 65.1 | 1.73e-10 | NR | HZT43933.1 | 2739509 | g126921 | i0 | 74.4 | 0.704819277108434 | 39 | 10 | 70.5 | 0 | 22 | 138 | 138 | 176 | HZT43933.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 117 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28639330 | 28639330 | PRJNA1240804_P_NODE_127407_length_166_cov_0.888889_g127041_i0 | PRJNA1240804 | 127407 | 166 | 0.888889 | 1.47555574 | Chthonomonas | 1077265 | Bacteria | Bacteria | 63.2 | 8.16e-10 | NR | MBI5705730.1 | 2033014 | g127041 | i0 | 71.8 | 1.40963855421687 | 39 | 11 | 70.5 | 0 | 132 | 16 | 361 | 399 | MBI5705730.1 homoserine dehydrogenase [Armatimonadota bacterium] | diamond | 234 | 63.5 | 0.995275590551181 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28652526 | 28652526 | PRJNA1240804_P_NODE_125687_length_166_cov_0.888889_g125321_i0 | PRJNA1240804 | 125687 | 166 | 0.888889 | 1.47555574 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 67.8 | 1.44e-11 | NR | MBS1717120.1 | 2033014 | g125321 | i0 | 58.8 | 1.86144578313253 | 51 | 21 | 92.2 | 0 | 153 | 1 | 72 | 122 | MBS1717120.1 hypothetical protein [Armatimonadota bacterium] | diamond | 309 | 67.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28652635 | 28652635 | PRJNA1240804_P_NODE_90067_length_180_cov_1.068702_g89701_i0 | PRJNA1240804 | 90067 | 180 | 1.068702 | 1.9236636 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.9 | 1.09e-10 | NR | MBS1714277.1 | 2033014 | g89701 | i0 | 57.1 | 0.933333333333333 | 56 | 24 | 93.3 | 0 | 178 | 11 | 334 | 389 | MBS1714277.1 glycosyltransferase family 4 protein [Armatimonadota bacterium] | diamond | 168 | 65.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28684239 | 28684239 | PRJNA1240804_P_NODE_114507_length_168_cov_0.873950_g114141_i0 | PRJNA1240804 | 114507 | 168 | 0.87395 | 1.468236 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 48.5 | 9.61e-5 | NR | HZT42546.1 | 2739509 | g114141 | i0 | 54.3 | 0.821428571428571 | 46 | 21 | 82.1 | 0 | 155 | 18 | 86 | 131 | HZT42546.1 OmpH family outer membrane protein [Chthonomonadaceae bacterium] | diamond | 138 | 48.5 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28747321 | 28747321 | PRJNA1240804_P_NODE_96107_length_176_cov_1.141732_g95741_i0 | PRJNA1240804 | 96107 | 176 | 1.141732 | 2.00944832 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 69.3 | 2.56e-12 | NR | MDR3691187.1 | 1936159 | g95741 | i0 | 75 | 0.75 | 44 | 11 | 75 | 0 | 160 | 29 | 94 | 137 | MDR3691187.1 hypothetical protein [Fimbriimonas sp.] | diamond | 132 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 28765317 | 28765317 | PRJNA1240804_P_NODE_85187_length_183_cov_1.313433_g84821_i0 | PRJNA1240804 | 85187 | 183 | 1.313433 | 2.40358239 | Bacillati | 1783272 | Bacteria | Bacteria | 49.3 | 2.96e-5 | NR | MCC6446971.1 | 2033014 | g84821 | i0 | 78.6 | 0.918032786885246 | 28 | 6 | 45.9 | 0 | 98 | 15 | 47 | 74 | MCC6446971.1 MarR family transcriptional regulator [Armatimonadota bacterium] | diamond | 168 | 49.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28936758 | 28936758 | PRJNA1240804_P_NODE_148108_length_162_cov_0.920354_g147742_i0 | PRJNA1240804 | 148108 | 162 | 0.920354 | 1.49097348 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 47.4 | 2.86e-4 | NR | HRF58714.1 | 2682144 | g147742 | i0 | 53.7 | 3.94444444444444 | 54 | 18 | 87 | 1 | 9 | 149 | 459 | 512 | HRF58714.1 ATP-binding protein [Fimbriimonadaceae bacterium] | diamond | 639 | 47.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29441587 | 29441587 | PRJNA1240804_P_NODE_139810_length_164_cov_0.904348_g139444_i0 | PRJNA1240804 | 139810 | 164 | 0.904348 | 1.48313072 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 72.4 | 4.39e-13 | NR | WP_025225494.1 | 1005039 | g139444 | i0 | 78.3 | 1.68292682926829 | 46 | 10 | 84.1 | 0 | 142 | 5 | 589 | 634 | WP_025225494.1 cation acetate symporter [Fimbriimonas ginsengisoli] | diamond | 276 | 72.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 29820543 | 29820543 | PRJNA1240804_P_NODE_148051_length_162_cov_0.920354_g147685_i0 | PRJNA1240804 | 148051 | 162 | 0.920354 | 1.49097348 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 76.6 | 1.19e-14 | NR | HLV80041.1 | 2739509 | g147685 | i0 | 71.2 | 0.962962962962963 | 52 | 15 | 96.3 | 0 | 158 | 3 | 171 | 222 | HLV80041.1 tetratricopeptide repeat protein [Chthonomonadaceae bacterium] | diamond | 156 | 76.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 29978686 | 29978686 | PRJNA1240804_P_NODE_127291_length_166_cov_0.888889_g126925_i0 | PRJNA1240804 | 127291 | 166 | 0.888889 | 1.47555574 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 70.9 | 1.69e-13 | NR | HLK60327.1 | 2739509 | g126925 | i0 | 66 | 0.849397590361446 | 47 | 16 | 84.9 | 0 | 19 | 159 | 43 | 89 | HLK60327.1 ParB N-terminal domain-containing protein [Chthonomonadaceae bacterium] | diamond | 141 | 70.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30073330 | 30073330 | PRJNA1240804_P_NODE_112632_length_168_cov_1.260504_g112266_i0 | PRJNA1240804 | 112632 | 168 | 1.260504 | 2.11764672 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 70.5 | 2.13e-12 | NR | MEP6757528.1 | 2282151 | g112266 | i0 | 51.9 | 0.964285714285714 | 54 | 26 | 96.4 | 0 | 6 | 167 | 388 | 441 | MEP6757528.1 hypothetical protein [Chthonomonadales bacterium] | diamond | 162 | 70.5 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 30199678 | 30199678 | PRJNA1240804_P_NODE_60852_length_204_cov_1.051613_g60486_i0 | PRJNA1240804 | 60852 | 204 | 1.051613 | 2.14529052 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0219 | NR | HJN19114.1 | 2033014 | g60486 | i0 | 43.2 | 0.647058823529412 | 44 | 16 | 51.5 | 1 | 54 | 158 | 43 | 86 | HJN19114.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Armatimonadota bacterium] | diamond | 132 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30231438 | 30231438 | PRJNA1240804_P_NODE_138352_length_164_cov_0.904348_g137986_i0 | PRJNA1240804 | 138352 | 164 | 0.904348 | 1.48313072 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 89.7 | 3.54e-19 | NR | MBN8690832.1 | 2033014 | g137986 | i0 | 91.3 | 0.841463414634146 | 46 | 4 | 84.1 | 0 | 148 | 11 | 699 | 744 | MBN8690832.1 restriction endonuclease [Armatimonadota bacterium] | diamond | 138 | 89.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30484353 | 30484353 | PRJNA1240804_P_NODE_73213_length_191_cov_1.387324_g72847_i0 | PRJNA1240804 | 73213 | 191 | 1.387324 | 2.64978884 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.1 | 0.00283 | NR | MDH7571738.1 | 2033014 | g72847 | i0 | 41.7 | 0.753926701570681 | 48 | 28 | 75.4 | 0 | 166 | 23 | 309 | 356 | MDH7571738.1 glycosyl hydrolase [Armatimonadota bacterium] | diamond | 144 | 45.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31115939 | 31115939 | PRJNA1240804_P_NODE_80795_length_186_cov_1.277372_g80429_i0 | PRJNA1240804 | 80795 | 186 | 1.277372 | 2.37591192 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 69.3 | 2.61e-13 | NR | MCA0359481.1 | 2033014 | g80429 | i0 | 86.1 | 4.01612903225806 | 36 | 5 | 58.1 | 0 | 11 | 118 | 78 | 113 | MCA0359481.1 iron-sulfur cluster assembly accessory protein [Armatimonadota bacterium] | diamond | 747 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31685228 | 31685228 | PRJNA1240804_P_NODE_143817_length_163_cov_0.912281_g143451_i0 | PRJNA1240804 | 143817 | 163 | 0.912281 | 1.48701803 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 89 | 6.31e-19 | NR | MCW3095297.1 | 2739509 | g143451 | i0 | 81.6 | 1.80368098159509 | 49 | 9 | 90.2 | 0 | 161 | 15 | 174 | 222 | MCW3095297.1 valyl-tRNA synthetase [Chthonomonadaceae bacterium] | diamond | 294 | 89 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31685281 | 31685281 | PRJNA1240804_P_NODE_75357_length_190_cov_1.007092_g74991_i0 | PRJNA1240804 | 75357 | 190 | 1.007092 | 1.9134748 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 45.8 | 0.00143 | NR | MCG9894791.1 | 2682144 | g74991 | i0 | 45.7 | 0.726315789473684 | 46 | 25 | 72.6 | 0 | 30 | 167 | 171 | 216 | MCG9894791.1 tyrosine-type recombinase/integrase [Fimbriimonadaceae bacterium] | diamond | 138 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31906763 | 31906763 | PRJNA1240804_P_NODE_133737_length_165_cov_0.896552_g133371_i0 | PRJNA1240804 | 133737 | 165 | 0.896552 | 1.4793108 | Armatimonadetes bacterium Cent15-Ar3 | 1987502 | Bacteria | Bacteria | 108 | 4.86e-28 | NR | OWU65878.1 | 1987502 | g133371 | i0 | 90.6 | 0.963636363636364 | 53 | 5 | 96.4 | 0 | 7 | 165 | 75 | 127 | OWU65878.1 MAG: hypothetical protein CBB60_002400, partial [Armatimonadetes bacterium Cent15-Ar3] | diamond | 159 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Cent15-Ar3 | ||||||
| 32381500 | 32381500 | PRJNA1240804_P_NODE_152819_length_157_cov_3.342593_g152453_i0 | PRJNA1240804 | 152819 | 157 | 3.342593 | 5.24787101 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.8 | 9.56e-4 | NR | HUS80383.1 | 2033014 | g152453 | i0 | 51.1 | 0.859872611464968 | 45 | 22 | 86 | 0 | 136 | 2 | 27 | 71 | HUS80383.1 SLBB domain-containing protein [Armatimonadota bacterium] | diamond | 135 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32508206 | 32508206 | PRJNA1240804_P_NODE_136759_length_164_cov_0.904348_g136393_i0 | PRJNA1240804 | 136759 | 164 | 0.904348 | 1.48313072 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 80.1 | 8.01e-16 | NR | MBX7135641.1 | 2682144 | g136393 | i0 | 73.5 | 0.896341463414634 | 49 | 13 | 89.6 | 0 | 162 | 16 | 79 | 127 | MBX7135641.1 tRNA (N6-isopentenyl adenosine(37)-C2)-methylthiotransferase MiaB [Fimbriimonadaceae bacterium] | diamond | 147 | 80.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae 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);;