contig_metadata
2 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7118661 | 7118661 | PRJNA758398_S_NODE_39446_length_172_cov_1.243902_g39305_i0 | PRJNA758398 | 39446 | 172 | 1.243902 | 2.13951144 | uncultured Desulfobacterium sp. | 201089 | Bacteria | Bacteria | 60.2 | 8.62e-5 | NTclustered | gi|2814788371|emb|OY764894.2| | 201089 | g39305 | i0 | 97.143 | 2.57558139534884 | 35 | 1 | 20 | 0 | 130 | 164 | 146400 | 146366 | MAG: uncultured Desulfobacterium sp. isolate 35125921-b51f-40db-957b-bccbeeb29ead genome assembly, chromosome: 1 | blastn | 443 | 60.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteriaceae | Desulfobacterium | uncultured Desulfobacterium sp. | ||
| 21142108 | 21142108 | PRJNA758398_S_NODE_17477_length_240_cov_1.068063_g17336_i0 | PRJNA758398 | 17477 | 240 | 1.068063 | 2.5633512 | Desulfuromonas versatilis | 2802975 | Bacteria | Bacteria | 196 | 9.42e-46 | NTclustered | gi|2065532709|dbj|AP024355.1| | 2802975 | g17336 | i0 | 82.805 | 88.9625 | 221 | 36 | 92 | 2 | 1 | 220 | 4581178 | 4581397 | Desulfuromonas versatilis NIT-T3 DNA, complete genome | blastn | 21351 | 196 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas versatilis |
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);;