contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2744634 | 2744634 | PRJNA1086823_P_NODE_7703_length_297_cov_1.741071_g7586_i0 | PRJNA1086823 | 7703 | 297 | 1.741071 | 5.17098087 | Hangzhou botourmia-like virus 5 | 2970176 | Viruses | Viruses | 394 | 3.98e-105 | NTclustered | gi|2284931938|gb|OM514633.1| | 2970176 | g7586 | i0 | 90.572 | 1 | 297 | 28 | 100 | 0 | 1 | 297 | 1449 | 1745 | MAG: Hangzhou botourmia-like virus 5 isolate DLGFY114 RNA-dependent RNA polymerase gene, complete cds | blastn | 297 | 394 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hangzhou botourmia-like virus 5 | |||
| 5296644 | 5296644 | PRJNA1086823_P_NODE_4765_length_363_cov_1.258621_g4648_i0 | PRJNA1086823 | 4765 | 363 | 1.258621 | 4.56879423 | Sclerotinia sclerotiorum narna-like virus 1 | 3366998 | Viruses | Viruses | 209 | 1.93e-49 | NTclustered | gi|2813513724|gb|PQ328746.1| | 3366998 | g4648 | i0 | 87.432 | 2.11845730027548 | 183 | 21 | 50 | 2 | 137 | 318 | 1570 | 1751 | Sclerotinia sclerotiorum narna-like virus 1 strain XZ69, complete genome | blastn | 769 | 209 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sclerotinia sclerotiorum narna-like virus 1 | |||
| 7846487 | 7846487 | PRJNA1086823_P_NODE_2127_length_515_cov_1.610860_g2011_i0 | PRJNA1086823 | 2127 | 515 | 1.61086 | 8.295929 | Colletotrichum higginsianum mitovirus 1 | 2824786 | Viruses | Viruses | 869 | 0 | NTclustered | gi|2026653156|gb|MW145152.1| | 2824786 | g2011 | i0 | 97.087 | 3.78834951456311 | 515 | 15 | 100 | 0 | 1 | 515 | 2134 | 1620 | Colletotrichum higginsianum mitovirus 1 isolate HTC-5 RNA-dependent RNA polymerase gene, complete cds | blastn | 1951 | 869 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Colletotrichum higginsianum mitovirus 1 | ||
| 15496427 | 15496427 | PRJNA1086823_P_NODE_1733_length_565_cov_1.247967_g1618_i0 | PRJNA1086823 | 1733 | 565 | 1.247967 | 7.05101355 | Colletotrichum higginsianum mitovirus 1 | 2824786 | Viruses | Viruses | 972 | 0 | NTclustered | gi|2026653156|gb|MW145152.1| | 2824786 | g1618 | i0 | 97.865 | 3.26371681415929 | 562 | 12 | 99 | 0 | 1 | 562 | 143 | 704 | Colletotrichum higginsianum mitovirus 1 isolate HTC-5 RNA-dependent RNA polymerase gene, complete cds | blastn | 1844 | 972 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Colletotrichum higginsianum mitovirus 1 | ||
| 18045639 | 18045639 | PRJNA1086823_P_NODE_775_length_850_cov_4.925354_g681_i0 | PRJNA1086823 | 775 | 850 | 4.925354 | 41.865509 | Botryosphaeria dothidea mitovirus 2 | 2829087 | Viruses | Viruses | 1509 | 0 | NTclustered | gi|2031679214|gb|MW218983.1| | 2829087 | g681 | i0 | 98.706 | 1.54117647058824 | 850 | 11 | 100 | 0 | 1 | 850 | 18 | 867 | Botryosphaeria dothidea mitovirus 2 isolate DT-5, complete genome | blastn | 1310 | 1509 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Botryosphaeria dothidea mitovirus 2 | ||
| 21870537 | 21870537 | PRJNA1086823_P_NODE_1498_length_608_cov_1.676636_g1384_i0 | PRJNA1086823 | 1498 | 608 | 1.676636 | 10.19394688 | Colletotrichum higginsianum mitovirus 1 | 2824786 | Viruses | Viruses | 913 | 0 | NTclustered | gi|2026653156|gb|MW145152.1| | 2824786 | g1384 | i0 | 93.75 | 2.38980263157895 | 608 | 38 | 100 | 0 | 1 | 608 | 686 | 1293 | Colletotrichum higginsianum mitovirus 1 isolate HTC-5 RNA-dependent RNA polymerase gene, complete cds | blastn | 1453 | 913 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Colletotrichum higginsianum mitovirus 1 | ||
| 23146020 | 23146020 | PRJNA1086823_P_NODE_259_length_1424_cov_4.139896_g202_i0 | PRJNA1086823 | 259 | 1424 | 4.139896 | 58.95211904 | Botryosphaeria dothidea mitovirus 2 | 2829087 | Viruses | Viruses | 2514 | 0 | NTclustered | gi|2031679214|gb|MW218983.1| | 2829087 | g202 | i0 | 98.525 | 10.2886235955056 | 1424 | 21 | 100 | 0 | 1 | 1424 | 2405 | 982 | Botryosphaeria dothidea mitovirus 2 isolate DT-5, complete genome | blastn | 14651 | 2514 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Botryosphaeria dothidea mitovirus 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);;