contig_metadata
9 rows where bioproject = "PRJNA546018", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 511184 | 511184 | PRJNA546018_S_NODE_48681_length_217_cov_435.961538_g48356_i0 | PRJNA546018 | 48681 | 217 | 435.961538 | 946.03653746 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 3.16e-10 | NTclustered | gi|2523416575|emb|OX996782.1| | 2697049 | g48356 | i0 | 100 | 0.345622119815668 | 42 | 0 | 19 | 0 | 156 | 197 | 17654 | 17695 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 75 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 1786672 | 1786672 | PRJNA546018_S_NODE_48682_length_217_cov_385.083333_g48357_i0 | PRJNA546018 | 48682 | 217 | 385.083333 | 835.63083261 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 3.16e-10 | NTclustered | gi|2523416575|emb|OX996782.1| | 2697049 | g48357 | i0 | 100 | 0.345622119815668 | 42 | 0 | 19 | 0 | 21 | 62 | 17695 | 17654 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 75 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 3062088 | 3062088 | PRJNA546018_S_NODE_47923_length_219_cov_114.544304_g47598_i0 | PRJNA546018 | 47923 | 219 | 114.544304 | 250.85202576 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 3.2e-10 | NTclustered | gi|2523416575|emb|OX996782.1| | 2697049 | g47598 | i0 | 100 | 0.342465753424658 | 42 | 0 | 19 | 0 | 158 | 199 | 17654 | 17695 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 75 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5614920 | 5614920 | PRJNA546018_S_NODE_41865_length_237_cov_61.045455_g41540_i0 | PRJNA546018 | 41865 | 237 | 61.045455 | 144.67772835 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 87.9 | 5.83e-13 | NTclustered | gi|2174999023|emb|OV377758.1| | 2697049 | g41540 | i0 | 100 | 0.426160337552743 | 47 | 0 | 20 | 0 | 22 | 68 | 38 | 84 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 101 | 87.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10714830 | 10714830 | PRJNA546018_S_NODE_16029_length_412_cov_11.438746_g15704_i0 | PRJNA546018 | 16029 | 412 | 11.438746 | 47.12763352 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 87.9 | 1.09e-12 | NTclustered | gi|2174999023|emb|OV377758.1| | 2697049 | g15704 | i0 | 100 | 0.114077669902913 | 47 | 0 | 11 | 0 | 345 | 391 | 84 | 38 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 47 | 87.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11989605 | 11989605 | PRJNA546018_S_NODE_23450_length_330_cov_6.427509_g23125_i0 | PRJNA546018 | 23450 | 330 | 6.427509 | 21.2107797 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 484 | 2.5799999999999996e-132 | NTclustered | gi|2196304039|gb|MZ679032.1| | 3003959 | g23125 | i0 | 94.888 | 5.91212121212121 | 313 | 11 | 94 | 5 | 11 | 320 | 4924 | 5234 | MAG: Picornavirales sp. isolate 377R-k141_737244 putative polyprotein gene, partial cds | blastn | 1951 | 484 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 13264681 | 13264681 | PRJNA546018_S_NODE_27231_length_303_cov_84.607438_g26906_i0 | PRJNA546018 | 27231 | 303 | 84.607438 | 256.36053714 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 78.7 | 4.66e-10 | NTclustered | gi|2523416575|emb|OX996782.1| | 2697049 | g26906 | i0 | 100 | 1.65676567656766 | 42 | 0 | 14 | 0 | 21 | 62 | 17695 | 17654 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 502 | 78.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18362821 | 18362821 | PRJNA546018_S_NODE_51375_length_211_cov_1.300000_g51050_i0 | PRJNA546018 | 51375 | 211 | 1.3 | 2.743 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g51050 | i0 | 100 | 0.137440758293839 | 29 | 0 | 14 | 0 | 1 | 29 | 58 | 86 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 32480946 | 32480946 | PRJNA546018_S_NODE_6139_length_730_cov_8.167414_g5865_i0 | PRJNA546018 | 6139 | 730 | 8.167414 | 59.6221222 | Panax cryptic virus 4 | 2809267 | Viruses | Viruses | 264 | 2.7e-82 | NR | QRG29207.1 | 2809267 | g5865 | i0 | 78.2 | 0.698630136986301 | 170 | 37 | 69.9 | 0 | 25 | 534 | 321 | 490 | QRG29207.1 putative CP [Panax cryptic virus 4] | diamond | 510 | 264 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Panax cryptic virus 4 |
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);;