contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 655961 | 655961 | PRJNA681822_P_NODE_46281_length_548_cov_1.941053_g44829_i0 | PRJNA681822 | 46281 | 548 | 1.941053 | 10.63697044 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 686 | 0 | NTclustered | gi|12583975|gb|AF245379.1|AF245379 | 48466 | g44829 | i0 | 89.397 | 284.459854014599 | 547 | 54 | 99 | 4 | 4 | 548 | 2612 | 2068 | Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence | blastn | 155884 | 686 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 4484213 | 4484213 | PRJNA681822_P_NODE_476284_length_241_cov_1.833333_g474794_i0 | PRJNA681822 | 476284 | 241 | 1.833333 | 4.41833253 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 309 | 1.17e-79 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g474794 | i0 | 90 | 85.5477178423236 | 240 | 23 | 99 | 1 | 1 | 239 | 3863038 | 3863277 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 20617 | 309 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 6274191 | 6274191 | PRJNA681822_P_NODE_233105_length_290_cov_1.866359_g231616_i0 | PRJNA681822 | 233105 | 290 | 1.866359 | 5.4124411 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2599616993|dbj|AP028972.1| | 3081749 | g231616 | i0 | 100 | 0.206896551724138 | 30 | 0 | 10 | 0 | 89 | 118 | 5348315 | 5348344 | Opitutales bacterium ASA1 DNA, complete genome | blastn | 60 | 56.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Alterococcaceae | Congregicoccus | Congregicoccus parvus | |
| 8823108 | 8823108 | PRJNA681822_P_NODE_196807_length_310_cov_1.949367_g195319_i0 | PRJNA681822 | 196807 | 310 | 1.949367 | 6.0430377 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 80.5 | 1.33e-10 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g195319 | i0 | 84.146 | 0.529032258064516 | 82 | 13 | 26 | 0 | 18 | 99 | 5154017 | 5153936 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 164 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 11373782 | 11373782 | PRJNA681822_P_NODE_217289_length_298_cov_1.893333_g215801_i0 | PRJNA681822 | 217289 | 298 | 1.893333 | 5.64213234 | Luteolibacter | 518753 | Bacteria | Bacteria | 346 | 1.1299999999999999e-90 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g215801 | i0 | 87.667 | 295.006711409396 | 300 | 34 | 100 | 3 | 1 | 298 | 2217430 | 2217132 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 87912 | 346 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 12133825 | 12133825 | PRJNA681822_P_NODE_333210_length_265_cov_1.604167_g331721_i0 | PRJNA681822 | 333210 | 265 | 1.604167 | 4.25104255 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 215 | 2.92e-51 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g331721 | i0 | 82.061 | 484.811320754717 | 262 | 37 | 98 | 8 | 7 | 265 | 276707 | 276453 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 128475 | 215 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 14684076 | 14684076 | PRJNA681822_P_NODE_380452_length_251_cov_1.730337_g378963_i0 | PRJNA681822 | 380452 | 251 | 1.730337 | 4.34314587 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 331 | 2.6100000000000006e-86 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g378963 | i0 | 90.476 | 112.498007968127 | 252 | 22 | 100 | 2 | 1 | 251 | 28406 | 28156 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 28237 | 331 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 15954970 | 15954970 | PRJNA681822_P_NODE_159813_length_334_cov_1.651341_g158325_i0 | PRJNA681822 | 159813 | 334 | 1.651341 | 5.51547894 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 606 | 5.359999999999998e-169 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g158325 | i0 | 99.401 | 260.943113772455 | 334 | 2 | 100 | 0 | 1 | 334 | 26377 | 26044 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 87155 | 606 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 15956578 | 15956578 | PRJNA681822_P_NODE_278933_length_279_cov_1.975728_g277444_i0 | PRJNA681822 | 278933 | 279 | 1.975728 | 5.51228112 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 339 | 1.7599999999999998e-88 | NTclustered | gi|164510704|emb|AJ966883.1| | 48466 | g277444 | i0 | 91.463 | 238.05376344086 | 246 | 21 | 88 | 0 | 34 | 279 | 4859 | 4614 | Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252 | blastn | 66417 | 339 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 19780371 | 19780371 | PRJNA681822_P_NODE_252056_length_286_cov_1.338028_g250567_i0 | PRJNA681822 | 252056 | 286 | 1.338028 | 3.82676008 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 270 | 6.7e-68 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g250567 | i0 | 85.714 | 2.60489510489511 | 259 | 33 | 91 | 3 | 2 | 260 | 3958994 | 3959248 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 745 | 270 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 21056992 | 21056992 | PRJNA681822_P_NODE_330437_length_266_cov_1.378238_g328948_i0 | PRJNA681822 | 330437 | 266 | 1.378238 | 3.66611308 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 228 | 3.7699999999999985e-55 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g328948 | i0 | 85.333 | 58.3157894736842 | 225 | 27 | 83 | 6 | 1 | 222 | 2907717 | 2907496 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 15512 | 228 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 23609001 | 23609001 | PRJNA681822_P_NODE_46319_length_548_cov_1.637895_g44867_i0 | PRJNA681822 | 46319 | 548 | 1.637895 | 8.9756646 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 394 | 7.78e-105 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g44867 | i0 | 80.15 | 2.52372262773723 | 534 | 100 | 97 | 6 | 17 | 547 | 4560339 | 4559809 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 1383 | 394 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 |
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);;