contig_metadata
13 rows where bioproject = "PRJNA1097627" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 208550 | 208550 | PRJNA1097627_P_NODE_4801_length_509_cov_2.561927_g4514_i0 | PRJNA1097627 | 4801 | 509 | 2.561927 | 13.04020843 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 928 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g4514 | i0 | 99.606 | 0.99803536345776 | 508 | 2 | 99 | 0 | 1 | 508 | 2547 | 2040 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 508 | 928 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 2761626 | 2761626 | PRJNA1097627_P_NODE_96783_length_276_cov_1.068966_g96490_i0 | PRJNA1097627 | 96783 | 276 | 1.068966 | 2.95034616 | Potyviridae sp. | 2681589 | Viruses | Viruses | 499 | 7.54e-137 | NTclustered | gi|2697177281|gb|OR867843.1| | 2681589 | g96490 | i0 | 100 | 0.978260869565217 | 270 | 0 | 98 | 0 | 7 | 276 | 5557 | 5288 | MAG: Potyviridae sp. isolate JTYGF13_16/3 genomic sequence | blastn | 270 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyviridae sp. | |||
| 5310569 | 5310569 | PRJNA1097627_P_NODE_285_length_2057_cov_4.197581_g183_i0 | PRJNA1097627 | 285 | 2057 | 4.197581 | 86.34424117 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3747 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g183 | i0 | 99.562 | 2.00145843461351 | 2057 | 8 | 100 | 1 | 1 | 2057 | 8695 | 6640 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 4117 | 3747 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 6588642 | 6588642 | PRJNA1097627_P_NODE_886_length_992_cov_2.684440_g660_i0 | PRJNA1097627 | 886 | 992 | 2.68444 | 26.6296448 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 1810 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g660 | i0 | 99.597 | 1 | 992 | 4 | 100 | 0 | 1 | 992 | 2064 | 1073 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 992 | 1810 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 10412914 | 10412914 | PRJNA1097627_P_NODE_67649_length_297_cov_3.218750_g67356_i0 | PRJNA1097627 | 67649 | 297 | 3.21875 | 9.5596875 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 549 | 8.029999999999997e-152 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g67356 | i0 | 100 | 1 | 297 | 0 | 100 | 0 | 1 | 297 | 513 | 809 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 297 | 549 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 11689600 | 11689600 | PRJNA1097627_P_NODE_95610_length_276_cov_1.753695_g95317_i0 | PRJNA1097627 | 95610 | 276 | 1.753695 | 4.8401982 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 483 | 7.589999999999998e-132 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g95317 | i0 | 98.188 | 1 | 276 | 5 | 100 | 0 | 1 | 276 | 6608 | 6333 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 276 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 15506957 | 15506957 | PRJNA1097627_P_NODE_145253_length_250_cov_0.870056_g144960_i0 | PRJNA1097627 | 145253 | 250 | 0.870056 | 2.17514 | Amaranthus caudatus fabavirus | 3090866 | Viruses | Viruses | 377 | 3.29e-100 | NTclustered | gi|2616762693|gb|OP783967.1| | 3090866 | g144960 | i0 | 93.976 | 2.988 | 249 | 15 | 99 | 0 | 1 | 249 | 4297 | 4545 | Amaranthus caudatus fabavirus isolate BJ-1 segment RNA1, complete sequence | blastn | 747 | 377 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Fabavirus | Amaranthus caudatus fabavirus | ||
| 16785023 | 16785023 | PRJNA1097627_P_NODE_334_length_1881_cov_3.530973_g215_i0 | PRJNA1097627 | 334 | 1881 | 3.530973 | 66.41760213 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3430 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g215 | i0 | 99.575 | 1 | 1881 | 8 | 100 | 0 | 1 | 1881 | 6319 | 4439 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 1881 | 3430 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 19332822 | 19332822 | PRJNA1097627_P_NODE_202876_length_241_cov_0.916667_g202583_i0 | PRJNA1097627 | 202876 | 241 | 0.916667 | 2.20916747 | Potyvirus sp. | 1955171 | Viruses | Viruses | 318 | 1.94e-82 | NTclustered | gi|2697177299|gb|OR867852.1| | 1955171 | g202583 | i0 | 100 | 24.9045643153527 | 172 | 0 | 71 | 0 | 64 | 235 | 1 | 172 | MAG: Potyvirus sp. isolate JTYGF13_16/282 genomic sequence | blastn | 6002 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sp. | ||
| 21884745 | 21884745 | PRJNA1097627_P_NODE_338_length_1862_cov_3.001118_g217_i0 | PRJNA1097627 | 338 | 1862 | 3.001118 | 55.88081716 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3422 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g217 | i0 | 99.839 | 1.0187969924812 | 1862 | 3 | 100 | 0 | 1 | 1862 | 4376 | 2515 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 1897 | 3422 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 23157590 | 23157590 | PRJNA1097627_P_NODE_167199_length_247_cov_0.867816_g166906_i0 | PRJNA1097627 | 167199 | 247 | 0.867816 | 2.14350552 | Potyvirus sp. | 1955171 | Viruses | Viruses | 431 | 2.45e-116 | NTclustered | gi|2697177301|gb|OR867853.1| | 1955171 | g166906 | i0 | 100 | 1.88259109311741 | 233 | 0 | 94 | 0 | 9 | 241 | 760 | 528 | MAG: Potyvirus sp. isolate JTYGF13_16/55 genomic sequence | blastn | 465 | 431 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sp. | ||
| 30130486 | 30130486 | PRJNA1097627_P_NODE_188132_length_243_cov_0.905882_g187839_i0 | PRJNA1097627 | 188132 | 243 | 0.905882 | 2.20129326 | Comovirinae sp. | 2767531 | Viruses | Viruses | 137 | 2.5799999999999996e-35 | NR | QNN26327.1 | 2767531 | g187839 | i0 | 92.5 | 0.987654320987654 | 80 | 6 | 98.8 | 0 | 242 | 3 | 23 | 102 | QNN26327.1 polyprotein 2 [Comovirinae sp.] | diamond | 240 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae sp. | |||
| 32122607 | 32122607 | PRJNA1097627_P_NODE_47598_length_320_cov_1.097166_g47306_i0 | PRJNA1097627 | 47598 | 320 | 1.097166 | 3.5109312 | Comovirinae sp. | 2767531 | Viruses | Viruses | 200 | 2.15e-57 | NR | QNN26327.1 | 2767531 | g47306 | i0 | 95.3 | 0.99375 | 106 | 5 | 99.4 | 0 | 318 | 1 | 101 | 206 | QNN26327.1 polyprotein 2 [Comovirinae sp.] | diamond | 318 | 200 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae 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);;