contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3086642 | 3086642 | PRJNA557436_S_NODE_2583_length_236_cov_18.502488_g2535_i0 | PRJNA557436 | 2583 | 236 | 18.502488 | 43.66587168 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 111 | 3.44e-20 | NTclustered | gi|2165836832|emb|OV197136.1| | 2697049 | g2535 | i0 | 93.421 | 7.42372881355932 | 76 | 3 | 31 | 2 | 2 | 75 | 41 | 116 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 1752 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 3086672 | 3086672 | PRJNA557436_S_NODE_903_length_376_cov_14.249267_g855_i0 | PRJNA557436 | 903 | 376 | 14.249267 | 53.57724392 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 1.25e-21 | NTclustered | gi|2165834320|emb|OV196026.1| | 2697049 | g855 | i0 | 93.75 | 22.2792553191489 | 80 | 2 | 21 | 3 | 1 | 78 | 30015 | 29937 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8377 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4362970 | 4362970 | PRJNA557436_S_NODE_2344_length_247_cov_7.056604_g2296_i0 | PRJNA557436 | 2344 | 247 | 7.056604 | 17.42981188 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 1.03e-5 | NTclustered | gi|2557654279|emb|OY684629.1| | 2697049 | g2296 | i0 | 97.368 | 0.396761133603239 | 38 | 0 | 15 | 1 | 42 | 78 | 26154 | 26117 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 98 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6913645 | 6913645 | PRJNA557436_S_NODE_66_length_1299_cov_5.343354_g53_i0 | PRJNA557436 | 66 | 1299 | 5.343354 | 69.41016846 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 115 | 1.67e-20 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g53 | i0 | 93.671 | 6.39107005388761 | 79 | 2 | 6 | 3 | 1222 | 1299 | 591 | 515 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8302 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8188569 | 8188569 | PRJNA557436_S_NODE_1327_length_316_cov_12.323843_g1279_i0 | PRJNA557436 | 1327 | 316 | 12.323843 | 38.94334388 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 134 | 1.03e-26 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g1279 | i0 | 98.684 | 0.591772151898734 | 76 | 0 | 24 | 1 | 1 | 75 | 515 | 590 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 187 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12014637 | 12014637 | PRJNA557436_S_NODE_1010_length_358_cov_22.990712_g962_i0 | PRJNA557436 | 1010 | 358 | 22.990712 | 82.30674896 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 134 | 1.18e-26 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g962 | i0 | 98.684 | 23.3826815642458 | 76 | 0 | 21 | 1 | 284 | 358 | 590 | 515 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8371 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14564701 | 14564701 | PRJNA557436_S_NODE_992_length_361_cov_14.570552_g944_i0 | PRJNA557436 | 992 | 361 | 14.570552 | 52.59969272 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 1.2e-21 | NTclustered | gi|2165836832|emb|OV197136.1| | 2697049 | g944 | i0 | 94.737 | 25 | 76 | 3 | 21 | 1 | 286 | 360 | 116 | 41 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 9025 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17113441 | 17113441 | PRJNA557436_S_NODE_3014_length_222_cov_21.208556_g2966_i0 | PRJNA557436 | 3014 | 222 | 21.208556 | 47.08299432 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 6.88e-22 | NTclustered | gi|2165836832|emb|OV197136.1| | 2697049 | g2966 | i0 | 94.737 | 40.5630630630631 | 76 | 3 | 34 | 1 | 2 | 76 | 41 | 116 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 9005 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18387575 | 18387575 | PRJNA557436_S_NODE_1655_length_288_cov_12.430830_g1607_i0 | PRJNA557436 | 1655 | 288 | 12.43083 | 35.8007904 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 134 | 9.25e-27 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g1607 | i0 | 98.684 | 0.649305555555556 | 76 | 0 | 26 | 1 | 214 | 288 | 590 | 515 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 187 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18387588 | 18387588 | PRJNA557436_S_NODE_3015_length_222_cov_7.871658_g2967_i0 | PRJNA557436 | 3015 | 222 | 7.871658 | 17.47508076 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 106 | 1.49e-18 | NTclustered | gi|2165835426|emb|OV196492.1| | 2697049 | g2967 | i0 | 92.308 | 0.779279279279279 | 78 | 1 | 34 | 4 | 148 | 222 | 138 | 63 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 173 | 106 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20937742 | 20937742 | PRJNA557436_S_NODE_2797_length_228_cov_21.699482_g2749_i0 | PRJNA557436 | 2797 | 228 | 21.699482 | 49.47481896 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 128 | 3.28e-25 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g2749 | i0 | 97.368 | 0.771929824561403 | 76 | 0 | 32 | 2 | 1 | 74 | 515 | 590 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 176 | 128 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24761898 | 24761898 | PRJNA557436_S_NODE_160_length_821_cov_6.811705_g53_i1 | PRJNA557436 | 160 | 821 | 6.811705 | 55.92409805 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 115 | 1.04e-20 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g53 | i1 | 93.671 | 10.1120584652862 | 79 | 2 | 10 | 3 | 1 | 78 | 515 | 591 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8302 | 115 | 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);;