contig_metadata
7 rows where bioproject = "PRJNA939370", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8567613 | 8567613 | PRJNA939370_S_NODE_2287_length_181_cov_2.037879_g2235_i0 | PRJNA939370 | 2287 | 181 | 2.037879 | 3.68856099 | Opitutus sp. VeGlc2 | 134634 | Bacteria | Bacteria | 268 | 1.3999999999999999e-67 | NTclustered | gi|164510706|emb|AJ966885.1| | 134634 | g2235 | i0 | 93.37 | 143.911602209945 | 181 | 12 | 100 | 0 | 1 | 181 | 2690 | 2510 | Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246 | blastn | 26048 | 268 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. VeGlc2 | |
| 9842671 | 9842671 | PRJNA939370_S_NODE_2548_length_173_cov_0.862903_g2496_i0 | PRJNA939370 | 2548 | 173 | 0.862903 | 1.49282219 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 285 | 1.32e-72 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g2496 | i0 | 97.041 | 77.1156069364162 | 169 | 5 | 98 | 0 | 5 | 173 | 5153560 | 5153392 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 13341 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 11118334 | 11118334 | PRJNA939370_S_NODE_889_length_307_cov_1.360465_g837_i0 | PRJNA939370 | 889 | 307 | 1.360465 | 4.17662755 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 385 | 2.49e-102 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g837 | i0 | 89.508 | 74.2052117263844 | 305 | 30 | 99 | 2 | 4 | 307 | 1315949 | 1316252 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 22781 | 385 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14942573 | 14942573 | PRJNA939370_S_NODE_1732_length_208_cov_0.949686_g1680_i0 | PRJNA939370 | 1732 | 208 | 0.949686 | 1.97534688 | Nibricoccus sp. IMCC34717 | 3034021 | Bacteria | Bacteria | 329 | 7.52e-86 | NTclustered | gi|2850969968|gb|CP119759.1| | 3034021 | g1680 | i0 | 95.192 | 88.6538461538462 | 208 | 10 | 100 | 0 | 1 | 208 | 1404229 | 1404436 | Nibricoccus sp. IMCC34717 chromosome, complete genome | blastn | 18440 | 329 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus sp. IMCC34717 | |
| 19107547 | 19107547 | PRJNA939370_S_NODE_3275_length_161_cov_0.991071_g3223_i0 | PRJNA939370 | 3275 | 161 | 0.991071 | 1.59562431 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 202 | 1.26e-47 | NTclustered | gi|164510706|emb|AJ966885.1| | 134634 | g3223 | i0 | 89.873 | 31.1366459627329 | 158 | 14 | 98 | 2 | 3 | 160 | 3646 | 3801 | Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246 | blastn | 5013 | 202 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. VeGlc2 | |
| 21316745 | 21316745 | PRJNA939370_S_NODE_2397_length_177_cov_0.960938_g2345_i0 | PRJNA939370 | 2397 | 177 | 0.960938 | 1.70086026 | Nibricoccus aquaticus | 2576891 | Bacteria | Bacteria | 294 | 2.25e-75 | NTclustered | gi|1243404978|gb|CP023344.1| | 2576891 | g2345 | i0 | 96.61 | 14.5310734463277 | 177 | 6 | 100 | 0 | 1 | 177 | 2497126 | 2497302 | Nibricoccus aquaticus strain HZ-65 chromosome, complete genome | blastn | 2572 | 294 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus aquaticus | |
| 32680100 | 32680100 | PRJNA939370_S_NODE_540_length_394_cov_0.910145_g488_i0 | PRJNA939370 | 540 | 394 | 0.910145 | 3.5859713 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 48.1 | 0.00161 | NR | MFN3407990.1 | 2052186 | g488 | i0 | 43.6 | 0.418781725888325 | 55 | 28 | 41.1 | 2 | 225 | 386 | 90 | 142 | MFN3407990.1 carotenoid biosynthesis protein [Limisphaerales bacterium] | diamond | 165 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales 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);;