contig_metadata
6 rows where bioproject = "PRJNA859990", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12325003 | 12325003 | PRJNA859990_S_NODE_11610_length_301_cov_1.350877_g11349_i0 | PRJNA859990 | 11610 | 301 | 1.350877 | 4.06613977 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 496 | 1.08e-135 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g11349 | i0 | 96.346 | 1 | 301 | 11 | 100 | 0 | 1 | 301 | 6691 | 6391 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 301 | 496 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 14873986 | 14873986 | PRJNA859990_S_NODE_7672_length_360_cov_1.968641_g7411_i0 | PRJNA859990 | 7672 | 360 | 1.968641 | 7.0871076 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 627 | 4.459999999999999e-175 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g7411 | i0 | 98.061 | 1.00277777777778 | 361 | 6 | 100 | 1 | 1 | 360 | 5437 | 5797 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 361 | 627 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 16148713 | 16148713 | PRJNA859990_S_NODE_6473_length_389_cov_1.515823_g6212_i0 | PRJNA859990 | 6473 | 389 | 1.515823 | 5.89655147 | Grifola frondosa partitivirus 1 | 2421281 | Viruses | Viruses | 708 | 0 | NTclustered | gi|1594452116|dbj|LC425601.1| | 2421281 | g6212 | i0 | 99.486 | 1 | 389 | 2 | 100 | 0 | 1 | 389 | 1582 | 1970 | Grifola frondosa partitivirus 1 M51 genomic RNA, segment RNA1, complete genome | blastn | 389 | 708 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Grifola frondosa partitivirus 1 | |||
| 17423975 | 17423975 | PRJNA859990_S_NODE_14_length_7209_cov_27.053391_g1_i0 | PRJNA859990 | 14 | 7209 | 27.053391 | 1950.27895719 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2477 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1 | i0 | 91.755 | 0.651824108752948 | 1783 | 142 | 65 | 5 | 5426 | 7205 | 5329 | 7109 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4699 | 2477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 25072058 | 25072058 | PRJNA859990_S_NODE_21840_length_242_cov_0.869822_g21579_i0 | PRJNA859990 | 21840 | 242 | 0.869822 | 2.10496924 | Betapartitivirus pleuroti | 3427255 | Viruses | Viruses | 424 | 4.01e-114 | NTclustered | gi|260516646|gb|GQ505290.1| | 674983 | g21579 | i0 | 98.34 | 4.93801652892562 | 241 | 4 | 99 | 0 | 2 | 242 | 3554 | 3314 | Pleurotus ostreatus virus 1 RNA-dependent RNA polymerase gene, partial cds | blastn | 1195 | 424 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Betapartitivirus | Betapartitivirus pleuroti | ||
| 26960018 | 26960018 | PRJNA859990_S_NODE_9062_length_335_cov_1.270992_g8801_i0 | PRJNA859990 | 9062 | 335 | 1.270992 | 4.2578232 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 110 | 1.4199999999999999e-25 | NR | AVM87439.1 | 3063761 | g8801 | i0 | 56.7 | 0.805970149253731 | 90 | 39 | 80.6 | 0 | 277 | 8 | 1065 | 1154 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 270 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 |
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);;