contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA358049" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1673121 | 1673121 | PRJNA358049_S_NODE_1142_length_531_cov_7.526971_g1101_i0 | PRJNA358049 | 1142 | 531 | 7.526971 | 39.96821601 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 588 | 3.209999999999999e-163 | NTclustered | gi|2288523299|gb|ON811606.1| | 2743097 | g1101 | i0 | 90.687 | 2.16760828625235 | 451 | 28 | 84 | 11 | 23 | 470 | 7113 | 6674 | MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome | blastn | 1151 | 588 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 1673414 | 1673414 | PRJNA358049_S_NODE_4202_length_293_cov_2.815574_g4154_i0 | PRJNA358049 | 4202 | 293 | 2.815574 | 8.24963182 | Hulunbuir Botou tick virus 1 | 2972048 | Viruses | Viruses | 135 | 2.6200000000000003e-27 | NTclustered | gi|2319492089|gb|ON746338.1| | 2972048 | g4154 | i0 | 98.684 | 1.33105802047782 | 76 | 1 | 26 | 0 | 195 | 270 | 101 | 26 | MAG: Hulunbuir Botou tick virus 1 isolate TIGMIC 7 genomic sequence | blastn | 390 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 1 | |||
| 4901101 | 4901101 | PRJNA358049_S_NODE_4_length_2870_cov_5.184332_g3_i0 | PRJNA358049 | 4 | 2870 | 5.184332 | 148.7903284 | Viruses | 10239 | Viruses | Viruses | 3345 | 0 | NTclustered | gi|2396039623|gb|ON812886.1| | 2808997 | g3 | i0 | 87.987 | 13.4801393728223 | 2847 | 322 | 99 | 17 | 1 | 2839 | 2835 | 1 | MAG: Botourmiaviridae sp. isolate TIGMIC_3, complete genome | blastn | 38688 | 3345 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 10602551 | 10602551 | PRJNA358049_S_NODE_69_length_1389_cov_5.918657_g58_i0 | PRJNA358049 | 69 | 1389 | 5.918657 | 82.21014573 | Erysiphe necator associated ourmia-like virus 36 | 2741816 | Viruses | Viruses | 970 | 0 | NTclustered | gi|1848976605|gb|MN611564.1| | 2741816 | g58 | i0 | 79.458 | 1.66810655147588 | 1402 | 262 | 100 | 24 | 1 | 1389 | 2149 | 761 | Erysiphe necator associated ourmia-like virus 36 isolate PMS12_DN11639, complete genome | blastn | 2317 | 970 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 36 | ||
| 20800140 | 20800140 | PRJNA358049_S_NODE_18537_length_162_cov_1.053097_g18489_i0 | PRJNA358049 | 18537 | 162 | 1.053097 | 1.70601714 | Picobirnavirus sp. | 1907787 | Viruses | Viruses | 169 | 1.28e-37 | NTclustered | gi|2120560611|gb|MZ556528.1| | 1907787 | g18489 | i0 | 98.936 | 0.580246913580247 | 94 | 1 | 58 | 0 | 2 | 95 | 94 | 1 | MAG: Picobirnavirus sp. isolate 304R-k141_30473 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 94 | 169 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 23350554 | 23350554 | PRJNA358049_S_NODE_16359_length_167_cov_1.754237_g16311_i0 | PRJNA358049 | 16359 | 167 | 1.754237 | 2.92957579 | Coltivirus dermacentoris | 3428066 | Viruses | Viruses | 259 | 7.69e-65 | NTclustered | gi|2758887253|gb|PP473574.1| | 46839 | g16311 | i0 | 94.611 | 7.47305389221557 | 167 | 9 | 100 | 0 | 1 | 167 | 4590 | 4756 | MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence | blastn | 1248 | 259 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris |
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);;