contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA695140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 676068 | 676068 | PRJNA695140_S_NODE_11341_length_159_cov_3.762295_g11160_i0 | PRJNA695140 | 11341 | 159 | 3.762295 | 5.98204905 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 220 | 3.4099999999999998e-53 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g11160 | i0 | 91.824 | 109.849056603774 | 159 | 11 | 99 | 2 | 2 | 159 | 1802 | 1645 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 17466 | 220 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 3227028 | 3227028 | PRJNA695140_S_NODE_11263_length_160_cov_1.577236_g11082_i0 | PRJNA695140 | 11263 | 160 | 1.577236 | 2.5235776 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 217 | 4.45e-52 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g11082 | i0 | 91.25 | 17.00625 | 160 | 13 | 100 | 1 | 1 | 160 | 2218397 | 2218555 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 2721 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 4504088 | 4504088 | PRJNA695140_S_NODE_10284_length_166_cov_3.007752_g10103_i0 | PRJNA695140 | 10284 | 166 | 3.007752 | 4.99286832 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 263 | 5.9e-66 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g10103 | i0 | 95.181 | 188.542168674699 | 166 | 8 | 100 | 0 | 1 | 166 | 3861794 | 3861959 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 31298 | 263 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 5779648 | 5779648 | PRJNA695140_S_NODE_8265_length_184_cov_1.802721_g8084_i0 | PRJNA695140 | 8265 | 184 | 1.802721 | 3.31700664 | Lacunisphaera limnophila | 1838286 | Bacteria | Bacteria | 171 | 4.15e-38 | NTclustered | gi|1070531674|gb|CP016094.1| | 1838286 | g8084 | i0 | 85.057 | 60.4021739130435 | 174 | 18 | 93 | 7 | 7 | 178 | 2014843 | 2014676 | Lacunisphaera limnophila strain IG16b, complete genome | blastn | 11114 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera limnophila | |
| 7054695 | 7054695 | PRJNA695140_S_NODE_2666_length_320_cov_2.607774_g2485_i0 | PRJNA695140 | 2666 | 320 | 2.607774 | 8.3448768 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 340 | 5.719999999999999e-89 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g2485 | i0 | 90.98 | 260.0125 | 255 | 19 | 79 | 4 | 66 | 318 | 3804531 | 3804279 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 83204 | 340 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 8329196 | 8329196 | PRJNA695140_S_NODE_11427_length_159_cov_1.795082_g11246_i0 | PRJNA695140 | 11427 | 159 | 1.795082 | 2.85418038 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 183 | 4.469999999999999e-42 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g11246 | i0 | 87.421 | 9.0440251572327 | 159 | 20 | 100 | 0 | 1 | 159 | 1010278 | 1010436 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 1438 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 8329261 | 8329261 | PRJNA695140_S_NODE_6267_length_210_cov_2.063584_g6086_i0 | PRJNA695140 | 6267 | 210 | 2.063584 | 4.3335264 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 263 | 7.82e-66 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g6086 | i0 | 89.756 | 83.1619047619048 | 205 | 21 | 98 | 0 | 6 | 210 | 3863230 | 3863026 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 17464 | 263 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 12660928 | 12660928 | PRJNA695140_S_NODE_2490_length_331_cov_4.329932_g2309_i0 | PRJNA695140 | 2490 | 331 | 4.329932 | 14.33207492 | Oleiharenicola | 2100741 | Bacteria | Bacteria | 62.1 | 5.18e-5 | NTclustered | gi|2707273910|gb|CP149973.1| | 3034326 | g2309 | i0 | 95 | 1.53474320241692 | 40 | 1 | 12 | 1 | 282 | 321 | 459931 | 459893 | Opitutia bacterium KCR 482 chromosome, complete genome | blastn | 508 | 62.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium KCR 482 | ||||
| 15978773 | 15978773 | PRJNA695140_S_NODE_113_length_1975_cov_50.620743_g35_i0 | PRJNA695140 | 113 | 1975 | 50.620743 | 999.75967425 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 2833 | 0 | NTclustered | gi|2874254096|emb|OY970179.1| | 412056 | g35 | i0 | 92.63 | 132.66582278481 | 1981 | 128 | 100 | 14 | 1 | 1975 | 1727236 | 1729204 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 | blastn | 262015 | 2833 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 23628806 | 23628806 | PRJNA695140_S_NODE_1719_length_403_cov_4.928962_g1538_i0 | PRJNA695140 | 1719 | 403 | 4.928962 | 19.86371686 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 333 | 1.23e-86 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g1538 | i0 | 85.03 | 40.560794044665 | 334 | 43 | 82 | 7 | 74 | 403 | 3862491 | 3862161 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 16346 | 333 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 23628820 | 23628820 | PRJNA695140_S_NODE_2739_length_315_cov_8.935252_g2558_i0 | PRJNA695140 | 2739 | 315 | 8.935252 | 28.1460438 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 272 | 2.0799999999999998e-68 | NTclustered | gi|2874254040|emb|OY970364.1| | 412056 | g2558 | i0 | 82.39 | 10.1365079365079 | 318 | 51 | 100 | 5 | 1 | 315 | 952605 | 952290 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 | blastn | 3193 | 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);;