contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27619223 | 27619223 | PRJNA681822_P_NODE_5684_length_1582_cov_4.996024_g5009_i0 | PRJNA681822 | 5684 | 1582 | 4.996024 | 79.03709968 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 337 | 2.959999999999999e-105 | NR | BDR95914.1 | 2979708 | g5009 | i0 | 47.7 | 1.2629582806574 | 333 | 174 | 63.1 | 0 | 1582 | 584 | 264 | 596 | BDR95914.1 hypothetical protein [Qingdao RNA virus 4] | diamond | 1998 | 337 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 29197965 | 29197965 | PRJNA681822_P_NODE_362029_length_257_cov_1.391304_g360540_i0 | PRJNA681822 | 362029 | 257 | 1.391304 | 3.57565128 | Sclerotinia sclerotiorum narnavirus 4 | 2830863 | Viruses | Viruses | 99.8 | 3.97e-22 | NR | QZE12025.1 | 2830863 | g360540 | i0 | 66.2 | 1.79766536964981 | 77 | 26 | 89.9 | 0 | 251 | 21 | 684 | 760 | QZE12025.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 4] | diamond | 462 | 99.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sclerotinia sclerotiorum narnavirus 4 | ||
| 29639515 | 29639515 | PRJNA681822_P_NODE_23490_length_783_cov_2.783099_g22212_i0 | PRJNA681822 | 23490 | 783 | 2.783099 | 21.79166517 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 164 | 5.299999999999999e-43 | NR | BDR95914.1 | 2979708 | g22212 | i0 | 39.8 | 0.885057471264368 | 231 | 137 | 88.5 | 1 | 698 | 6 | 3 | 231 | BDR95914.1 hypothetical protein [Qingdao RNA virus 4] | diamond | 693 | 164 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 29765951 | 29765951 | PRJNA681822_P_NODE_130571_length_358_cov_1.210526_g129084_i0 | PRJNA681822 | 130571 | 358 | 1.210526 | 4.33368308 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 80.5 | 8.18e-15 | NR | XCM68108.1 | 3003959 | g129084 | i0 | 43 | 0.720670391061452 | 86 | 49 | 72.1 | 0 | 260 | 3 | 60 | 145 | XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 258 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29765979 | 29765979 | PRJNA681822_P_NODE_304291_length_273_cov_1.405000_g302802_i0 | PRJNA681822 | 304291 | 273 | 1.405 | 3.83565 | Streptophyte associated narna-like virus 9 | 3067074 | Viruses | Viruses | 127 | 4.7699999999999996e-32 | NR | WPR17282.1 | 3067074 | g302802 | i0 | 73.8 | 1.78021978021978 | 80 | 21 | 87.9 | 0 | 242 | 3 | 54 | 133 | WPR17282.1 MAG: RNA-dependent RNA polymerase, partial [Streptophyte associated narna-like virus 9] | diamond | 486 | 127 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Streptophyte associated narna-like virus 9 | |||
| 30998342 | 30998342 | PRJNA681822_P_NODE_395354_length_250_cov_0.870056_g393865_i0 | PRJNA681822 | 395354 | 250 | 0.870056 | 2.17514 | Taiwan douglas-fir deltapartitivirus | 2933092 | Viruses | Viruses | 105 | 2.2799999999999998e-24 | NR | CAI5384001.1 | 2933092 | g393865 | i0 | 61.4 | 0.996 | 83 | 31 | 99.6 | 1 | 2 | 250 | 114 | 195 | CAI5384001.1 RNA-dependent RNA polymerase [Taiwan douglas-fir deltapartitivirus] | diamond | 249 | 105 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Taiwan douglas-fir deltapartitivirus | ||
| 32105099 | 32105099 | PRJNA681822_P_NODE_109178_length_380_cov_1.374593_g107692_i0 | PRJNA681822 | 109178 | 380 | 1.374593 | 5.2234534 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 157 | 1.7e-41 | NR | BDR95913.1 | 2979708 | g107692 | i0 | 63.5 | 0.994736842105263 | 126 | 46 | 99.5 | 0 | 1 | 378 | 1360 | 1485 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 378 | 157 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 32389945 | 32389945 | PRJNA681822_P_NODE_342859_length_262_cov_2.169312_g341370_i0 | PRJNA681822 | 342859 | 262 | 2.169312 | 5.68359744 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 156 | 4.02e-42 | NR | XCM68434.1 | 3003959 | g341370 | i0 | 80 | 0.973282442748092 | 85 | 17 | 97.3 | 0 | 260 | 6 | 594 | 678 | XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 255 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32548361 | 32548361 | PRJNA681822_P_NODE_213219_length_300_cov_2.268722_g211731_i0 | PRJNA681822 | 213219 | 300 | 2.268722 | 6.806166 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 64.3 | 2.05e-9 | NR | BDR95913.1 | 2979708 | g211731 | i0 | 33.7 | 1.04 | 104 | 63 | 98 | 1 | 1 | 294 | 1685 | 1788 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 312 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 |
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);;