RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1148965" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA1148965 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
2851776 2851776 PRJNA1148965_S_NODE_663_length_257_cov_1.407609_g660_i0 PRJNA1148965 663 257 1.407609 3.61755513 Betacoronavirus pandemicum 3418604 Viruses Viruses 93.5 1.38e-14   NTclustered gi|2557633336|emb|OY694998.1| 2697049 g660 i0 93.651 24.011673151751 63 2 25 2 1 63 19713 19653 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 6171 93.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10504626 10504626 PRJNA1148965_S_NODE_689_length_255_cov_1.285714_g686_i0 PRJNA1148965 689 255 1.285714 3.2785707 Betacoronavirus pandemicum 3418604 Viruses Viruses 76.8 1.37e-9   NTclustered gi|2565363363|emb|OY636195.1| 2697049 g686 i0 92.593 15.1450980392157 54 2 21 2 1 54 19679 19628 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3862 76.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23253126 23253126 PRJNA1148965_S_NODE_419_length_302_cov_3.096070_g416_i0 PRJNA1148965 419 302 3.09607 9.3501314 Betacoronavirus pandemicum 3418604 Viruses Viruses 82.4 3.59e-11   NTclustered gi|2165835007|emb|OV196275.1| 2697049 g416 i0 89.394 19.2615894039735 66 5 22 1 2 67 30055 29992 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 5817 82.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23253127 23253127 PRJNA1148965_S_NODE_939_length_208_cov_4.333333_g936_i0 PRJNA1148965 939 208 4.333333 9.01333264 Betacoronavirus pandemicum 3418604 Viruses Viruses 71.3 5.03e-8   NTclustered gi|2560263575|emb|OY712376.1| 2697049 g936 i0 93.75 19.7115384615385 48 1 23 1 1 48 5963 5918 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4100 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23988769 23988769 PRJNA1148965_S_NODE_839_length_243_cov_0.917647_g836_i0 PRJNA1148965 839 243 0.917647 2.22988221 Viruses 10239 Viruses Viruses 73.1 1.68e-8   NTclustered gi|2557633336|emb|OY694998.1| 2697049 g836 i0 92.308 19.3662551440329 52 2 21 2 192 243 19653 19702 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4706 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;