contig_metadata
12 rows where bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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. | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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);;