contig_metadata
10 rows where bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1282972 | 1282972 | PRJDB3785_S_NODE_12802_length_214_cov_2.139394_g12649_i0 | PRJDB3785 | 12802 | 214 | 2.139394 | 4.57830316 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 379 | 7.609999999999999e-101 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g12649 | i0 | 98.598 | 11 | 214 | 3 | 100 | 0 | 1 | 214 | 218 | 5 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2354 | 379 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 2558532 | 2558532 | PRJDB3785_S_NODE_103_length_2790_cov_3.331631_g92_i0 | PRJDB3785 | 103 | 2790 | 3.331631 | 92.9525049 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 5123 | 0 | NTclustered | gi|2209094750|gb|OL472447.1| | 2900464 | g92 | i0 | 99.821 | 10.9960573476703 | 2789 | 5 | 99 | 0 | 1 | 2789 | 587 | 3375 | MAG: Brine shrimp iflavirus 3 isolate BH/10-12 RNA-dependent RNA polymerase gene, complete cds | blastn | 30679 | 5123 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 2558674 | 2558674 | PRJDB3785_S_NODE_22203_length_170_cov_1.082645_g22050_i0 | PRJDB3785 | 22203 | 170 | 1.082645 | 1.8404965 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 292 | 7.69e-75 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g22050 | i0 | 97.647 | 3 | 170 | 4 | 100 | 0 | 1 | 170 | 7376 | 7545 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 510 | 292 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 7661245 | 7661245 | PRJDB3785_S_NODE_6967_length_284_cov_2.591489_g6814_i0 | PRJDB3785 | 6967 | 284 | 2.591489 | 7.35982876 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 514 | 2.78e-141 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g6814 | i0 | 99.296 | 11 | 284 | 2 | 100 | 0 | 1 | 284 | 599 | 316 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 3124 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 14036761 | 14036761 | PRJDB3785_S_NODE_12752_length_215_cov_1.036145_g12599_i0 | PRJDB3785 | 12752 | 215 | 1.036145 | 2.22771175 | brine shrimp partitivirus 1 | 2900392 | Viruses | Viruses | 387 | 4.57e-103 | NTclustered | gi|2209094913|gb|OL472528.1| | 2900392 | g12599 | i0 | 99.07 | 4 | 215 | 2 | 100 | 0 | 1 | 215 | 1741 | 1527 | MAG: Brine shrimp partitivirus 1 isolate YC/91 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 860 | 387 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 1 | |||
| 14036972 | 14036972 | PRJDB3785_S_NODE_52_length_5859_cov_6.423580_g51_i0 | PRJDB3785 | 52 | 5859 | 6.42358 | 376.3575522 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 10781 | 0 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g51 | i0 | 99.881 | 11.0078511691415 | 5859 | 7 | 100 | 0 | 1 | 5859 | 3353 | 9211 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 64495 | 10781 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 22960751 | 22960751 | PRJDB3785_S_NODE_21779_length_171_cov_1.647541_g21626_i0 | PRJDB3785 | 21779 | 171 | 1.647541 | 2.81729511 | brine shrimp partitivirus 1 | 2900392 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2209094913|gb|OL472528.1| | 2900392 | g21626 | i0 | 100 | 4.00584795321637 | 171 | 0 | 100 | 0 | 1 | 171 | 1895 | 1725 | MAG: Brine shrimp partitivirus 1 isolate YC/91 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 685 | 316 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 1 | |||
| 27032338 | 27032338 | PRJDB3785_S_NODE_27002_length_161_cov_1.339286_g26849_i0 | PRJDB3785 | 27002 | 161 | 1.339286 | 2.15625046 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 107 | 1.49e-25 | NR | XDJ26655.1 | 1530251 | g26849 | i0 | 98.1 | 0.987577639751553 | 53 | 1 | 98.8 | 0 | 2 | 160 | 1679 | 1731 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 159 | 107 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 28327210 | 28327210 | PRJDB3785_S_NODE_26946_length_161_cov_1.366071_g26793_i0 | PRJDB3785 | 26946 | 161 | 1.366071 | 2.19937431 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 107 | 1.49e-25 | NR | XDJ26655.1 | 1530251 | g26793 | i0 | 83 | 0.987577639751553 | 53 | 9 | 98.8 | 0 | 3 | 161 | 1319 | 1371 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 159 | 107 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31232919 | 31232919 | PRJDB3785_S_NODE_24575_length_165_cov_0.879310_g24422_i0 | PRJDB3785 | 24575 | 165 | 0.87931 | 1.4508615 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 81.6 | 2.47e-16 | NR | XDJ26655.1 | 1530251 | g24422 | i0 | 74.1 | 0.981818181818182 | 54 | 14 | 98.2 | 0 | 164 | 3 | 1763 | 1816 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 162 | 81.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae 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);;