contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 269201 | 269201 | PRJNA1120060_P_NODE_636041_length_343_cov_1.225926_g618279_i0 | PRJNA1120060 | 636041 | 343 | 1.225926 | 4.20492618 | Taiwan douglas-fir deltapartitivirus | 2933092 | Viruses | Viruses | 67 | 3.51e-10 | NR | CAI5384001.1 | 2933092 | g618279 | i0 | 61.1 | 0.472303206997085 | 54 | 18 | 47.2 | 1 | 178 | 17 | 128 | 178 | CAI5384001.1 RNA-dependent RNA polymerase [Taiwan douglas-fir deltapartitivirus] | diamond | 162 | 67 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Taiwan douglas-fir deltapartitivirus | ||
| 26941690 | 26941690 | PRJNA1120060_P_NODE_1496062_length_293_cov_4.122727_g1478074_i0 | PRJNA1120060 | 1496062 | 293 | 4.122727 | 12.07959011 | Actinidia fungus negative-stranded RNA virus 1 | 3079862 | Viruses | Viruses | 43.9 | 0.0277 | NR | WON42279.1 | 3079862 | g1478074 | i0 | 34.2 | 0.747440273037543 | 73 | 41 | 69.6 | 3 | 242 | 39 | 2087 | 2157 | WON42279.1 RNA-dependent RNA polymerase [Actinidia fungus negative-stranded RNA virus 1] | diamond | 219 | 43.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Actinidia fungus negative-stranded RNA virus 1 | ||||||
| 27447678 | 27447678 | PRJNA1120060_P_NODE_1261443_length_309_cov_2.084746_g1243502_i0 | PRJNA1120060 | 1261443 | 309 | 2.084746 | 6.44186514 | Pinus albicaulis amalgavirus 1 | 2982067 | Viruses | Viruses | 56.6 | 1.13e-6 | NR | DAZ91039.1 | 2982067 | g1243502 | i0 | 37.8 | 0.796116504854369 | 82 | 37 | 66 | 1 | 103 | 306 | 868 | 949 | DAZ91039.1 TPA_asm: fusion protein [Pinus albicaulis amalgavirus 1] | diamond | 246 | 56.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Amalgaviridae | Amalgavirus | Pinus albicaulis amalgavirus 1 | ||
| 27732970 | 27732970 | PRJNA1120060_P_NODE_2752824_length_247_cov_1.718391_g2734740_i0 | PRJNA1120060 | 2752824 | 247 | 1.718391 | 4.24442577 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 76.6 | 4.53e-14 | NR | BDR95914.1 | 2979708 | g2734740 | i0 | 47.7 | 0.789473684210526 | 65 | 34 | 78.9 | 0 | 219 | 25 | 454 | 518 | BDR95914.1 hypothetical protein [Qingdao RNA virus 4] | diamond | 195 | 76.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 28773766 | 28773766 | PRJNA1120060_P_NODE_1767007_length_282_cov_2.143541_g1748996_i0 | PRJNA1120060 | 1767007 | 282 | 2.143541 | 6.04478562 | Pinus patula amalgavirus 1 | 2058877 | Viruses | Viruses | 120 | 3.21e-30 | NR | DAB41736.1 | 2058877 | g1748996 | i0 | 61.4 | 0.936170212765957 | 88 | 34 | 93.6 | 0 | 282 | 19 | 212 | 299 | DAB41736.1 TPA_exp: ORF1p, partial [Pinus patula amalgavirus 1] | diamond | 264 | 120 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Amalgaviridae | Pinus patula amalgavirus 1 | |||
| 31649019 | 31649019 | PRJNA1120060_P_NODE_2380457_length_258_cov_2.097297_g2362392_i0 | PRJNA1120060 | 2380457 | 258 | 2.097297 | 5.41102626 | Border disease virus | 358764 | Viruses | Viruses | 47.4 | 0.00103 | NR | AAA18909.1 | 358764 | g2362392 | i0 | 42.6 | 1.82558139534884 | 47 | 24 | 54.7 | 1 | 75 | 215 | 385 | 428 | AAA18909.1 polyprotein; structural protein; glycoprotein, partial [Border disease virus] | diamond | 471 | 47.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus ovis | ||
| 32787902 | 32787902 | PRJNA1120060_P_NODE_678340_length_336_cov_4.197719_g660533_i0 | PRJNA1120060 | 678340 | 336 | 4.197719 | 14.10433584 | Poaceae Liege alphachrysovirus 2 | 2972876 | Viruses | Viruses | 50.8 | 1.65e-4 | NR | UVG55906.1 | 2972876 | g660533 | i0 | 57.5 | 0.357142857142857 | 40 | 17 | 35.7 | 0 | 97 | 216 | 572 | 611 | UVG55906.1 putative RNA-dependent RNA polymerase [Poaceae Liege alphachrysovirus 2] | diamond | 120 | 50.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Poaceae Liege alphachrysovirus 2 |
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);;