contig_metadata
6 rows where bioproject = "PRJNA1034995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3995111 | 3995111 | PRJNA1034995_S_NODE_51644_length_159_cov_2.775862_g51488_i0 | PRJNA1034995 | 51644 | 159 | 2.775862 | 4.41362058 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 195 | 2.07e-45 | NTclustered | gi|2621704341|emb|OY760937.1| | 2499141 | g51488 | i0 | 92.593 | 28.3207547169811 | 135 | 10 | 85 | 0 | 3 | 137 | 3991031 | 3990897 | MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1 | blastn | 4503 | 195 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 6546643 | 6546643 | PRJNA1034995_S_NODE_54106_length_152_cov_3.935780_g53950_i0 | PRJNA1034995 | 54106 | 152 | 3.93578 | 5.9823856 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 204 | 3.2399999999999996e-48 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g53950 | i0 | 90.85 | 81.6710526315789 | 153 | 12 | 100 | 2 | 1 | 152 | 1240 | 1089 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 12414 | 204 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 11647085 | 11647085 | PRJNA1034995_S_NODE_41150_length_199_cov_6.134615_g40994_i0 | PRJNA1034995 | 41150 | 199 | 6.134615 | 12.20788385 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 311 | 2.58e-80 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g40994 | i0 | 98.851 | 21.7638190954774 | 174 | 2 | 87 | 0 | 1 | 174 | 3557873 | 3558046 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 4331 | 311 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 15471337 | 15471337 | PRJNA1034995_S_NODE_34153_length_239_cov_4.362245_g33997_i0 | PRJNA1034995 | 34153 | 239 | 4.362245 | 10.42576555 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 307 | 4.15e-79 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g33997 | i0 | 92.523 | 239.983263598326 | 214 | 16 | 90 | 0 | 1 | 214 | 28254 | 28467 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 57356 | 307 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 18020278 | 18020278 | PRJNA1034995_S_NODE_27595_length_291_cov_11.217742_g27439_i0 | PRJNA1034995 | 27595 | 291 | 11.217742 | 32.64362922 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 219 | 2.5099999999999998e-52 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g27439 | i0 | 85.854 | 1.19587628865979 | 205 | 29 | 70 | 0 | 59 | 263 | 1351055 | 1350851 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 348 | 219 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 30216649 | 30216649 | PRJNA1034995_S_NODE_33352_length_244_cov_16.457711_g33196_i0 | PRJNA1034995 | 33352 | 244 | 16.457711 | 40.15681484 | Bacteria | 2 | Bacteria | Bacteria | 120 | 7.880000000000001e-33 | NR | MBI2814774.1 | 2026771 | g33196 | i0 | 77.6 | 1.81967213114754 | 76 | 17 | 93.4 | 0 | 242 | 15 | 3 | 78 | MBI2814774.1 GxxExxY protein [Opitutia bacterium] | diamond | 444 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia 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);;