contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 29842854 | 29842854 | PRJDB12578_S_NODE_204491_length_165_cov_1.051724_g181433_i0 | PRJDB12578 | 204491 | 165 | 1.051724 | 1.7353446 | Ruian virus | 2656660 | Viruses | Viruses | 66.2 | 6.48e-11 | NR | QFR59048.1 | 2656660 | g181433 | i0 | 51.9 | 0.981818181818182 | 54 | 26 | 98.2 | 0 | 164 | 3 | 472 | 525 | QFR59048.1 MAG: putative RNA dependent RNA polymerase, partial [Ruian virus] | diamond | 162 | 66.2 | 1 | Viruses | Ruian virus | ||||||||
| 29842856 | 29842856 | PRJDB12578_S_NODE_63011_length_610_cov_1.606061_g40417_i0 | PRJDB12578 | 63011 | 610 | 1.606061 | 9.7969721 | Linepithema humile rhabdo-like virus 1 | 2259786 | Viruses | Viruses | 80.5 | 8.95e-14 | NR | YP_010799352.1 | 2259786 | g40417 | i0 | 73.5 | 0.240983606557377 | 49 | 12 | 23.6 | 1 | 547 | 404 | 97 | 145 | YP_010799352.1 putative capsid [Linepithema humile rhabdo-like virus 1] | diamond | 147 | 80.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Synelinevirus | Synelinevirus paranaense | ||
| 30000966 | 30000966 | PRJDB12578_S_NODE_187931_length_172_cov_1.691057_g164873_i0 | PRJDB12578 | 187931 | 172 | 1.691057 | 2.90861804 | Pedersore virga-like virus | 2980587 | Viruses | Viruses | 43.9 | 0.00553 | NR | UYL94373.1 | 2980587 | g164873 | i0 | 57.1 | 1.41279069767442 | 35 | 15 | 61 | 0 | 54 | 158 | 634 | 668 | UYL94373.1 MAG: polyprotein, partial [Pedersore virga-like virus] | diamond | 243 | 43.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Pedersore virga-like virus | |||
| 30000971 | 30000971 | PRJDB12578_S_NODE_49711_length_917_cov_2.764977_g29271_i0 | PRJDB12578 | 49711 | 917 | 2.764977 | 25.35483909 | Bracoviriform congregatae | 39640 | Viruses | Viruses | 96.3 | 4.74e-18 | NR | YP_184879.1 | 39640 | g29271 | i0 | 68.1 | 0.451472191930207 | 69 | 22 | 22.6 | 0 | 769 | 563 | 592 | 660 | YP_184879.1 hypothetical protein CcBV_30.5 [Bracoviriform congregatae] | diamond | 414 | 96.3 | 1 | Viruses | Polydnaviriformidae | Bracoviriform | Bracoviriform congregatae | ||||||
| 30190272 | 30190272 | PRJDB12578_S_NODE_202112_length_166_cov_0.880342_g179054_i0 | PRJDB12578 | 202112 | 166 | 0.880342 | 1.46136772 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 62 | 1.31e-9 | NR | BCT22611.1 | RQ14 | g179054 | i0 | 52.7 | 0.993975903614458 | 55 | 25 | 97.6 | 1 | 164 | 3 | 52 | 106 | BCT22611.1 DNA-binding virion core protein VP8/L4R [Carp edema virus] | diamond | 165 | 62 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30317278 | 30317278 | PRJDB12578_S_NODE_49032_length_935_cov_2.913093_g28773_i0 | PRJDB12578 | 49032 | 935 | 2.913093 | 27.23741955 | Linepithema humile toti-like virus 1 | 2259783 | Viruses | Viruses | 49.3 | 0.0213 | NR | AXA52554.1 | 2259783 | g28773 | i0 | 35.9 | 0.250267379679144 | 78 | 39 | 23.1 | 2 | 556 | 341 | 416 | 488 | AXA52554.1 putative RdRp-complex [Linepithema humile toti-like virus 1] | diamond | 234 | 49.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Lebotiviridae | Lebotivirus | Lebotivirus shichi | ||
| 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 | ||
| 31011839 | 31011839 | PRJDB12578_S_NODE_214955_length_162_cov_0.893805_g191897_i0 | PRJDB12578 | 214955 | 162 | 0.893805 | 1.4479641 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 60.1 | 2.12e-9 | NR | BCT22744.1 | RQ14 | g191897 | i0 | 59.2 | 0.907407407407407 | 49 | 20 | 90.7 | 0 | 148 | 2 | 3 | 51 | BCT22744.1 hypothetical protein [Carp edema virus] | diamond | 147 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 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 | |||
| 31480523 | 31480523 | PRJDB12578_S_NODE_35116_length_1446_cov_8.627058_g19193_i0 | PRJDB12578 | 35116 | 1446 | 8.627058 | 124.74725868 | Viruses | 10239 | Viruses | Viruses | 544 | 2.16e-188 | NR | QVG74787.1 | 2585031 | g19193 | i0 | 57.2 | 3.90041493775934 | 474 | 196 | 97.1 | 4 | 41 | 1444 | 1 | 473 | QVG74787.1 RNA-dependent RNA polymerase [Riboviria sp.] | diamond | 5640 | 548 | 0.992700729927007 | Viruses | Riboviria sp. | ||||||||
| 32498653 | 32498653 | PRJDB12578_S_NODE_104079_length_279_cov_1.578261_g81021_i0 | PRJDB12578 | 104079 | 279 | 1.578261 | 4.40334819 | Daxi virus | 2656652 | Viruses | Viruses | 65.1 | 8.05e-10 | NR | QFR59049.1 | 2656652 | g81021 | i0 | 36 | 1.89247311827957 | 89 | 56 | 94.6 | 1 | 279 | 16 | 85 | 173 | QFR59049.1 MAG: putative RNA dependent RNA polymerase [Daxi virus] | diamond | 528 | 65.1 | 1 | Viruses | Daxi virus |
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);;