contig_metadata
6 rows where bioproject = "PRJNA1034994", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1442953 | 1442953 | PRJNA1034994_P_NODE_1022_length_508_cov_4.482759_g938_i0 | PRJNA1034994 | 1022 | 508 | 4.482759 | 22.77241572 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 625 | 2.3399999999999997e-174 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g938 | i0 | 88.867 | 195.785433070866 | 512 | 52 | 100 | 5 | 1 | 508 | 3833068 | 3833578 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 99459 | 625 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 11646790 | 11646790 | PRJNA1034994_P_NODE_1450_length_422_cov_1.128940_g1366_i0 | PRJNA1034994 | 1450 | 422 | 1.12894 | 4.7641268 | Verrucomicrobia bacterium IMCC26134 | 1637999 | Bacteria | Bacteria | 713 | 0 | NTclustered | gi|807238858|gb|CP011265.1| | 1637999 | g1366 | i0 | 97.156 | 127.13981042654 | 422 | 12 | 100 | 0 | 1 | 422 | 1903300 | 1903721 | Verrucomicrobia bacterium IMCC26134, complete genome | blastn | 53653 | 713 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 | |||||
| 12921929 | 12921929 | PRJNA1034994_P_NODE_1131_length_480_cov_2.385749_g1047_i0 | PRJNA1034994 | 1131 | 480 | 2.385749 | 11.4515952 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 617 | 3.68e-172 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g1047 | i0 | 89.979 | 97.7291666666667 | 479 | 47 | 99 | 1 | 1 | 478 | 5637774 | 5638252 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 46910 | 617 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 15471095 | 15471095 | PRJNA1034994_P_NODE_3193_length_290_cov_3.129032_g3109_i0 | PRJNA1034994 | 3193 | 290 | 3.129032 | 9.0741928 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 420 | 6.39e-113 | NTclustered | gi|226525317|gb|FJ872374.1| | 156588 | g3109 | i0 | 92.881 | 56.5758620689655 | 295 | 12 | 100 | 8 | 1 | 290 | 4031 | 4321 | Uncultured Verrucomicrobia bacterium clone 184 genomic sequence | blastn | 16407 | 420 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 23120423 | 23120423 | PRJNA1034994_P_NODE_3639_length_285_cov_1.452830_g3555_i0 | PRJNA1034994 | 3639 | 285 | 1.45283 | 4.1405655 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 483 | 7.879999999999998e-132 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g3555 | i0 | 97.193 | 41.0140350877193 | 285 | 8 | 100 | 0 | 1 | 285 | 3804634 | 3804918 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 11689 | 483 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 27319735 | 27319735 | PRJNA1034994_P_NODE_4843_length_270_cov_2.258883_g4759_i0 | PRJNA1034994 | 4843 | 270 | 2.258883 | 6.0989841 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 114 | 4.86e-30 | NR | MBR3944625.1 | 1872421 | g4759 | i0 | 98.2 | 1.22222222222222 | 55 | 1 | 61.1 | 0 | 4 | 168 | 106 | 160 | MBR3944625.1 hypothetical protein [Akkermansia sp.] | diamond | 330 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. |
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);;