contig_metadata
13 rows where bioproject = "PRJNA283169" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646586 | 1646586 | PRJNA283169_P_NODE_5682_length_179_cov_2.430769_g5619_i0 | PRJNA283169 | 5682 | 179 | 2.430769 | 4.35107651 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 3.26e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5619 | i0 | 100 | 16.0949720670391 | 31 | 0 | 17 | 0 | 24 | 54 | 30034 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2881 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2922471 | 2922471 | PRJNA283169_P_NODE_8263_length_152_cov_2.077670_g8200_i0 | PRJNA283169 | 8263 | 152 | 2.07767 | 3.1580584 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 7.43e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g8200 | i0 | 97.222 | 18.9868421052632 | 36 | 0 | 24 | 1 | 113 | 148 | 30004 | 30038 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2886 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5475186 | 5475186 | PRJNA283169_P_NODE_5365_length_185_cov_0.963235_g5302_i0 | PRJNA283169 | 5365 | 185 | 0.963235 | 1.78198475 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 7.3e-6 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5302 | i0 | 100 | 15.5891891891892 | 34 | 0 | 18 | 0 | 137 | 170 | 30004 | 30037 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2884 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6749483 | 6749483 | PRJNA283169_P_NODE_5886_length_176_cov_2.157480_g5823_i0 | PRJNA283169 | 5886 | 176 | 2.15748 | 3.7971648 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.87e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5823 | i0 | 100 | 16.375 | 32 | 0 | 18 | 0 | 135 | 166 | 30004 | 30035 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2882 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6749492 | 6749492 | PRJNA283169_P_NODE_6806_length_167_cov_0.872881_g6743_i0 | PRJNA283169 | 6806 | 167 | 0.872881 | 1.45771127 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 3.01e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g6743 | i0 | 100 | 21.562874251497 | 31 | 0 | 19 | 0 | 13 | 43 | 30034 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3601 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10575719 | 10575719 | PRJNA283169_P_NODE_3649_length_217_cov_1.613095_g3586_i0 | PRJNA283169 | 3649 | 217 | 1.613095 | 3.50041615 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 1.15e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g3586 | i0 | 100 | 13.2811059907834 | 32 | 0 | 15 | 0 | 135 | 166 | 30004 | 30035 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2882 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11850425 | 11850425 | PRJNA283169_P_NODE_4070_length_207_cov_4.265823_g4007_i0 | PRJNA283169 | 4070 | 207 | 4.265823 | 8.83025361 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 67.6 | 6.47e-7 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g4007 | i0 | 93.478 | 13.9903381642512 | 46 | 2 | 22 | 1 | 7 | 52 | 30045 | 30001 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2896 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11850443 | 11850443 | PRJNA283169_P_NODE_5510_length_182_cov_1.278195_g5447_i0 | PRJNA283169 | 5510 | 182 | 1.278195 | 2.3263149 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 9.25e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5447 | i0 | 100 | 16.3571428571429 | 32 | 0 | 18 | 0 | 45 | 76 | 30033 | 30002 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2977 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11850472 | 11850472 | PRJNA283169_P_NODE_8070_length_162_cov_0.920354_g8007_i0 | PRJNA283169 | 8070 | 162 | 0.920354 | 1.49097348 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 2.9e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g8007 | i0 | 97.143 | 17.8086419753086 | 35 | 0 | 22 | 1 | 5 | 39 | 30037 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2885 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14400811 | 14400811 | PRJNA283169_P_NODE_7732_length_163_cov_1.342105_g7669_i0 | PRJNA283169 | 7732 | 163 | 1.342105 | 2.18763115 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 2.92e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g7669 | i0 | 100 | 17.6748466257669 | 31 | 0 | 19 | 0 | 12 | 42 | 30033 | 30003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2881 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20773288 | 20773288 | PRJNA283169_P_NODE_6097_length_173_cov_1.467742_g6034_i0 | PRJNA283169 | 6097 | 173 | 1.467742 | 2.53919366 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g6034 | i0 | 100 | 16.0982658959538 | 30 | 0 | 17 | 0 | 18 | 47 | 30032 | 30003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2785 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24597927 | 24597927 | PRJNA283169_P_NODE_7540_length_164_cov_0.904348_g7477_i0 | PRJNA283169 | 7540 | 164 | 0.904348 | 1.48313072 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.18e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g7477 | i0 | 100 | 23.3658536585366 | 32 | 0 | 20 | 0 | 10 | 41 | 30035 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3832 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 32020053 | 32020053 | PRJNA283169_P_NODE_7258_length_165_cov_0.896552_g7195_i0 | PRJNA283169 | 7258 | 165 | 0.896552 | 1.4793108 | Fiersviridae | 2842319 | Viruses | Viruses | 45.8 | 0.00108 | NR | YP_010769635.1 | 2786202 | g7195 | i0 | 46 | 1.92727272727273 | 50 | 24 | 85.5 | 1 | 159 | 19 | 165 | 214 | YP_010769635.1 maturation protein [ssRNA phage Gerhypos.1_20] | diamond | 318 | 45.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Oxychlovirus | Oxychlovirus tellurivivens |
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);;