contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1255065" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28431892 | 28431892 | PRJNA1255065_P_NODE_82366_length_197_cov_1.040541_g80138_i0 | PRJNA1255065 | 82366 | 197 | 1.040541 | 2.04986577 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 54.7 | 1.23e-6 | NR | CAI9858973.1 | 3048756 | g80138 | i0 | 81.8 | 0.50253807106599 | 33 | 6 | 50.3 | 0 | 97 | 195 | 618 | 650 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 99 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 28512840 | 28512840 | PRJNA1255065_P_NODE_128687_length_165_cov_1.344828_g126459_i0 | PRJNA1255065 | 128687 | 165 | 1.344828 | 2.2189662 | Totivirus | 11007 | Viruses | Viruses | 80.1 | 1.32e-16 | NR | QOQ37359.1 | 2776824 | g126459 | i0 | 67.3 | 2.96363636363636 | 55 | 18 | 100 | 0 | 1 | 165 | 124 | 178 | QOQ37359.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 489 | 80.9 | 0.990111248454882 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 28873826 | 28873826 | PRJNA1255065_P_NODE_139928_length_164_cov_0.904348_g137700_i0 | PRJNA1255065 | 139928 | 164 | 0.904348 | 1.48313072 | Tolivirales sp. | 2809914 | Viruses | Viruses | 47 | 4.08e-4 | NR | WRQ65890.1 | 2809914 | g137700 | i0 | 44.4 | 2.01219512195122 | 54 | 29 | 97 | 1 | 6 | 164 | 167 | 220 | WRQ65890.1 polyprotein, partial [Tolivirales sp.] | diamond | 330 | 47 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29031978 | 29031978 | PRJNA1255065_P_NODE_56668_length_259_cov_1.466667_g54440_i0 | PRJNA1255065 | 56668 | 259 | 1.466667 | 3.79866753 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 141 | 1.11e-36 | NR | UNY41988.1 | 3003959 | g54440 | i0 | 75 | 0.972972972972973 | 84 | 21 | 97.3 | 0 | 253 | 2 | 2365 | 2448 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 252 | 141 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29459774 | 29459774 | PRJNA1255065_P_NODE_131470_length_165_cov_0.896552_g129242_i0 | PRJNA1255065 | 131470 | 165 | 0.896552 | 1.4793108 | Totivirus | 11007 | Viruses | Viruses | 101 | 1.35e-23 | NR | QOQ37362.1 | 2776824 | g129242 | i0 | 90.9 | 2 | 55 | 5 | 100 | 0 | 1 | 165 | 186 | 240 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 330 | 102 | 0.990196078431373 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 31401227 | 31401227 | PRJNA1255065_P_NODE_72716_length_214_cov_0.939394_g70488_i0 | PRJNA1255065 | 72716 | 214 | 0.939394 | 2.01030316 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 82.4 | 2.66e-16 | NR | UNY41988.1 | 3003959 | g70488 | i0 | 55.2 | 0.939252336448598 | 67 | 30 | 93.9 | 0 | 212 | 12 | 2640 | 2706 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 201 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31622342 | 31622342 | PRJNA1255065_P_NODE_83476_length_195_cov_1.404110_g81248_i0 | PRJNA1255065 | 83476 | 195 | 1.40411 | 2.7380145 | Nigrospora oryzae partitivirus 1 | 2269000 | Viruses | Viruses | 47.4 | 4.52e-4 | NR | AXF84302.1 | 2269000 | g81248 | i0 | 52.8 | 1.98461538461538 | 36 | 17 | 55.4 | 0 | 119 | 12 | 279 | 314 | AXF84302.1 RNA-dependent RNA polymerase [Nigrospora oryzae partitivirus 1] | diamond | 387 | 47.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Nigrospora oryzae partitivirus 1 | |||
| 32160425 | 32160425 | PRJNA1255065_P_NODE_76498_length_207_cov_0.974684_g74270_i0 | PRJNA1255065 | 76498 | 207 | 0.974684 | 2.01759588 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 92.8 | 5.59e-20 | NR | XCM67838.1 | 3003959 | g74270 | i0 | 57.6 | 0.956521739130435 | 66 | 28 | 95.7 | 0 | 10 | 207 | 833 | 898 | XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 198 | 92.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32381784 | 32381784 | PRJNA1255065_P_NODE_130479_length_165_cov_0.896552_g128251_i0 | PRJNA1255065 | 130479 | 165 | 0.896552 | 1.4793108 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 105 | 9.99e-25 | NR | CAI9858976.1 | 3048757 | g128251 | i0 | 100 | 0.981818181818182 | 54 | 0 | 98.2 | 0 | 163 | 2 | 537 | 590 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 162 | 105 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 |
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);;