contig_metadata
3 rows where bioproject = "PRJNA781453" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10966597 | 10966597 | PRJNA781453_P_NODE_22309_length_309_cov_1.305085_g22194_i0 | PRJNA781453 | 22309 | 309 | 1.305085 | 4.03271265 | Avian carcinoma virus | 11958 | Viruses | Viruses | 555 | 1.7999999999999994e-153 | NTclustered | gi|209658|gb|M25158.1|AC2TKSEA | 11958 | g22194 | i0 | 99.029 | 99.7928802588997 | 309 | 3 | 100 | 0 | 1 | 309 | 1704 | 1396 | Avian retrovirus proviral tyrosine kinase (ENV-SEA oncogene), 3' end | blastn | 30836 | 555 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian carcinoma virus | ||
| 16515139 | 16515139 | PRJNA781453_P_NODE_24693_length_293_cov_1.045455_g24578_i0 | PRJNA781453 | 24693 | 293 | 1.045455 | 3.06318315 | root | 1 | Root_unresolved | Root_unresolved | 542 | 1.32e-149 | NTclustered | gi|829492|gb|U24467.1|HIV1U24467 | 11676 | g24578 | i0 | 100 | 121.235494880546 | 293 | 0 | 100 | 0 | 1 | 293 | 318 | 26 | Human immunodeficiency virus type 1 patient 3799(9-93), clone 15 LTR, (nef), partial cds | blastn | 35522 | 542 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 27401367 | 27401367 | PRJNA781453_P_NODE_16823_length_357_cov_1.021127_g16708_i0 | PRJNA781453 | 16823 | 357 | 1.021127 | 3.64542339 | Citrus yellow mosaic virus | 174178 | Viruses | Viruses | 117 | 1.28e-27 | NR | ACH86211.1 | 174178 | g16708 | i0 | 70.7 | 1.89915966386555 | 75 | 22 | 63 | 0 | 227 | 3 | 239 | 313 | ACH86211.1 unknown [Citrus yellow mosaic virus] | diamond | 678 | 117 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Badnavirus tessellocitri |
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);;