RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1057075" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1057075 · 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
176615 176615 PRJNA1057075_S_NODE_5861_length_190_cov_1.638298_g5762_i0 PRJNA1057075 5861 190 1.638298 3.1127662 Betacoronavirus pandemicum 3418604 Viruses Viruses 351 1.4399999999999997e-92   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g5762 i0 100 100 190 0 100 0 1 190 19853 20042 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 19000 351 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
5279352 5279352 PRJNA1057075_S_NODE_5185_length_200_cov_1.377483_g5086_i0 PRJNA1057075 5185 200 1.377483 2.754966 Betacoronavirus pandemicum 3418604 Viruses Viruses 370 4.22e-98   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g5086 i0 100 100 200 0 100 0 1 200 10868 10669 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 20000 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
5279367 5279367 PRJNA1057075_S_NODE_805_length_375_cov_4.046012_g706_i0 PRJNA1057075 805 375 4.046012 15.172545 Betacoronavirus pandemicum 3418604 Viruses Viruses 693 0   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g706 i0 100 100 375 0 100 0 1 375 13354 12980 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 37500 693 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6554533 6554533 PRJNA1057075_S_NODE_5246_length_199_cov_1.040000_g5147_i0 PRJNA1057075 5246 199 1.04 2.0696 Betacoronavirus pandemicum 3418604 Viruses Viruses 368 1.51e-97   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g5147 i0 100 100 199 0 100 0 1 199 18204 18402 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 19900 368 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6554538 6554538 PRJNA1057075_S_NODE_6726_length_180_cov_3.175573_g6627_i0 PRJNA1057075 6726 180 3.175573 5.7160314 Betacoronavirus pandemicum 3418604 Viruses Viruses 333 4.87e-87   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g6627 i0 100 100 180 0 100 0 1 180 327 506 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 18000 333 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10379900 10379900 PRJNA1057075_S_NODE_4149_length_220_cov_1.625731_g4050_i0 PRJNA1057075 4149 220 1.625731 3.5766082 Betacoronavirus pandemicum 3418604 Viruses Viruses 405 1.2999999999999997e-108   NTclustered gi|2447599485|emb|OX434190.1| 2697049 g4050 i0 100 99.5454545454545 219 0 99 0 2 220 15387 15169 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 21900 405 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
14205299 14205299 PRJNA1057075_S_NODE_8732_length_165_cov_3.137931_g8633_i0 PRJNA1057075 8732 165 3.137931 5.17758615 Betacoronavirus pandemicum 3418604 Viruses Viruses 305 9.59e-79   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g8633 i0 100 100 165 0 100 0 1 165 873 709 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 16500 305 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
16753506 16753506 PRJNA1057075_S_NODE_6194_length_186_cov_1.897810_g6095_i0 PRJNA1057075 6194 186 1.89781 3.5299266 Betacoronavirus pandemicum 3418604 Viruses Viruses 344 2.34e-90   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g6095 i0 100 100 186 0 100 0 1 186 25526 25711 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 18600 344 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20577661 20577661 PRJNA1057075_S_NODE_10477_length_153_cov_5.798077_g10378_i0 PRJNA1057075 10477 153 5.798077 8.87105781 Betacoronavirus pandemicum 3418604 Viruses Viruses 283 4.0799999999999995e-72   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g10378 i0 100 100 153 0 100 0 1 153 335 183 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 15300 283 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20577662 20577662 PRJNA1057075_S_NODE_10917_length_150_cov_5.376238_g10818_i0 PRJNA1057075 10917 150 5.376238 8.064357 Betacoronavirus pandemicum 3418604 Viruses Viruses 278 1.85e-70   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g10818 i0 100 100 150 0 100 0 1 150 23664 23515 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 15000 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20577691 20577691 PRJNA1057075_S_NODE_9717_length_159_cov_2.981818_g9618_i0 PRJNA1057075 9717 159 2.981818 4.74109062 Betacoronavirus pandemicum 3418604 Viruses Viruses 294 1.98e-75   NTclustered gi|2213039892|gb|ON085404.1| 2697049 g9618 i0 100 100 159 0 100 0 1 159 12846 12688 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/C014183520/2020, complete genome blastn 15900 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20577692 20577692 PRJNA1057075_S_NODE_97_length_634_cov_2.894017_g60_i0 PRJNA1057075 97 634 2.894017 18.34806778 Betacoronavirus pandemicum 3418604 Viruses Viruses 1151 0   NTclustered gi|2178372089|emb|OV485089.1| 2697049 g60 i0 99.682 101.130914826498 629 2 100 0 1 629 28847 28219 Severe acute respiratory syndrome coronavirus 2 isolate hCoV-19/Switzerland/LU-DIA-011436023001/2021 genome assembly, chromosome: 1 blastn 64117 1151 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
21853479 21853479 PRJNA1057075_S_NODE_8778_length_165_cov_1.560345_g8679_i0 PRJNA1057075 8778 165 1.560345 2.57456925 Betacoronavirus pandemicum 3418604 Viruses Viruses 305 9.59e-79   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g8679 i0 100 100 165 0 100 0 1 165 11086 11250 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 16500 305 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23128903 23128903 PRJNA1057075_S_NODE_5579_length_194_cov_1.434483_g5480_i0 PRJNA1057075 5579 194 1.434483 2.78289702 Betacoronavirus pandemicum 3418604 Viruses Viruses 359 8.809999999999999e-95   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g5480 i0 100 100 194 0 100 0 1 194 10303 10110 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 19400 359 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);;