contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB1404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295283 | 1295283 | PRJEB1404_S_NODE_1162_length_267_cov_60.125000_g1142_i0 | PRJEB1404 | 1162 | 267 | 60.125 | 160.53375 | Orthoebolavirus sudanense | 3052460 | Viruses | Viruses | 63.9 | 1.13e-5 | NTclustered | gi|2471616984|gb|OQ673055.1| | 186540 | g1142 | i0 | 97.297 | 12.6404494382022 | 37 | 1 | 14 | 0 | 231 | 267 | 37 | 1 | Sudan ebolavirus isolate Ebolavirus/H.sapiens-wt/Uganda/2022/2022002394_C054, partial genome | blastn | 3375 | 63.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Filoviridae | Orthoebolavirus | Orthoebolavirus sudanense | ||
| 16288411 | 16288411 | PRJEB1404_S_NODE_2733_length_194_cov_96.201258_g2713_i0 | PRJEB1404 | 2733 | 194 | 96.201258 | 186.63044052 | Viruses | 10239 | Viruses | Viruses | 65.8 | 2.15e-6 | NTclustered | gi|2565357930|emb|OY628901.1| | 2697049 | g2713 | i0 | 100 | 17.5103092783505 | 35 | 0 | 18 | 0 | 160 | 194 | 9639 | 9673 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3397 | 65.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17872718 | 17872718 | PRJEB1404_S_NODE_2295_length_211_cov_74.392045_g2275_i0 | PRJEB1404 | 2295 | 211 | 74.392045 | 156.96721495 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 65.8 | 2.38e-6 | NTclustered | gi|2557648451|emb|OY677355.1| | 2697049 | g2275 | i0 | 100 | 17.9478672985782 | 35 | 0 | 17 | 0 | 1 | 35 | 9675 | 9641 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3787 | 65.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20421776 | 20421776 | PRJEB1404_S_NODE_2977_length_186_cov_223.569536_g2957_i0 | PRJEB1404 | 2977 | 186 | 223.569536 | 415.83933696 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 65.8 | 2.04e-6 | NTclustered | gi|2557648451|emb|OY677355.1| | 2697049 | g2957 | i0 | 100 | 20.1451612903226 | 35 | 0 | 19 | 0 | 152 | 186 | 9641 | 9675 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3747 | 65.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21697816 | 21697816 | PRJEB1404_S_NODE_3138_length_182_cov_127.251701_g3118_i0 | PRJEB1404 | 3138 | 182 | 127.251701 | 231.59809582 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 7.15e-6 | NTclustered | gi|2565362283|emb|OY635503.1| | 2697049 | g3118 | i0 | 93.023 | 18.8846153846154 | 43 | 3 | 24 | 0 | 1 | 43 | 2243 | 2201 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3437 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23938067 | 23938067 | PRJEB1404_S_NODE_1319_length_257_cov_81.684685_g1299_i0 | PRJEB1404 | 1319 | 257 | 81.684685 | 209.92964045 | Viruses | 10239 | Viruses | Viruses | 62.1 | 3.88e-5 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g1299 | i0 | 100 | 13.2373540856031 | 33 | 0 | 13 | 0 | 1 | 33 | 1108 | 1076 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3402 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 25211784 | 25211784 | PRJEB1404_S_NODE_1780_length_234_cov_248.070352_g1760_i0 | PRJEB1404 | 1780 | 234 | 248.070352 | 580.48462368 | Viruses | 10239 | Viruses | Viruses | 62.1 | 3.48e-5 | NTclustered | gi|2557657929|emb|OY694257.1| | 2697049 | g1760 | i0 | 100 | 15.5940170940171 | 33 | 0 | 14 | 0 | 202 | 234 | 22477 | 22509 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3649 | 62.1 | 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);;