contig_metadata
12 rows where bioproject = "PRJNA983838", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 964622 | 964622 | PRJNA983838_P_NODE_108781_length_249_cov_2.494318_g106414_i0 | PRJNA983838 | 108781 | 249 | 2.494318 | 6.21085182 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 279 | 9.5e-71 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g106414 | i0 | 90.521 | 161.044176706827 | 211 | 20 | 85 | 0 | 1 | 211 | 4652053 | 4652263 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 40100 | 279 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 4792830 | 4792830 | PRJNA983838_P_NODE_114764_length_245_cov_0.906977_g112397_i0 | PRJNA983838 | 114764 | 245 | 0.906977 | 2.22209365 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 235 | 2.05e-57 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g112397 | i0 | 90.96 | 281.477551020408 | 177 | 12 | 72 | 3 | 35 | 210 | 4785881 | 4785708 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 68962 | 235 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 7342547 | 7342547 | PRJNA983838_P_NODE_114786_length_245_cov_0.906977_g112419_i0 | PRJNA983838 | 114786 | 245 | 0.906977 | 2.22209365 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 270 | 5.609999999999999e-68 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g112419 | i0 | 86.939 | 113.930612244898 | 245 | 27 | 99 | 5 | 1 | 242 | 4231852 | 4231610 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 27913 | 270 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14992458 | 14992458 | PRJNA983838_P_NODE_102572_length_255_cov_2.747253_g100205_i0 | PRJNA983838 | 102572 | 255 | 2.747253 | 7.00549515 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 127 | 3.4e-34 | NR | HKZ32703.1 | 2793154 | g100205 | i0 | 65.1 | 2.92941176470588 | 83 | 29 | 97.6 | 0 | 254 | 6 | 135 | 217 | HKZ32703.1 superoxide dismutase [Vicinamibacteria bacterium] | diamond | 747 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 26741037 | 26741037 | PRJNA983838_P_NODE_38821_length_533_cov_1.223913_g36461_i0 | PRJNA983838 | 38821 | 533 | 1.223913 | 6.52345629 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 47.8 | 0.00834 | NR | NOZ77945.1 | 1978231 | g36461 | i0 | 42.2 | 0.360225140712946 | 64 | 31 | 32.6 | 1 | 304 | 477 | 228 | 291 | NOZ77945.1 GNAT family N-acetyltransferase [Acidobacteriota bacterium] | diamond | 192 | 47.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26994430 | 26994430 | PRJNA983838_P_NODE_53462_length_408_cov_1.164179_g51095_i0 | PRJNA983838 | 53462 | 408 | 1.164179 | 4.74985032 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 51.2 | 1.72e-4 | NR | HXK08188.1 | 2793154 | g51095 | i0 | 38.6 | 0.742647058823529 | 101 | 48 | 72.1 | 3 | 15 | 308 | 150 | 239 | HXK08188.1 GDSL-type esterase/lipase family protein [Vicinamibacteria bacterium] | diamond | 303 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 27942473 | 27942473 | PRJNA983838_P_NODE_84785_length_288_cov_2.158140_g82418_i0 | PRJNA983838 | 84785 | 288 | 2.15814 | 6.2154432 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 88.6 | 4.82e-18 | NR | HTA46279.1 | 2212468 | g82418 | i0 | 70.2 | 0.59375 | 57 | 17 | 59.4 | 0 | 288 | 118 | 478 | 534 | HTA46279.1 3,4-dehydroadipyl-CoA semialdehyde dehydrogenase [Bryobacteraceae bacterium] | diamond | 171 | 88.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28668696 | 28668696 | PRJNA983838_P_NODE_108147_length_250_cov_0.881356_g105780_i0 | PRJNA983838 | 108147 | 250 | 0.881356 | 2.20339 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 49.3 | 1.92e-4 | NR | MEZ5292908.1 | 2910147 | g105780 | i0 | 32.9 | 0.984 | 82 | 52 | 98.4 | 2 | 5 | 250 | 275 | 353 | MEZ5292908.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 246 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29994912 | 29994912 | PRJNA983838_P_NODE_118931_length_242_cov_0.923077_g116564_i0 | PRJNA983838 | 118931 | 242 | 0.923077 | 2.23384634 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 82.4 | 3.94e-16 | NR | MBV8068816.1 | 2052142 | g116564 | i0 | 49.3 | 1.82231404958678 | 73 | 37 | 90.5 | 0 | 20 | 238 | 390 | 462 | MBV8068816.1 glycosyltransferase [Acidobacteriaceae bacterium] | diamond | 441 | 82.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30974316 | 30974316 | PRJNA983838_P_NODE_113354_length_246_cov_0.901734_g110987_i0 | PRJNA983838 | 113354 | 246 | 0.901734 | 2.21826564 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.00591 | NR | MBS1827897.1 | 1978231 | g110987 | i0 | 31.3 | 0.975609756097561 | 80 | 47 | 89 | 3 | 233 | 15 | 508 | 586 | MBS1827897.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 240 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31707399 | 31707399 | PRJNA983838_P_NODE_102157_length_256_cov_1.704918_g99790_i0 | PRJNA983838 | 102157 | 256 | 1.704918 | 4.36459008 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 114 | 1.01e-27 | NR | MPZ19343.1 | 2004800 | g99790 | i0 | 61 | 3.85546875 | 82 | 32 | 96.1 | 0 | 11 | 256 | 376 | 457 | MPZ19343.1 hypothetical protein [Luteitalea sp.] | diamond | 987 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. | ||
| 32618675 | 32618675 | PRJNA983838_P_NODE_91380_length_275_cov_1.742574_g89013_i0 | PRJNA983838 | 91380 | 275 | 1.742574 | 4.7920785 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 175 | 2.23e-51 | NR | HZB44364.1 | 2283092 | g89013 | i0 | 95.6 | 0.992727272727273 | 91 | 4 | 99.3 | 0 | 274 | 2 | 200 | 290 | HZB44364.1 M48 family metallopeptidase [Pyrinomonadaceae bacterium] | diamond | 273 | 175 | 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);;