contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27768938 | 27768938 | PRJNA1249535_S_NODE_244544_length_283_cov_1.438095_g241161_i0 | PRJNA1249535 | 244544 | 283 | 1.438095 | 4.06980885 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 53.1 | 1.26e-5 | NR | UNI74120.1 | 2900383 | g241161 | i0 | 38.8 | 0.710247349823322 | 67 | 41 | 71 | 0 | 205 | 5 | 1 | 67 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 201 | 53.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 28115855 | 28115855 | PRJNA1249535_S_NODE_184965_length_314_cov_5.029046_g181582_i0 | PRJNA1249535 | 184965 | 314 | 5.029046 | 15.79120444 | brine shrimp chuvirus 1 | 2900479 | Viruses | Viruses | 43.5 | 0.0478 | NR | UIW13701.1 | 2900479 | g181582 | i0 | 48.9 | 0.429936305732484 | 45 | 19 | 43 | 1 | 3 | 137 | 770 | 810 | UIW13701.1 MAG: RNA-dependent RNA polymerase [brine shrimp chuvirus 1] | diamond | 135 | 43.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | brine shrimp chuvirus 1 | |||
| 30421655 | 30421655 | PRJNA1249535_S_NODE_222833_length_294_cov_3.253394_g219450_i0 | PRJNA1249535 | 222833 | 294 | 3.253394 | 9.56497836 | Betacoronavirus 1 | 694003 | Viruses | Viruses | 43.9 | 0.028 | NR | QTF66155.1 | 694003 | g219450 | i0 | 35.4 | 0.489795918367347 | 48 | 28 | 45.9 | 1 | 268 | 134 | 1165 | 1212 | QTF66155.1 ORF1ab polyprotein [Betacoronavirus 1] | diamond | 144 | 43.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus gravedinis | ||
| 31527631 | 31527631 | PRJNA1249535_S_NODE_75816_length_408_cov_7.250746_g72435_i0 | PRJNA1249535 | 75816 | 408 | 7.250746 | 29.58304368 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 136 | 1.95e-35 | NR | UNI74120.1 | 2900383 | g72435 | i0 | 59.5 | 0.816176470588235 | 111 | 45 | 81.6 | 0 | 3 | 335 | 249 | 359 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 333 | 136 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 32065177 | 32065177 | PRJNA1249535_S_NODE_254118_length_278_cov_1.273171_g250735_i0 | PRJNA1249535 | 254118 | 278 | 1.273171 | 3.53941538 | brine shrimp yue-like virus 8 | 2900460 | Viruses | Viruses | 169 | 2.05e-46 | NR | UNI74191.1 | 2900460 | g250735 | i0 | 90.1 | 0.982014388489209 | 91 | 9 | 98.2 | 0 | 2 | 274 | 1197 | 1287 | UNI74191.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 8] | diamond | 273 | 169 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 8 | |||
| 32602919 | 32602919 | PRJNA1249535_S_NODE_11220_length_799_cov_9.249311_g8744_i0 | PRJNA1249535 | 11220 | 799 | 9.249311 | 73.90199489 | Xinjiang tick rhabdovirus | 2560016 | Viruses | Viruses | 91.3 | 7.5e-17 | NR | YP_010797955.1 | 2560016 | g8744 | i0 | 36.2 | 0.529411764705882 | 141 | 88 | 52.2 | 2 | 2 | 418 | 219 | 359 | YP_010797955.1 NP [Xinjiang tick rhabdovirus] | diamond | 423 | 91.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lostrhavirus | Lostrhavirus hyalomma | ||
| 32791667 | 32791667 | PRJNA1249535_S_NODE_242560_length_284_cov_1.658768_g239177_i0 | PRJNA1249535 | 242560 | 284 | 1.658768 | 4.71090112 | brine shrimp yue-like virus 4 | 2900456 | Viruses | Viruses | 117 | 1.27e-28 | NR | UNI74172.1 | 2900456 | g239177 | i0 | 61.2 | 0.897887323943662 | 85 | 33 | 89.8 | 0 | 30 | 284 | 240 | 324 | UNI74172.1 MAG: hypothetical protein [brine shrimp yue-like virus 4] | diamond | 255 | 117 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like 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);;