RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA674048 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
5746657 5746657 PRJNA674048_P_NODE_33105_length_160_cov_12590.990991_g32902_i0 PRJNA674048 33105 160 12590.990991 20145.5855856 Betacoronavirus pandemicum 3418604 Viruses Viruses 108 2.79e-19   NTclustered gi|2155033579|emb|OV039277.1| 2697049 g32902 i0 100 10.39375 58 0 36 0 103 160 30508 30565 Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 blastn 1663 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
9571555 9571555 PRJNA674048_P_NODE_14128_length_239_cov_16.563158_g13925_i0 PRJNA674048 14128 239 16.563158 39.58594762 Sopidub virus 3131684 Viruses Viruses 182 2.63e-41   NTclustered gi|2717323145|gb|PP173985.1| 3131684 g13925 i0 91.603 4.9163179916318 131 11 55 0 1 131 2261 2131 MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence blastn 1175 182 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae   Sopidub virus
24869275 24869275 PRJNA674048_P_NODE_20960_length_192_cov_1.454545_g20757_i0 PRJNA674048 20960 192 1.454545 2.7927264 Crogonang virus 24 3062947 Viruses Viruses 327 2.45e-85   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g20757 i0 97.396 1 192 5 100 0 1 192 5053 5244 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 192 327 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
24869293 24869293 PRJNA674048_P_NODE_22660_length_184_cov_82011.481481_g22457_i0 PRJNA674048 22660 184 82011.481481 150901.12592504 Betacoronavirus pandemicum 3418604 Viruses Viruses 167 5.37e-37   NTclustered gi|2155033579|emb|OV039277.1| 2697049 g22457 i0 97.917 15.0054347826087 96 2 52 0 46 141 30503 30598 Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 blastn 2761 167 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);;