contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 326992 | 326992 | PRJNA1200128_S_NODE_1941_length_474_cov_11469.538283_g1835_i0 | PRJNA1200128 | 1941 | 474 | 11469.538283 | 54365.61146142 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 119 | 4.4800000000000005e-22 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g1835 | i0 | 94.805 | 28.2552742616034 | 77 | 2 | 16 | 2 | 390 | 466 | 160 | 86 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 13393 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 1601687 | 1601687 | PRJNA1200128_S_NODE_11542_length_241_cov_6.393939_g11433_i0 | PRJNA1200128 | 11542 | 241 | 6.393939 | 15.40939299 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g11433 | i0 | 100 | 0.477178423236515 | 30 | 0 | 12 | 0 | 212 | 241 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 2877863 | 2877863 | PRJNA1200128_S_NODE_10563_length_248_cov_2.175610_g10454_i0 | PRJNA1200128 | 10563 | 248 | 2.17561 | 5.3955128 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g10454 | i0 | 96.97 | 0.245967741935484 | 33 | 0 | 13 | 1 | 217 | 248 | 38 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 5430205 | 5430205 | PRJNA1200128_S_NODE_24665_length_191_cov_0.952703_g24556_i0 | PRJNA1200128 | 24665 | 191 | 0.952703 | 1.81966273 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g24556 | i0 | 100 | 0.738219895287958 | 29 | 0 | 15 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5430274 | 5430274 | PRJNA1200128_S_NODE_4065_length_340_cov_3.286195_g3956_i0 | PRJNA1200128 | 4065 | 340 | 3.286195 | 11.173063 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g3956 | i0 | 100 | 0.338235294117647 | 30 | 0 | 9 | 0 | 1 | 30 | 56 | 85 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 5430306 | 5430306 | PRJNA1200128_S_NODE_4925_length_317_cov_1748.098540_g4816_i0 | PRJNA1200128 | 4925 | 317 | 1748.09854 | 5541.4723718 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 119 | 2.89e-22 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g4816 | i0 | 94.805 | 26.1261829652997 | 77 | 2 | 24 | 2 | 9 | 85 | 86 | 160 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8282 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6704828 | 6704828 | PRJNA1200128_S_NODE_25126_length_189_cov_6.102740_g25017_i0 | PRJNA1200128 | 25126 | 189 | 6.10274 | 11.5341786 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g25017 | i0 | 100 | 0.301587301587302 | 29 | 0 | 15 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 6704937 | 6704937 | PRJNA1200128_S_NODE_7686_length_274_cov_20455.783550_g7577_i0 | PRJNA1200128 | 7686 | 274 | 20455.78355 | 56048.846927 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.26e-24 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g7577 | i0 | 96.104 | 26.3649635036496 | 77 | 1 | 28 | 2 | 190 | 266 | 160 | 86 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7224 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9254957 | 9254957 | PRJNA1200128_S_NODE_12128_length_237_cov_24312.355670_g12019_i0 | PRJNA1200128 | 12128 | 237 | 24312.35567 | 57620.2829379 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 4.44e-24 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g12019 | i0 | 96.104 | 27.9620253164557 | 77 | 1 | 32 | 2 | 9 | 85 | 86 | 160 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 6627 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9972831 | 9972831 | PRJNA1200128_S_NODE_4788_length_320_cov_17934.873646_g4679_i0 | PRJNA1200128 | 4788 | 320 | 17934.873646 | 57391.5956672 | Viruses | 10239 | Viruses | Viruses | 119 | 2.92e-22 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g4679 | i0 | 94.805 | 23.425 | 77 | 2 | 24 | 2 | 236 | 312 | 160 | 86 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7496 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10530988 | 10530988 | PRJNA1200128_S_NODE_6209_length_293_cov_3.296000_g6100_i0 | PRJNA1200128 | 6209 | 293 | 3.296 | 9.65728 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g6100 | i0 | 100 | 0.197952218430034 | 30 | 0 | 10 | 0 | 1 | 30 | 6 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 11805557 | 11805557 | PRJNA1200128_S_NODE_11530_length_241_cov_8.277778_g11421_i0 | PRJNA1200128 | 11530 | 241 | 8.277778 | 19.94944498 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g11421 | i0 | 100 | 0.477178423236515 | 30 | 0 | 12 | 0 | 1 | 30 | 56 | 85 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 11805706 | 11805706 | PRJNA1200128_S_NODE_5010_length_315_cov_17308.573529_g4901_i0 | PRJNA1200128 | 5010 | 315 | 17308.573529 | 54522.00661635 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 6.159999999999999e-24 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g4901 | i0 | 96.104 | 26.3396825396825 | 77 | 1 | 24 | 2 | 9 | 85 | 86 | 160 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8297 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13080744 | 13080744 | PRJNA1200128_S_NODE_5491_length_306_cov_2.250951_g5382_i0 | PRJNA1200128 | 5491 | 306 | 2.250951 | 6.88791006 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g5382 | i0 | 100 | 0.186274509803922 | 29 | 0 | 9 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 13080751 | 13080751 | PRJNA1200128_S_NODE_6651_length_287_cov_2.315574_g6542_i0 | PRJNA1200128 | 6651 | 287 | 2.315574 | 6.64569738 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g6542 | i0 | 100 | 0.198606271777003 | 29 | 0 | 10 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 15629875 | 15629875 | PRJNA1200128_S_NODE_21353_length_200_cov_0.847134_g21244_i0 | PRJNA1200128 | 21353 | 200 | 0.847134 | 1.694268 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g21244 | i0 | 100 | 0.285 | 29 | 0 | 15 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 15630009 | 15630009 | PRJNA1200128_S_NODE_7933_length_272_cov_1.615721_g7824_i0 | PRJNA1200128 | 7933 | 272 | 1.615721 | 4.39476112 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g7824 | i0 | 96.97 | 0.224264705882353 | 33 | 1 | 12 | 0 | 1 | 33 | 6 | 38 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18178615 | 18178615 | PRJNA1200128_S_NODE_11535_length_241_cov_7.075758_g11426_i0 | PRJNA1200128 | 11535 | 241 | 7.075758 | 17.05257678 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g11426 | i0 | 100 | 0.477178423236515 | 30 | 0 | 12 | 0 | 212 | 241 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 20171004 | 20171004 | PRJNA1200128_S_NODE_9396_length_257_cov_18270.299065_g9287_i0 | PRJNA1200128 | 9396 | 257 | 18270.299065 | 46954.66859705 | Viruses | 10239 | Viruses | Viruses | 122 | 1.7599999999999994e-23 | NTclustered | gi|2165835030|emb|OV196298.1| | 2697049 | g9287 | i0 | 96.053 | 25.2645914396887 | 76 | 1 | 30 | 2 | 9 | 84 | 77 | 150 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 6493 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20728398 | 20728398 | PRJNA1200128_S_NODE_10637_length_247_cov_23118.078431_g10528_i0 | PRJNA1200128 | 10637 | 247 | 23118.078431 | 57101.65372457 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 4.66e-24 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g10528 | i0 | 96.104 | 33.6518218623482 | 77 | 1 | 31 | 2 | 9 | 85 | 86 | 160 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8312 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22003887 | 22003887 | PRJNA1200128_S_NODE_6518_length_288_cov_19295.224490_g6409_i0 | PRJNA1200128 | 6518 | 288 | 19295.22449 | 55570.2465312 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 124 | 5.57e-24 | NTclustered | gi|2165832904|emb|OV195202.1| | 2697049 | g6409 | i0 | 96.104 | 28.8333333333333 | 77 | 1 | 27 | 2 | 204 | 280 | 160 | 86 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8304 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23996784 | 23996784 | PRJNA1200128_S_NODE_13139_length_231_cov_21076.595745_g13030_i0 | PRJNA1200128 | 13139 | 231 | 21076.595745 | 48686.93617095 | Viruses | 10239 | Viruses | Viruses | 122 | 1.55e-23 | NTclustered | gi|2165835030|emb|OV196298.1| | 2697049 | g13030 | i0 | 96.053 | 28.0562770562771 | 76 | 1 | 35 | 2 | 9 | 84 | 77 | 150 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 6481 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24553243 | 24553243 | PRJNA1200128_S_NODE_5740_length_301_cov_2.968992_g5631_i0 | PRJNA1200128 | 5740 | 301 | 2.968992 | 8.93666592 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 60.2 | 1.67e-4 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g5631 | i0 | 97.222 | 0.461794019933555 | 36 | 0 | 12 | 1 | 1 | 36 | 51 | 85 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 139 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 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);;