contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA600413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 573025 | 573025 | PRJNA600413_P_NODE_121121_length_165_cov_0.879310_g120420_i0 | PRJNA600413 | 121121 | 165 | 0.87931 | 1.4508615 | Geothrix sp. PMB-07 | 3068640 | Bacteria | Bacteria | 261 | 2.11e-65 | NTclustered | gi|2563347696|gb|CP132333.1| | 3068640 | g120420 | i0 | 95.152 | 3.78181818181818 | 165 | 8 | 100 | 0 | 1 | 165 | 2879708 | 2879872 | Geothrix sp. PMB-07 chromosome, complete genome | blastn | 624 | 261 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. PMB-07 | ||
| 573167 | 573167 | PRJNA600413_P_NODE_131201_length_163_cov_0.894737_g130500_i0 | PRJNA600413 | 131201 | 163 | 0.894737 | 1.45842131 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 124 | 2.84e-24 | NTclustered | gi|2874253836|emb|OY969886.1| | 171953 | g130500 | i0 | 80.892 | 0.96319018404908 | 157 | 30 | 96 | 0 | 7 | 163 | 3678366 | 3678210 | MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 | blastn | 157 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 5678027 | 5678027 | PRJNA600413_P_NODE_43765_length_220_cov_1.192982_g43064_i0 | PRJNA600413 | 43765 | 220 | 1.192982 | 2.6245604 | uncultured Bryobacterales bacterium | 2569091 | Bacteria | Bacteria | 193 | 1.1e-44 | NTclustered | gi|2546137838|emb|OY282420.1| | 2569091 | g43064 | i0 | 83.568 | 2.23181818181818 | 213 | 28 | 95 | 5 | 12 | 220 | 2023511 | 2023720 | MAG: uncultured Bryobacterales bacterium isolate 78526416-339a-45b8-a6d3-8fabb82c2801 genome assembly, chromosome: 1 | blastn | 491 | 193 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | uncultured Bryobacterales bacterium | ||||
| 6951756 | 6951756 | PRJNA600413_P_NODE_153446_length_157_cov_2.694444_g152745_i0 | PRJNA600413 | 153446 | 157 | 2.694444 | 4.23027708 | Mesoterricola silvestris | 2927979 | Bacteria | Bacteria | 65.8 | 1.66e-6 | NTclustered | gi|2490891634|dbj|AP027080.1| | 2927979 | g152745 | i0 | 93.182 | 2.70700636942675 | 44 | 3 | 28 | 0 | 114 | 157 | 2668670 | 2668713 | Mesoterricola silvestris W79 DNA, complete genome | blastn | 425 | 65.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Mesoterricola | Mesoterricola silvestris | ||
| 9503493 | 9503493 | PRJNA600413_P_NODE_78968_length_180_cov_1.961832_g78267_i0 | PRJNA600413 | 78968 | 180 | 1.961832 | 3.5312976 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 220 | 3.96e-53 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g78267 | i0 | 89.385 | 205.216666666667 | 179 | 13 | 99 | 4 | 1 | 179 | 4784768 | 4784596 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 36939 | 220 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 10777307 | 10777307 | PRJNA600413_P_NODE_115909_length_165_cov_1.620690_g115208_i0 | PRJNA600413 | 115909 | 165 | 1.62069 | 2.6741385 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 219 | 1.29e-52 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g115208 | i0 | 91.72 | 57.2969696969697 | 157 | 13 | 95 | 0 | 1 | 157 | 2094245 | 2094401 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 9454 | 219 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 13329204 | 13329204 | PRJNA600413_P_NODE_85791_length_176_cov_1.606299_g85090_i0 | PRJNA600413 | 85791 | 176 | 1.606299 | 2.82708624 | Geothrix sp. 21YS21S-4 | 3068889 | Bacteria | Bacteria | 270 | 3.77e-68 | NTclustered | gi|2565867660|gb|CP132719.1| | 3068889 | g85090 | i0 | 94.318 | 26.9375 | 176 | 10 | 100 | 0 | 1 | 176 | 3007487 | 3007662 | Geothrix sp. 21YS21S-4 chromosome, complete genome | blastn | 4741 | 270 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. 21YS21S-4 | ||
| 13329306 | 13329306 | PRJNA600413_P_NODE_90991_length_173_cov_1.483871_g90290_i0 | PRJNA600413 | 90991 | 173 | 1.483871 | 2.56709683 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 307 | 2.81e-79 | NTclustered | gi|630059916|gb|KJ191781.1| | 171953 | g90290 | i0 | 98.837 | 97.0924855491329 | 172 | 2 | 99 | 0 | 1 | 172 | 4 | 175 | Uncultured Acidobacteria bacterium clone CB12 16S ribosomal RNA gene, partial sequence | blastn | 16797 | 307 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14604268 | 14604268 | PRJNA600413_P_NODE_95752_length_170_cov_1.685950_g95051_i0 | PRJNA600413 | 95752 | 170 | 1.68595 | 2.866115 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 176 | 8.09e-40 | NTclustered | gi|2621701418|emb|OY760136.1| | 2910147 | g95051 | i0 | 90.299 | 28.8764705882353 | 134 | 13 | 79 | 0 | 27 | 160 | 2855678 | 2855811 | MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 | blastn | 4909 | 176 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 17151739 | 17151739 | PRJNA600413_P_NODE_3654_length_773_cov_4.301105_g3092_i0 | PRJNA600413 | 3654 | 773 | 4.301105 | 33.24754165 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 774 | 0 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g3092 | i0 | 85.204 | 91.4825355756792 | 784 | 82 | 100 | 28 | 1 | 773 | 4785537 | 4786297 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 70716 | 774 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 18424736 | 18424736 | PRJNA600413_P_NODE_104215_length_167_cov_0.864407_g103514_i0 | PRJNA600413 | 104215 | 167 | 0.864407 | 1.44355969 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 102 | 1.37e-17 | NTclustered | gi|2874253980|emb|OY970305.1| | 194844 | g103514 | i0 | 77.844 | 1.26347305389222 | 167 | 35 | 99 | 2 | 2 | 167 | 384912 | 385077 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1 | blastn | 211 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 24799499 | 24799499 | PRJNA600413_P_NODE_139480_length_162_cov_0.902655_g138779_i0 | PRJNA600413 | 139480 | 162 | 0.902655 | 1.4623011 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 52.8 | 0.013 | NTclustered | gi|2621704042|emb|OY760734.1| | 2910147 | g138779 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 86 | 113 | 2847784 | 2847757 | MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales 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);;