contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27721816 | 27721816 | PRJNA983848_P_NODE_149844_length_247_cov_0.896552_g143961_i0 | PRJNA983848 | 149844 | 247 | 0.896552 | 2.21448344 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 75.9 | 4.98e-16 | NR | CAB4148105.1 | 2100421 | g143961 | i0 | 63.5 | 0.631578947368421 | 52 | 16 | 63.2 | 1 | 247 | 92 | 9 | 57 | CAB4148105.1 hypothetical protein UFOVP431_110 [uncultured Caudovirales phage] | diamond | 156 | 75.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28921007 | 28921007 | PRJNA983848_P_NODE_150228_length_247_cov_0.896552_g144345_i0 | PRJNA983848 | 150228 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 68.6 | 3.23e-11 | NR | XOR78579.1 | 2832643 | g144345 | i0 | 72.7 | 0.534412955465587 | 44 | 12 | 53.4 | 0 | 247 | 116 | 887 | 930 | XOR78579.1 MAG: p036 protein [Caudoviricetes sp.] | diamond | 132 | 68.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29589864 | 29589864 | PRJNA983848_P_NODE_142070_length_251_cov_0.876404_g136187_i0 | PRJNA983848 | 142070 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 108 | 2.04e-25 | NR | YP_009005974.1 | 1458697 | g136187 | i0 | 63.4 | 8.85657370517928 | 82 | 30 | 98 | 0 | 247 | 2 | 396 | 477 | YP_009005974.1 DNA polymerase [Rhizobium phage vB_RglS_P106B] | diamond | 2223 | 109 | 0.990825688073395 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rigallicvirus | Rigallicvirus P106B | ||||
| 32366044 | 32366044 | PRJNA983848_P_NODE_143659_length_250_cov_0.881356_g137776_i0 | PRJNA983848 | 143659 | 250 | 0.881356 | 2.20339 | Haloarcula hispanica tailed virus 2 | 1273751 | Viruses | Viruses | 115 | 7.83e-29 | NR | YP_008060355.1 | 1273751 | g137776 | i0 | 64.2 | 0.972 | 81 | 29 | 97.2 | 0 | 3 | 245 | 202 | 282 | YP_008060355.1 minor tail protein [Haloarcula hispanica tailed virus 2] | diamond | 243 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saparoviridae | Halohivirus | Halohivirus suolae |
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);;