contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26898866 | 26898866 | PRJNA944406_P_NODE_51561_length_262_cov_1.142857_g50602_i0 | PRJNA944406 | 51561 | 262 | 1.142857 | 2.99428534 | Crogonang virus 3 | 3062908 | Viruses | Viruses | 82.8 | 3.92e-16 | NR | WPR17999.1 | 3062908 | g50602 | i0 | 45.3 | 1.96946564885496 | 86 | 47 | 98.5 | 0 | 258 | 1 | 622 | 707 | WPR17999.1 MAG: structural polyprotein [Crogonang virus 3] | diamond | 516 | 82.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 3 | ||||
| 27151332 | 27151332 | PRJNA944406_P_NODE_6462_length_501_cov_1.789720_g5506_i0 | PRJNA944406 | 6462 | 501 | 1.78972 | 8.9664972 | Bombus-associated virus Pic1 | 2511061 | Viruses | Viruses | 48.5 | 0.00354 | NR | QAY29255.1 | 2511061 | g5506 | i0 | 43.5 | 0.550898203592814 | 92 | 46 | 53.9 | 3 | 380 | 111 | 95 | 182 | QAY29255.1 putative structral polyprotein [Bombus-associated virus Pic1] | diamond | 276 | 48.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Bombus-associated virus Pic1 | ||||
| 27341567 | 27341567 | PRJNA944406_P_NODE_7923_length_445_cov_2.478495_g6966_i0 | PRJNA944406 | 7923 | 445 | 2.478495 | 11.02930275 | Qianjiang dicistro-like virus 3 | 3347443 | Viruses | Viruses | 134 | 4.2999999999999996e-33 | NR | XHA87762.1 | 3347444 | g6966 | i0 | 48.6 | 1.88089887640449 | 138 | 71 | 93 | 0 | 12 | 425 | 248 | 385 | XHA87762.1 MAG: putative viral coat protein [Qianjiang dicistro-like virus 30] | diamond | 837 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Qianjiang dicistro-like virus 30 | |||
| 28825131 | 28825131 | PRJNA944406_P_NODE_10608_length_383_cov_0.993548_g9649_i0 | PRJNA944406 | 10608 | 383 | 0.993548 | 3.80528884 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 44.7 | 0.0379 | NR | UHM27588.1 | 2905415 | g9649 | i0 | 31.1 | 0.806788511749347 | 103 | 67 | 80.7 | 2 | 9 | 317 | 977 | 1075 | UHM27588.1 MAG: RNA helicase [Sanya dicistrovirus 1] | diamond | 309 | 44.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 29172929 | 29172929 | PRJNA944406_P_NODE_56009_length_257_cov_2.217391_g55050_i0 | PRJNA944406 | 56009 | 257 | 2.217391 | 5.69869487 | Aspergillus nidulans partitivirus 1 | 2806428 | Viruses | Viruses | 152 | 5.99e-42 | NR | QQZ02314.1 | 2806428 | g55050 | i0 | 81.2 | 0.992217898832685 | 85 | 16 | 99.2 | 0 | 255 | 1 | 377 | 461 | QQZ02314.1 capsid protein [Aspergillus nidulans partitivirus 1] | diamond | 255 | 152 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus nidulans partitivirus 1 | |||
| 29519959 | 29519959 | PRJNA944406_P_NODE_13410_length_347_cov_1.569343_g12451_i0 | PRJNA944406 | 13410 | 347 | 1.569343 | 5.44562021 | Avian astrovirus | 1914440 | Viruses | Viruses | 45.8 | 0.0104 | NR | APA19801.1 | 1914440 | g12451 | i0 | 21.2 | 2.04034582132565 | 118 | 85 | 95.1 | 1 | 335 | 6 | 667 | 784 | APA19801.1 nonstructural protein [Avian astrovirus] | diamond | 708 | 45.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Avastrovirus | Avian astrovirus | ||
| 29645923 | 29645923 | PRJNA944406_P_NODE_2390_length_901_cov_1.664251_g1642_i0 | PRJNA944406 | 2390 | 901 | 1.664251 | 14.99490151 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 119 | 5.31e-26 | NR | UHM27588.1 | 2905415 | g1642 | i0 | 49.6 | 0.39622641509434 | 119 | 57 | 38.6 | 3 | 1 | 348 | 1556 | 1674 | UHM27588.1 MAG: RNA helicase [Sanya dicistrovirus 1] | diamond | 357 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 31194014 | 31194014 | PRJNA944406_P_NODE_95895_length_244_cov_0.900585_g94936_i0 | PRJNA944406 | 95895 | 244 | 0.900585 | 2.1974274 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 45.4 | 0.0043 | NR | XCM67936.1 | 3003959 | g94936 | i0 | 40.3 | 0.94672131147541 | 77 | 35 | 89.8 | 3 | 11 | 229 | 616 | 685 | XCM67936.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 231 | 45.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31454291 | 31454291 | PRJNA944406_P_NODE_10996_length_376_cov_2.541254_g10037_i0 | PRJNA944406 | 10996 | 376 | 2.541254 | 9.55511504 | Viruses | 10239 | Viruses | Viruses | 52 | 9.35e-5 | NR | AWK77842.1 | 2201276 | g10037 | i0 | 35.3 | 3.55851063829787 | 85 | 52 | 65.4 | 1 | 365 | 120 | 423 | 507 | AWK77842.1 structural polyprotein [Darwin bee virus 1] | diamond | 1338 | 52 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Darwin bee virus 1 | ||||
| 31637115 | 31637115 | PRJNA944406_P_NODE_82896_length_247_cov_0.885057_g81937_i0 | PRJNA944406 | 82896 | 247 | 0.885057 | 2.18609079 | Iflaviridae sp. | 1955145 | Viruses | Viruses | 156 | 5.139999999999999e-42 | NR | XCO48908.1 | 1955145 | g81937 | i0 | 91.5 | 1.9919028340081 | 82 | 7 | 99.6 | 0 | 2 | 247 | 873 | 954 | XCO48908.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.] | diamond | 492 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae sp. | |||
| 31890162 | 31890162 | PRJNA944406_P_NODE_6517_length_498_cov_2.654118_g5561_i0 | PRJNA944406 | 6517 | 498 | 2.654118 | 13.21750764 | Durnavirales sp. | 2809355 | Viruses | Viruses | 157 | 3.12e-42 | NR | WRQ64726.1 | 2809355 | g5561 | i0 | 49.1 | 0.993975903614458 | 165 | 84 | 99.4 | 0 | 3 | 497 | 309 | 473 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 495 | 157 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 31985077 | 31985077 | PRJNA944406_P_NODE_56138_length_257_cov_1.673913_g55179_i0 | PRJNA944406 | 56138 | 257 | 1.673913 | 4.30195641 | Soybean thrips dicistrovirus 1 | 2797876 | Viruses | Viruses | 165 | 4.62e-45 | NR | QQN90115.1 | 2797876 | g55179 | i0 | 91.8 | 0.992217898832685 | 85 | 7 | 99.2 | 0 | 255 | 1 | 1231 | 1315 | QQN90115.1 nonstructural polyprotein [Soybean thrips dicistrovirus 1] | diamond | 255 | 165 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Soybean thrips dicistrovirus 1 | |||
| 32775030 | 32775030 | PRJNA944406_P_NODE_28360_length_283_cov_2.147619_g27401_i0 | PRJNA944406 | 28360 | 283 | 2.147619 | 6.07776177 | Penicillium stoloniferum virus S | 216371 | Viruses | Viruses | 121 | 2.27e-30 | NR | YP_052857.1 | 216371 | g27401 | i0 | 60.6 | 0.996466431095406 | 94 | 37 | 99.6 | 0 | 283 | 2 | 155 | 248 | YP_052857.1 capsid protein [Penicillium stoloniferum virus S] | diamond | 282 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus essepenicillii |
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);;