contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA630877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 603073 | 603073 | PRJNA630877_S_NODE_131761_length_175_cov_3.201493_g112624_i0 | PRJNA630877 | 131761 | 175 | 3.201493 | 5.60261275 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 230 | 6.349999999999998e-56 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g112624 | i0 | 90.341 | 97.9428571428571 | 176 | 15 | 100 | 2 | 1 | 175 | 1509 | 1683 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 17140 | 230 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 1151757 | 1151757 | PRJNA630877_S_NODE_76201_length_313_cov_3.617647_g57064_i0 | PRJNA630877 | 76201 | 313 | 3.617647 | 11.32323511 | Bacteria | 2 | Bacteria | Bacteria | 444 | 4.13e-120 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g57064 | i0 | 92.308 | 153.702875399361 | 312 | 24 | 99 | 0 | 1 | 312 | 3831045 | 3830734 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 48109 | 444 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 5706726 | 5706726 | PRJNA630877_S_NODE_159765_length_150_cov_1.990826_g140628_i0 | PRJNA630877 | 159765 | 150 | 1.990826 | 2.986239 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 213 | 5.3e-51 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g140628 | i0 | 92.105 | 107.373333333333 | 152 | 10 | 100 | 2 | 1 | 150 | 1868 | 1717 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 16106 | 213 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 12082566 | 12082566 | PRJNA630877_S_NODE_45010_length_660_cov_13.894992_g27208_i0 | PRJNA630877 | 45010 | 660 | 13.894992 | 91.7069472 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 1208 | 0 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g27208 | i0 | 99.697 | 105.922727272727 | 660 | 2 | 100 | 0 | 1 | 660 | 736430 | 737089 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 69909 | 1208 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 19729746 | 19729746 | PRJNA630877_S_NODE_78316_length_302_cov_6.720307_g59179_i0 | PRJNA630877 | 78316 | 302 | 6.720307 | 20.29532714 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 475 | 1.4099999999999997e-129 | NTclustered | gi|389545847|gb|JQ400775.1| | 156588 | g59179 | i0 | 95.05 | 102.506622516556 | 303 | 13 | 100 | 2 | 1 | 302 | 330 | 29 | Uncultured Verrucomicrobia bacterium clone CNY_00669 16S ribosomal RNA gene, partial sequence | blastn | 30957 | 475 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 21005521 | 21005521 | PRJNA630877_S_NODE_53477_length_517_cov_9.060924_g34601_i0 | PRJNA630877 | 53477 | 517 | 9.060924 | 46.84497708 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 845 | 0 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g34601 | i0 | 96.132 | 171.810444874275 | 517 | 20 | 100 | 0 | 1 | 517 | 737542 | 737026 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 88826 | 845 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 22280229 | 22280229 | PRJNA630877_S_NODE_13918_length_1840_cov_7.908838_g7582_i0 | PRJNA630877 | 13918 | 1840 | 7.908838 | 145.5226192 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 1947 | 0 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g7582 | i0 | 85.961 | 191.945108695652 | 1852 | 224 | 100 | 31 | 1 | 1840 | 26740 | 28567 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 353179 | 1947 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 22280233 | 22280233 | PRJNA630877_S_NODE_44918_length_662_cov_13.652174_g27139_i0 | PRJNA630877 | 44918 | 662 | 13.652174 | 90.37739188 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 948 | 0 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g27139 | i0 | 92.62 | 105.519637462236 | 664 | 41 | 99 | 8 | 1 | 660 | 736430 | 737089 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 69854 | 948 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 22280246 | 22280246 | PRJNA630877_S_NODE_98758_length_230_cov_1.873016_g79621_i0 | PRJNA630877 | 98758 | 230 | 1.873016 | 4.3079368 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g79621 | i0 | 92.308 | 1.26086956521739 | 39 | 2 | 17 | 1 | 147 | 185 | 1050321 | 1050284 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 290 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 24829372 | 24829372 | PRJNA630877_S_NODE_116540_length_195_cov_1.707792_g97403_i0 | PRJNA630877 | 116540 | 195 | 1.707792 | 3.3301944 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 243 | 9.32e-60 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g97403 | i0 | 89.34 | 83.425641025641 | 197 | 16 | 100 | 5 | 1 | 195 | 3833222 | 3833415 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 16268 | 243 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 24829381 | 24829381 | PRJNA630877_S_NODE_37100_length_839_cov_3.810777_g21304_i0 | PRJNA630877 | 37100 | 839 | 3.810777 | 31.97241903 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 1066 | 0 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g21304 | i0 | 89.94 | 131.07747318236 | 835 | 73 | 99 | 8 | 11 | 839 | 1316393 | 1315564 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 109974 | 1066 | 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);;