RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJDB4470 · 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
3836058 3836058 PRJDB4470_P_NODE_88664_length_185_cov_1.102941_g87509_i0 PRJDB4470 88664 185 1.102941 2.04044085 Pestivirus bovis 3052619 Viruses Viruses 298 1.84e-76   NTclustered gi|575471150|gb|KF772785.1| 11099 g87509 i0 99.394 79.3135135135135 165 0 89 1 1 165 164 1 Bovine viral diarrhea virus 1 isolate CC13B, complete genome blastn 14673 298 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis
6387736 6387736 PRJDB4470_P_NODE_38806_length_351_cov_2.784768_g37654_i0 PRJDB4470 38806 351 2.784768 9.77453568 Carlavirus latensdianthi 3427766 Viruses Viruses 52.8 0.033   NTclustered gi|1995060321|gb|MN450069.1| 12164 g37654 i0 100 0.0797720797720798 28 0 8 0 324 351 42 15 Carnation latent virus isolate KL, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
21383548 21383548 PRJDB4470_P_NODE_6857_length_920_cov_5.510907_g6140_i0 PRJDB4470 6857 920 5.5109069999999996 50.7003444 Pestivirus 11095 Viruses Viruses 1334 0   NTclustered gi|386285713|gb|JQ418634.1| 11099 g6140 i0 93.437 97.2836956521739 899 59 98 0 1 899 9776 8878 Bovine viral diarrhea virus 1 isolate 08GB45-2 polyprotein gene, complete cds blastn 89501 1345 0.99182156133829 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis
22658450 22658450 PRJDB4470_P_NODE_86778_length_187_cov_2.623188_g85623_i0 PRJDB4470 86778 187 2.623188 4.90536156 root 1 Root_unresolved Root_unresolved 196 6.989999999999999e-46   NTclustered gi|2006234009|gb|MW741553.1| 11060 g85623 i0 96.61 96.3903743315508 118 4 97 0 4 121 10595 10478 Dengue virus type 2 isolate DENV-2 Rega Lab strain polyprotein (POLY) gene, complete cds; and sfRNA1 lncRNA gene, partial sequence blastn 18025 196 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Orthoflavivirus Orthoflavivirus denguei

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