RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA348537" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA348537 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
9321493 9321493 PRJNA348537_S_NODE_1608_length_230_cov_48598.774359_g1562_i0 PRJNA348537 1608 230 48598.774359 111777.1810257 Betacoronavirus pandemicum 3418604 Viruses Viruses 108 4.32e-19   NTclustered gi|2165835422|emb|OV196488.1| 2697049 g1562 i0 94.444 39.9521739130435 72 1 30 3 162 230 117 46 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 9189 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11872094 11872094 PRJNA348537_S_NODE_1390_length_246_cov_28582.199052_g1344_i0 PRJNA348537 1390 246 28582.199052 70312.20966792 Betacoronavirus pandemicum 3418604 Viruses Viruses 110 1.3e-19   NTclustered gi|2165835422|emb|OV196488.1| 2697049 g1344 i0 94.521 37.3861788617886 73 1 28 3 1 70 46 118 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 9197 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11872102 11872102 PRJNA348537_S_NODE_2050_length_208_cov_1.728324_g2004_i0 PRJNA348537 2050 208 1.728324 3.59491392 Marnaviridae sp. 2715102 Viruses Viruses 71.3 5.03e-8   NTclustered gi|2196309074|gb|MZ679344.1| 2715102 g2004 i0 84.507 0.341346153846154 71 11 34 0 112 182 583 653 MAG: Marnaviridae sp. isolate 350R-k141_4881 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 71 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
13147129 13147129 PRJNA348537_S_NODE_631_length_347_cov_151.855769_g585_i0 PRJNA348537 631 347 151.855769 526.93951843 Betacoronavirus pandemicum 3418604 Viruses Viruses 67.6 1.17e-6   NTclustered gi|2557626074|emb|OY681529.1| 2697049 g585 i0 95.238 11.6138328530259 42 2 12 0 1 42 3078 3037 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4030 67.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
19519286 19519286 PRJNA348537_S_NODE_1996_length_209_cov_3962.591954_g1950_i0 PRJNA348537 1996 209 3962.591954 8281.81718386 Betacoronavirus pandemicum 3418604 Viruses Viruses 67.6 6.54e-7   NTclustered gi|2560249809|emb|OY708303.1| 2697049 g1950 i0 100 18.3157894736842 36 0 17 0 2 37 11290 11255 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3828 67.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
22069956 22069956 PRJNA348537_S_NODE_1518_length_236_cov_5814.567164_g1472_i0 PRJNA348537 1518 236 5814.567164 13722.37850704 Betacoronavirus pandemicum 3418604 Viruses Viruses 71.3 5.84e-8   NTclustered gi|2560271642|emb|OY714418.1| 2697049 g1472 i0 100 17.3813559322034 38 0 16 0 4 41 6785 6748 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4102 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
25296638 25296638 PRJNA348537_S_NODE_1180_length_267_cov_39228.021552_g1134_i0 PRJNA348537 1180 267 39228.021552 104738.81754384 Betacoronavirus 694002 Viruses Viruses 102 2.39e-17   NTclustered gi|2165835422|emb|OV196488.1| 2697049 g1134 i0 92.105 44.2134831460674 76 1 40 5 196 267 120 46 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 11805 102 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);;