contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA1241156" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29694203 | 29694203 | PRJNA1241156_S_NODE_62850_length_248_cov_0.965854_g62390_i0 | PRJNA1241156 | 62850 | 248 | 0.965854 | 2.39531792 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.5 | 2.21e-8 | NR | DAR64507.1 | 2832643 | g62390 | i0 | 78 | 0.495967741935484 | 41 | 9 | 49.6 | 0 | 123 | 1 | 1 | 41 | DAR64507.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 123 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30547497 | 30547497 | PRJNA1241156_S_NODE_23833_length_351_cov_2.613636_g23373_i0 | PRJNA1241156 | 23833 | 351 | 2.613636 | 9.17386236 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 96.3 | 2.03e-21 | NR | CAB4124299.1 | 2100421 | g23373 | i0 | 43.9 | 0.837606837606838 | 98 | 54 | 82.9 | 1 | 45 | 335 | 170 | 267 | CAB4124299.1 WcaG Nucleoside-diphosphate-sugar epimerases [uncultured Caudovirales phage] | diamond | 294 | 96.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32286885 | 32286885 | PRJNA1241156_S_NODE_64899_length_243_cov_8.370000_g64439_i0 | PRJNA1241156 | 64899 | 243 | 8.37 | 20.3391 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 64.3 | 6.83e-10 | NR | DAU46120.1 | 2832643 | g64439 | i0 | 44.2 | 0.950617283950617 | 77 | 43 | 95.1 | 0 | 3 | 233 | 174 | 250 | DAU46120.1 MAG TPA: upper collar protein [Caudoviricetes sp.] | diamond | 231 | 64.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32823202 | 32823202 | PRJNA1241156_S_NODE_18240_length_373_cov_2.624242_g17780_i0 | PRJNA1241156 | 18240 | 373 | 2.624242 | 9.78842266 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.3 | 9.53e-7 | NR | DAQ86025.1 | 2832643 | g17780 | i0 | 50 | 3.78016085790885 | 48 | 24 | 38.6 | 0 | 337 | 194 | 39 | 86 | DAQ86025.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 1410 | 54.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;