contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216703 | 216703 | PRJNA1111146_P_NODE_398361_length_179_cov_0.904762_g397223_i0 | PRJNA1111146 | 398361 | 179 | 0.904762 | 1.61952398 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 134 | 5.2600000000000005e-27 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g397223 | i0 | 84.962 | 29.2960893854749 | 133 | 18 | 74 | 2 | 16 | 147 | 7241766 | 7241897 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 5244 | 134 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 1490631 | 1490631 | PRJNA1111146_P_NODE_224842_length_201_cov_1.540541_g223704_i0 | PRJNA1111146 | 224842 | 201 | 1.540541 | 3.09648741 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 137 | 4.69e-28 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g223704 | i0 | 84.783 | 1.43781094527363 | 138 | 20 | 68 | 1 | 39 | 175 | 4746069 | 4745932 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 289 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 4042542 | 4042542 | PRJNA1111146_P_NODE_160544_length_217_cov_1.329268_g159406_i0 | PRJNA1111146 | 160544 | 217 | 1.329268 | 2.88451156 | Methylacidimicrobium sp. AP8 | 2730359 | Bacteria | Bacteria | 152 | 1.84e-32 | NTclustered | gi|1934804479|emb|LR797830.1| | 2730359 | g159406 | i0 | 80 | 280.456221198157 | 210 | 38 | 96 | 4 | 5 | 213 | 561270 | 561476 | Methylacidimicrobium sp. AP8 isolate MTHMO1 genome assembly, chromosome: I | blastn | 60859 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidimicrobium | Methylacidimicrobium sp. AP8 | ||||
| 10420415 | 10420415 | PRJNA1111146_P_NODE_431729_length_177_cov_0.919355_g430591_i0 | PRJNA1111146 | 431729 | 177 | 0.919355 | 1.62725835 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 148 | 1.85e-31 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g430591 | i0 | 82.659 | 10.9491525423729 | 173 | 24 | 96 | 4 | 8 | 177 | 458896 | 458727 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 1938 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 12500726 | 12500726 | PRJNA1111146_P_NODE_303890_length_186_cov_1.684211_g302752_i0 | PRJNA1111146 | 303890 | 186 | 1.684211 | 3.13263246 | Akkermansia | 239934 | Bacteria | Bacteria | 193 | 8.98e-45 | NTclustered | gi|2051350654|gb|CP072036.1| | 2927224 | g302752 | i0 | 86.034 | 47.2795698924731 | 179 | 25 | 96 | 0 | 1 | 179 | 1092879 | 1093057 | Akkermansia massiliensis strain Akk1573 chromosome, complete genome | blastn | 8794 | 193 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia massiliensis | |
| 20617151 | 20617151 | PRJNA1111146_P_NODE_234717_length_199_cov_1.561644_g233579_i0 | PRJNA1111146 | 234717 | 199 | 1.561644 | 3.10767156 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 246 | 7.379999999999999e-61 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g233579 | i0 | 89.055 | 1.01005025125628 | 201 | 19 | 99 | 1 | 1 | 198 | 3952344 | 3952144 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 201 | 246 | 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);;