contig_metadata
8 rows where bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20535803 | 20535803 | PRJEB673_P_NODE_2717_length_600_cov_1.658407_g2416_i0 | PRJEB673 | 2717 | 600 | 1.658407 | 9.950442 | Cripavirus sp. | 1955141 | Viruses | Viruses | 186 | 1.22e-50 | NR | ULF99874.1 | 1955141 | g2416 | i0 | 46.7 | 3.95 | 197 | 105 | 98.5 | 0 | 599 | 9 | 1517 | 1713 | ULF99874.1 MAG: hypothetical protein 1 [Cripavirus sp.] | diamond | 2370 | 186 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 21811736 | 21811736 | PRJEB673_P_NODE_98_length_2363_cov_2.653780_g63_i0 | PRJEB673 | 98 | 2363 | 2.65378 | 62.7088214 | Cripavirus | 144051 | Viruses | Viruses | 212 | 7.839999999999998e-54 | NR | ULF99858.1 | 1955141 | g63 | i0 | 42.3 | 2.15700380871773 | 307 | 152 | 35.8 | 6 | 2334 | 1489 | 197 | 503 | ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] | diamond | 5097 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 26876171 | 26876171 | PRJEB673_P_NODE_1_length_6210_cov_3.522915_g0_i0 | PRJEB673 | 1 | 6210 | 3.522915 | 218.7730215 | Ripucork virus | 3130406 | Viruses | Viruses | 347 | 7.69e-100 | NR | WZH59587.1 | 3130406 | g0 | i0 | 34.4 | 0.297584541062802 | 616 | 377 | 29.1 | 10 | 1215 | 3023 | 12 | 613 | WZH59587.1 MAG: RNA-dependent RNA polymerase [Ripucork virus] | diamond | 1848 | 347 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripucork virus | |||
| 27152894 | 27152894 | PRJEB673_P_NODE_1822_length_716_cov_1.444934_g1574_i0 | PRJEB673 | 1822 | 716 | 1.444934 | 10.34572744 | Cripavirus | 144051 | Viruses | Viruses | 102 | 1.12e-20 | NR | NP_044946.1 | 64279 | g1574 | i0 | 44.8 | 2.47206703910615 | 116 | 63 | 48.2 | 1 | 163 | 507 | 16 | 131 | NP_044946.1 capsid polyprotein, partial [Drosophila C virus] | diamond | 1770 | 103 | 0.990291262135922 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus drosophilae | ||
| 28708057 | 28708057 | PRJEB673_P_NODE_10567_length_172_cov_1.007299_g10218_i0 | PRJEB673 | 10567 | 172 | 1.007299 | 1.73255428 | Gremmeniella abietina RNA virus MS1 | 191436 | Viruses | Viruses | 68.9 | 1e-12 | NR | AII15934.1 | 191436 | g10218 | i0 | 51.8 | 1.95348837209302 | 56 | 27 | 97.7 | 0 | 172 | 5 | 40 | 95 | AII15934.1 RNA-dependent RNA polymerase, partial [Gremmeniella abietina RNA virus MS1] | diamond | 336 | 68.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus gremmeniellae | ||
| 29307756 | 29307756 | PRJEB673_P_NODE_2029_length_682_cov_2.284389_g1766_i0 | PRJEB673 | 2029 | 682 | 2.284389 | 15.57953298 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 261 | 6.750000000000001e-79 | NR | XCM68377.1 | 3003959 | g1766 | i0 | 58.7 | 7.95307917888563 | 225 | 92 | 98.5 | 1 | 6 | 677 | 260 | 484 | XCM68377.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 5424 | 261 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32752421 | 32752421 | PRJEB673_P_NODE_13060_length_150_cov_1.034783_g12711_i0 | PRJEB673 | 13060 | 150 | 1.034783 | 1.5521745 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 41.2 | 0.0383 | NR | ULF99807.1 | 1955144 | g12711 | i0 | 40.8 | 0.98 | 49 | 25 | 98 | 1 | 4 | 150 | 437 | 481 | ULF99807.1 MAG: putative replicase polyprotein, partial [Dicistroviridae sp.] | diamond | 147 | 41.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 32846794 | 32846794 | PRJEB673_P_NODE_20_length_3473_cov_3.276905_g0_i1 | PRJEB673 | 20 | 3473 | 3.276905 | 113.80691065 | Ripucork virus | 3130406 | Viruses | Viruses | 96.3 | 4.54e-16 | NR | WZH59589.1 | 3130406 | g0 | i1 | 25 | 0.43276706017852 | 501 | 334 | 41.7 | 17 | 1379 | 2827 | 37 | 513 | WZH59589.1 MAG: hypothetical protein [Ripucork virus] | diamond | 1503 | 96.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripucork 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);;