contig_metadata
12 rows where bioproject = "PRJNA812001", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3361964 | 3361964 | PRJNA812001_P_NODE_9483_length_508_cov_1.593103_g9237_i0 | PRJNA812001 | 9483 | 508 | 1.593103 | 8.09296324 | Alphafusarivirus fusarii | 2955263 | Viruses | Viruses | 887 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g9237 | i0 | 98.225 | 6.66338582677165 | 507 | 9 | 99 | 0 | 2 | 508 | 2174 | 1668 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 3385 | 887 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 3776409 | 3776409 | PRJNA812001_P_NODE_743_length_1549_cov_2.595528_g647_i0 | PRJNA812001 | 743 | 1549 | 2.595528 | 40.20472872 | Alphafusarivirus | 2946790 | Viruses | Viruses | 2772 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g647 | i0 | 98.967 | 6.14267269205939 | 1549 | 16 | 100 | 0 | 1 | 1549 | 3991 | 2443 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 9515 | 2772 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 11014680 | 11014680 | PRJNA812001_P_NODE_47649_length_293_cov_9.000000_g47403_i0 | PRJNA812001 | 47649 | 293 | 9 | 26.37 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g47403 | i0 | 100 | 0.194539249146758 | 29 | 0 | 10 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 16527270 | 16527270 | PRJNA812001_P_NODE_8293_length_540_cov_1.800857_g8048_i0 | PRJNA812001 | 8293 | 540 | 1.800857 | 9.7246278 | Alphafusarivirus | 2946790 | Viruses | Viruses | 965 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g8048 | i0 | 98.889 | 5 | 540 | 6 | 100 | 0 | 1 | 540 | 1253 | 714 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 2700 | 970 | 0.994845360824742 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 18661989 | 18661989 | PRJNA812001_P_NODE_25075_length_353_cov_1.650000_g24829_i0 | PRJNA812001 | 25075 | 353 | 1.65 | 5.8245 | Fusarium pseudograminearum fusarivirus 1 | 3036235 | Viruses | Viruses | 647 | 0 | NTclustered | gi|2463884872|gb|OP100308.1| | 3036235 | g24829 | i0 | 99.717 | 7 | 353 | 1 | 100 | 0 | 1 | 353 | 1631 | 1279 | Fusarium pseudograminearum fusarivirus 1 isolate ZZ-1, complete genome | blastn | 2471 | 647 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Fusarium pseudograminearum fusarivirus 1 | |||
| 18662255 | 18662255 | PRJNA812001_P_NODE_51255_length_287_cov_5.294393_g51009_i0 | PRJNA812001 | 51255 | 287 | 5.294393 | 15.19490791 | Skokie picorna-like virus | 2789431 | Viruses | Viruses | 414 | 2.94e-111 | NTclustered | gi|1935607038|gb|MT747994.1| | 2789431 | g51009 | i0 | 92.683 | 3.07665505226481 | 287 | 21 | 100 | 0 | 1 | 287 | 8110 | 7824 | Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds | blastn | 883 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Skokie picorna-like virus | ||||
| 19937671 | 19937671 | PRJNA812001_P_NODE_8376_length_537_cov_4.818966_g8131_i0 | PRJNA812001 | 8376 | 537 | 4.818966 | 25.87784742 | Skokie picorna-like virus | 2789431 | Viruses | Viruses | 383 | 1.6499999999999996e-101 | NTclustered | gi|1935607038|gb|MT747994.1| | 2789431 | g8131 | i0 | 89.216 | 1.70763500931099 | 306 | 33 | 57 | 0 | 232 | 537 | 8356 | 8051 | Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds | blastn | 917 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Skokie picorna-like virus | ||||
| 21212668 | 21212668 | PRJNA812001_P_NODE_28297_length_341_cov_2.317164_g28051_i0 | PRJNA812001 | 28297 | 341 | 2.317164 | 7.90152924 | Alphafusarivirus fusarii | 2955263 | Viruses | Viruses | 608 | 1.5199999999999993e-169 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g28051 | i0 | 98.827 | 5.99706744868035 | 341 | 4 | 100 | 0 | 1 | 341 | 4355 | 4015 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 2045 | 608 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 22487361 | 22487361 | PRJNA812001_P_NODE_2698_length_921_cov_2.498821_g2496_i0 | PRJNA812001 | 2698 | 921 | 2.498821 | 23.01414141 | Carpotroche-associated picornavirus | 2975512 | Viruses | Viruses | 1435 | 0 | NTclustered | gi|2292905076|gb|OL964097.1| | 2975512 | g2496 | i0 | 94.788 | 2.98479913137894 | 921 | 48 | 100 | 0 | 1 | 921 | 7845 | 6925 | Carpotroche-associated picornavirus polyprotein gene, complete cds | blastn | 2749 | 1435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Carpotroche-associated picornavirus | |||
| 23763072 | 23763072 | PRJNA812001_P_NODE_24619_length_355_cov_2.631206_g24373_i0 | PRJNA812001 | 24619 | 355 | 2.631206 | 9.3407813 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g24373 | i0 | 100 | 0.0788732394366197 | 28 | 0 | 8 | 0 | 328 | 355 | 41 | 14 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 24176001 | 24176001 | PRJNA812001_P_NODE_219_length_2271_cov_4.098726_g168_i0 | PRJNA812001 | 219 | 2271 | 4.098726 | 93.08206746 | Alphafusarivirus | 2946790 | Viruses | Viruses | 4082 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g168 | i0 | 99.119 | 6.35094671950683 | 2271 | 19 | 99 | 1 | 1 | 2270 | 4346 | 6616 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 14423 | 4082 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 25451162 | 25451162 | PRJNA812001_P_NODE_7660_length_560_cov_2.322382_g7415_i0 | PRJNA812001 | 7660 | 560 | 2.322382 | 13.0053392 | Alphafusarivirus | 2946790 | Viruses | Viruses | 1018 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g7415 | i0 | 99.464 | 5.95535714285714 | 560 | 3 | 100 | 0 | 1 | 560 | 598 | 39 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 3335 | 1018 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii |
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);;