contig_metadata
12 rows where bioproject = "PRJNA1036688" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169643 | 169643 | PRJNA1036688_P_NODE_3401_length_352_cov_2.749206_g3110_i0 | PRJNA1036688 | 3401 | 352 | 2.749206 | 9.67720512 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 529 | 1.2599999999999996e-145 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g3110 | i0 | 93.768 | 148.196022727273 | 353 | 21 | 100 | 1 | 1 | 352 | 2365853 | 2365501 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 52165 | 529 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 2720108 | 2720108 | PRJNA1036688_P_NODE_7363_length_206_cov_2.686391_g7071_i0 | PRJNA1036688 | 7363 | 206 | 2.686391 | 5.53396546 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 302 | 1.62e-77 | NTclustered | gi|183579828|emb|AM905425.1| | 497964 | g7071 | i0 | 97.207 | 242.393203883495 | 179 | 4 | 87 | 1 | 28 | 206 | 2188 | 2365 | Chthoniobacter flavus 23S rRNA gene, strain Ellin428 | blastn | 49933 | 302 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 9936207 | 9936207 | PRJNA1036688_P_NODE_8728_length_185_cov_1.527027_g8436_i0 | PRJNA1036688 | 8728 | 185 | 1.527027 | 2.82499995 | Opitutus | 178440 | Bacteria | Bacteria | 315 | 1.8199999999999998e-81 | NTclustered | gi|470483113|ref|NR_076574.1| | 107709 | g8436 | i0 | 97.297 | 165.281081081081 | 185 | 5 | 100 | 0 | 1 | 185 | 1598 | 1782 | Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence | blastn | 30577 | 315 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 11648185 | 11648185 | PRJNA1036688_P_NODE_5430_length_258_cov_1.760181_g5138_i0 | PRJNA1036688 | 5430 | 258 | 1.760181 | 4.54126698 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 427 | 3.34e-115 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g5138 | i0 | 96.525 | 115.015503875969 | 259 | 8 | 100 | 1 | 1 | 258 | 2363758 | 2364016 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 29674 | 427 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 12923357 | 12923357 | PRJNA1036688_P_NODE_2551_length_428_cov_1.964194_g2261_i0 | PRJNA1036688 | 2551 | 428 | 1.964194 | 8.40675032 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 632 | 1.1599999999999998e-176 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g2261 | i0 | 93.853 | 160.679906542056 | 423 | 20 | 98 | 6 | 9 | 428 | 2364637 | 2365056 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 68771 | 632 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 12923400 | 12923400 | PRJNA1036688_P_NODE_7971_length_196_cov_1.735849_g7679_i0 | PRJNA1036688 | 7971 | 196 | 1.735849 | 3.40226404 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 285 | 1.54e-72 | NTclustered | gi|2874253974|emb|OY970299.1| | 412056 | g7679 | i0 | 92.857 | 148.923469387755 | 196 | 14 | 100 | 0 | 1 | 196 | 1258288 | 1258093 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 | blastn | 29189 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 15472472 | 15472472 | PRJNA1036688_P_NODE_11793_length_154_cov_1.290598_g11501_i0 | PRJNA1036688 | 11793 | 154 | 1.290598 | 1.98752092 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 285 | 1.14e-72 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g11501 | i0 | 100 | 5.87012987012987 | 154 | 0 | 100 | 0 | 1 | 154 | 2704 | 2857 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 904 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 18021492 | 18021492 | PRJNA1036688_P_NODE_10055_length_169_cov_2.121212_g9763_i0 | PRJNA1036688 | 10055 | 169 | 2.121212 | 3.58484828 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 279 | 5.95e-71 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g9763 | i0 | 96.45 | 8.07100591715976 | 169 | 6 | 100 | 0 | 1 | 169 | 421 | 253 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 1364 | 279 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 18859691 | 18859691 | PRJNA1036688_P_NODE_11055_length_160_cov_1.268293_g10763_i0 | PRJNA1036688 | 11055 | 160 | 1.268293 | 2.0292688 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 281 | 1.55e-71 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g10763 | i0 | 98.148 | 270.3875 | 162 | 1 | 100 | 2 | 1 | 160 | 3413305 | 3413144 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 43262 | 281 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 19295457 | 19295457 | PRJNA1036688_P_NODE_12056_length_152_cov_1.008696_g11764_i0 | PRJNA1036688 | 12056 | 152 | 1.008696 | 1.53321792 | Verrucomicrobium sp. GAS474 | 1882831 | Bacteria | Bacteria | 183 | 4.22e-42 | NTclustered | gi|1085974270|emb|LT629781.1| | 1882831 | g11764 | i0 | 91.241 | 1.88157894736842 | 137 | 9 | 89 | 3 | 18 | 152 | 3537351 | 3537486 | Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I | blastn | 286 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. GAS474 | |
| 19295468 | 19295468 | PRJNA1036688_P_NODE_2496_length_435_cov_2.183417_g2207_i0 | PRJNA1036688 | 2496 | 435 | 2.183417 | 9.49786395 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 787 | 0 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g2207 | i0 | 99.31 | 79.7218390804598 | 435 | 3 | 100 | 0 | 1 | 435 | 1316 | 882 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 34679 | 787 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 24395765 | 24395765 | PRJNA1036688_P_NODE_9780_length_172_cov_1.888889_g9488_i0 | PRJNA1036688 | 9780 | 172 | 1.888889 | 3.24888908 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 272 | 1.02e-68 | NTclustered | gi|2874253974|emb|OY970299.1| | 412056 | g9488 | i0 | 95.322 | 91.0523255813954 | 171 | 8 | 99 | 0 | 2 | 172 | 1258248 | 1258418 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 | blastn | 15661 | 272 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae 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);;