contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA768450" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021340 | 2021340 | PRJNA768450_S_NODE_1042_length_539_cov_5.224490_g999_i0 | PRJNA768450 | 1042 | 539 | 5.22449 | 28.1600011 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 62.1 | 8.8e-5 | NTclustered | gi|2560516847|emb|OY702104.1| | 2697049 | g999 | i0 | 100 | 6.30055658627087 | 33 | 0 | 6 | 0 | 507 | 539 | 23282 | 23314 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3396 | 62.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2021394 | 2021394 | PRJNA768450_S_NODE_11802_length_207_cov_2.335443_g11753_i0 | PRJNA768450 | 11802 | 207 | 2.335443 | 4.83436701 | Deltapartitivirus duobetae | 3428206 | Viruses | Viruses | 374 | 3.4e-99 | NTclustered | gi|523580592|gb|KC845533.1| | 912029 | g11753 | i0 | 100 | 7.68115942028986 | 202 | 0 | 98 | 0 | 1 | 202 | 412 | 613 | Beet cryptic virus 2 isolate Rp coat protein gene, complete cds | blastn | 1590 | 374 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Deltapartitivirus duobetae | ||
| 3297148 | 3297148 | PRJNA768450_S_NODE_2843_length_361_cov_8.038462_g2794_i0 | PRJNA768450 | 2843 | 361 | 8.0384620000000009 | 29.01884782 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 137 | 9.18e-28 | NTclustered | gi|2165834218|emb|OV195924.1| | 2697049 | g2794 | i0 | 97.531 | 23.7479224376731 | 81 | 0 | 22 | 2 | 276 | 354 | 352 | 272 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8573 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4573929 | 4573929 | PRJNA768450_S_NODE_18184_length_176_cov_3.464567_g18135_i0 | PRJNA768450 | 18184 | 176 | 3.464567 | 6.09763792 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.87e-5 | NTclustered | gi|2557393137|emb|OY661705.1| | 2697049 | g18135 | i0 | 91.111 | 3.60227272727273 | 45 | 3 | 25 | 1 | 1 | 44 | 7180 | 7136 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 634 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5034484 | 5034484 | PRJNA768450_S_NODE_15524_length_187_cov_1.971014_g15475_i0 | PRJNA768450 | 15524 | 187 | 1.971014 | 3.68579618 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.016 | NTclustered | gi|2565360070|emb|OY632882.1| | 2697049 | g15475 | i0 | 100 | 0.449197860962567 | 28 | 0 | 15 | 0 | 1 | 28 | 22489 | 22462 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 84 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7124114 | 7124114 | PRJNA768450_S_NODE_1186_length_511_cov_401.487013_g1140_i0 | PRJNA768450 | 1186 | 511 | 401.487013 | 2051.59863643 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 135 | 4.83e-27 | NTclustered | gi|2165834303|emb|OV196009.1| | 2697049 | g1140 | i0 | 94.382 | 16.6027397260274 | 89 | 3 | 17 | 2 | 1 | 87 | 30000 | 29912 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8484 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10949553 | 10949553 | PRJNA768450_S_NODE_13809_length_196_cov_1.360544_g13760_i0 | PRJNA768450 | 13809 | 196 | 1.360544 | 2.66666624 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2557641183|emb|OY671812.1| | 2697049 | g13760 | i0 | 100 | 0.142857142857143 | 28 | 0 | 14 | 0 | 169 | 196 | 16421 | 16448 | 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 | ||
| 17324423 | 17324423 | PRJNA768450_S_NODE_6834_length_255_cov_2.548544_g6785_i0 | PRJNA768450 | 6834 | 255 | 2.548544 | 6.4987872 | Deltapartitivirus duobetae | 3428206 | Viruses | Viruses | 468 | 1.94e-127 | NTclustered | gi|2754350654|gb|PP987721.1| | 912029 | g6785 | i0 | 100 | 6.94509803921569 | 253 | 0 | 99 | 0 | 3 | 255 | 1143 | 891 | Beet cryptic virus 2 isolate Kz1-49C segment dsRNA2a, partial sequence | blastn | 1771 | 468 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Deltapartitivirus duobetae |
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);;