RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
32910758 32910758 PRJEB20058_P_NODE_169121_length_288_cov_11.444934_g166298_i0 PRJEB20058 169121 288 11.444934 32.96140992 Thermus phage phiKo 2301535 Viruses Viruses 127 1.97e-34   NR AYJ74689.1 2301535 g166298 i0 63.2 0.989583333333333 95 33 96.9 1 8 286 109 203 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 285 127 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32979463 32979463 PRJEB20058_P_NODE_181619_length_274_cov_2.422535_g178796_i0 PRJEB20058 181619 274 2.422535 6.6377459 Thermus phage phiKo 2301535 Viruses Viruses 50.8 2.67e-5   NR AYJ74682.1 2301535 g178796 i0 51.7 0.635036496350365 58 24 59.1 2 49 210 102 159 AYJ74682.1 peptidase [Thermus phage phiKo] diamond 174 50.8 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32997042 32997042 PRJEB20058_P_NODE_88035_length_438_cov_74.026525_g85241_i0 PRJEB20058 88035 438 74.026525 324.2361795 Thermus phage phiKo 2301535 Viruses Viruses 77.4 2.4e-14   NR AYJ74689.1 2301535 g85241 i0 64.9 0.39041095890411 57 18 37.7 1 323 159 137 193 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 171 77.4 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
33065045 33065045 PRJEB20058_P_NODE_47789_length_608_cov_28.369287_g45079_i0 PRJEB20058 47789 608 28.369287 172.48526496 Thermus phage phiKo 2301535 Viruses Viruses 74.3 3.18e-13   NR AYJ74698.1 2301535 g45079 i0 58.8 0.251644736842105 51 21 25.2 0 173 21 30 80 AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] diamond 153 74.3 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
33115375 33115375 PRJEB20058_P_NODE_125839_length_353_cov_6.558219_g123020_i0 PRJEB20058 125839 353 6.558219 23.15051307 Thermus phage phiKo 2301535 Viruses Viruses 45.4 0.00395   NR AYJ74698.1 2301535 g123020 i0 37.7 0.45042492917847 53 32 45 1 176 18 10 61 AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] diamond 159 45.4 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
33133520 33133520 PRJEB20058_P_NODE_72391_length_489_cov_5.654206_g69616_i0 PRJEB20058 72391 489 5.654206 27.64906734 Thermus phage phiKo 2301535 Viruses Viruses 83.6 3e-17   NR AYJ74698.1 2301535 g69616 i0 48.8 0.49079754601227 80 40 48.5 1 237 473 29 108 AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] diamond 240 83.6 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);;