contig_metadata
12 rows where bioproject = "PRJNA438687" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4262254 | 4262254 | PRJNA438687_S_NODE_1304_length_347_cov_38.173077_g1214_i0 | PRJNA438687 | 1304 | 347 | 38.173077 | 132.46057719 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 551 | 2.659999999999999e-152 | NTclustered | gi|451917408|gb|KC451272.1| | 34034 | g1214 | i0 | 97.516 | 89.0778097982709 | 322 | 8 | 93 | 0 | 1 | 322 | 322 | 1 | Uncultured delta proteobacterium clone RLBp3211 16S ribosomal RNA gene, partial sequence | blastn | 30910 | 551 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 4262314 | 4262314 | PRJNA438687_S_NODE_4064_length_220_cov_6.329730_g3974_i0 | PRJNA438687 | 4064 | 220 | 6.32973 | 13.925406 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 52.8 | 0.019 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g3974 | i0 | 81.429 | 0.318181818181818 | 70 | 8 | 31 | 5 | 151 | 218 | 1542762 | 1542828 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 70 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 10019343 | 10019343 | PRJNA438687_S_NODE_4868_length_201_cov_27.319277_g4778_i0 | PRJNA438687 | 4868 | 201 | 27.319277 | 54.91174677 | Bacteria | 2 | Bacteria | Bacteria | 350 | 5.539999999999999e-92 | NTclustered | gi|1214630307|gb|MF438913.1| | 34034 | g4778 | i0 | 98.01 | 99.4427860696517 | 201 | 4 | 100 | 0 | 1 | 201 | 365 | 165 | Uncultured delta proteobacterium clone cafs1646 16S ribosomal RNA gene, partial sequence | blastn | 19988 | 350 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 10639146 | 10639146 | PRJNA438687_S_NODE_2069_length_302_cov_17.797753_g1979_i0 | PRJNA438687 | 2069 | 302 | 17.797753 | 53.74921406 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 442 | 1.4299999999999994e-119 | NTclustered | gi|451917199|gb|KC451063.1| | 34034 | g1979 | i0 | 95.341 | 93.7384105960265 | 279 | 11 | 92 | 2 | 1 | 277 | 279 | 1 | Uncultured delta proteobacterium clone RLBp139 16S ribosomal RNA gene, partial sequence | blastn | 28309 | 442 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11294325 | 11294325 | PRJNA438687_S_NODE_4709_length_204_cov_42.828402_g4619_i0 | PRJNA438687 | 4709 | 204 | 42.828402 | 87.36994008 | Myxococcota | 2818505 | Bacteria | Bacteria | 355 | 1.21e-93 | NTclustered | gi|162288851|gb|EU300278.1| | 34034 | g4619 | i0 | 98.039 | 99.8333333333333 | 204 | 4 | 100 | 0 | 1 | 204 | 491 | 288 | Uncultured delta proteobacterium clone GASP-KC3S2_H06 16S ribosomal RNA gene, partial sequence | blastn | 20366 | 355 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11294352 | 11294352 | PRJNA438687_S_NODE_6029_length_178_cov_100.566434_g5939_i0 | PRJNA438687 | 6029 | 178 | 100.566434 | 179.00825252 | Bacteria | 2 | Bacteria | Bacteria | 324 | 2.89e-84 | NTclustered | gi|146428689|gb|EF219505.1| | 34034 | g5939 | i0 | 99.438 | 99.7415730337079 | 178 | 1 | 100 | 0 | 1 | 178 | 679 | 502 | Uncultured delta proteobacterium clone AI-1F_B06 16S ribosomal RNA gene, partial sequence | blastn | 17754 | 324 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11294369 | 11294369 | PRJNA438687_S_NODE_6649_length_169_cov_8.955224_g6559_i0 | PRJNA438687 | 6649 | 169 | 8.955224 | 15.13432856 | Bacteria | 2 | Bacteria | Bacteria | 313 | 5.859999999999999e-81 | NTclustered | gi|161722964|gb|EU283354.1| | 34034 | g6559 | i0 | 100 | 100 | 169 | 0 | 100 | 0 | 1 | 169 | 458 | 290 | Uncultured delta proteobacterium clone AS15 16S ribosomal RNA gene, complete sequence | blastn | 16900 | 313 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12570075 | 12570075 | PRJNA438687_S_NODE_6030_length_178_cov_84.356643_g5940_i0 | PRJNA438687 | 6030 | 178 | 84.356643 | 150.15482454 | Aetherobacter | 888829 | Bacteria | Bacteria | 324 | 2.89e-84 | NTclustered | gi|119952009|dbj|AB288569.1| | 34034 | g5940 | i0 | 99.438 | 99.9269662921348 | 178 | 1 | 100 | 0 | 1 | 178 | 823 | 646 | Uncultured delta proteobacterium gene for 16S rRNA, partial sequence, clone: RPS-H3 | blastn | 17787 | 324 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 13844754 | 13844754 | PRJNA438687_S_NODE_5131_length_195_cov_36.237500_g5041_i0 | PRJNA438687 | 5131 | 195 | 36.2375 | 70.663125 | Bacteria | 2 | Bacteria | Bacteria | 353 | 4.12e-93 | NTclustered | gi|1330559837|gb|MG804461.1| | 34034 | g5041 | i0 | 100 | 96.4102564102564 | 191 | 0 | 98 | 0 | 1 | 191 | 170 | 360 | Uncultured delta proteobacterium clone 1d_90523 16S ribosomal RNA gene, partial sequence | blastn | 18800 | 353 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 15119051 | 15119051 | PRJNA438687_S_NODE_7732_length_155_cov_109.858333_g7642_i0 | PRJNA438687 | 7732 | 155 | 109.858333 | 170.28041615 | Bacteria | 2 | Bacteria | Bacteria | 287 | 3.21e-73 | NTclustered | gi|679036717|gb|KM016287.1| | 34034 | g7642 | i0 | 100 | 98.6129032258064 | 155 | 0 | 100 | 0 | 1 | 155 | 923 | 769 | Uncultured delta proteobacterium clone CO2-OTU2 16S ribosomal RNA gene, partial sequence | blastn | 15285 | 287 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 18286906 | 18286906 | PRJNA438687_S_NODE_1955_length_308_cov_31.366300_g1865_i0 | PRJNA438687 | 1955 | 308 | 31.3663 | 96.608204 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 357 | 5.44e-94 | NTclustered | gi|60266418|gb|AY921872.1| | 34034 | g1865 | i0 | 90 | 87.75 | 280 | 23 | 91 | 5 | 1 | 279 | 276 | 1 | Uncultured delta proteobacterium clone AKYH836 16S ribosomal RNA gene, partial sequence | blastn | 27027 | 357 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 18286925 | 18286925 | PRJNA438687_S_NODE_2715_length_270_cov_130.825532_g2625_i0 | PRJNA438687 | 2715 | 270 | 130.825532 | 353.2289364 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 449 | 7.51e-122 | NTclustered | gi|151350053|gb|EF662762.1| | 34034 | g2625 | i0 | 97.348 | 98.3037037037037 | 264 | 7 | 98 | 0 | 7 | 270 | 18 | 281 | Uncultured delta proteobacterium clone GASP-MA1W3_B08 16S ribosomal RNA gene, partial sequence | blastn | 26542 | 449 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium |
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);;