contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29401678 | 29401678 | PRJEB29441_P_NODE_34089_length_179_cov_1.523077_g33648_i0 | PRJEB29441 | 34089 | 179 | 1.523077 | 2.72630783 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 59.7 | 1.64e-8 | NR | UJQ92879.1 | 2583949 | g33648 | i0 | 45.8 | 1.97765363128492 | 59 | 31 | 98.9 | 1 | 3 | 179 | 526 | 583 | UJQ92879.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 354 | 59.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 29496394 | 29496394 | PRJEB29441_P_NODE_28510_length_196_cov_1.782313_g28069_i0 | PRJEB29441 | 28510 | 196 | 1.782313 | 3.49333348 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 43.9 | 0.00768 | NR | UJQ92791.1 | 2583949 | g28069 | i0 | 47.8 | 0.704081632653061 | 46 | 23 | 68.9 | 1 | 35 | 169 | 149 | 194 | UJQ92791.1 MAG: hypothetical protein [Narnaviridae sp.] | diamond | 138 | 43.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 29528063 | 29528063 | PRJEB29441_P_NODE_33770_length_180_cov_1.480916_g33329_i0 | PRJEB29441 | 33770 | 180 | 1.480916 | 2.6656488 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 104 | 2.33e-24 | NR | UJQ92790.1 | 2583949 | g33329 | i0 | 88.1 | 1.96666666666667 | 59 | 7 | 98.3 | 0 | 179 | 3 | 209 | 267 | UJQ92790.1 MAG: putative RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 354 | 104 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 29590763 | 29590763 | PRJEB29441_P_NODE_16130_length_270_cov_2.298643_g15689_i0 | PRJEB29441 | 16130 | 270 | 2.298643 | 6.2063361 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 150 | 1.03e-39 | NR | UJQ92915.1 | 2583949 | g15689 | i0 | 83.3 | 1.87777777777778 | 84 | 14 | 93.3 | 0 | 270 | 19 | 255 | 338 | UJQ92915.1 MAG: putative RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 507 | 150 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 30538758 | 30538758 | PRJEB29441_P_NODE_17533_length_257_cov_1.615385_g17092_i0 | PRJEB29441 | 17533 | 257 | 1.615385 | 4.15153945 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 145 | 2.84e-38 | NR | UJQ92790.1 | 2583949 | g17092 | i0 | 82.9 | 2.91828793774319 | 82 | 14 | 95.7 | 0 | 6 | 251 | 108 | 189 | UJQ92790.1 MAG: putative RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 750 | 145 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 30760029 | 30760029 | PRJEB29441_P_NODE_17574_length_257_cov_0.966346_g17133_i0 | PRJEB29441 | 17574 | 257 | 0.966346 | 2.48350922 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 93.6 | 4.71e-20 | NR | URG16717.1 | 2809572 | g17133 | i0 | 62.2 | 0.957198443579767 | 82 | 29 | 94.6 | 2 | 245 | 3 | 159 | 239 | URG16717.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 246 | 93.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 30886354 | 30886354 | PRJEB29441_P_NODE_28734_length_195_cov_2.595890_g28293_i0 | PRJEB29441 | 28734 | 195 | 2.59589 | 5.0619855 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 106 | 8.38e-25 | NR | UJQ92915.1 | 2583949 | g28293 | i0 | 79.7 | 0.984615384615385 | 64 | 13 | 98.5 | 0 | 2 | 193 | 184 | 247 | UJQ92915.1 MAG: putative RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 192 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 31455405 | 31455405 | PRJEB29441_P_NODE_40176_length_166_cov_0.871795_g39735_i0 | PRJEB29441 | 40176 | 166 | 0.871795 | 1.4471797 | Ripaglac virus | 3130411 | Viruses | Viruses | 55.8 | 3.15e-7 | NR | WZH59599.1 | 3130411 | g39735 | i0 | 56.5 | 0.831325301204819 | 46 | 20 | 83.1 | 0 | 162 | 25 | 566 | 611 | WZH59599.1 MAG: RNA-dependent RNA polymerase [Ripaglac virus] | diamond | 138 | 55.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripaglac virus | |||
| 31834700 | 31834700 | PRJEB29441_P_NODE_22277_length_224_cov_1.348571_g21836_i0 | PRJEB29441 | 22277 | 224 | 1.348571 | 3.02079904 | Ripatrop virus | 3131332 | Viruses | Viruses | 81.6 | 5.37e-16 | NR | WZH61242.1 | 3131332 | g21836 | i0 | 50.7 | 0.950892857142857 | 71 | 35 | 95.1 | 0 | 1 | 213 | 68 | 138 | WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus] | diamond | 213 | 81.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripatrop virus | |||
| 32214622 | 32214622 | PRJEB29441_P_NODE_38458_length_167_cov_2.508475_g38017_i0 | PRJEB29441 | 38458 | 167 | 2.508475 | 4.18915325 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 108 | 8.75e-26 | NR | UJQ92702.1 | 2583949 | g38017 | i0 | 89.1 | 0.988023952095808 | 55 | 6 | 98.8 | 0 | 166 | 2 | 331 | 385 | UJQ92702.1 MAG: putative RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 165 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. |
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);;