contig_metadata
21 rows where bioproject = "PRJEB9859" and tax_phylum = "Pisuviricota"
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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;