contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3590023 | 3590023 | PRJNA1166865_P_NODE_12643_length_600_cov_37.620493_g12409_i0 | PRJNA1166865 | 12643 | 600 | 37.620493 | 225.722958 | root | 1 | Root_unresolved | Root_unresolved | 1090 | 0 | NTclustered | gi|2288721861|gb|OP218818.1| | 10535 | g12409 | i0 | 100 | 98.8483333333333 | 590 | 0 | 98 | 0 | 1 | 590 | 2311 | 1722 | Unidentified adenovirus strain CHOP Ad5 | blastn | 59309 | 1090 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 3590109 | 3590109 | PRJNA1166865_P_NODE_663_length_1761_cov_47.666469_g622_i0 | PRJNA1166865 | 663 | 1761 | 47.666469 | 839.40651909 | root | 1 | Root_unresolved | Root_unresolved | 3234 | 0 | NTclustered | gi|2616465679|gb|OR735196.1| | 10515 | g622 | i0 | 99.83 | 99.9789892106757 | 1761 | 2 | 100 | 1 | 1 | 1761 | 4065 | 2306 | Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome | blastn | 176063 | 3253 | 0.994159237626806 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 5416656 | 5416656 | PRJNA1166865_P_NODE_70565_length_261_cov_1.601064_g70324_i0 | PRJNA1166865 | 70565 | 261 | 1.601064 | 4.17877704 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|1766756986|gb|MK684196.1| | 12224 | g70324 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 209 | 236 | 622 | 595 | Sugarcane mosaic virus isolate RwS17_002 polyprotein gene, partial cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 6142406 | 6142406 | PRJNA1166865_P_NODE_2085_length_1263_cov_6.807563_g1991_i0 | PRJNA1166865 | 2085 | 1263 | 6.807563 | 85.97952069 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2314 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g1991 | i0 | 99.762 | 84.507521773555 | 1263 | 1 | 100 | 1 | 1 | 1263 | 1776 | 3036 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 106733 | 2327 | 0.994413407821229 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6142515 | 6142515 | PRJNA1166865_P_NODE_805_length_1677_cov_51.791147_g622_i1 | PRJNA1166865 | 805 | 1677 | 51.791147 | 868.53753519 | root | 1 | Root_unresolved | Root_unresolved | 2217 | 0 | NTclustered | gi|2616465679|gb|OR735196.1| | 10515 | g622 | i1 | 99.917 | 99.933214072749 | 1203 | 1 | 100 | 0 | 475 | 1677 | 3508 | 2306 | Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome | blastn | 167588 | 2222 | 0.997749774977498 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 7417542 | 7417542 | PRJNA1166865_P_NODE_886_length_1631_cov_6.725289_g829_i0 | PRJNA1166865 | 886 | 1631 | 6.725289 | 109.68946359 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2979 | 0 | NTclustered | gi|146351838|gb|EF543648.1| | 149595 | g829 | i0 | 99.632 | 76.4794604537094 | 1631 | 6 | 100 | 0 | 1 | 1631 | 2 | 1632 | Canine parainfluenza virus strain FA nucleocapsid (N) gene, complete cds | blastn | 124738 | 2985 | 0.997989949748744 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 9241527 | 9241527 | PRJNA1166865_P_NODE_70808_length_260_cov_2.379679_g70567_i0 | PRJNA1166865 | 70808 | 260 | 2.379679 | 6.1871654 | Simplexvirus humanalpha1 | 3050292 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1407524148|gb|MG999872.1| | 10298 | g70567 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 93 | 121 | 130495 | 130523 | Human alphaherpesvirus 1 strain 2003-15756, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 11242846 | 11242846 | PRJNA1166865_P_NODE_2729_length_1148_cov_5.747907_g2618_i0 | PRJNA1166865 | 2729 | 1148 | 5.747907 | 65.98597236 | Paramyxoviridae | 11158 | Viruses | Viruses | 2104 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2618 | i0 | 99.739 | 68.9477351916376 | 1148 | 3 | 100 | 0 | 1 | 1148 | 2057 | 3204 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 79152 | 2115 | 0.994799054373522 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 18165039 | 18165039 | PRJNA1166865_P_NODE_63595_length_277_cov_2.142157_g63354_i0 | PRJNA1166865 | 63595 | 277 | 2.142157 | 5.93377489 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 67.6 | 9.1e-7 | NTclustered | gi|1971775256|gb|MW460245.1| | 2805747 | g63354 | i0 | 100 | 0.545126353790614 | 36 | 0 | 13 | 0 | 103 | 138 | 619 | 654 | Burkholderia phage BCSR5, complete genome | blastn | 151 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 21441593 | 21441593 | PRJNA1166865_P_NODE_737_length_1714_cov_4.862279_g690_i0 | PRJNA1166865 | 737 | 1714 | 4.862279 | 83.33946206 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3155 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g690 | i0 | 99.883 | 97.0933488914819 | 1714 | 2 | 100 | 0 | 1 | 1714 | 6203 | 4490 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 166418 | 3155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24539282 | 24539282 | PRJNA1166865_P_NODE_60520_length_284_cov_1.924171_g60279_i0 | PRJNA1166865 | 60520 | 284 | 1.924171 | 5.46464564 | Sinorhizobium phage StopSmel | 2981545 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2622989299|gb|OR786374.1| | 2981545 | g60279 | i0 | 96.875 | 0.112676056338028 | 32 | 1 | 11 | 0 | 201 | 232 | 26669 | 26700 | Sinorhizobium phage StopSmel, complete genome | blastn | 32 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sinorhizobium phage StopSmel |
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);;