RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1120203", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 13 ✖

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 13 ✖

tax_clade 0

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
9202612 9202612 PRJNA1120203_P_NODE_26028_length_476_cov_1.141439_g25014_i0 PRJNA1120203 26028 476 1.141439 5.43324964 Melon partitivirus 2305257 Viruses Viruses 671 0   NTclustered gi|1571819094|ref|NC_040483.1| 2305257 g25014 i0 92.083 4.51470588235294 480 33 100 4 1 476 479 1 Melon partitivirus isolate MCV1 putative RNA-dependent RNA polymerase (RdRp) gene, complete cds blastn 2149 671 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Melon partitivirus
9202853 9202853 PRJNA1120203_P_NODE_47168_length_329_cov_1.457031_g46152_i0 PRJNA1120203 47168 329 1.457031 4.79363199 Alphacoronavirus amsterdamense 3433809 Viruses Viruses 601 2.4499999999999993e-167   NTclustered gi|2447465036|dbj|LC756668.1| 277944 g46152 i0 99.695 99.6960486322188 328 1 99 0 1 328 24345 24672 Human coronavirus NL63 HCoVNL63_Fukushima_O230_2018 RNA, nearly complete genome blastn 32800 601 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Alphacoronavirus Alphacoronavirus amsterdamense
10478328 10478328 PRJNA1120203_P_NODE_23109_length_519_cov_1.381166_g22097_i0 PRJNA1120203 23109 519 1.381166 7.16825154 Betacoronavirus pandemicum 3418604 Viruses Viruses 959 0   NTclustered gi|2551850806|gb|OR345918.1| 2697049 g22097 i0 100 100 519 0 100 0 1 519 28660 28142 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-LACPHL-AY00055/2023 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds blastn 51900 959 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11753058 11753058 PRJNA1120203_P_NODE_10910_length_985_cov_1.921053_g10064_i0 PRJNA1120203 10910 985 1.921053 18.92237205 Alphacoronavirus amsterdamense 3433809 Viruses Viruses 1808 0   NTclustered gi|2447465036|dbj|LC756668.1| 277944 g10064 i0 99.797 100.233502538071 985 2 100 0 1 985 27298 26314 Human coronavirus NL63 HCoVNL63_Fukushima_O230_2018 RNA, nearly complete genome blastn 98730 1808 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Alphacoronavirus Alphacoronavirus amsterdamense
11753189 11753189 PRJNA1120203_P_NODE_27690_length_456_cov_1.289817_g26675_i0 PRJNA1120203 27690 456 1.289817 5.88156552 Enterovirus cerhino 3428504 Viruses Viruses 749 0   NTclustered gi|2271979367|gb|ON729335.1| 2045075 g26675 i0 96.272 61.234649122807 456 17 100 0 1 456 4339 4794 Rhinovirus C34 strain SC647, complete genome blastn 27923 749 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus cerhino
15577895 15577895 PRJNA1120203_P_NODE_55453_length_303_cov_1.313043_g54437_i0 PRJNA1120203 55453 303 1.313043 3.97852029 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 488 1.8199999999999993e-133   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g54437 i0 95.724 1.003300330033 304 11 100 2 1 303 6003 5701 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 304 488 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15578497 15578497 PRJNA1120203_P_NODE_98133_length_244_cov_0.900585_g97117_i0 PRJNA1120203 98133 244 0.900585 2.1974274 Zebrafish picornavirus 1 2304617 Viruses Viruses 407 4.08e-109   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g97117 i0 96.721 3 244 8 100 0 1 244 5946 6189 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 732 407 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16852014 16852014 PRJNA1120203_P_NODE_27674_length_456_cov_1.446475_g26659_i0 PRJNA1120203 27674 456 1.446475 6.595926 Alphacoronavirus amsterdamense 3433809 Viruses Viruses 832 0   NTclustered gi|2447465036|dbj|LC756668.1| 277944 g26659 i0 99.561 100 456 2 100 0 1 456 26288 25833 Human coronavirus NL63 HCoVNL63_Fukushima_O230_2018 RNA, nearly complete genome blastn 45600 832 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Alphacoronavirus Alphacoronavirus amsterdamense
21951396 21951396 PRJNA1120203_P_NODE_23998_length_504_cov_2.262181_g22986_i0 PRJNA1120203 23998 504 2.262181 11.40139224 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 815 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g22986 i0 95.833 1 504 21 100 0 1 504 6641 6138 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 504 815 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
28227664 28227664 PRJNA1120203_P_NODE_25126_length_487_cov_2.603865_g24113_i0 PRJNA1120203 25126 487 2.603865 12.68082255 Viruses 10239 Viruses Viruses 179 1.48e-48   NR AVM87226.1 2116158 g24113 i0 55.5 1.92197125256674 155 69 95.5 0 469 5 40 194 AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] diamond 936 179 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zhejiang gunthers frog calicivirus 1
28459843 28459843 PRJNA1120203_P_NODE_68046_length_272_cov_1.889447_g67030_i0 PRJNA1120203 68046 272 1.889447 5.13929584 Zebrafish gut calicivirus RQ08 Viruses Viruses 67.4 1.15e-10   NR AVM87550.1 RQ08 g67030 i0 38.2 1.94117647058824 89 54 97.1 1 269 6 727 815 AVM87550.1 polyprotein, partial [Yancheng osbecks grenadier anchovy calicivirus] diamond 528 67.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
29533202 29533202 PRJNA1120203_P_NODE_73370_length_261_cov_1.212766_g72354_i0 PRJNA1120203 73370 261 1.212766 3.16531926 Zebrafish gut calicivirus RQ08 Viruses Viruses 88.2 5.03e-18   NR XBS25272.1 RQ08 g72354 i0 51.4 0.850574712643678 74 36 85.1 0 1 222 1543 1616 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 222 88.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
31112503 31112503 PRJNA1120203_P_NODE_27055_length_463_cov_2.117949_g26041_i0 PRJNA1120203 27055 463 2.117949 9.80610387 Zebrafish gut calicivirus RQ08 Viruses Viruses 190 9.62e-53   NR XBS25272.1 RQ08 g26041 i0 59.9 0.98488120950324 152 61 98.5 0 458 3 1306 1457 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 456 190 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;