contig_metadata
9 rows where bioproject = "PRJNA896554" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3421246 | 3421246 | PRJNA896554_P_NODE_151443_length_250_cov_3.180791_g143903_i0 | PRJNA896554 | 151443 | 250 | 3.180791 | 7.9519775 | Respirovirus muris | 3052731 | Viruses | Viruses | 436 | 5.349999999999999e-118 | NTclustered | gi|152002452|dbj|AB275416.1| | 3052731 | g143903 | i0 | 99.177 | 49.524 | 243 | 1 | 97 | 1 | 9 | 250 | 3971 | 3729 | Respirovirus muris genomic RNA, complete genome, strain: Cl. 151 | blastn | 12381 | 436 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus muris | ||
| 3422113 | 3422113 | PRJNA896554_P_NODE_343_length_7208_cov_32.789488_g264_i0 | PRJNA896554 | 343 | 7208 | 32.789488 | 2363.46629504 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2471 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g264 | i0 | 91.699 | 0.649833518312986 | 1783 | 143 | 65 | 5 | 8 | 1788 | 7108 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4684 | 2471 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 7247621 | 7247621 | PRJNA896554_P_NODE_107766_length_314_cov_0.958506_g100226_i0 | PRJNA896554 | 107766 | 314 | 0.958506 | 3.00970884 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 569 | 6.559999999999998e-158 | NTclustered | gi|301171118|dbj|AB196001.1| | 12183 | g100226 | i0 | 99.363 | 99.9140127388535 | 314 | 2 | 100 | 0 | 1 | 314 | 3926 | 3613 | Potato virus X genomic RNA, complete genome, strain: TO | blastn | 31373 | 569 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati | ||
| 7249626 | 7249626 | PRJNA896554_P_NODE_42906_length_814_cov_1.217274_g35756_i0 | PRJNA896554 | 42906 | 814 | 1.217274 | 9.90861036 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 1432 | 0 | NTclustered | gi|2025365930|gb|MT752834.1| | 12183 | g35756 | i0 | 98.403 | 99.9963144963145 | 814 | 13 | 100 | 0 | 1 | 814 | 2662 | 1849 | Potato virus X isolate Jin119, complete genome | blastn | 81397 | 1432 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati | ||
| 7250137 | 7250137 | PRJNA896554_P_NODE_68306_length_467_cov_2.096447_g60766_i0 | PRJNA896554 | 68306 | 467 | 2.096447 | 9.79040749 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 841 | 0 | NTclustered | gi|1620027|dbj|D87962.1| | 12183 | g60766 | i0 | 99.143 | 100.267665952891 | 467 | 4 | 100 | 0 | 1 | 467 | 150 | 616 | Potato virus X mRNA for 12kDa nonstructural protein, 8kDa nonstructural protein, coat protein, complete cds | blastn | 46825 | 841 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati | ||
| 12723196 | 12723196 | PRJNA896554_P_NODE_111090_length_307_cov_1.594017_g103550_i0 | PRJNA896554 | 111090 | 307 | 1.594017 | 4.89363219 | Tobamovirus | 12234 | Viruses | Viruses | 568 | 2.3e-157 | NTclustered | gi|1540839158|gb|MK133093.1| | 1761477 | g103550 | i0 | 100 | 100 | 307 | 0 | 100 | 0 | 1 | 307 | 336 | 30 | Tomato brown rugose fruit virus isolate TBRFV-P12-3G, complete genome | blastn | 30700 | 568 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 14899847 | 14899847 | PRJNA896554_P_NODE_63892_length_502_cov_1.939394_g56358_i0 | PRJNA896554 | 63892 | 502 | 1.939394 | 9.73575788 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 883 | 0 | NTclustered | gi|1315193312|gb|MF682527.1| | 12183 | g56358 | i0 | 98.406 | 100.962151394422 | 502 | 8 | 100 | 0 | 1 | 502 | 5480 | 5981 | Potato virus X isolate PVX_Tn147, complete genome | blastn | 50683 | 883 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati | ||
| 16172343 | 16172343 | PRJNA896554_P_NODE_114193_length_301_cov_1.631579_g106653_i0 | PRJNA896554 | 114193 | 301 | 1.631579 | 4.91105279 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 540 | 4.899999999999999e-149 | NTclustered | gi|2025365930|gb|MT752834.1| | 12183 | g106653 | i0 | 99.003 | 99.9601328903654 | 301 | 3 | 100 | 0 | 1 | 301 | 4595 | 4895 | Potato virus X isolate Jin119, complete genome | blastn | 30088 | 540 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati | ||
| 21273947 | 21273947 | PRJNA896554_P_NODE_69397_length_460_cov_1.643411_g61857_i0 | PRJNA896554 | 69397 | 460 | 1.643411 | 7.5596906 | Potexvirus ecspotati | 3433837 | Viruses | Viruses | 815 | 0 | NTclustered | gi|2025365630|gb|MT752784.1| | 12183 | g61857 | i0 | 98.693 | 99.8739130434783 | 459 | 6 | 99 | 0 | 2 | 460 | 3551 | 3093 | Potato virus X isolate Ica098-2, complete genome | blastn | 45942 | 815 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecspotati |
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);;