RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJEB12982 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
8948046 8948046 PRJEB12982_P_NODE_7088_length_273_cov_1.227679_g6925_i0 PRJEB12982 7088 273 1.227679 3.35156367 Dicistroviridae sp. 1955144 Viruses Viruses 115 7.160000000000001e-29   NR XCO49366.1 1955144 g6925 i0 57.3 2.93406593406593 89 38 97.8 0 5 271 184 272 XCO49366.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 801 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
20421609 20421609 PRJEB12982_P_NODE_17_length_3322_cov_6.748854_g15_i0 PRJEB12982 17 3322 6.748854 224.19692988 Picornavirales 464095 Viruses Viruses 504 1.7699999999999995e-158   NR NP_044946.1 64279 g15 i0 35.6 7.03943407585792 978 493 84.8 25 258 3074 16 895 NP_044946.1 capsid polyprotein, partial [Drosophila C virus] diamond 23385 506 0.99604743083004 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
26652896 26652896 PRJEB12982_P_NODE_381_length_1267_cov_2.582102_g311_i0 PRJEB12982 381 1267 2.582102 32.71523234 Dicistroviridae sp. 1955144 Viruses Viruses 292 5.65e-84   NR ULF99809.1 1955144 g311 i0 39.1 1.02999210734017 435 245 99.4 9 7 1266 1033 1462 ULF99809.1 MAG: replicase polyprotein [Dicistroviridae sp.] diamond 1305 292 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28416471 28416471 PRJEB12982_P_NODE_2406_length_499_cov_2.093333_g2245_i0 PRJEB12982 2406 499 2.093333 10.44573167 Viruses 10239 Viruses Viruses 79.3 1.1e-13   NR WPV63180.1 3083669 g2245 i0 28.7 1.64128256513026 164 110 96.8 2 17 499 614 773 WPV63180.1 MAG: RNA-dependent RNA polymerase [Wenzhou bat dicistrovirus 3] diamond 819 79.7 0.994981179422836 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Wenzhou bat dicistrovirus 3
28669055 28669055 PRJEB12982_P_NODE_2047_length_544_cov_2.109091_g1888_i0 PRJEB12982 2047 544 2.109091 11.47345504 Picornavirales 464095 Viruses Viruses 213 2.41e-60   NR ULF99869.1 1955141 g1888 i0 55.3 11.8455882352941 179 80 98.7 0 540 4 1519 1697 ULF99869.1 MAG: hypothetical protein 1 [Cripavirus sp.] diamond 6444 215 0.990697674418605 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.

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