contig_metadata
4 rows where bioproject = "PRJNA939369", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2189785 | 2189785 | PRJNA939369_S_NODE_502_length_1483_cov_5.260993_g296_i0 | PRJNA939369 | 502 | 1483 | 5.260993 | 78.02052619 | Fiersviridae | 2842319 | Viruses | Viruses | 85.9 | 8.56e-14 | NR | YP_010771401.1 | 2786414 | g296 | i0 | 25.4 | 1.50101146325017 | 311 | 211 | 59.7 | 7 | 446 | 1330 | 184 | 489 | YP_010771401.1 maturation protein [ssRNA phage SRR5466725_16] | diamond | 2226 | 86.7 | 0.990772779700115 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Grendvuvirus | Grendvuvirus asiocola | ||
| 30309868 | 30309868 | PRJNA939369_S_NODE_312_length_1918_cov_3.566938_g165_i0 | PRJNA939369 | 312 | 1918 | 3.566938 | 68.41387084 | Leviviridae sp. | 2027243 | Viruses | Viruses | 245 | 1.18e-71 | NR | URG16217.1 | 2027243 | g165 | i0 | 42.9 | 2.32429614181439 | 345 | 177 | 52.6 | 7 | 561 | 1568 | 3 | 336 | URG16217.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 4458 | 245 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32403244 | 32403244 | PRJNA939369_S_NODE_62139_length_248_cov_0.880000_g61722_i0 | PRJNA939369 | 62139 | 248 | 0.88 | 2.1824 | Konmavirus | 2842809 | Viruses | Viruses | 68.6 | 3.17e-11 | NR | YP_010770188.1 | 2786682 | g61722 | i0 | 50.7 | 1.79032258064516 | 69 | 34 | 83.5 | 0 | 229 | 23 | 300 | 368 | YP_010770188.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_4] | diamond | 444 | 68.9 | 0.995645863570392 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Blumeviridae | Konmavirus | Konmavirus peladaptatum | ||
| 32774707 | 32774707 | PRJNA939369_S_NODE_28300_length_306_cov_0.939914_g27883_i0 | PRJNA939369 | 28300 | 306 | 0.939914 | 2.87613684 | Leviviridae sp. | 2027243 | Viruses | Viruses | 79.3 | 1.08e-14 | NR | UJQ85467.1 | 2027243 | g27883 | i0 | 48.1 | 1.54901960784314 | 79 | 41 | 77.5 | 0 | 239 | 3 | 294 | 372 | UJQ85467.1 MAG: hypothetical protein 3 [Leviviridae sp.] | diamond | 474 | 79.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae 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);;