contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA859990" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5949258 | 5949258 | PRJNA859990_S_NODE_2845_length_553_cov_1.602083_g2587_i0 | PRJNA859990 | 2845 | 553 | 1.602083 | 8.85951899 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 95.3 | 8.92e-15 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g2587 | i0 | 87.805 | 5.42676311030741 | 82 | 8 | 15 | 2 | 28 | 108 | 74 | 154 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3001 | 95.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 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 | ||
| 25462779 | 25462779 | PRJNA859990_S_NODE_19560_length_247_cov_0.862069_g19299_i0 | PRJNA859990 | 19560 | 247 | 0.862069 | 2.12931043 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 340 | 4.25e-89 | NTclustered | gi|1377652890|gb|MH209352.1| | 11320 | g19299 | i0 | 100 | 74.4858299595142 | 184 | 0 | 74 | 0 | 64 | 247 | 1261 | 1078 | Influenza A virus (A/chicken/Guangxi/SD098/2017(H7N9)) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 18398 | 340 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae |
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);;