contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16055026 | 16055026 | PRJNA774958_P_NODE_1353_length_1271_cov_1.144407_g1242_i0 | PRJNA774958 | 1353 | 1271 | 1.144407 | 14.54541297 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 502 | 1.3999999999999997e-157 | NR | AVM87439.1 | 3063761 | g1242 | i0 | 56.2 | 1.00786782061369 | 427 | 183 | 99.8 | 2 | 1 | 1269 | 259 | 685 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 1281 | 502 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 27590724 | 27590724 | PRJNA774958_P_NODE_6424_length_648_cov_2.019130_g6196_i0 | PRJNA774958 | 6424 | 648 | 2.01913 | 13.0839624 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 124 | 1.66e-28 | NR | UVF58820.1 | 3063761 | g6196 | i0 | 41.4 | 1.69907407407407 | 191 | 92 | 82.9 | 7 | 537 | 1 | 829 | 1011 | UVF58820.1 MAG: polyprotein [Asterropteryx spinosa picornavirus] | diamond | 1101 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 28073495 | 28073495 | PRJNA774958_P_NODE_3325_length_880_cov_1.840149_g3139_i0 | PRJNA774958 | 3325 | 880 | 1.840149 | 16.1933112 | Viruses | 10239 | Viruses | Viruses | 73.2 | 2.54e-10 | NR | WZL61394.1 | 3139874 | g3139 | i0 | 29.8 | 1.08068181818182 | 168 | 111 | 55.9 | 4 | 56 | 547 | 415 | 579 | WZL61394.1 MAG: hypothetical protein [Kasler Point virus] | diamond | 951 | 73.2 | 1 | Viruses | Kasler Point virus | ||||||||
| 30147929 | 30147929 | PRJNA774958_P_NODE_17772_length_383_cov_0.993548_g17525_i0 | PRJNA774958 | 17772 | 383 | 0.993548 | 3.80528884 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 49.3 | 9.18e-4 | NR | BCT22715.1 | RQ14 | g17525 | i0 | 31.7 | 0.814621409921671 | 104 | 63 | 76 | 3 | 85 | 375 | 810 | 912 | BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus] | diamond | 312 | 49.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30274848 | 30274848 | PRJNA774958_P_NODE_9952_length_518_cov_1.364045_g9709_i0 | PRJNA774958 | 9952 | 518 | 1.364045 | 7.0657531 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 87.8 | 4.98e-17 | NR | BCT22626.1 | RQ14 | g9709 | i0 | 36 | 0.868725868725869 | 150 | 92 | 84.6 | 3 | 39 | 476 | 3 | 152 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 450 | 87.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30369831 | 30369831 | PRJNA774958_P_NODE_9132_length_542_cov_1.074627_g8890_i0 | PRJNA774958 | 9132 | 542 | 1.074627 | 5.82447834 | Phytophthora cinnamomi ormycovirus 7-5 | 3239326 | Viruses | Viruses | 114 | 1.41e-25 | NR | XDO01625.1 | 3239326 | g8890 | i0 | 38.3 | 0.968634686346863 | 175 | 105 | 95.8 | 2 | 535 | 17 | 511 | 684 | XDO01625.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 7-5] | diamond | 525 | 114 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus phytophthorae | |||
| 30442142 | 30442142 | PRJNA774958_P_NODE_14733_length_424_cov_0.985755_g14486_i0 | PRJNA774958 | 14733 | 424 | 0.985755 | 4.1796012 | Viruses | 10239 | Viruses | Viruses | 44.7 | 0.0465 | NR | DAM02168.1 | 2832643 | g14486 | i0 | 37.5 | 0.849056603773585 | 56 | 35 | 39.6 | 0 | 290 | 123 | 132 | 187 | DAM02168.1 MAG TPA: major capsid protein [Caudoviricetes sp.] | diamond | 360 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31475631 | 31475631 | PRJNA774958_P_NODE_5636_length_689_cov_2.982143_g5416_i0 | PRJNA774958 | 5636 | 689 | 2.982143 | 20.54696527 | Pleurotus ostreatus deltaflexivirus 1 | 3027515 | Viruses | Viruses | 375 | 4.62e-116 | NR | WCU24521.1 | 3027515 | g5416 | i0 | 92.2 | 0.840348330914369 | 193 | 15 | 84 | 0 | 580 | 2 | 1 | 193 | WCU24521.1 putative polyprotein [Pleurotus ostreatus deltaflexivirus 1] | diamond | 579 | 375 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus pleurotii |
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);;