contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5827973 | 5827973 | PRJNA745553_S_NODE_365_length_1014_cov_11.620616_g296_i0 | PRJNA745553 | 365 | 1014 | 11.620616 | 117.83304624 | Bacteria | 2 | Bacteria | Bacteria | 189 | 1.46e-51 | NR | OYW09811.1 | 1970571 | g296 | i0 | 71.1 | 2.52366863905325 | 121 | 35 | 35.8 | 0 | 916 | 554 | 431 | 551 | OYW09811.1 MAG: hypothetical protein B7X34_05945 [Acidobacteriia bacterium 12-62-4] | diamond | 2559 | 189 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Acidobacteriia bacterium 12-62-4 | |||||
| 7102864 | 7102864 | PRJNA745553_S_NODE_19326_length_281_cov_4.072115_g19131_i0 | PRJNA745553 | 19326 | 281 | 4.072115 | 11.44264315 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 137 | 1.85e-37 | NR | HCA58381.1 | 2052146 | g19131 | i0 | 95.7 | 0.747330960854093 | 70 | 3 | 74.7 | 0 | 12 | 221 | 123 | 192 | HCA58381.1 tRNA pseudouridine(55) synthase TruB [Blastocatellia bacterium] | diamond | 210 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 22876172 | 22876172 | PRJNA745553_S_NODE_20458_length_273_cov_5.295000_g20263_i0 | PRJNA745553 | 20458 | 273 | 5.295 | 14.45535 | Bacteria | 2 | Bacteria | Bacteria | 145 | 3.06e-40 | NR | MDQ3419358.1 | 1978231 | g20263 | i0 | 97.3 | 16.8461538461538 | 73 | 2 | 80.2 | 0 | 23 | 241 | 33 | 105 | MDQ3419358.1 chromosomal replication initiator protein DnaA [Acidobacteriota bacterium] | diamond | 4599 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27274033 | 27274033 | PRJNA745553_S_NODE_26503_length_242_cov_1.508876_g26308_i0 | PRJNA745553 | 26503 | 242 | 1.508876 | 3.65147992 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 52 | 1.98e-5 | NR | MCK6684041.1 | 2651171 | g26308 | i0 | 67.9 | 2.08264462809917 | 28 | 9 | 34.7 | 0 | 242 | 159 | 399 | 426 | MCK6684041.1 alpha-amylase [Thermoanaerobaculia bacterium] | diamond | 504 | 52 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28231045 | 28231045 | PRJNA745553_S_NODE_626_length_871_cov_4.926065_g533_i0 | PRJNA745553 | 626 | 871 | 4.926065 | 42.90602615 | Bacteria | 2 | Bacteria | Bacteria | 86.3 | 3.07e-16 | NR | MCX6597008.1 | 1978231 | g533 | i0 | 36.9 | 1.76004592422503 | 157 | 90 | 54.1 | 5 | 354 | 824 | 10 | 157 | MCX6597008.1 carboxypeptidase-like regulatory domain-containing protein [Acidobacteriota bacterium] | diamond | 1533 | 86.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28252850 | 28252850 | PRJNA745553_S_NODE_15386_length_314_cov_3.016598_g15191_i0 | PRJNA745553 | 15386 | 314 | 3.016598 | 9.47211772 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 50.4 | 1.56e-4 | NR | HKT68588.1 | 2282142 | g15191 | i0 | 58.8 | 0.32484076433121 | 34 | 14 | 32.5 | 0 | 278 | 177 | 344 | 377 | HKT68588.1 glycoside hydrolase family 27 protein [Terriglobales bacterium] | diamond | 102 | 50.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 28663501 | 28663501 | PRJNA745553_S_NODE_7887_length_425_cov_5.414773_g7692_i0 | PRJNA745553 | 7887 | 425 | 5.414773 | 23.01278525 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 65.1 | 5.01e-11 | NR | HZH34389.1 | 2283092 | g7692 | i0 | 71.4 | 0.296470588235294 | 42 | 12 | 29.6 | 0 | 2 | 127 | 23 | 64 | HZH34389.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 126 | 65.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29011081 | 29011081 | PRJNA745553_S_NODE_588_length_890_cov_8.916769_g499_i0 | PRJNA745553 | 588 | 890 | 8.916769 | 79.3592441 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 369 | 5.2200000000000005e-123 | NR | MDR3736699.1 | 2052142 | g499 | i0 | 80.3 | 0.771910112359551 | 229 | 42 | 76.2 | 1 | 852 | 175 | 207 | 435 | MDR3736699.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 687 | 369 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 29515678 | 29515678 | PRJNA745553_S_NODE_3050_length_586_cov_2.038986_g2867_i0 | PRJNA745553 | 3050 | 586 | 2.038986 | 11.94845796 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 49.3 | 2.38e-4 | NR | HRJ90080.1 | 2283092 | g2867 | i0 | 51.1 | 0.24061433447099 | 47 | 23 | 24.1 | 0 | 187 | 47 | 9 | 55 | HRJ90080.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 141 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29894908 | 29894908 | PRJNA745553_S_NODE_12371_length_349_cov_2.789855_g12176_i0 | PRJNA745553 | 12371 | 349 | 2.789855 | 9.73659395 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 100 | 5.27e-22 | NR | MEO6237923.1 | 2910147 | g12176 | i0 | 62.1 | 0.747851002865329 | 87 | 32 | 73.9 | 1 | 347 | 90 | 678 | 764 | MEO6237923.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Vicinamibacterales bacterium] | diamond | 261 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30084229 | 30084229 | PRJNA745553_S_NODE_25932_length_244_cov_2.602339_g25737_i0 | PRJNA745553 | 25932 | 244 | 2.602339 | 6.34970716 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 88.6 | 2.53e-18 | NR | HKV13248.1 | 2651171 | g25737 | i0 | 62.5 | 1.64754098360656 | 72 | 26 | 88.5 | 1 | 226 | 11 | 257 | 327 | HKV13248.1 RNB domain-containing ribonuclease [Thermoanaerobaculia bacterium] | diamond | 402 | 88.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30811036 | 30811036 | PRJNA745553_S_NODE_12714_length_345_cov_1.658088_g12519_i0 | PRJNA745553 | 12714 | 345 | 1.658088 | 5.7204036 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 94.7 | 1.73e-20 | NR | MBV8201834.1 | 1978231 | g12519 | i0 | 44.2 | 0.982608695652174 | 113 | 52 | 98.3 | 2 | 3 | 341 | 7 | 108 | MBV8201834.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 339 | 94.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31759454 | 31759454 | PRJNA745553_S_NODE_4057_length_539_cov_4.858369_g3868_i0 | PRJNA745553 | 4057 | 539 | 4.858369 | 26.18660891 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 146 | 3.04e-40 | NR | HXF34980.1 | 2952895 | g3868 | i0 | 56.3 | 0.75139146567718 | 135 | 48 | 74.6 | 4 | 67 | 468 | 1 | 125 | HXF34980.1 alpha/beta hydrolase [Candidatus Acidiferrales bacterium] | diamond | 405 | 146 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 32707989 | 32707989 | PRJNA745553_S_NODE_5920_length_475_cov_3.164179_g5726_i0 | PRJNA745553 | 5920 | 475 | 3.164179 | 15.02985025 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.5 | 1.18e-8 | NR | MBS1766496.1 | 1978231 | g5726 | i0 | 50 | 1.15578947368421 | 60 | 30 | 37.9 | 0 | 18 | 197 | 207 | 266 | MBS1766496.1 methyltransferase domain-containing protein [Acidobacteriota bacterium] | diamond | 549 | 63.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;