RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12578 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
15305453 15305453 PRJDB12578_S_NODE_179913_length_178_cov_1.201550_g156855_i0 PRJDB12578 179913 178 1.20155 2.138759 Solenopsis invicta virus 8 2547311 Viruses Viruses 124 1.94e-32   NR QBL75895.1 2547311 g156855 i0 96.6 0.99438202247191 59 2 99.4 0 1 177 110 168 QBL75895.1 putative capsid protein [Solenopsis invicta virus 8] diamond 177 124 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
17856128 17856128 PRJDB12578_S_NODE_204995_length_165_cov_0.896552_g181937_i0 PRJDB12578 204995 165 0.896552 1.4793108 Solenopsis invicta virus 8 2547311 Viruses Viruses 114 1.12e-27   NR QBL75896.1 2547311 g181937 i0 96.4 1 55 2 100 0 165 1 1400 1454 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 165 114 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
26747101 26747101 PRJDB12578_S_NODE_209161_length_163_cov_2.675439_g186103_i0 PRJDB12578 209161 163 2.675439 4.36096557 Solenopsis invicta virus 8 2547311 Viruses Viruses 54.7 7.78e-7   NR QBL75896.1 2547311 g186103 i0 81.8 0.607361963190184 33 6 60.7 0 59 157 1 33 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 99 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
27759301 27759301 PRJDB12578_S_NODE_40804_length_1209_cov_3.683621_g22988_i0 PRJDB12578 40804 1209 3.683621 44.53497789 Ips partiti-like virus 1 3077388 Viruses Viruses 429 4.449999999999998e-145   NR WPV71142.1 3077388 g22988 i0 59.3 0.890818858560794 359 142 88.8 3 60 1133 70 425 WPV71142.1 MAG: putative capsid protein [Ips partiti-like virus 1] diamond 1077 429 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Ips partiti-like virus 1
27948442 27948442 PRJDB12578_S_NODE_188165_length_172_cov_1.642276_g165107_i0 PRJDB12578 188165 172 1.642276 2.82471472 Solenopsis invicta virus 8 2547311 Viruses Viruses 120 8.089999999999998e-30   NR QBL75896.1 2547311 g165107 i0 100 0.976744186046512 56 0 97.7 0 3 170 1270 1325 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 168 120 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
28043150 28043150 PRJDB12578_S_NODE_178545_length_179_cov_1.192308_g155487_i0 PRJDB12578 178545 179 1.192308 2.13423132 Solenopsis invicta virus 8 2547311 Viruses Viruses 120 4.96e-30   NR QBL75896.1 2547311 g155487 i0 91.5 0.988826815642458 59 5 98.9 0 3 179 469 527 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 177 120 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
28422203 28422203 PRJDB12578_S_NODE_145086_length_208_cov_1.578616_g122028_i0 PRJDB12578 145086 208 1.578616 3.28352128 Solenopsis invicta virus 8 2547311 Viruses Viruses 133 2.69e-34   NR QBL75896.1 2547311 g122028 i0 97.1 0.995192307692308 69 2 99.5 0 1 207 591 659 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 207 133 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
28863979 28863979 PRJDB12578_S_NODE_150988_length_202_cov_1.366013_g127930_i0 PRJDB12578 150988 202 1.366013 2.75934626 Solenopsis invicta virus 8 2547311 Viruses Viruses 134 9.72e-37   NR QBL75894.2 2547311 g127930 i0 97 0.98019801980198 66 2 98 0 200 3 49 114 QBL75894.2 putative capsid protein [Solenopsis invicta virus 8] diamond 198 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
29148643 29148643 PRJDB12578_S_NODE_210189_length_163_cov_1.350877_g187131_i0 PRJDB12578 210189 163 1.350877 2.20192951 Solenopsis invicta virus 8 2547311 Viruses Viruses 113 1.4700000000000002e-27   NR QBL75896.1 2547311 g187131 i0 100 0.993865030674847 54 0 99.4 0 1 162 700 753 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 162 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
29463566 29463566 PRJDB12578_S_NODE_35930_length_1409_cov_12.725000_g19748_i0 PRJDB12578 35930 1409 12.725 179.29525 Drosophila biauraria male killing partitivirus 1 2933356 Viruses Viruses 57.4 7.02e-5   NR BDH75795.1 2933356 g19748 i0 22.8 0.570617459190916 268 174 55.8 6 1097 312 31 271 BDH75795.1 uncharacterized protein [Drosophila biauraria male killing partitivirus 1] diamond 804 57.4 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Drosophila biauraria male killing partitivirus 1
29684653 29684653 PRJDB12578_S_NODE_165110_length_189_cov_1.857143_g142052_i0 PRJDB12578 165110 189 1.857143 3.51000027 Solenopsis invicta virus 8 2547311 Viruses Viruses 125 8.01e-33   NR QBL75895.1 2547311 g142052 i0 93.5 0.984126984126984 62 4 98.4 0 188 3 302 363 QBL75895.1 putative capsid protein [Solenopsis invicta virus 8] diamond 186 125 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
30348894 30348894 PRJDB12578_S_NODE_217512_length_154_cov_2.742857_g194454_i0 PRJDB12578 217512 154 2.742857 4.22399978 Solenopsis invicta virus 8 2547311 Viruses Viruses 102 1.0699999999999997e-23   NR QBL75896.1 2547311 g194454 i0 96.1 0.993506493506494 51 2 99.4 0 154 2 522 572 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 153 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
30380337 30380337 PRJDB12578_S_NODE_130113_length_226_cov_2.338983_g107055_i0 PRJDB12578 130113 226 2.338983 5.28610158 Solenopsis invicta virus 8 2547311 Viruses Viruses 154 2.35e-41   NR QBL75896.1 2547311 g107055 i0 100 0.982300884955752 74 0 98.2 0 224 3 755 828 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 222 154 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
30727433 30727433 PRJDB12578_S_NODE_98774_length_296_cov_1.234818_g75716_i0 PRJDB12578 98774 296 1.234818 3.65506128 Solenopsis invicta virus 8 2547311 Viruses Viruses 191 4.01e-54   NR QBL75896.1 2547311 g75716 i0 98 0.993243243243243 98 2 99.3 0 294 1 1674 1771 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 294 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
31075120 31075120 PRJDB12578_S_NODE_128675_length_228_cov_2.893855_g105617_i0 PRJDB12578 128675 228 2.893855 6.5979894 Solenopsis invicta virus 8 2547311 Viruses Viruses 148 2.59e-39   NR QBL75896.1 2547311 g105617 i0 98.7 0.986842105263158 75 1 98.7 0 227 3 1450 1524 QBL75896.1 non-structural polyprotein [Solenopsis invicta virus 8] diamond 225 148 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
31232863 31232863 PRJDB12578_S_NODE_217015_length_156_cov_2.140187_g193957_i0 PRJDB12578 217015 156 2.140187 3.33869172 Solenopsis invicta virus 8 2547311 Viruses Viruses 107 1.3600000000000002e-26   NR QBL75894.2 2547311 g193957 i0 94.2 1 52 3 100 0 1 156 244 295 QBL75894.2 putative capsid protein [Solenopsis invicta virus 8] diamond 156 107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae Sopolycivirus Solenopsis invicta virus 8
31422826 31422826 PRJDB12578_S_NODE_38696_length_1295_cov_15.763242_g21570_i0 PRJDB12578 38696 1295 15.763242 204.1339839 Osugoroshi virus 2202814 Viruses Viruses 51.6 0.00365   NR BCP45668.1 2202814 g21570 i0 37.1 0.324324324324324 70 42 16.2 1 1136 927 15 82 BCP45668.1 hypothetical protein [Osugoroshi virus] diamond 420 51.6 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Osugoroshi virus

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