RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA484127", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 14 ✖

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA484127 · 14 ✖

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
1723562 1723562 PRJNA484127_P_NODE_8702_length_404_cov_1.552870_g8553_i0 PRJNA484127 8702 404 1.55287 6.2735948 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 265 4.57e-66   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8553 i0 89.855 0.512376237623762 207 19 51 2 199 404 5329 5534 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 207 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2999318 2999318 PRJNA484127_P_NODE_2923_length_640_cov_2.109347_g2781_i0 PRJNA484127 2923 640 2.109347 13.4998208 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 867 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2781 i0 91.195 0.99375 636 55 99 1 5 640 7028 6394 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 636 867 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2999320 2999320 PRJNA484127_P_NODE_29303_length_254_cov_1.464088_g29154_i0 PRJNA484127 29303 254 1.464088 3.71878352 Zebrafish picornavirus 1 2304617 Viruses Viruses 414 2.5499999999999998e-111   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g29154 i0 96.063 3 254 10 100 0 1 254 6587 6334 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 762 414 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11927054 11927054 PRJNA484127_P_NODE_18710_length_302_cov_2.362445_g18561_i0 PRJNA484127 18710 302 2.362445 7.1345839 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 309 1.5100000000000002e-79   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g18561 i0 96.277 0.622516556291391 188 7 62 0 2 189 4517 4704 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 188 309 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
13201937 13201937 PRJNA484127_P_NODE_1431_length_886_cov_2.367774_g1313_i0 PRJNA484127 1431 886 2.367774 20.97847764 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1238 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1313 i0 91.883 1.00112866817156 887 70 100 2 1 886 5537 6422 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 887 1238 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15751015 15751015 PRJNA484127_P_NODE_16073_length_320_cov_1.202429_g15924_i0 PRJNA484127 16073 320 1.202429 3.8477728 Zebrafish picornavirus 1 2304617 Viruses Viruses 569 6.699999999999998e-158   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g15924 i0 98.75 3 320 4 100 0 1 320 5825 6144 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 960 569 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
15751252 15751252 PRJNA484127_P_NODE_28793_length_256_cov_1.278689_g28644_i0 PRJNA484127 28793 256 1.278689 3.27344384 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 219 2.1699999999999993e-52   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g28644 i0 92.763 0.59375 152 10 59 1 103 254 1105 955 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 152 219 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
17025548 17025548 PRJNA484127_P_NODE_11954_length_357_cov_2.169014_g11805_i0 PRJNA484127 11954 357 2.169014 7.74337998 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 309 1.8200000000000003e-79   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g11805 i0 92.202 0.610644257703081 218 17 61 0 140 357 4915 5132 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 218 309 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
27044686 27044686 PRJNA484127_P_NODE_21642_length_286_cov_1.403756_g21493_i0 PRJNA484127 21642 286 1.403756 4.01474216 Zebrafish gut calicivirus RQ08 Viruses Viruses 84 2.14e-16   NR XBS25272.1 RQ08 g21493 i0 46.3 0.996503496503496 95 50 99.7 1 286 2 1827 1920 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 285 84 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
28781432 28781432 PRJNA484127_P_NODE_7_length_5013_cov_9.529960_g6_i0 PRJNA484127 7 5013 9.52996 477.7368948 Zebrafish gut calicivirus RQ08 Viruses Viruses 1168 0   NR XBS25272.1 RQ08 g6 i0 41.6 0.935368043087971 1563 830 89.9 27 5004 496 664 2203 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 4689 1168 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
30076181 30076181 PRJNA484127_P_NODE_39772_length_234_cov_4.279503_g39623_i0 PRJNA484127 39772 234 4.279503 10.01403702 Zebrafish gut calicivirus RQ08 Viruses Viruses 42.4 0.0465   NR AVM87224.1 RQ08 g39623 i0 37.8 0.948717948717949 74 39 89.7 4 211 2 34 104 AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] diamond 222 42.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
30202458 30202458 PRJNA484127_P_NODE_412_length_1418_cov_5.441636_g357_i0 PRJNA484127 412 1418 5.441636 77.16239848 Zebrafish gut calicivirus RQ08 Viruses Viruses 340 6.36e-100   NR XBS25272.1 RQ08 g357 i0 43.3 0.98589562764457 466 245 96.9 11 1376 3 199 653 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 1398 340 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
31245318 31245318 PRJNA484127_P_NODE_24235_length_274_cov_1.164179_g24086_i0 PRJNA484127 24235 274 1.164179 3.18985046 Zebrafish gut calicivirus RQ08 Viruses Viruses 82.8 4.64e-16   NR AVM87212.1 RQ08 g24086 i0 52.3 0.941605839416058 86 39 94.2 2 261 4 688 771 AVM87212.1 polyprotein [Dongbei arctic lamprey calicivirus 2] diamond 258 82.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
31640911 31640911 PRJNA484127_P_NODE_11476_length_363_cov_1.327586_g11327_i0 PRJNA484127 11476 363 1.327586 4.81913718 Viruses 10239 Viruses Viruses 80.5 9.15e-15   NR AVM87224.1 2116168 g11327 i0 35.8 3 120 76 98.3 1 3 359 332 451 AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] diamond 1089 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Fujian spotted paddle-tail newt 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);;