RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJEB7614" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 14 ✖

bioproject 1

  • PRJEB7614 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
25525691 25525691 PRJEB7614e_S_NODE_1089_length_232_cov_7402.766497_g1081_i0 PRJEB7614 1089 232 7402.766497 17174.41827304 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 71.3 5.73e-8   NTclustered gi|2165834141|emb|OV195847.1| 2697049 g1081 i0 92 15.8275862068966 50 4 22 0 3 52 29964 29915 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 3672 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
25752675 25752675 PRJEB7614e_S_NODE_370_length_320_cov_3211.845614_g362_i0 PRJEB7614 370 320 3211.845614 10277.9059648 Viruses 10239 Viruses Viruses 71.3 8.29e-8   NTclustered gi|2165834141|emb|OV195847.1| 2697049 g362 i0 92 11.6125 50 4 16 0 3 52 29964 29915 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 3716 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
25797721 25797721 PRJEB7614b_S_NODE_187_length_348_cov_37385.575080_g185_i0 PRJEB7614 187 348 37385.57508 130101.8012784 Human coronavirus OC43 31631 Viruses Viruses 87.9 9.04e-13   NTclustered gi|2117663563|dbj|LC315647.2| 31631 g185 i0 100 14.6494252873563 47 0 14 0 1 47 30753 30707 Human coronavirus OC43 Tokyo/SGH-61/2014 RNA, complete genome blastn 5098 87.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus gravedinis
25797740 25797740 PRJEB7614d_S_NODE_1019_length_220_cov_1814.205405_g981_i0 PRJEB7614 1019 220 1814.205405 3991.251891 Brassica yellows virus 1046403 Viruses Viruses 108 4.1e-19   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g981 i0 98.387 29.8909090909091 62 0 28 1 160 220 1071 1132 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6576 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
25797765 25797765 PRJEB7614e_S_NODE_987_length_240_cov_5764.419512_g979_i0 PRJEB7614 987 240 5764.419512 13834.6068288 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 71.3 5.96e-8   NTclustered gi|2560518070|emb|OY703170.1| 2697049 g979 i0 97.561 16.4541666666667 41 1 17 0 19 59 18474 18434 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3949 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
25933952 25933952 PRJEB7614c_S_NODE_348_length_273_cov_11424.273109_g347_i0 PRJEB7614 348 273 11424.273109 31188.26558757 Brassica yellows virus 1046403 Viruses Viruses 121 6.77e-23   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g347 i0 98.529 25.025641025641 68 1 25 0 1 68 1136 1069 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6832 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
26206225 26206225 PRJEB7614b_S_NODE_926_length_220_cov_61811.097297_g924_i0 PRJEB7614 926 220 61811.097297 135984.4140534 Brassica yellows virus 1046403 Viruses Viruses 110 1.14e-19   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g924 i0 100 27.1363636363636 59 0 27 0 1 59 1128 1070 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 5970 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
26206257 26206257 PRJEB7614e_S_NODE_702_length_267_cov_20164.137931_g694_i0 PRJEB7614 702 267 20164.137931 53838.24827577 Brassica yellows virus 1046403 Viruses Viruses 115 3.07e-21   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g694 i0 98.485 25.9737827715356 66 0 25 1 202 267 1071 1135 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6935 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
26296612 26296612 PRJEB7614e_S_NODE_1710_length_210_cov_3397.222857_g1702_i0 PRJEB7614 1710 210 3397.222857 7134.1679997 Viruses 10239 Viruses Viruses 69.4 1.83e-7   NTclustered gi|2557656947|emb|OY688217.1| 2697049 g1702 i0 100 18.852380952381 37 0 18 0 1 37 22927 22891 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3959 69.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26296615 26296615 PRJEB7614e_S_NODE_3134_length_193_cov_63.981013_g3126_i0 PRJEB7614 3134 193 63.981013 123.48335509 Viruses 10239 Viruses Viruses 65.8 2.14e-6   NTclustered gi|2560518070|emb|OY703170.1| 2697049 g3126 i0 95.238 20.4818652849741 42 1 21 1 151 191 18433 18474 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3953 65.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26432621 26432621 PRJEB7614b_S_NODE_1311_length_200_cov_67290.812121_g1309_i0 PRJEB7614 1311 200 67290.812121 134581.624242 Viruses 10239 Viruses Viruses 84.2 6.16e-12   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g1309 i0 100 25.375 45 0 23 0 1 45 1115 1071 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 5075 84.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
26478294 26478294 PRJEB7614a_S_NODE_99960_length_186_cov_340.523179_g98756_i0 PRJEB7614 99960 186 340.523179 633.37311294 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 69.4 1.58e-7   NTclustered gi|2557637075|emb|OY693509.1| 2697049 g98756 i0 100 20.6559139784946 37 0 20 0 150 186 34 70 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3842 69.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26478322 26478322 PRJEB7614e_S_NODE_1592_length_213_cov_7884.033708_g1584_i0 PRJEB7614 1592 213 7884.033708 16792.99179804 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 71.3 5.17e-8   NTclustered gi|2165834141|emb|OV195847.1| 2697049 g1584 i0 92 17.1032863849765 50 4 23 0 162 211 29915 29964 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 3643 71.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26568631 26568631 PRJEB7614b_S_NODE_616_length_249_cov_51446.224299_g614_i0 PRJEB7614 616 249 51446.224299 128101.09850451 Viruses 10239 Viruses Viruses 84.2 7.99e-12   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g614 i0 94.545 20.1566265060241 55 1 22 2 196 249 1062 1115 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 5019 84.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV

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