RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1248424" and tax_kingdom = "Bamfordvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Bamfordvirae · 4 ✖

bioproject 1

  • PRJNA1248424 · 4 ✖

analysis 1

  • diamond · 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
27389870 27389870 PRJNA1248424_P_NODE_68943_length_251_cov_1.179775_g62874_i0 PRJNA1248424 68943 251 1.179775 2.96123525 Drosophila-associated adintovirus 1 2744816 Viruses Viruses 77.8 1.88e-14   NR QKS69560.1 2744816 g62874 i0 55.2 6.50199203187251 67 30 80.1 0 251 51 254 320 QKS69560.1 PolB [Drosophila-associated adintovirus 1] diamond 1632 77.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Drosophila-associated adintovirus 1
27610807 27610807 PRJNA1248424_P_NODE_75844_length_245_cov_0.895349_g69775_i0 PRJNA1248424 75844 245 0.895349 2.19360505 Adintovirus tegillarca14448 3115949 Viruses Viruses 52.8 7.44e-6   NR DBA51532.1 3115949 g69775 i0 37.7 1.77551020408163 77 47 94.3 1 240 10 90 165 DBA51532.1 MAG TPA_asm: PacK [Adintovirus tegillarca14448] diamond 435 52.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus tegillarca14448
29283957 29283957 PRJNA1248424_P_NODE_58569_length_279_cov_1.703883_g52501_i0 PRJNA1248424 58569 279 1.703883 4.75383357 Adintovirus tegillarca14448 3115949 Viruses Viruses 65.5 2.15e-10   NR DBA51532.1 3115949 g52501 i0 37.5 0.946236559139785 88 55 94.6 0 267 4 114 201 DBA51532.1 MAG TPA_asm: PacK [Adintovirus tegillarca14448] diamond 264 65.5 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus tegillarca14448
30136431 30136431 PRJNA1248424_P_NODE_58212_length_280_cov_1.487923_g52144_i0 PRJNA1248424 58212 280 1.487923 4.1661844 Adintovirus pristionchus14876 3115940 Viruses Viruses 60.1 4.61e-8   NR DBA46422.1 3115940 g52144 i0 50.9 0.589285714285714 55 27 58.9 0 278 114 678 732 DBA46422.1 MAG TPA_asm: PolBa [Adintovirus pristionchus14876] diamond 165 60.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus pristionchus14876

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