contig_metadata
7 rows where bioproject = "PRJNA928559", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 904042 | 904042 | PRJNA928559_P_NODE_41_length_9217_cov_33.662620_g30_i0 | PRJNA928559 | 41 | 9217 | 33.66262 | 3102.6836854 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 17016 | 0 | NTclustered | gi|1884529248|gb|MT831364.1| | 2697049 | g30 | i0 | 99.989 | 100 | 9217 | 1 | 100 | 0 | 1 | 9217 | 20466 | 29682 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WA-S2106/2020, complete genome | blastn | 921700 | 17016 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2179339 | 2179339 | PRJNA928559_P_NODE_402_length_4247_cov_11.198610_g301_i0 | PRJNA928559 | 402 | 4247 | 11.19861 | 475.6049667 | Kummerowia striata picorna-like virus | 2739852 | Viruses | Viruses | 5941 | 0 | NTclustered | gi|1851269098|gb|MN832470.1| | 2739852 | g301 | i0 | 93.662 | 2.53590769955263 | 3976 | 246 | 94 | 5 | 274 | 4247 | 7789 | 3818 | Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence | blastn | 10770 | 5941 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Kummerowia striata picorna-like virus | ||||
| 8557369 | 8557369 | PRJNA928559_P_NODE_7_length_19459_cov_38.316569_g2_i0 | PRJNA928559 | 7 | 19459 | 38.316569 | 7456.02116171 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 35918 | 0 | NTclustered | gi|2054207027|emb|OU183464.1| | 2697049 | g2 | i0 | 99.985 | 100.005139010227 | 19460 | 2 | 100 | 1 | 1 | 19459 | 34 | 19493 | Severe acute respiratory syndrome coronavirus 2 isolate hCoV-19/Iceland/836/2020 genome assembly, chromosome: hCoV-19_Iceland_836_2020 | blastn | 1946000 | 35918 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12381092 | 12381092 | PRJNA928559_P_NODE_10150_length_963_cov_13.192135_g8951_i0 | PRJNA928559 | 10150 | 963 | 13.192135 | 127.04026005 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1755 | 0 | NTclustered | gi|2125806870|gb|OK670657.1| | 2697049 | g8951 | i0 | 100 | 98.5597092419522 | 950 | 0 | 99 | 0 | 14 | 963 | 20448 | 19499 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/MN-MDH-14344/2021 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), and membrane glycoprotein (M) genes, complete cds; ORF6 gene, complete sequence; ORF7a protein (ORF7a) and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds | blastn | 94913 | 1755 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14932226 | 14932226 | PRJNA928559_P_NODE_632_length_3457_cov_11.764775_g482_i0 | PRJNA928559 | 632 | 3457 | 11.764775 | 406.70827175 | Kummerowia striata picorna-like virus | 2739852 | Viruses | Viruses | 4723 | 0 | NTclustered | gi|1851269098|gb|MN832470.1| | 2739852 | g482 | i0 | 91.502 | 1.3153022852184 | 3436 | 286 | 99 | 6 | 26 | 3457 | 1 | 3434 | Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence | blastn | 4547 | 4723 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Kummerowia striata picorna-like virus | ||||
| 22580751 | 22580751 | PRJNA928559_P_NODE_220038_length_233_cov_5.725000_g218469_i0 | PRJNA928559 | 220038 | 233 | 5.725 | 13.33925 | Sopidub virus | 3131684 | Viruses | Viruses | 180 | 9.169999999999999e-41 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g218469 | i0 | 91.538 | 24.6351931330472 | 130 | 11 | 56 | 0 | 104 | 233 | 2130 | 2259 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 5740 | 180 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 26835108 | 26835108 | PRJNA928559_P_NODE_58541_length_454_cov_1.842520_g56974_i0 | PRJNA928559 | 58541 | 454 | 1.84252 | 8.3650408 | Ripistub virus | 3131286 | Viruses | Viruses | 65.5 | 2.97e-9 | NR | WZH61163.1 | 3131286 | g56974 | i0 | 43.4 | 2.97356828193833 | 83 | 38 | 54.8 | 1 | 176 | 424 | 109 | 182 | WZH61163.1 MAG: RNA-dependent RNA polymerase, partial [Ripistub virus] | diamond | 1350 | 65.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Ripistub virus |
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);;