RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 8 ✖

bioproject 1

  • PRJNA429937 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
20829041 20829041 PRJNA429937_P_NODE_75537_length_381_cov_5.377841_g53418_i0 PRJNA429937 75537 381 5.377841 20.48957421 Halorubrum sp. CSM-61 2485838 Archaea Archaea 245 4.61e-78   NR WP_123619210.1 2485838 g53418 i0 95.1 0.960629921259842 122 6 96.1 0 14 379 34 155 WP_123619210.1 galactonate dehydratase [Halorubrum sp. CSM-61] diamond 366 245 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CSM-61
29776249 29776249 PRJNA429937_P_NODE_57171_length_461_cov_4.319444_g2639_i3 PRJNA429937 57171 461 4.319444 19.91263684 root 1 Root_unresolved Root_unresolved 114 2.61e-26   NR WP_336247442.1 2223 g2639 i3 52.5 1.8351409978308 141 57 85.9 3 396 1 245 384 WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] diamond 846 114 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
29871123 29871123 PRJNA429937_P_NODE_10431_length_1122_cov_2.154620_g6122_i0 PRJNA429937 10431 1122 2.15462 24.1748364 root 1 Root_unresolved Root_unresolved 216 6.999999999999999e-62   NR MCX6692367.1 2052170 g6122 i0 40.7 3.42513368983957 317 158 78.3 7 1 879 88 398 MCX6692367.1 IS1380 family transposase [Methanoregula sp.] diamond 3843 218 0.990825688073395 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
30092072 30092072 PRJNA429937_P_NODE_51812_length_490_cov_4.377440_g2639_i2 PRJNA429937 51812 490 4.37744 21.449456 root 1 Root_unresolved Root_unresolved 116 1.06e-26   NR WP_336247442.1 2223 g2639 i2 52.5 1.7265306122449 141 57 80.8 3 396 1 245 384 WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] diamond 846 116 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
30345536 30345536 PRJNA429937_P_NODE_4472_length_1596_cov_4.192087_g2639_i0 PRJNA429937 4472 1596 4.192087 66.90570852 root 1 Root_unresolved Root_unresolved 330 9.56e-102   NR WP_336247442.1 2223 g2639 i0 66.9 1.05639097744361 281 83 51.1 3 1596 781 245 524 WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] diamond 1686 330 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
30755821 30755821 PRJNA429937_P_NODE_72754_length_392_cov_2.851240_g50898_i0 PRJNA429937 72754 392 2.85124 11.1768608 root 1 Root_unresolved Root_unresolved 143 7.079999999999999e-37   NR HVN73417.1 2052170 g50898 i0 61.6 25.3316326530612 112 43 85.7 0 18 353 590 701 HVN73417.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Methanoregula sp.] diamond 9930 144 0.993055555555556 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
31482969 31482969 PRJNA429937_P_NODE_50296_length_499_cov_4.359574_g2639_i1 PRJNA429937 50296 499 4.359574 21.75427426 root 1 Root_unresolved Root_unresolved 114 4.1e-26   NR WP_336247442.1 2223 g2639 i1 52.5 1.69539078156313 141 57 79.4 3 104 499 245 384 WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] diamond 846 114 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
32527059 32527059 PRJNA429937_P_NODE_64439_length_426_cov_4.680101_g2639_i4 PRJNA429937 64439 426 4.680101 19.93723026 root 1 Root_unresolved Root_unresolved 130 4.3199999999999996e-32   NR WP_336247442.1 2223 g2639 i4 55.6 2.12676056338028 151 57 100 3 426 1 235 384 WP_336247442.1 pilus assembly protein N-terminal domain-containing protein [Methanothrix soehngenii] diamond 906 130 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii

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