RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA498309", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Preplasmiviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA498309 · 4 ✖

analysis 1

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
29413743 29413743 PRJNA498309_P_NODE_47509_length_390_cov_3.458924_g45373_i0 PRJNA498309 47509 390 3.458924 13.4898036 Thermus phage phiKo 2301535 Viruses Viruses 82.4 2.98e-17   NR AYJ74698.1 2301535 g45373 i0 55.2 0.515384615384615 67 29 51.5 1 168 368 3 68 AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] diamond 201 82.4 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29855920 29855920 PRJNA498309_P_NODE_76771_length_261_cov_3.218750_g74622_i0 PRJNA498309 76771 261 3.21875 8.4009375 Thermus phage phiKo 2301535 Viruses Viruses 50.8 5.33e-6   NR AYJ74681.1 2301535 g74622 i0 51.4 0.425287356321839 37 18 42.5 0 35 145 27 63 AYJ74681.1 hypothetical protein phiKo_06 [Thermus phage phiKo] diamond 111 50.8 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30393452 30393452 PRJNA498309_P_NODE_88133_length_225_cov_3.095745_g85984_i0 PRJNA498309 88133 225 3.095745 6.96542625 Thermus phage phiKo 2301535 Viruses Viruses 79.7 2.52e-16   NR AYJ74689.1 2301535 g85984 i0 64.2 0.706666666666667 53 17 70.7 1 65 223 1 51 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 159 79.7 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32226926 32226926 PRJNA498309_P_NODE_81698_length_245_cov_2.139423_g79549_i0 PRJNA498309 81698 245 2.139423 5.24158635 Thermus phage phiKo 2301535 Viruses Viruses 103 1.25e-25   NR AYJ74689.1 2301535 g79549 i0 62.5 0.979591836734694 80 29 98 1 245 6 45 123 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 240 103 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo

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