contig_metadata
13 rows where bioproject = "PRJNA1047321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7827024 | 7827024 | PRJNA1047321_P_NODE_3147_length_369_cov_2.033784_g2978_i0 | PRJNA1047321 | 3147 | 369 | 2.033784 | 7.50466296 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 564 | 3.64e-156 | NTclustered | gi|2874253826|emb|OY969810.1| | 2026791 | g2978 | i0 | 94.309 | 102.921409214092 | 369 | 20 | 99 | 1 | 1 | 368 | 6660304 | 6659936 | MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1 | blastn | 37978 | 564 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 7827030 | 7827030 | PRJNA1047321_P_NODE_3907_length_328_cov_0.898039_g3737_i0 | PRJNA1047321 | 3907 | 328 | 0.898039 | 2.94556792 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2874253836|emb|OY969886.1| | 171953 | g3737 | i0 | 96.875 | 0.0975609756097561 | 32 | 1 | 10 | 0 | 73 | 104 | 2338543 | 2338574 | MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 12928168 | 12928168 | PRJNA1047321_P_NODE_8211_length_243_cov_0.905882_g8040_i0 | PRJNA1047321 | 8211 | 243 | 0.905882 | 2.20129326 | Acidobacteriota | 57723 | Bacteria | Bacteria | 137 | 3.51e-36 | NR | MBA3334589.1 | 1978231 | g8040 | i0 | 78.8 | 8.88888888888889 | 80 | 17 | 98.8 | 0 | 3 | 242 | 112 | 191 | MBA3334589.1 type I glutamate--ammonia ligase [Acidobacteriota bacterium] | diamond | 2160 | 138 | 0.992753623188406 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 14203116 | 14203116 | PRJNA1047321_P_NODE_4672_length_295_cov_2.707207_g4502_i0 | PRJNA1047321 | 4672 | 295 | 2.707207 | 7.98626065 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 379 | 1.11e-100 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g4502 | i0 | 89.831 | 202.081355932203 | 295 | 30 | 100 | 0 | 1 | 295 | 4787469 | 4787175 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 59614 | 379 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 19300185 | 19300185 | PRJNA1047321_P_NODE_4316_length_309_cov_2.411017_g4146_i0 | PRJNA1047321 | 4316 | 309 | 2.411017 | 7.45004253 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 405 | 1.92e-108 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g4146 | i0 | 90.291 | 249.330097087379 | 309 | 30 | 100 | 0 | 1 | 309 | 3559324 | 3559016 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 77043 | 405 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27129666 | 27129666 | PRJNA1047321_P_NODE_7582_length_246_cov_0.890173_g7411_i0 | PRJNA1047321 | 7582 | 246 | 0.890173 | 2.18982558 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 62.4 | 1.56e-9 | NR | HZN11927.1 | 2052146 | g7411 | i0 | 37.3 | 0.914634146341463 | 75 | 47 | 91.5 | 0 | 17 | 241 | 1 | 75 | HZN11927.1 PRC-barrel domain-containing protein [Blastocatellia bacterium] | diamond | 225 | 62.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28069502 | 28069502 | PRJNA1047321_P_NODE_7285_length_247_cov_0.885057_g7114_i0 | PRJNA1047321 | 7285 | 247 | 0.885057 | 2.18609079 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 126 | 1.15e-31 | NR | MYN66478.1 | 1978231 | g7114 | i0 | 73.2 | 2.98785425101215 | 82 | 22 | 99.6 | 0 | 247 | 2 | 439 | 520 | MYN66478.1 DUF87 domain-containing protein [Acidobacteriota bacterium] | diamond | 738 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28140986 | 28140986 | PRJNA1047321_P_NODE_6425_length_251_cov_1.634831_g6254_i0 | PRJNA1047321 | 6425 | 251 | 1.634831 | 4.10342581 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 89.7 | 4.53e-19 | NR | HVJ28611.1 | 2910147 | g6254 | i0 | 63.6 | 1.73306772908367 | 66 | 24 | 78.9 | 0 | 53 | 250 | 18 | 83 | HVJ28611.1 AraC family transcriptional regulator [Vicinamibacterales bacterium] | diamond | 435 | 89.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29814048 | 29814048 | PRJNA1047321_P_NODE_8411_length_242_cov_0.911243_g8240_i0 | PRJNA1047321 | 8411 | 242 | 0.911243 | 2.20520806 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 50.4 | 7.12e-5 | NR | HEX9930534.1 | 2283092 | g8240 | i0 | 34.9 | 1.06611570247934 | 86 | 49 | 97.9 | 1 | 2 | 238 | 539 | 624 | HEX9930534.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 258 | 50.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30477727 | 30477727 | PRJNA1047321_P_NODE_5353_length_275_cov_1.193069_g5182_i0 | PRJNA1047321 | 5353 | 275 | 1.193069 | 3.28093975 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 94 | 1.79e-20 | NR | MCA1606582.1 | 1978231 | g5182 | i0 | 54.5 | 0.96 | 88 | 40 | 96 | 0 | 272 | 9 | 154 | 241 | MCA1606582.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 264 | 94 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31046605 | 31046605 | PRJNA1047321_P_NODE_7635_length_246_cov_0.890173_g7464_i0 | PRJNA1047321 | 7635 | 246 | 0.890173 | 2.18982558 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 69.3 | 1.65e-11 | NR | HSB17870.1 | 2212468 | g7464 | i0 | 50 | 1.79268292682927 | 74 | 33 | 89 | 2 | 3 | 221 | 559 | 629 | HSB17870.1 ABC transporter permease [Bryobacteraceae bacterium] | diamond | 441 | 69.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31457462 | 31457462 | PRJNA1047321_P_NODE_8536_length_242_cov_0.911243_g8365_i0 | PRJNA1047321 | 8536 | 242 | 0.911243 | 2.20520806 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 159 | 8.25e-46 | NR | GIU74549.1 | 2212468 | g8365 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 240 | 1 | 111 | 190 | GIU74549.1 MAG: L-asparaginase [Bryobacteraceae bacterium] | diamond | 240 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32533216 | 32533216 | PRJNA1047321_P_NODE_8759_length_241_cov_0.916667_g8588_i0 | PRJNA1047321 | 8759 | 241 | 0.916667 | 2.20916747 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 83.6 | 1.57e-16 | NR | HZU52761.1 | 2052165 | g8588 | i0 | 73.1 | 0.647302904564315 | 52 | 14 | 64.7 | 0 | 157 | 2 | 1071 | 1122 | HZU52761.1 DUF3857 domain-containing protein [Holophagaceae bacterium] | diamond | 156 | 83.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae 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);;