RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJEB10140 · 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
1286010 1286010 PRJEB10140_P_NODE_153842_length_242_cov_1.331606_g136534_i0 PRJEB10140 153842 242 1.331606 3.22248652 Skokie tombus-like virus 2789423 Viruses Viruses 405 1.45e-108   NTclustered gi|1933757591|gb|MW177750.1| 2789423 g136534 i0 96.721 2.01652892561983 244 6 100 1 1 242 296 53 Skokie tombus-like virus strain USAdp hypothetical protein 2 gene, partial cds blastn 488 405 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Skokie tombus-like virus
6391391 6391391 PRJEB10140_P_NODE_56426_length_650_cov_5.490849_g40005_i0 PRJEB10140 56426 650 5.490849 35.6905185 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.018   NTclustered gi|2560523083|emb|OY698888.1| 2697049 g40005 i0 100 0.0446153846153846 29 0 4 0 558 586 12031 12003 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10216144 10216144 PRJEB10140_P_NODE_80249_length_457_cov_2.232843_g63000_i0 PRJEB10140 80249 457 2.232843 10.20409251 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.012   NTclustered gi|2560523083|emb|OY698888.1| 2697049 g63000 i0 100 0.0634573304157549 29 0 6 0 216 244 12003 12031 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
12766729 12766729 PRJEB10140_P_NODE_41791_length_858_cov_8.461063_g27258_i0 PRJEB10140 41791 858 8.461063 72.59592054 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.024   NTclustered gi|2560523083|emb|OY698888.1| 2697049 g27258 i0 100 0.0337995337995338 29 0 3 0 450 478 12031 12003 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
22659131 22659131 PRJEB10140_P_NODE_183858_length_209_cov_0.975000_g166549_i0 PRJEB10140 183858 209 0.975 2.03775 Viruses 10239 Viruses Viruses 215 2.21e-51   NTclustered gi|2214127666|tpg|BK059611.1| 2904742 g166549 i0 85.167 2 209 31 100 0 1 209 8412 8204 TPA_asm: Leptasterias associated picornavirus 2, complete genome blastn 418 215 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Leptasterias associated picornavirus 2

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