contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJEB9859" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3971189 | 3971189 | PRJEB9859_P_NODE_2064_length_316_cov_4279.383275_g2029_i0 | PRJEB9859 | 2064 | 316 | 4279.383275 | 13522.851149 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 82.4 | 3.77e-11 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g2029 | i0 | 92.982 | 11.4841772151899 | 57 | 2 | 17 | 2 | 232 | 286 | 29964 | 29908 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3629 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5247728 | 5247728 | PRJEB9859_P_NODE_4945_length_245_cov_13167.888889_g4910_i0 | PRJEB9859 | 4945 | 245 | 13167.888889 | 32261.32777805 | Respirovirus laryngotracheitidis | 3049952 | Viruses | Viruses | 67.6 | 7.9e-7 | NTclustered | gi|1832329193|gb|MT232426.1| | 12730 | g4910 | i0 | 97.436 | 15.4081632653061 | 39 | 1 | 16 | 0 | 173 | 211 | 3 | 41 | MAG: Human respirovirus 1 isolate 2019AZ, complete genome | blastn | 3775 | 67.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 5247777 | 5247777 | PRJEB9859_P_NODE_85_length_811_cov_37.657289_g79_i0 | PRJEB9859 | 85 | 811 | 37.657289 | 305.40061379 | Nilaparvata lugens C virus | 1577072 | Viruses | Viruses | 122 | 6.12e-23 | NTclustered | gi|726973360|gb|KM270560.1| | 1577072 | g79 | i0 | 86.207 | 2.1035758323058 | 116 | 12 | 14 | 3 | 698 | 809 | 9048 | 9163 | Nilaparvata lugens C virus, complete genome | blastn | 1706 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Nilaparvata lugens C virus | ||
| 6523231 | 6523231 | PRJEB9859_P_NODE_2086_length_315_cov_4209.076923_g2051_i0 | PRJEB9859 | 2086 | 315 | 4209.076923 | 13258.59230745 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 82.4 | 3.76e-11 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g2051 | i0 | 96.078 | 11.7904761904762 | 51 | 1 | 16 | 1 | 232 | 281 | 29964 | 29914 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3714 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7797440 | 7797440 | PRJEB9859_P_NODE_4047_length_254_cov_1.217778_g4012_i0 | PRJEB9859 | 4047 | 254 | 1.217778 | 3.09315612 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 233 | 7.669999999999999e-57 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g4012 | i0 | 98.485 | 0.519685039370079 | 132 | 2 | 52 | 0 | 123 | 254 | 600 | 469 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 132 | 233 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 8652165 | 8652165 | PRJEB9859_P_NODE_4107_length_252_cov_12471.201794_g4072_i0 | PRJEB9859 | 4107 | 252 | 12471.201794 | 31427.42852088 | Viruses | 10239 | Viruses | Viruses | 67.6 | 8.16e-7 | NTclustered | gi|2557634435|emb|OY691424.1| | 2697049 | g4072 | i0 | 100 | 15.9166666666667 | 36 | 0 | 14 | 0 | 45 | 80 | 7555 | 7590 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4011 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8652173 | 8652173 | PRJEB9859_P_NODE_5827_length_240_cov_13491.246445_g5792_i0 | PRJEB9859 | 5827 | 240 | 13491.246445 | 32378.991468 | Viruses | 10239 | Viruses | Viruses | 67.6 | 7.71e-7 | NTclustered | gi|2557646933|emb|OY676332.1| | 2697049 | g5792 | i0 | 97.5 | 16.7208333333333 | 40 | 0 | 17 | 1 | 29 | 68 | 17603 | 17641 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4013 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9072350 | 9072350 | PRJEB9859_P_NODE_1828_length_328_cov_4263.538462_g1793_i0 | PRJEB9859 | 1828 | 328 | 4263.538462 | 13984.40615536 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 80.5 | 1.42e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1793 | i0 | 96 | 11.4878048780488 | 50 | 1 | 15 | 1 | 49 | 97 | 29915 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3768 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9072378 | 9072378 | PRJEB9859_P_NODE_3008_length_281_cov_11190.285714_g2973_i0 | PRJEB9859 | 3008 | 281 | 11190.285714 | 31444.70285634 | Narnavirus sp. | 2587225 | Viruses | Viruses | 67.6 | 9.25e-7 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g2973 | i0 | 97.5 | 13.6334519572954 | 40 | 0 | 14 | 1 | 70 | 109 | 1072 | 1110 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3831 | 67.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 10348058 | 10348058 | PRJEB9859_P_NODE_5829_length_240_cov_12923.151659_g5794_i0 | PRJEB9859 | 5829 | 240 | 12923.151659 | 31015.5639816 | Narnavirus sp. | 2587225 | Viruses | Viruses | 69.4 | 2.14e-7 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g5794 | i0 | 100 | 16.025 | 37 | 0 | 15 | 0 | 32 | 68 | 78 | 42 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3846 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 10348071 | 10348071 | PRJEB9859_P_NODE_6769_length_217_cov_1694.420213_g6734_i0 | PRJEB9859 | 6769 | 217 | 1694.420213 | 3676.89186221 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 73.1 | 1.47e-8 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g6734 | i0 | 94 | 15.5760368663594 | 50 | 0 | 22 | 2 | 75 | 121 | 29911 | 29960 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3380 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12477920 | 12477920 | PRJEB9859_P_NODE_3130_length_277_cov_11444.141129_g3095_i0 | PRJEB9859 | 3130 | 277 | 11444.141129 | 31700.27092733 | Viruses | 10239 | Viruses | Viruses | 65.8 | 3.27e-6 | NTclustered | gi|2557646933|emb|OY676332.1| | 2697049 | g3095 | i0 | 97.436 | 14.5595667870036 | 39 | 0 | 14 | 1 | 173 | 210 | 17641 | 17603 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4033 | 65.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14173501 | 14173501 | PRJEB9859_P_NODE_1252_length_368_cov_3686.058997_g1218_i0 | PRJEB9859 | 1252 | 368 | 3686.058997 | 13564.69710896 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 80.5 | 1.6e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1218 | i0 | 96 | 9.94565217391304 | 50 | 1 | 13 | 1 | 232 | 280 | 29964 | 29915 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3660 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14173517 | 14173517 | PRJEB9859_P_NODE_2012_length_318_cov_4306.297578_g1977_i0 | PRJEB9859 | 2012 | 318 | 4306.297578 | 13694.02629804 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 4.92e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1977 | i0 | 95.918 | 11.0283018867925 | 49 | 1 | 15 | 1 | 40 | 87 | 29916 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3507 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15447627 | 15447627 | PRJEB9859_P_NODE_2013_length_318_cov_4177.031142_g1978_i0 | PRJEB9859 | 2013 | 318 | 4177.031142 | 13282.95903156 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 84.2 | 1.06e-11 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1978 | i0 | 94.545 | 12.7264150943396 | 55 | 2 | 17 | 1 | 34 | 87 | 29910 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 4047 | 84.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15447639 | 15447639 | PRJEB9859_P_NODE_2793_length_288_cov_4712.413127_g2758_i0 | PRJEB9859 | 2793 | 288 | 4712.413127 | 13571.74980576 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 80.5 | 1.22e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g2758 | i0 | 96 | 13.2291666666667 | 50 | 1 | 17 | 1 | 9 | 57 | 29915 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3810 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16721759 | 16721759 | PRJEB9859_P_NODE_2014_length_318_cov_4141.653979_g1979_i0 | PRJEB9859 | 2014 | 318 | 4141.653979 | 13170.45965322 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 4.92e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1979 | i0 | 95.918 | 11.6320754716981 | 49 | 1 | 15 | 1 | 232 | 279 | 29964 | 29916 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3699 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16721827 | 16721827 | PRJEB9859_P_NODE_6074_length_233_cov_994.093137_g6039_i0 | PRJEB9859 | 6074 | 233 | 994.093137 | 2316.23700921 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 76.8 | 1.24e-9 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g6039 | i0 | 95.833 | 14.68669527897 | 48 | 1 | 20 | 1 | 172 | 218 | 29916 | 29963 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3422 | 76.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 16721830 | 16721830 | PRJEB9859_P_NODE_6254_length_228_cov_12429.467337_g6219_i0 | PRJEB9859 | 6254 | 228 | 12429.467337 | 28339.18552836 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 3.35e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g6219 | i0 | 94.118 | 16.8201754385965 | 51 | 3 | 22 | 0 | 69 | 119 | 29914 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3835 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17996679 | 17996679 | PRJEB9859_P_NODE_5655_length_241_cov_13280.632075_g5620_i0 | PRJEB9859 | 5655 | 241 | 13280.632075 | 32006.32330075 | Narnavirus sp. | 2587225 | Viruses | Viruses | 69.4 | 2.15e-7 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g5620 | i0 | 100 | 15.8589211618257 | 37 | 0 | 15 | 0 | 173 | 209 | 1110 | 1074 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3822 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 19270480 | 19270480 | PRJEB9859_P_NODE_3096_length_278_cov_872.795181_g3061_i0 | PRJEB9859 | 3096 | 278 | 872.795181 | 2426.37060318 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 76.8 | 1.52e-9 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g3061 | i0 | 95.833 | 11.6007194244604 | 48 | 1 | 17 | 1 | 217 | 263 | 29916 | 29963 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3225 | 76.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20125561 | 20125561 | PRJEB9859_P_NODE_5456_length_242_cov_13063.751174_g5421_i0 | PRJEB9859 | 5456 | 242 | 13063.751174 | 31614.27784108 | Viruses | 10239 | Viruses | Viruses | 67.6 | 7.78e-7 | NTclustered | gi|2557657929|emb|OY694257.1| | 2697049 | g5421 | i0 | 100 | 16.8223140495868 | 36 | 0 | 15 | 0 | 35 | 70 | 22476 | 22511 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4071 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20125564 | 20125564 | PRJEB9859_P_NODE_5656_length_241_cov_13236.613208_g5621_i0 | PRJEB9859 | 5656 | 241 | 13236.613208 | 31900.23783128 | Viruses | 10239 | Viruses | Viruses | 67.6 | 7.75e-7 | NTclustered | gi|2565351231|emb|OY624745.1| | 2697049 | g5621 | i0 | 100 | 16.0290456431535 | 36 | 0 | 15 | 0 | 173 | 208 | 12795 | 12760 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3863 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21821807 | 21821807 | PRJEB9859_P_NODE_5458_length_242_cov_12801.469484_g5423_i0 | PRJEB9859 | 5458 | 242 | 12801.469484 | 30979.55615128 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 67.6 | 7.78e-7 | NTclustered | gi|2557422028|emb|OY662395.1| | 2697049 | g5423 | i0 | 97.5 | 16.0909090909091 | 40 | 0 | 17 | 1 | 173 | 212 | 9677 | 9639 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3894 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23097056 | 23097056 | PRJEB9859_P_NODE_1359_length_360_cov_3577.927492_g1324_i0 | PRJEB9859 | 1359 | 360 | 3577.927492 | 12880.5389712 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 5.63e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g1324 | i0 | 95.918 | 10.4833333333333 | 49 | 1 | 13 | 1 | 82 | 129 | 29916 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3774 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24370793 | 24370793 | PRJEB9859_P_NODE_2140_length_313_cov_4382.644366_g2105_i0 | PRJEB9859 | 2140 | 313 | 4382.644366 | 13717.67686558 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 4.83e-10 | NTclustered | gi|2165834141|emb|OV195847.1| | 2697049 | g2105 | i0 | 95.918 | 11.3674121405751 | 49 | 1 | 15 | 1 | 35 | 82 | 29916 | 29964 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3558 | 78.7 | 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);;