RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1111146", 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

  • PRJNA1111146 · 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
215732 215732 PRJNA1111146_P_NODE_1741_length_1634_cov_3.695762_g999_i0 PRJNA1111146 1741 1634 3.695762 60.38875108 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2684 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g999 i0 96.271 1.00122399020808 1636 57 100 4 1 1634 5344 6977 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1636 2684 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
216767 216767 PRJNA1111146_P_NODE_413641_length_178_cov_1.272000_g412503_i0 PRJNA1111146 413641 178 1.272 2.26416 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 311 2.25e-80   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g412503 i0 98.305 0.99438202247191 177 3 99 0 1 177 4128 3952 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 177 311 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7869570 7869570 PRJNA1111146_P_NODE_409467_length_178_cov_1.816000_g408329_i0 PRJNA1111146 409467 178 1.816 3.23248 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 215 1.81e-51   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g408329 i0 98.374 0.691011235955056 123 1 69 1 1 123 984 1105 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 123 215 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11695142 11695142 PRJNA1111146_P_NODE_32990_length_321_cov_1.052239_g31853_i0 PRJNA1111146 32990 321 1.052239 3.37768719 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 427 4.28e-115   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g31853 i0 97.967 0.766355140186916 246 5 77 0 76 321 639 394 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 246 427 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12969638 12969638 PRJNA1111146_P_NODE_177371_length_211_cov_1.930380_g176233_i0 PRJNA1111146 177371 211 1.93038 4.0731018 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 346 7.59e-91   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g176233 i0 97.99 0.943127962085308 199 4 94 0 13 211 5194 4996 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 199 346 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
23169485 23169485 PRJNA1111146_P_NODE_89959_length_249_cov_1.734694_g88821_i0 PRJNA1111146 89959 249 1.734694 4.31938806 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 453 5.29e-123   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g88821 i0 99.597 0.995983935742972 248 1 99 0 1 248 4345 4592 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 248 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24443104 24443104 PRJNA1111146_P_NODE_7400_length_580_cov_2.920304_g6294_i0 PRJNA1111146 7400 580 2.920304 16.9377632 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 846 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6294 i0 92.931 1 580 40 100 1 1 580 6482 7060 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 580 846 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
26814766 26814766 PRJNA1111146_P_NODE_438421_length_177_cov_0.903226_g437283_i0 PRJNA1111146 438421 177 0.903226 1.59871002 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 73.9 1.58e-13   NR XBH23991.1 3063761 g437283 i0 62.7 0.864406779661017 51 19 86.4 0 1 153 799 849 XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] diamond 153 73.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28267789 28267789 PRJNA1111146_P_NODE_36526_length_312_cov_1.664093_g35389_i0 PRJNA1111146 36526 312 1.664093 5.19197016 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 183 3.49e-51   NR WKU61618.1 3063761 g35389 i0 86.5 1 104 14 100 0 312 1 1810 1913 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 312 183 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
29341572 29341572 PRJNA1111146_P_NODE_38729_length_307_cov_2.452756_g37592_i0 PRJNA1111146 38729 307 2.452756 7.52996092 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 108 4.68e-25   NR AVM87439.1 3063761 g37592 i0 55.3 0.9185667752443 94 42 91.9 0 282 1 928 1021 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 282 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
31417833 31417833 PRJNA1111146_P_NODE_140396_length_224_cov_3.269006_g139258_i0 PRJNA1111146 140396 224 3.269006 7.32257344 Zebrafish jaw picornavirus RQ13 Viruses Viruses 100 1.29e-22   NR YP_009241363.1 RQ13 g139258 i0 56.8 6.91071428571429 74 32 99.1 0 2 223 272 345 YP_009241363.1 3D [Tortoise rafivirus A] diamond 1548 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
31639161 31639161 PRJNA1111146_P_NODE_231376_length_200_cov_1.428571_g230238_i0 PRJNA1111146 231376 200 1.428571 2.857142 Zebrafish jaw picornavirus RQ13 Viruses Viruses 46.2 0.00129   NR UMO75551.1 RQ13 g230238 i0 38.8 1.38 49 30 73.5 0 53 199 1365 1413 UMO75551.1 MAG: polyprotein [Coypu sapelovirus 2] diamond 276 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Sapelovirus Zebrafish jaw picornavirus
31901120 31901120 PRJNA1111146_P_NODE_8257_length_544_cov_1.698574_g7144_i0 PRJNA1111146 8257 544 1.698574 9.24024256 Zebrafish jaw picornavirus RQ13 Viruses Viruses 70.5 1.98e-10   NR QJX58422.1 RQ13 g7144 i0 44.3 2.42647058823529 88 47 47.4 2 3 260 2272 2359 QJX58422.1 polyprotein [Salivirus A] diamond 1320 70.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Salivirus Zebrafish jaw picornavirus
32597166 32597166 PRJNA1111146_P_NODE_31260_length_326_cov_0.893773_g30123_i0 PRJNA1111146 31260 326 0.893773 2.91369998 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 151 6.34e-40   NR WKU61618.1 3063761 g30123 i0 88.4 0.791411042944785 86 10 79.1 0 68 325 1662 1747 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 258 151 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2

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