contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452029 | 452029 | PRJNA492280_P_NODE_22521_length_164_cov_2.929134_g22414_i0 | PRJNA492280 | 22521 | 164 | 2.929134 | 4.80377976 | Totivirus sp. | 2776824 | Viruses | Viruses | 171 | 3.62e-38 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g22414 | i0 | 82.941 | 2.05487804878049 | 170 | 20 | 98 | 2 | 4 | 164 | 1028 | 859 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 337 | 171 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 452135 | 452135 | PRJNA492280_P_NODE_31521_length_151_cov_3.043860_g31414_i0 | PRJNA492280 | 31521 | 151 | 3.04386 | 4.5962286 | Ripathuj virus | 3131458 | Viruses | Viruses | 84.2 | 4.37e-12 | NTclustered | gi|2717322573|gb|PP173760.1| | 3131458 | g31414 | i0 | 92.982 | 0.814569536423841 | 57 | 4 | 80 | 0 | 76 | 132 | 413 | 469 | MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence | blastn | 123 | 84.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathuj virus | |||||
| 452230 | 452230 | PRJNA492280_P_NODE_8721_length_180_cov_5.538462_g8614_i0 | PRJNA492280 | 8721 | 180 | 5.538462 | 9.9692316 | Erysiphe necator associated partitivirus 2 | 2737084 | Viruses | Viruses | 99 | 1.93e-16 | NTclustered | gi|2273760843|gb|OL472009.1| | 2737084 | g8614 | i0 | 92.647 | 1.5 | 68 | 5 | 38 | 0 | 110 | 177 | 474 | 541 | MAG: Erysiphe necator associated partitivirus 2 isolate KOP19SW segment RNA2, complete sequence | blastn | 270 | 99 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Erysiphe necator associated partitivirus 2 | |||
| 1726635 | 1726635 | PRJNA492280_P_NODE_1462_length_365_cov_5.649390_g1359_i0 | PRJNA492280 | 1462 | 365 | 5.64939 | 20.6202735 | Cladosporium cladosporioides partitivirus 1 | 3036362 | Viruses | Viruses | 353 | 8.48e-93 | NTclustered | gi|2465372832|gb|OP946875.1| | 3036362 | g1359 | i0 | 90.58 | 18.0602739726027 | 276 | 12 | 96 | 1 | 4 | 279 | 484 | 745 | Cladosporium cladosporioides partitivirus 1 isolate AGS-CB3.2 segment RNA1, complete sequence | blastn | 6592 | 353 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Cladosporium cladosporioides partitivirus 1 | |||
| 3002607 | 3002607 | PRJNA492280_P_NODE_14283_length_164_cov_4.897638_g14176_i0 | PRJNA492280 | 14283 | 164 | 4.897638 | 8.03212632 | Erysiphe necator associated ourmia-like virus 87 | 2741867 | Viruses | Viruses | 115 | 1.72e-21 | NTclustered | gi|1848976707|gb|MN611615.1| | 2741867 | g14176 | i0 | 94.595 | 1.3109756097561 | 74 | 4 | 88 | 0 | 89 | 162 | 1702 | 1775 | Erysiphe necator associated ourmia-like virus 87 isolate PMS5_114, complete genome | blastn | 215 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 87 | ||
| 4279067 | 4279067 | PRJNA492280_P_NODE_27764_length_160_cov_4.715447_g27657_i0 | PRJNA492280 | 27764 | 160 | 4.715447 | 7.5447152 | Erysiphe necator associated ourmia-like virus 41 | 2741821 | Viruses | Viruses | 250 | 4.38e-62 | NTclustered | gi|2396039960|gb|ON812995.1| | 2741821 | g27657 | i0 | 96.078 | 2.775 | 153 | 6 | 96 | 0 | 5 | 157 | 682 | 530 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate TIGMIC_10, complete genome | blastn | 444 | 250 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 8105067 | 8105067 | PRJNA492280_P_NODE_20787_length_164_cov_3.204724_g20680_i0 | PRJNA492280 | 20787 | 164 | 3.204724 | 5.25574736 | Potexvirus pepini | 3433856 | Viruses | Viruses | 233 | 4.56e-57 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g20680 | i0 | 89.697 | 61.1524390243902 | 165 | 14 | 99 | 1 | 3 | 164 | 1163 | 1327 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 10029 | 233 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 8751773 | 8751773 | PRJNA492280_P_NODE_14787_length_164_cov_4.669291_g14680_i0 | PRJNA492280 | 14787 | 164 | 4.669291 | 7.65763724 | Potexvirus | 12176 | Viruses | Viruses | 224 | 2.74e-54 | NTclustered | gi|1830461434|gb|MT018444.1| | 112229 | g14680 | i0 | 89.157 | 56.2012195121951 | 166 | 12 | 98 | 2 | 2 | 161 | 3317 | 3152 | Pepino mosaic virus isolate Ah, complete genome | blastn | 9217 | 224 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11930723 | 11930723 | PRJNA492280_P_NODE_4690_length_234_cov_2.329949_g4583_i0 | PRJNA492280 | 4690 | 234 | 2.329949 | 5.45208066 | Erysiphe necator associated ourmia-like virus 41 | 2741821 | Viruses | Viruses | 372 | 1.42e-98 | NTclustered | gi|2396039960|gb|ON812995.1| | 2741821 | g4583 | i0 | 96.104 | 6.0042735042735 | 231 | 4 | 99 | 1 | 3 | 233 | 1980 | 2205 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate TIGMIC_10, complete genome | blastn | 1405 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 13205602 | 13205602 | PRJNA492280_P_NODE_12471_length_164_cov_6.464567_g12364_i0 | PRJNA492280 | 12471 | 164 | 6.464567 | 10.60188988 | Sapovirus sp. | 1906670 | Viruses | Viruses | 110 | 8.01e-20 | NTclustered | gi|2196304084|gb|MZ679047.1| | 1906670 | g12364 | i0 | 93.333 | 28.0792682926829 | 75 | 4 | 45 | 1 | 89 | 162 | 1461 | 1535 | MAG: Sapovirus sp. isolate R16-k141_22382 polyprotein gene, partial cds | blastn | 4605 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Sapovirus | Sapovirus sp. | ||
| 13205799 | 13205799 | PRJNA492280_P_NODE_31851_length_151_cov_2.684211_g31744_i0 | PRJNA492280 | 31851 | 151 | 2.684211 | 4.05315861 | Potexvirus pepini | 3433856 | Viruses | Viruses | 272 | 8.689999999999998e-69 | NTclustered | gi|429474440|gb|JX866668.1| | 112229 | g31744 | i0 | 100 | 85.8609271523179 | 147 | 0 | 97 | 0 | 2 | 148 | 3036 | 2890 | Pepino mosaic virus isolate VFTX12-16, complete genome | blastn | 12965 | 272 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 15754488 | 15754488 | PRJNA492280_P_NODE_13673_length_164_cov_5.251969_g13566_i0 | PRJNA492280 | 13673 | 164 | 5.251969 | 8.61322916 | Sopafab virus | 3131770 | Viruses | Viruses | 130 | 6.15e-26 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g13566 | i0 | 98.63 | 28.2560975609756 | 73 | 1 | 45 | 0 | 89 | 161 | 122 | 194 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 4634 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 16401440 | 16401440 | PRJNA492280_P_NODE_1813_length_335_cov_2.580537_g1706_i0 | PRJNA492280 | 1813 | 335 | 2.580537 | 8.64479895 | Viruses | 10239 | Viruses | Viruses | 60.2 | 1.89e-4 | NTclustered | gi|2167415105|tpg|BK059322.1| | 12271 | g1706 | i0 | 100 | 10.089552238806 | 32 | 0 | 10 | 0 | 185 | 216 | 3 | 34 | TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence | blastn | 3380 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus arabis | ||
| 20853802 | 20853802 | PRJNA492280_P_NODE_7757_length_189_cov_4.414474_g7650_i0 | PRJNA492280 | 7757 | 189 | 4.414474 | 8.34335586 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 182 | 1.98e-41 | NTclustered | gi|2500387314|ref|NC_077170.1| | 2741801 | g7650 | i0 | 99.01 | 1.71957671957672 | 101 | 1 | 53 | 0 | 1 | 101 | 1704 | 1604 | Erysiphe necator associated ourmia-like virus 21 isolate RDPM33, complete genome | blastn | 325 | 182 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 24051009 | 24051009 | PRJNA492280_P_NODE_8179_length_185_cov_3.317568_g8072_i0 | PRJNA492280 | 8179 | 185 | 3.317568 | 6.1375008 | Potexvirus | 12176 | Viruses | Viruses | 174 | 3.23e-39 | NTclustered | gi|1421680767|gb|MH550257.1| | 112229 | g8072 | i0 | 98.969 | 82.0324324324324 | 97 | 1 | 92 | 0 | 1 | 97 | 1410 | 1314 | Pepino mosaic virus isolate GR17-8b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 15176 | 174 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 24678028 | 24678028 | PRJNA492280_P_NODE_2520_length_294_cov_9.124514_g2413_i0 | PRJNA492280 | 2520 | 294 | 9.124514 | 26.82607116 | Chrocabarb virus | 3129305 | Viruses | Viruses | 255 | 1.94e-63 | NTclustered | gi|2717317232|gb|PP171753.1| | 3129305 | g2413 | i0 | 92.063 | 85.8605442176871 | 189 | 4 | 76 | 2 | 105 | 292 | 147 | 325 | MAG: Chrocabarb virus isolate CC1A_k141_102991 genomic sequence | blastn | 25243 | 255 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocabarb virus |
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);;