contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655449 | 1655449 | PRJNA315314_S_NODE_13202_length_224_cov_4.230769_g12881_i0 | PRJNA315314 | 13202 | 224 | 4.230769 | 9.47692256 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2557638132|emb|OY695180.1| | 2697049 | g12881 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 1 | 28 | 20057 | 20030 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2931312 | 2931312 | PRJNA315314_S_NODE_13283_length_223_cov_3938.922680_g12962_i0 | PRJNA315314 | 13283 | 223 | 3938.92268 | 8783.7975764 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 71.3 | 5.47e-8 | NTclustered | gi|2557654415|emb|OY684664.1| | 2697049 | g12962 | i0 | 100 | 19.3004484304933 | 38 | 0 | 17 | 0 | 186 | 223 | 21929 | 21966 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4304 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2931639 | 2931639 | PRJNA315314_S_NODE_4423_length_380_cov_138.470085_g4102_i0 | PRJNA315314 | 4423 | 380 | 138.470085 | 526.186323 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 1.27e-21 | NTclustered | gi|2165835007|emb|OV196275.1| | 2697049 | g4102 | i0 | 94.805 | 11.6078947368421 | 77 | 1 | 19 | 2 | 21 | 94 | 121 | 197 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4411 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4207887 | 4207887 | PRJNA315314_S_NODE_14484_length_214_cov_4042.210811_g14163_i0 | PRJNA315314 | 14484 | 214 | 4042.210811 | 8650.33113554 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 73.1 | 1.45e-8 | NTclustered | gi|2557654279|emb|OY684629.1| | 2697049 | g14163 | i0 | 100 | 20.1355140186916 | 39 | 0 | 18 | 0 | 1 | 39 | 26153 | 26115 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4309 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4207987 | 4207987 | PRJNA315314_S_NODE_19804_length_185_cov_4818.333333_g19483_i0 | PRJNA315314 | 19804 | 185 | 4818.333333 | 8913.91666605 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 1.57e-7 | NTclustered | gi|2565365187|emb|OY637518.1| | 2697049 | g19483 | i0 | 100 | 23.2 | 37 | 0 | 20 | 0 | 1 | 37 | 11670 | 11634 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4292 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5484227 | 5484227 | PRJNA315314_S_NODE_1705_length_596_cov_109.925926_g1366_i1 | PRJNA315314 | 1705 | 596 | 109.925926 | 655.15851896 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 2.06e-21 | NTclustered | gi|2165835007|emb|OV196275.1| | 2697049 | g1366 | i1 | 94.805 | 7.05872483221477 | 77 | 1 | 12 | 2 | 21 | 94 | 121 | 197 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4207 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5484430 | 5484430 | PRJNA315314_S_NODE_30265_length_154_cov_3.304000_g29944_i0 | PRJNA315314 | 30265 | 154 | 3.304 | 5.08816 | Ripothoz virus | 3131336 | Viruses | Viruses | 62.1 | 2.1e-5 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g29944 | i0 | 97.222 | 0.233766233766234 | 36 | 1 | 23 | 0 | 80 | 115 | 5236 | 5201 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 36 | 62.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 7443247 | 7443247 | PRJNA315314_S_NODE_3046_length_454_cov_1564.717647_g2728_i0 | PRJNA315314 | 3046 | 454 | 1564.717647 | 7103.81811738 | Pisoniviricetes | 2732506 | Viruses | Viruses | 69.4 | 4.37e-7 | NTclustered | gi|2167415105|tpg|BK059322.1| | 12271 | g2728 | i0 | 100 | 8.85462555066079 | 37 | 0 | 8 | 0 | 1 | 37 | 6 | 42 | TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence | blastn | 4020 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus arabis | ||
| 8033995 | 8033995 | PRJNA315314_S_NODE_1627_length_608_cov_111.143351_g1366_i0 | PRJNA315314 | 1627 | 608 | 111.143351 | 675.75157408 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 2.11e-21 | NTclustered | gi|2165835007|emb|OV196275.1| | 2697049 | g1366 | i0 | 94.805 | 6.91940789473684 | 77 | 1 | 12 | 2 | 515 | 588 | 197 | 121 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4207 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10584848 | 10584848 | PRJNA315314_S_NODE_4729_length_368_cov_2248.592920_g4408_i0 | PRJNA315314 | 4729 | 368 | 2248.59292 | 8274.8219456 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 71.3 | 9.65e-8 | NTclustered | gi|2557652486|emb|OY682391.1| | 2697049 | g4408 | i0 | 100 | 11.7771739130435 | 38 | 0 | 11 | 0 | 1 | 38 | 11279 | 11242 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4334 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10584920 | 10584920 | PRJNA315314_S_NODE_7869_length_287_cov_2926.693798_g7548_i0 | PRJNA315314 | 7869 | 287 | 2926.693798 | 8399.61120026 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 71.3 | 7.33e-8 | NTclustered | gi|2557652486|emb|OY682391.1| | 2697049 | g7548 | i0 | 100 | 14.9059233449477 | 38 | 0 | 13 | 0 | 250 | 287 | 11242 | 11279 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4278 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11859468 | 11859468 | PRJNA315314_S_NODE_2030_length_547_cov_1407.843629_g1747_i0 | PRJNA315314 | 2030 | 547 | 1407.843629 | 7700.90465063 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 5.34e-7 | NTclustered | gi|2557641183|emb|OY671812.1| | 2697049 | g1747 | i0 | 97.5 | 7.72577696526508 | 40 | 1 | 7 | 0 | 1 | 40 | 16459 | 16420 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4226 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12543885 | 12543885 | PRJNA315314_S_NODE_7490_length_294_cov_2820.233962_g7169_i0 | PRJNA315314 | 7490 | 294 | 2820.233962 | 8291.48784828 | Viruses | 10239 | Viruses | Viruses | 71.3 | 7.53e-8 | NTclustered | gi|2557389902|emb|OY653400.1| | 2697049 | g7169 | i0 | 100 | 14.7755102040816 | 38 | 0 | 13 | 0 | 257 | 294 | 19645 | 19682 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4344 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15683268 | 15683268 | PRJNA315314_S_NODE_10533_length_249_cov_3422.527273_g10212_i0 | PRJNA315314 | 10533 | 249 | 3422.527273 | 8522.09290977 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 2.24e-7 | NTclustered | gi|2565365187|emb|OY637518.1| | 2697049 | g10212 | i0 | 100 | 17.6506024096386 | 37 | 0 | 15 | 0 | 213 | 249 | 11634 | 11670 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4395 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16367784 | 16367784 | PRJNA315314_S_NODE_14053_length_217_cov_3948.760638_g13732_i0 | PRJNA315314 | 14053 | 217 | 3948.760638 | 8568.81058446 | Viruses | 10239 | Viruses | Viruses | 71.3 | 5.29e-8 | NTclustered | gi|2557389902|emb|OY653400.1| | 2697049 | g13732 | i0 | 100 | 20.0230414746544 | 38 | 0 | 18 | 0 | 1 | 38 | 19682 | 19645 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4345 | 71.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16958429 | 16958429 | PRJNA315314_S_NODE_5874_length_332_cov_2469.039604_g5553_i0 | PRJNA315314 | 5874 | 332 | 2469.039604 | 8197.21148528 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 75 | 6.67e-9 | NTclustered | gi|2174999023|emb|OV377758.1| | 2697049 | g5553 | i0 | 100 | 13.0632530120482 | 40 | 0 | 12 | 0 | 293 | 332 | 129 | 90 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4337 | 75 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20782370 | 20782370 | PRJNA315314_S_NODE_23717_length_171_cov_6.267606_g23396_i0 | PRJNA315314 | 23717 | 171 | 6.267606 | 10.71760626 | Sopafab virus | 3131770 | Viruses | Viruses | 119 | 1.39e-22 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g23396 | i0 | 79.891 | 46.6432748538012 | 184 | 20 | 98 | 11 | 4 | 171 | 310 | 128 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 7976 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 22057559 | 22057559 | PRJNA315314_S_NODE_7498_length_294_cov_37.449057_g7177_i0 | PRJNA315314 | 7498 | 294 | 37.449057 | 110.10022758 | Chrocagost virus | 3129398 | Viruses | Viruses | 244 | 4.1899999999999996e-60 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g7177 | i0 | 88.235 | 156.666666666667 | 204 | 24 | 69 | 0 | 7 | 210 | 5659 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 46060 | 244 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 24607086 | 24607086 | PRJNA315314_S_NODE_3560_length_422_cov_1851.017812_g3240_i0 | PRJNA315314 | 3560 | 422 | 1851.017812 | 7811.29516664 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 4.04e-7 | NTclustered | gi|2565352131|emb|OY625234.1| | 2697049 | g3240 | i0 | 100 | 9.91232227488152 | 37 | 0 | 9 | 0 | 1 | 37 | 23719 | 23683 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4183 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24607197 | 24607197 | PRJNA315314_S_NODE_8500_length_277_cov_185.935484_g8179_i0 | PRJNA315314 | 8500 | 277 | 185.935484 | 515.04129068 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 8.91e-22 | NTclustered | gi|2165835007|emb|OV196275.1| | 2697049 | g8179 | i0 | 94.805 | 15.8050541516245 | 77 | 1 | 27 | 2 | 21 | 94 | 121 | 197 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4378 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24607216 | 24607216 | PRJNA315314_S_NODE_9220_length_266_cov_2991.050633_g8899_i0 | PRJNA315314 | 9220 | 266 | 2991.050633 | 7956.19468378 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 2.42e-7 | NTclustered | gi|2557639802|emb|OY695838.1| | 2697049 | g8899 | i0 | 97.5 | 15.4548872180451 | 40 | 1 | 15 | 0 | 227 | 266 | 4716 | 4755 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4111 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum |
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);;