contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA851399" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3389998 | 3389998 | PRJNA851399_P_NODE_22743_length_171_cov_1.672131_g22290_i0 | PRJNA851399 | 22743 | 171 | 1.672131 | 2.85934401 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 113 | 2.54e-28 | NR | MFI5088259.1 | 2282142 | g22290 | i0 | 92.9 | 2.94736842105263 | 56 | 4 | 98.2 | 0 | 169 | 2 | 271 | 326 | MFI5088259.1 glutamate--tRNA ligase [Terriglobales bacterium] | diamond | 504 | 113 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 7217650 | 7217650 | PRJNA851399_P_NODE_37206_length_162_cov_0.902655_g36753_i0 | PRJNA851399 | 37206 | 162 | 0.902655 | 1.4623011 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 108 | 9.58e-26 | NR | HZS99434.1 | 2282142 | g36753 | i0 | 96.2 | 1.92592592592593 | 53 | 2 | 98.1 | 0 | 161 | 3 | 340 | 392 | HZS99434.1 trehalase family glycosidase [Terriglobales bacterium] | diamond | 312 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 13592859 | 13592859 | PRJNA851399_P_NODE_13951_length_202_cov_1.326797_g13498_i0 | PRJNA851399 | 13951 | 202 | 1.326797 | 2.68012994 | Bacteria | 2 | Bacteria | Bacteria | 114 | 1.18e-27 | NR | MDT7690618.1 | 1978231 | g13498 | i0 | 81.8 | 13.7227722772277 | 66 | 12 | 98 | 0 | 3 | 200 | 363 | 428 | MDT7690618.1 glycerol kinase [Acidobacteriota bacterium] | diamond | 2772 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 13593267 | 13593267 | PRJNA851399_P_NODE_38551_length_162_cov_0.902655_g38098_i0 | PRJNA851399 | 38551 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 102 | 5.13e-24 | NR | OLE55298.1 | 1803431 | g38098 | i0 | 92.6 | 36.8703703703704 | 54 | 4 | 100 | 0 | 1 | 162 | 188 | 241 | OLE55298.1 MAG: Fis family transcriptional regulator [Acidobacteria bacterium 13_1_20CM_3_53_8] | diamond | 5973 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium 13_1_20CM_3_53_8 | ||||||
| 15262017 | 15262017 | PRJNA851399_P_NODE_42052_length_156_cov_2.859813_g41599_i0 | PRJNA851399 | 42052 | 156 | 2.859813 | 4.46130828 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 93.2 | 1.71e-20 | NR | HZS97851.1 | 2282142 | g41599 | i0 | 88.2 | 0.980769230769231 | 51 | 6 | 98.1 | 0 | 3 | 155 | 72 | 122 | HZS97851.1 amidase [Terriglobales bacterium] | diamond | 153 | 93.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 19965709 | 19965709 | PRJNA851399_P_NODE_20956_length_175_cov_1.619048_g20503_i0 | PRJNA851399 | 20956 | 175 | 1.619048 | 2.833334 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 108 | 3.9e-26 | NR | HEY1215381.1 | 2212468 | g20503 | i0 | 91.4 | 0.994285714285714 | 58 | 5 | 99.4 | 0 | 2 | 175 | 195 | 252 | HEY1215381.1 class I SAM-dependent DNA methyltransferase [Bryobacteraceae bacterium] | diamond | 174 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27308031 | 27308031 | PRJNA851399_P_NODE_40643_length_161_cov_0.910714_g40190_i0 | PRJNA851399 | 40643 | 161 | 0.910714 | 1.46624954 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 70.5 | 1.36e-12 | NR | HEY3824708.1 | 2212468 | g40190 | i0 | 69.6 | 0.857142857142857 | 46 | 14 | 85.7 | 0 | 138 | 1 | 166 | 211 | HEY3824708.1 AEC family transporter [Bryobacteraceae bacterium] | diamond | 138 | 70.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27970924 | 27970924 | PRJNA851399_P_NODE_17325_length_185_cov_1.213235_g16872_i0 | PRJNA851399 | 17325 | 185 | 1.213235 | 2.24448475 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 125 | 8.499999999999998e-32 | NR | HTG89503.1 | 2910147 | g16872 | i0 | 93.4 | 2.96756756756757 | 61 | 4 | 98.9 | 0 | 1 | 183 | 391 | 451 | HTG89503.1 PQQ-binding-like beta-propeller repeat protein [Vicinamibacterales bacterium] | diamond | 549 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28002754 | 28002754 | PRJNA851399_P_NODE_21745_length_173_cov_2.467742_g21292_i0 | PRJNA851399 | 21745 | 173 | 2.467742 | 4.26919366 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 7.05e-13 | NR | PYX69507.1 | 1978231 | g21292 | i0 | 52.6 | 0.988439306358382 | 57 | 27 | 98.8 | 0 | 172 | 2 | 54 | 110 | PYX69507.1 MAG: hypothetical protein DMG72_20725 [Acidobacteriota bacterium] | diamond | 171 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28286493 | 28286493 | PRJNA851399_P_NODE_17226_length_185_cov_1.500000_g16773_i0 | PRJNA851399 | 17226 | 185 | 1.5 | 2.775 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 126 | 5.09e-32 | NR | MEO8076390.1 | 1978231 | g16773 | i0 | 86.9 | 2.96756756756757 | 61 | 8 | 98.9 | 0 | 3 | 185 | 365 | 425 | MEO8076390.1 glycosyl hydrolase 115 family protein [Acidobacteriota bacterium] | diamond | 549 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28823206 | 28823206 | PRJNA851399_P_NODE_35848_length_163_cov_0.894737_g35395_i0 | PRJNA851399 | 35848 | 163 | 0.894737 | 1.45842131 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 78.6 | 2.65e-15 | NR | HEV3214672.1 | 2910147 | g35395 | i0 | 75.9 | 1.98773006134969 | 54 | 13 | 99.4 | 0 | 162 | 1 | 262 | 315 | HEV3214672.1 MFS transporter [Vicinamibacterales bacterium] | diamond | 324 | 78.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29454573 | 29454573 | PRJNA851399_P_NODE_30970_length_165_cov_0.879310_g30517_i0 | PRJNA851399 | 30970 | 165 | 0.87931 | 1.4508615 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 112 | 3.73e-27 | NR | HET6218491.1 | 2052142 | g30517 | i0 | 96.3 | 0.981818181818182 | 54 | 2 | 98.2 | 0 | 2 | 163 | 212 | 265 | HET6218491.1 phosphoketolase family protein [Acidobacteriaceae bacterium] | diamond | 162 | 112 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30181303 | 30181303 | PRJNA851399_P_NODE_28992_length_166_cov_0.871795_g28539_i0 | PRJNA851399 | 28992 | 166 | 0.871795 | 1.4471797 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 101 | 3.1e-23 | NR | HST12039.1 | 2282142 | g28539 | i0 | 87 | 0.975903614457831 | 54 | 7 | 97.6 | 0 | 164 | 3 | 1356 | 1409 | HST12039.1 response regulator [Terriglobales bacterium] | diamond | 162 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 30276478 | 30276478 | PRJNA851399_P_NODE_32912_length_164_cov_0.886957_g32459_i0 | PRJNA851399 | 32912 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 89 | 5.15e-19 | NR | HEX8638146.1 | 2283092 | g32459 | i0 | 85.2 | 6.91463414634146 | 54 | 8 | 98.8 | 0 | 2 | 163 | 251 | 304 | HEX8638146.1 efflux RND transporter periplasmic adaptor subunit [Pyrinomonadaceae bacterium] | diamond | 1134 | 89 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30308254 | 30308254 | PRJNA851399_P_NODE_35932_length_163_cov_0.894737_g35479_i0 | PRJNA851399 | 35932 | 163 | 0.894737 | 1.45842131 | Acidobacteria bacterium ADurb.Bin34 | 1852787 | Bacteria | Bacteria | 79 | 5.4e-16 | NR | OQA37692.1 | 1852787 | g35479 | i0 | 69.8 | 0.975460122699387 | 53 | 16 | 97.5 | 0 | 4 | 162 | 163 | 215 | OQA37692.1 MAG: Hemerythrin HHE cation binding domain protein [Acidobacteria bacterium ADurb.Bin340] | diamond | 159 | 79 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium ADurb.Bin340 | ||||||
| 30402995 | 30402995 | PRJNA851399_P_NODE_21113_length_175_cov_1.619048_g20660_i0 | PRJNA851399 | 21113 | 175 | 1.619048 | 2.833334 | Candidatus Polarisedimenticolaceae bacterium | 2910585 | Bacteria | Bacteria | 111 | 8.28e-27 | NR | HEX5044201.1 | 2910585 | g20660 | i0 | 82.8 | 0.994285714285714 | 58 | 10 | 99.4 | 0 | 2 | 175 | 392 | 449 | HEX5044201.1 PDZ domain-containing protein [Candidatus Polarisedimenticolaceae bacterium] | diamond | 174 | 111 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolales | Candidatus Polarisedimenticolaceae | Candidatus Polarisedimenticolaceae bacterium | |||
| 30497421 | 30497421 | PRJNA851399_P_NODE_28213_length_166_cov_0.871795_g27760_i0 | PRJNA851399 | 28213 | 166 | 0.871795 | 1.4471797 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 100 | 4.98e-25 | NR | MDQ2747125.1 | 1978231 | g27760 | i0 | 83.3 | 0.975903614457831 | 54 | 9 | 97.6 | 0 | 162 | 1 | 15 | 68 | MDQ2747125.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 162 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30528837 | 30528837 | PRJNA851399_P_NODE_16653_length_187_cov_1.224638_g16200_i0 | PRJNA851399 | 16653 | 187 | 1.224638 | 2.29007306 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 41.6 | 0.045 | NR | HEY1336201.1 | 2212468 | g16200 | i0 | 44.4 | 0.866310160427808 | 54 | 21 | 83.4 | 3 | 13 | 168 | 140 | 186 | HEY1336201.1 glycosyltransferase family 2 protein [Bryobacteraceae bacterium] | diamond | 162 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30908210 | 30908210 | PRJNA851399_P_NODE_28794_length_166_cov_0.871795_g28341_i0 | PRJNA851399 | 28794 | 166 | 0.871795 | 1.4471797 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 98.6 | 1.22e-22 | NR | HZS98482.1 | 2282142 | g28341 | i0 | 90.9 | 0.993975903614458 | 55 | 5 | 99.4 | 0 | 166 | 2 | 329 | 383 | HZS98482.1 MdtA/MuxA family multidrug efflux RND transporter periplasmic adaptor subunit [Terriglobales bacterium] | diamond | 165 | 98.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31160445 | 31160445 | PRJNA851399_P_NODE_36995_length_162_cov_1.539823_g36542_i0 | PRJNA851399 | 36995 | 162 | 1.539823 | 2.49451326 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 58.5 | 3.09e-8 | NR | MCD9185470.1 | 2283092 | g36542 | i0 | 96.7 | 0.555555555555556 | 30 | 1 | 55.6 | 0 | 69 | 158 | 1 | 30 | MCD9185470.1 phosphotransferase family protein [Pyrinomonadaceae bacterium] | diamond | 90 | 58.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31666762 | 31666762 | PRJNA851399_P_NODE_33637_length_164_cov_0.886957_g33184_i0 | PRJNA851399 | 33637 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 78.6 | 2.98e-15 | NR | HJY28062.1 | 2283092 | g33184 | i0 | 70.4 | 1.97560975609756 | 54 | 16 | 98.8 | 0 | 162 | 1 | 43 | 96 | HJY28062.1 alpha/beta fold hydrolase [Pyrinomonadaceae bacterium] | diamond | 324 | 78.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31864662 | 31864662 | PRJNA851399_P_NODE_23837_length_169_cov_1.700000_g23384_i0 | PRJNA851399 | 23837 | 169 | 1.7 | 2.873 | Granulicella | 940557 | Bacteria | Bacteria | 100 | 3.62e-23 | NR | WP_217644083.1 | 474950 | g23384 | i0 | 85.5 | 6.83431952662722 | 55 | 8 | 97.6 | 0 | 167 | 3 | 160 | 214 | WP_217644083.1 voltage-gated chloride channel family protein [Granulicella pectinivorans] | diamond | 1155 | 101 | 0.99009900990099 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella pectinivorans | ||
| 32086348 | 32086348 | PRJNA851399_P_NODE_32718_length_164_cov_0.886957_g32265_i0 | PRJNA851399 | 32718 | 164 | 0.886957 | 1.45460948 | Acidobacteriota | 57723 | Bacteria | Bacteria | 102 | 1.85e-24 | NR | HEY6403087.1 | 2052146 | g32265 | i0 | 92.5 | 7.75609756097561 | 53 | 4 | 97 | 0 | 2 | 160 | 245 | 297 | HEY6403087.1 hypothetical protein [Blastocatellia bacterium] | diamond | 1272 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32149721 | 32149721 | PRJNA851399_P_NODE_25838_length_167_cov_0.864407_g25385_i0 | PRJNA851399 | 25838 | 167 | 0.864407 | 1.44355969 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 1.1099999999999999e-23 | NR | MBI1791239.1 | 1978231 | g25385 | i0 | 79.6 | 4.8502994011976 | 54 | 11 | 97 | 0 | 162 | 1 | 199 | 252 | MBI1791239.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 810 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32521386 | 32521386 | PRJNA851399_P_NODE_30559_length_165_cov_0.879310_g30106_i0 | PRJNA851399 | 30559 | 165 | 0.87931 | 1.4508615 | Candidatus Sulfopaludibacter sp. | 2963552 | Bacteria | Bacteria | 114 | 1.15e-29 | NR | HEV2444413.1 | 2963552 | g30106 | i0 | 90.9 | 3 | 55 | 5 | 100 | 0 | 1 | 165 | 107 | 161 | HEV2444413.1 ThuA domain-containing protein [Candidatus Sulfopaludibacter sp.] | diamond | 495 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. | ||
| 32804609 | 32804609 | PRJNA851399_P_NODE_24260_length_168_cov_1.714286_g23807_i0 | PRJNA851399 | 24260 | 168 | 1.714286 | 2.88000048 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 80.9 | 4.8e-16 | NR | MBZ5620338.1 | 2081523 | g23807 | i0 | 74.1 | 0.964285714285714 | 54 | 14 | 96.4 | 0 | 3 | 164 | 391 | 444 | MBZ5620338.1 carboxypeptidase regulatory-like domain-containing protein [Terriglobia bacterium] | diamond | 162 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia 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);;