contig_metadata
23 rows where bioproject = "PRJNA1188114", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2870737 | 2870737 | PRJNA1188114_P_NODE_12783_length_167_cov_0.864407_g12731_i0 | PRJNA1188114 | 12783 | 167 | 0.864407 | 1.44355969 | Holophagales bacterium | 2478486 | Bacteria | Bacteria | 145 | 2.25e-30 | NTclustered | gi|1958024485|gb|CP064972.1| | 2478486 | g12731 | i0 | 83.125 | 57.0299401197605 | 160 | 25 | 95 | 2 | 9 | 167 | 2820333 | 2820175 | Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome | blastn | 9524 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagales bacterium | ||||
| 6697889 | 6697889 | PRJNA1188114_P_NODE_20046_length_161_cov_0.910714_g19994_i0 | PRJNA1188114 | 20046 | 161 | 0.910714 | 1.46624954 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 68.6 | 9.52e-12 | NR | HKH46763.1 | 2651171 | g19994 | i0 | 97 | 3.07453416149068 | 33 | 1 | 61.5 | 0 | 62 | 160 | 1 | 33 | HKH46763.1 carbamoyltransferase [Thermoanaerobaculia bacterium] | diamond | 495 | 68.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 26755646 | 26755646 | PRJNA1188114_P_NODE_7661_length_185_cov_1.227941_g7609_i0 | PRJNA1188114 | 7661 | 185 | 1.227941 | 2.27169085 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 91.7 | 6.61e-20 | NR | HSK74154.1 | 2283092 | g7609 | i0 | 70 | 1.96216216216216 | 60 | 18 | 97.3 | 0 | 6 | 185 | 304 | 363 | HSK74154.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] | diamond | 363 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27325245 | 27325245 | PRJNA1188114_P_NODE_9803_length_176_cov_1.377953_g9751_i0 | PRJNA1188114 | 9803 | 176 | 1.377953 | 2.42519728 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 97.4 | 4.37e-22 | NR | HEY3039857.1 | 2283092 | g9751 | i0 | 77.6 | 3.95454545454545 | 58 | 13 | 98.9 | 0 | 174 | 1 | 113 | 170 | HEY3039857.1 DUF3179 domain-containing (seleno)protein [Pyrinomonadaceae bacterium] | diamond | 696 | 97.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27830422 | 27830422 | PRJNA1188114_P_NODE_12184_length_167_cov_0.864407_g12132_i0 | PRJNA1188114 | 12184 | 167 | 0.864407 | 1.44355969 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 48.9 | 8.92e-5 | NR | MBM3787663.1 | 1978231 | g12132 | i0 | 50 | 0.754491017964072 | 42 | 21 | 75.4 | 0 | 142 | 17 | 144 | 185 | MBM3787663.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 126 | 48.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28020073 | 28020073 | PRJNA1188114_P_NODE_20365_length_155_cov_2.707547_g20313_i0 | PRJNA1188114 | 20365 | 155 | 2.707547 | 4.19669785 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 90.5 | 5.52e-20 | NR | HXH24484.1 | 2910147 | g20313 | i0 | 84 | 8.80645161290323 | 50 | 8 | 96.8 | 0 | 152 | 3 | 139 | 188 | HXH24484.1 galactose-1-phosphate uridylyltransferase [Vicinamibacterales bacterium] | diamond | 1365 | 90.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28430468 | 28430468 | PRJNA1188114_P_NODE_11466_length_169_cov_1.700000_g11414_i0 | PRJNA1188114 | 11466 | 169 | 1.7 | 2.873 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 48.5 | 1.26e-4 | NR | MEO8053233.1 | 1978231 | g11414 | i0 | 52.3 | 1.54437869822485 | 44 | 21 | 78.1 | 0 | 14 | 145 | 291 | 334 | MEO8053233.1 IS1182 family transposase [Acidobacteriota bacterium] | diamond | 261 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28746091 | 28746091 | PRJNA1188114_P_NODE_13387_length_166_cov_0.871795_g13335_i0 | PRJNA1188114 | 13387 | 166 | 0.871795 | 1.4471797 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 78.2 | 4.08e-15 | NR | HVE59534.1 | 2283092 | g13335 | i0 | 69.6 | 1.01204819277108 | 56 | 15 | 97.6 | 1 | 3 | 164 | 300 | 355 | HVE59534.1 VCBS repeat-containing protein [Pyrinomonadaceae bacterium] | diamond | 168 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28859744 | 28859744 | PRJNA1188114_P_NODE_18368_length_162_cov_0.902655_g18316_i0 | PRJNA1188114 | 18368 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 97.1 | 8.83e-22 | NR | MBS1798025.1 | 1978231 | g18316 | i0 | 92.6 | 9 | 54 | 4 | 100 | 0 | 162 | 1 | 270 | 323 | MBS1798025.1 DUF4173 domain-containing protein [Acidobacteriota bacterium] | diamond | 1458 | 97.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28903751 | 28903751 | PRJNA1188114_P_NODE_13908_length_166_cov_0.871795_g13856_i0 | PRJNA1188114 | 13908 | 166 | 0.871795 | 1.4471797 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 65.5 | 1.15e-10 | NR | HJZ69458.1 | 2052146 | g13856 | i0 | 68.5 | 0.975903614457831 | 54 | 16 | 95.8 | 1 | 7 | 165 | 134 | 187 | HJZ69458.1 UDP-2,4-diacetamido-2,4,6-trideoxy-beta-L-altropyranose hydrolase [Blastocatellia bacterium] | diamond | 162 | 65.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28999067 | 28999067 | PRJNA1188114_P_NODE_10128_length_174_cov_2.440000_g10076_i0 | PRJNA1188114 | 10128 | 174 | 2.44 | 4.2456 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 71.2 | 3.12e-13 | NR | HEX4229880.1 | 2212468 | g10076 | i0 | 64.8 | 2.82758620689655 | 54 | 19 | 93.1 | 0 | 164 | 3 | 111 | 164 | HEX4229880.1 ankyrin repeat domain-containing protein [Bryobacteraceae bacterium] | diamond | 492 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29030505 | 29030505 | PRJNA1188114_P_NODE_10708_length_172_cov_1.853659_g10656_i0 | PRJNA1188114 | 10708 | 172 | 1.853659 | 3.18829348 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 81.3 | 3.32e-16 | NR | MBX9599624.1 | 2212468 | g10656 | i0 | 73.7 | 0.994186046511628 | 57 | 15 | 99.4 | 0 | 1 | 171 | 10 | 66 | MBX9599624.1 amidohydrolase family protein [Bryobacteraceae bacterium] | diamond | 171 | 81.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29125294 | 29125294 | PRJNA1188114_P_NODE_16869_length_163_cov_0.894737_g16817_i0 | PRJNA1188114 | 16869 | 163 | 0.894737 | 1.45842131 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 87.4 | 2.19e-18 | NR | MEN6537227.1 | 2212468 | g16817 | i0 | 83 | 0.975460122699387 | 53 | 9 | 97.5 | 0 | 3 | 161 | 371 | 423 | MEN6537227.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29598291 | 29598291 | PRJNA1188114_P_NODE_13770_length_166_cov_0.871795_g13718_i0 | PRJNA1188114 | 13770 | 166 | 0.871795 | 1.4471797 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 88.2 | 1.28e-18 | NR | MBX5497055.1 | 2212468 | g13718 | i0 | 74.1 | 0.975903614457831 | 54 | 14 | 97.6 | 0 | 165 | 4 | 505 | 558 | MBX5497055.1 tetratricopeptide repeat protein [Bryobacteraceae bacterium] | diamond | 162 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29598294 | 29598294 | PRJNA1188114_P_NODE_6110_length_191_cov_1.802817_g6058_i0 | PRJNA1188114 | 6110 | 191 | 1.802817 | 3.44338047 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.9 | 0.00734 | NR | MEN3336403.1 | 1978231 | g6058 | i0 | 45.2 | 0.973821989528796 | 62 | 32 | 94.2 | 1 | 189 | 10 | 445 | 506 | MEN3336403.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 186 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29724632 | 29724632 | PRJNA1188114_P_NODE_2550_length_269_cov_2.190909_g2498_i0 | PRJNA1188114 | 2550 | 269 | 2.190909 | 5.89354521 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 65.1 | 7.09e-10 | NR | HEY7390854.1 | 2212468 | g2498 | i0 | 42.4 | 0.947955390334573 | 85 | 47 | 94.8 | 1 | 1 | 255 | 963 | 1045 | HEY7390854.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 255 | 65.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30072265 | 30072265 | PRJNA1188114_P_NODE_6252_length_190_cov_1.446809_g6200_i0 | PRJNA1188114 | 6252 | 190 | 1.446809 | 2.7489371 | Bryobacter sp. | 1962911 | Bacteria | Bacteria | 103 | 5.1899999999999996e-24 | NR | MCU0246426.1 | 1962911 | g6200 | i0 | 74.6 | 0.994736842105263 | 63 | 16 | 99.5 | 0 | 1 | 189 | 837 | 899 | MCU0246426.1 TonB-dependent receptor [Bryobacter sp.] | diamond | 189 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacter | Bryobacter sp. | ||
| 31146148 | 31146148 | PRJNA1188114_P_NODE_10275_length_174_cov_1.456000_g10223_i0 | PRJNA1188114 | 10275 | 174 | 1.456 | 2.53344 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 81.3 | 3.79e-16 | NR | HEX3646019.1 | 2910147 | g10223 | i0 | 68.4 | 0.982758620689655 | 57 | 18 | 98.3 | 0 | 172 | 2 | 144 | 200 | HEX3646019.1 serine protease [Vicinamibacterales bacterium] | diamond | 171 | 81.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31652412 | 31652412 | PRJNA1188114_P_NODE_11817_length_168_cov_1.084034_g11765_i0 | PRJNA1188114 | 11817 | 168 | 1.084034 | 1.82117712 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 76.3 | 2.11e-14 | NR | HQR37440.1 | 2052146 | g11765 | i0 | 68.8 | 2.78571428571429 | 48 | 15 | 85.7 | 0 | 25 | 168 | 462 | 509 | HQR37440.1 M28 family peptidase [Blastocatellia bacterium] | diamond | 468 | 76.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31968854 | 31968854 | PRJNA1188114_P_NODE_8898_length_180_cov_1.229008_g8846_i0 | PRJNA1188114 | 8898 | 180 | 1.229008 | 2.2122144 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 55.8 | 3.63e-7 | NR | HKW03088.1 | 2910147 | g8846 | i0 | 47.4 | 0.95 | 57 | 19 | 95 | 1 | 172 | 2 | 102 | 147 | HKW03088.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 171 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32063778 | 32063778 | PRJNA1188114_P_NODE_6898_length_188_cov_1.244604_g6846_i0 | PRJNA1188114 | 6898 | 188 | 1.244604 | 2.33985552 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 115 | 5.22e-31 | NR | MEK7725130.1 | 1978231 | g6846 | i0 | 91.9 | 0.98936170212766 | 62 | 5 | 98.9 | 0 | 2 | 187 | 11 | 72 | MEK7725130.1 DNA starvation/stationary phase protection protein Dps [Acidobacteriota bacterium] | diamond | 186 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32317308 | 32317308 | PRJNA1188114_P_NODE_14579_length_165_cov_0.879310_g14527_i0 | PRJNA1188114 | 14579 | 165 | 0.87931 | 1.4508615 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 55.8 | 7.13e-8 | NR | MDQ3710601.1 | 1978231 | g14527 | i0 | 54.5 | 1 | 55 | 22 | 94.5 | 1 | 156 | 1 | 63 | 117 | MDQ3710601.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 165 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32853401 | 32853401 | PRJNA1188114_P_NODE_15480_length_164_cov_0.886957_g15428_i0 | PRJNA1188114 | 15480 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 93.6 | 1.57e-20 | NR | HRH42843.1 | 2283092 | g15428 | i0 | 75.9 | 0.98780487804878 | 54 | 13 | 98.8 | 0 | 164 | 3 | 640 | 693 | HRH42843.1 TonB-dependent receptor [Pyrinomonadaceae bacterium] | diamond | 162 | 93.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;