contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672563 | 672563 | PRJNA692200_S_NODE_1121_length_431_cov_320.225131_g1074_i0 | PRJNA692200 | 1121 | 431 | 320.225131 | 1380.17031461 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 132 | 5.19e-26 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g1074 | i0 | 96.296 | 1.19257540603248 | 81 | 1 | 18 | 1 | 27 | 105 | 40 | 120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 514 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5776004 | 5776004 | PRJNA692200_S_NODE_1005_length_441_cov_322.469388_g960_i0 | PRJNA692200 | 1005 | 441 | 322.469388 | 1422.09000108 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 132 | 5.32e-26 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g960 | i0 | 96.296 | 1.16553287981859 | 81 | 1 | 18 | 1 | 27 | 105 | 40 | 120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 514 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7051508 | 7051508 | PRJNA692200_S_NODE_4406_length_301_cov_1320.654762_g4349_i0 | PRJNA692200 | 4406 | 301 | 1320.654762 | 3975.17083362 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 71.3 | 7.73e-8 | NTclustered | gi|2165836883|emb|OV197187.1| | 2697049 | g4349 | i0 | 87.719 | 12.8073089700997 | 57 | 5 | 18 | 1 | 1 | 55 | 103 | 159 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3855 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7051532 | 7051532 | PRJNA692200_S_NODE_5126_length_286_cov_233.860759_g5069_i0 | PRJNA692200 | 5126 | 286 | 233.860759 | 668.84177074 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g5069 | i0 | 97.059 | 0.118881118881119 | 34 | 0 | 12 | 1 | 1 | 33 | 12995 | 13028 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 7557168 | 7557168 | PRJNA692200_S_NODE_20366_length_166_cov_0.888889_g20309_i0 | PRJNA692200 | 20366 | 166 | 0.888889 | 1.47555574 | Potyvirus | 12195 | Viruses | Viruses | 305 | 9.67e-79 | NTclustered | gi|157739355|gb|EU021065.1| | 12844 | g20309 | i0 | 100 | 99.3795180722892 | 165 | 0 | 99 | 0 | 2 | 166 | 1448 | 1284 | Sweet potato feathery mottle virus isolate Fio polyprotein gene, partial cds | blastn | 16497 | 305 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus batataplumei | ||
| 8325941 | 8325941 | PRJNA692200_S_NODE_2687_length_351_cov_980.519868_g2630_i0 | PRJNA692200 | 2687 | 351 | 980.519868 | 3441.62473668 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 137 | 8.9e-28 | NTclustered | gi|2165834303|emb|OV196009.1| | 2697049 | g2630 | i0 | 96.471 | 23.8461538461538 | 85 | 0 | 24 | 2 | 8 | 90 | 29995 | 29912 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8370 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8326111 | 8326111 | PRJNA692200_S_NODE_8127_length_242_cov_1733.860104_g8070_i0 | PRJNA692200 | 8127 | 242 | 1733.860104 | 4195.94145168 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 73.1 | 1.67e-8 | NTclustered | gi|2165836883|emb|OV197187.1| | 2697049 | g8070 | i0 | 87.931 | 15.9338842975207 | 58 | 5 | 23 | 1 | 187 | 242 | 160 | 103 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3856 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9601270 | 9601270 | PRJNA692200_S_NODE_2628_length_353_cov_984.404605_g2571_i0 | PRJNA692200 | 2628 | 353 | 984.404605 | 3474.94825565 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 137 | 8.959999999999999e-28 | NTclustered | gi|2165834303|emb|OV196009.1| | 2697049 | g2571 | i0 | 96.471 | 23.7110481586402 | 85 | 0 | 24 | 2 | 8 | 90 | 29995 | 29912 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8370 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12151779 | 12151779 | PRJNA692200_S_NODE_12770_length_201_cov_2.559211_g12713_i0 | PRJNA692200 | 12770 | 201 | 2.559211 | 5.14401411 | Mitovirus sp. | 2587224 | Viruses | Viruses | 89.8 | 1.33e-13 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g12713 | i0 | 98.039 | 0.253731343283582 | 51 | 1 | 25 | 0 | 149 | 199 | 111 | 61 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 51 | 89.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 12152099 | 12152099 | PRJNA692200_S_NODE_5090_length_287_cov_4.260504_g5033_i0 | PRJNA692200 | 5090 | 287 | 4.260504 | 12.22764648 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g5033 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 31 | 58 | 1596 | 1569 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13426585 | 13426585 | PRJNA692200_S_NODE_2731_length_349_cov_417.023333_g2674_i0 | PRJNA692200 | 2731 | 349 | 417.023333 | 1455.41143217 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 132 | 4.12e-26 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g2674 | i0 | 96.296 | 1.84240687679083 | 81 | 1 | 23 | 1 | 27 | 105 | 40 | 120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 643 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13426735 | 13426735 | PRJNA692200_S_NODE_7231_length_253_cov_270.774510_g7174_i0 | PRJNA692200 | 7231 | 253 | 270.77451 | 685.0595103 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g7174 | i0 | 97.059 | 0.134387351778656 | 34 | 0 | 13 | 1 | 1 | 33 | 12995 | 13028 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 15975608 | 15975608 | PRJNA692200_S_NODE_3953_length_312_cov_476.121673_g3896_i0 | PRJNA692200 | 3953 | 312 | 476.121673 | 1485.49961976 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 132 | 3.64e-26 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g3896 | i0 | 96.296 | 1.6474358974359 | 81 | 1 | 25 | 1 | 27 | 105 | 40 | 120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 514 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17250389 | 17250389 | PRJNA692200_S_NODE_10694_length_217_cov_2.773810_g10637_i0 | PRJNA692200 | 10694 | 217 | 2.77381 | 6.0191677 | Mimivirus LCMiAC01 | 2506608 | Viruses | Viruses | 75 | 4.09e-9 | NTclustered | gi|1588062284|gb|MK500402.1| | 2506608 | g10637 | i0 | 97.674 | 5.78801843317972 | 43 | 1 | 20 | 0 | 153 | 195 | 17130 | 17088 | MAG: Mimivirus LCMiAC01 genomic sequence | blastn | 1256 | 75 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC01 | |||
| 18524809 | 18524809 | PRJNA692200_S_NODE_2815_length_346_cov_449.451178_g2758_i0 | PRJNA692200 | 2815 | 346 | 449.451178 | 1555.10107588 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 132 | 4.09e-26 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g2758 | i0 | 96.296 | 1.48554913294798 | 81 | 1 | 23 | 1 | 27 | 105 | 40 | 120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 514 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18525001 | 18525001 | PRJNA692200_S_NODE_8495_length_238_cov_295.169312_g8438_i0 | PRJNA692200 | 8495 | 238 | 295.169312 | 702.50296256 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g8438 | i0 | 97.059 | 0.142857142857143 | 34 | 0 | 14 | 1 | 206 | 238 | 13028 | 12995 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 19799783 | 19799783 | PRJNA692200_S_NODE_4116_length_308_cov_217.069498_g4059_i0 | PRJNA692200 | 4116 | 308 | 217.069498 | 668.57405384 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g4059 | i0 | 97.059 | 0.11038961038961 | 34 | 0 | 11 | 1 | 1 | 33 | 12995 | 13028 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 19799801 | 19799801 | PRJNA692200_S_NODE_4496_length_299_cov_7.856000_g4439_i0 | PRJNA692200 | 4496 | 299 | 7.856 | 23.48944 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 538 | 1.7499999999999993e-148 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g4439 | i0 | 99.003 | 4.68896321070234 | 301 | 1 | 100 | 2 | 1 | 299 | 7932 | 8232 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1402 | 538 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 19799958 | 19799958 | PRJNA692200_S_NODE_9876_length_225_cov_1.494318_g9819_i0 | PRJNA692200 | 9876 | 225 | 1.494318 | 3.3622155 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g9819 | i0 | 94.286 | 0.155555555555556 | 35 | 1 | 15 | 1 | 96 | 129 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei |
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);;