contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26718404 | 26718404 | PRJNA1059246_P_NODE_21101_length_493_cov_1.976190_g20482_i0 | PRJNA1059246 | 21101 | 493 | 1.97619 | 9.7426167 | Sclerotinia sclerotiorum narnavirus 1 | 2822897 | Viruses | Viruses | 47 | 0.00951 | NR | QZE12035.1 | 2822897 | g20482 | i0 | 29.2 | 0.979716024340771 | 161 | 85 | 95.5 | 5 | 477 | 7 | 75 | 210 | QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1] | diamond | 483 | 47 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sclerotinia sclerotiorum narnavirus 1 | ||
| 26741923 | 26741923 | PRJNA1059246_P_NODE_55901_length_271_cov_1.151515_g55275_i0 | PRJNA1059246 | 55901 | 271 | 1.151515 | 3.12060565 | Narnavirus | 186767 | Viruses | Viruses | 70.9 | 6.42e-12 | NR | QED22729.1 | 2601606 | g55275 | i0 | 43.1 | 5.00369003690037 | 72 | 41 | 79.7 | 0 | 9 | 224 | 264 | 335 | QED22729.1 RNA-dependent RNA polymerase, partial [Botryosphaeria dothidea narnavirus 1] | diamond | 1356 | 71.2 | 0.995786516853933 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Botryosphaeria dothidea narnavirus 1 | |||
| 27066900 | 27066900 | PRJNA1059246_P_NODE_47902_length_298_cov_1.720000_g47276_i0 | PRJNA1059246 | 47902 | 298 | 1.72 | 5.1256 | Soybean thrips partiti-like virus 1 | 2801003 | Viruses | Viruses | 54.7 | 4.49e-6 | NR | QQO81406.1 | 2801004 | g47276 | i0 | 33.3 | 0.724832214765101 | 72 | 48 | 72.5 | 0 | 249 | 34 | 398 | 469 | QQO81406.1 RNA-dependent RNA polymerase, partial [Soybean thrips partiti-like virus 10] | diamond | 216 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Soybean thrips partiti-like virus 10 | |||
| 27280171 | 27280171 | PRJNA1059246_P_NODE_45043_length_312_cov_0.966527_g44417_i0 | PRJNA1059246 | 45043 | 312 | 0.966527 | 3.01556424 | Wolframvirales | 2732502 | Viruses | Viruses | 70.1 | 2.13e-11 | NR | WNA22212.1 | 2719525 | g44417 | i0 | 34.9 | 3.02884615384615 | 106 | 66 | 99 | 2 | 4 | 312 | 479 | 584 | WNA22212.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 4] | diamond | 945 | 70.5 | 0.994326241134752 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 27414907 | 27414907 | PRJNA1059246_P_NODE_24103_length_457_cov_1.234375_g23479_i0 | PRJNA1059246 | 24103 | 457 | 1.234375 | 5.64109375 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 130 | 9.31e-32 | NR | QKK82958.1 | 2739846 | g23479 | i0 | 47.3 | 0.971553610503282 | 148 | 74 | 96.5 | 2 | 454 | 14 | 1700 | 1844 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 444 | 130 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like virus | ||||
| 27635806 | 27635806 | PRJNA1059246_P_NODE_41224_length_330_cov_1.684825_g40598_i0 | PRJNA1059246 | 41224 | 330 | 1.684825 | 5.5599225 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 55.1 | 5.04e-6 | NR | QKK82958.1 | 2739846 | g40598 | i0 | 32.4 | 0.954545454545455 | 105 | 63 | 94.5 | 2 | 3 | 314 | 1461 | 1558 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 315 | 55.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like virus | ||||
| 28614555 | 28614555 | PRJNA1059246_P_NODE_6767_length_947_cov_3.512586_g6296_i0 | PRJNA1059246 | 6767 | 947 | 3.512586 | 33.26418942 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 52.4 | 0.00231 | NR | XCO49393.1 | 1955144 | g6296 | i0 | 40.5 | 0.26610348468849 | 84 | 49 | 26.3 | 1 | 844 | 596 | 1418 | 1501 | XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.] | diamond | 252 | 52.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 28677713 | 28677713 | PRJNA1059246_P_NODE_30507_length_396_cov_1.068111_g29881_i0 | PRJNA1059246 | 30507 | 396 | 1.068111 | 4.22971956 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 126 | 1.17e-32 | NR | QDH88920.1 | 1955170 | g29881 | i0 | 48.1 | 0.992424242424242 | 131 | 66 | 99.2 | 2 | 394 | 2 | 65 | 193 | QDH88920.1 MAG: RNA-dependent RNA polymerase, partial [Partitiviridae sp.] | diamond | 393 | 126 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 31078217 | 31078217 | PRJNA1059246_P_NODE_42755_length_322_cov_2.626506_g42129_i0 | PRJNA1059246 | 42755 | 322 | 2.626506 | 8.45734932 | Hebei narnavirus 5 | 3371271 | Viruses | Viruses | 67 | 2.76e-10 | NR | XHY85189.1 | 3371271 | g42129 | i0 | 44.1 | 0.549689440993789 | 59 | 33 | 55 | 0 | 182 | 6 | 66 | 124 | XHY85189.1 MAG: RNA-dependent RNA polymerase [Hebei narnavirus 5] | diamond | 177 | 67 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hebei narnavirus 5 | ||
| 32658913 | 32658913 | PRJNA1059246_P_NODE_2400_length_1587_cov_2.013210_g2169_i0 | PRJNA1059246 | 2400 | 1587 | 2.01321 | 31.9496427 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 223 | 5.7e-59 | NR | QKK82958.1 | 2739846 | g2169 | i0 | 32.1 | 0.958412098298677 | 507 | 259 | 87.9 | 14 | 128 | 1522 | 2498 | 2961 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 1521 | 223 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like 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);;