contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4146943 | 4146943 | PRJNA1188114_P_NODE_3084_length_248_cov_1.437186_g3032_i0 | PRJNA1188114 | 3084 | 248 | 1.437186 | 3.56422128 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 375 | 1.1699999999999999e-99 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g3032 | i0 | 94.286 | 95.5524193548387 | 245 | 14 | 100 | 0 | 1 | 245 | 1010097 | 1010341 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 23697 | 375 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 6697902 | 6697902 | PRJNA1188114_P_NODE_4046_length_221_cov_1.546512_g3994_i0 | PRJNA1188114 | 4046 | 221 | 1.546512 | 3.41779152 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 283 | 6.379999999999999e-72 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g3994 | i0 | 90.61 | 289.588235294118 | 213 | 20 | 96 | 0 | 9 | 221 | 1320575 | 1320363 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 63999 | 283 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 7973243 | 7973243 | PRJNA1188114_P_NODE_13807_length_166_cov_0.871795_g13755_i0 | PRJNA1188114 | 13807 | 166 | 0.871795 | 1.4471797 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 124 | 2.9e-24 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g13755 | i0 | 94.937 | 2.9578313253012 | 79 | 4 | 48 | 0 | 88 | 166 | 1970632 | 1970554 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 491 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 7973299 | 7973299 | PRJNA1188114_P_NODE_2027_length_301_cov_1.214286_g1975_i0 | PRJNA1188114 | 2027 | 301 | 1.214286 | 3.65500086 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 488 | 1.7999999999999998e-133 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g1975 | i0 | 96.013 | 286.116279069767 | 301 | 10 | 100 | 2 | 1 | 301 | 3411428 | 3411726 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 86121 | 488 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 14348996 | 14348996 | PRJNA1188114_P_NODE_1332_length_371_cov_1.835404_g1280_i0 | PRJNA1188114 | 1332 | 371 | 1.835404 | 6.80934884 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 518 | 2.89e-142 | NTclustered | gi|183579828|emb|AM905425.1| | 497964 | g1280 | i0 | 92.758 | 249.525606469003 | 359 | 24 | 96 | 2 | 1 | 358 | 2465 | 2108 | Chthoniobacter flavus 23S rRNA gene, strain Ellin428 | blastn | 92574 | 518 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 15622788 | 15622788 | PRJNA1188114_P_NODE_2333_length_280_cov_1.324675_g2281_i0 | PRJNA1188114 | 2333 | 280 | 1.324675 | 3.70909 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 335 | 2.2899999999999993e-87 | NTclustered | gi|2874254020|emb|OY970345.1| | 412056 | g2281 | i0 | 89.219 | 118.971428571429 | 269 | 27 | 96 | 2 | 12 | 280 | 3894741 | 3894475 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1 | blastn | 33312 | 335 | 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);;