contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJDB4941" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5112727 | 5112727 | PRJDB4941_P_NODE_28665_length_186_cov_2.656934_g27897_i0 | PRJDB4941 | 28665 | 186 | 2.656934 | 4.94189724 | Haloferula helveola | 490095 | Bacteria | Bacteria | 137 | 4.27e-28 | NTclustered | gi|2647781590|dbj|AP024702.1| | 490095 | g27897 | i0 | 81.503 | 7.16129032258065 | 173 | 26 | 91 | 6 | 14 | 183 | 2548531 | 2548700 | Haloferula helveola CN-1 DNA, complete genome | blastn | 1332 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 7662744 | 7662744 | PRJDB4941_P_NODE_31167_length_178_cov_1.209302_g30399_i0 | PRJDB4941 | 31167 | 178 | 1.209302 | 2.15255756 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 113 | 6.81e-21 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g30399 | i0 | 80.405 | 1.67415730337079 | 148 | 29 | 83 | 0 | 17 | 164 | 2866916 | 2867063 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 298 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 10213191 | 10213191 | PRJDB4941_P_NODE_28249_length_188_cov_1.496403_g27481_i0 | PRJDB4941 | 28249 | 188 | 1.496403 | 2.81323764 | Opitutus terrae | 107709 | Bacteria | Bacteria | 117 | 5.63e-22 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g27481 | i0 | 85.586 | 0.590425531914894 | 111 | 16 | 59 | 0 | 66 | 176 | 2020382 | 2020272 | Opitutus terrae PB90-1, complete genome | blastn | 111 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 11488205 | 11488205 | PRJDB4941_P_NODE_21870_length_217_cov_1.476190_g21102_i0 | PRJDB4941 | 21870 | 217 | 1.47619 | 3.2033323 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 132 | 2.39e-26 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g21102 | i0 | 78.605 | 0.990783410138249 | 215 | 35 | 96 | 7 | 1 | 209 | 4044533 | 4044742 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 215 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 12764135 | 12764135 | PRJDB4941_P_NODE_41951_length_154_cov_2.085714_g41183_i0 | PRJDB4941 | 41951 | 154 | 2.085714 | 3.21199956 | Opitutus terrae | 107709 | Bacteria | Bacteria | 141 | 2.62e-29 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g41183 | i0 | 83.784 | 9.06493506493507 | 148 | 24 | 96 | 0 | 3 | 150 | 1089325 | 1089472 | Opitutus terrae PB90-1, complete genome | blastn | 1396 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 16587491 | 16587491 | PRJDB4941_P_NODE_4754_length_628_cov_2.804836_g4003_i0 | PRJDB4941 | 4754 | 628 | 2.804836 | 17.61437008 | Synoicihabitans lomoniglobus | 2909285 | Bacteria | Bacteria | 60.2 | 3.73e-4 | NTclustered | gi|2452067159|gb|CP119075.1| | 2909285 | g4003 | i0 | 100 | 0.0509554140127389 | 32 | 0 | 5 | 0 | 30 | 61 | 222775 | 222806 | Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome | blastn | 32 | 60.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Synoicihabitans | Synoicihabitans lomoniglobus | |
| 20108122 | 20108122 | PRJDB4941_P_NODE_25896_length_197_cov_2.108108_g25128_i0 | PRJDB4941 | 25896 | 197 | 2.108108 | 4.15297276 | Opitutaceae | 134623 | Bacteria | Bacteria | 239 | 1.22e-58 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g25128 | i0 | 88.718 | 6.77157360406091 | 195 | 22 | 99 | 0 | 1 | 195 | 4843191 | 4842997 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 1334 | 239 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 20411115 | 20411115 | PRJDB4941_P_NODE_34517_length_169_cov_0.866667_g33749_i0 | PRJDB4941 | 34517 | 169 | 0.866667 | 1.46466723 | Opitutus terrae | 107709 | Bacteria | Bacteria | 156 | 1.05e-33 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g33749 | i0 | 85.43 | 0.893491124260355 | 151 | 20 | 88 | 2 | 10 | 158 | 1106456 | 1106606 | Opitutus terrae PB90-1, complete genome | blastn | 151 | 156 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae |
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);;