RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1068513 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
28141404 28141404 PRJNA1068513_S_NODE_2005_length_568_cov_1.795960_g1963_i0 PRJNA1068513 2005 568 1.79596 10.2010528 archaeon 1906665 Archaea Archaea 105 1.82e-24   NR MDP2436777.1 1906665 g1963 i0 39.3 0.617957746478873 117 71 61.8 0 534 184 89 205 MDP2436777.1 dTMP kinase [archaeon] diamond 351 105 1 Archaea               archaeon
28709654 28709654 PRJNA1068513_S_NODE_6987_length_345_cov_2.860294_g6941_i0 PRJNA1068513 6987 345 2.860294 9.8680143 archaeon 1906665 Archaea Archaea 135 1.42e-34   NR MCQ2816260.1 1906665 g6941 i0 61.7 1.59130434782609 94 36 81.7 0 2 283 438 531 MCQ2816260.1 hypothetical protein [archaeon] diamond 549 135 1 Archaea               archaeon
29309341 29309341 PRJNA1068513_S_NODE_5649_length_382_cov_5.559871_g5603_i0 PRJNA1068513 5649 382 5.559871 21.23870722 Methanobacteriota archaeon 2026739 Archaea Archaea 47 0.00521   NR MDC0212646.1 2026739 g5603 i0 32.8 0.455497382198953 58 39 45.5 0 56 229 363 420 MDC0212646.1 thymidine phosphorylase [Methanobacteriota archaeon] diamond 174 47 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
31070145 31070145 PRJNA1068513_S_NODE_4615_length_421_cov_1.804598_g4570_i0 PRJNA1068513 4615 421 1.804598 7.59735758 Archaea 2157 Archaea Archaea 104 3.44e-25   NR MEM3335614.1 1906666 g4570 i0 45 2.54394299287411 120 60 83.4 3 4 354 53 169 MEM3335614.1 thermonuclease family protein [Thermoplasmata archaeon] diamond 1071 105 0.990476190476191 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32113797 32113797 PRJNA1068513_S_NODE_8518_length_310_cov_1.666667_g8472_i0 PRJNA1068513 8518 310 1.666667 5.1666677 Caldisphaera 200414 Archaea Archaea 56.6 1.08e-7   NR WP_015233053.1 200415 g8472 i0 42.6 2.23548387096774 61 33 59 1 200 18 55 113 WP_015233053.1 ribonuclease P protein component 4 [Caldisphaera lagunensis] diamond 693 57 0.992982456140351 Archaea   Thermoproteati Thermoproteota Thermoprotei Acidilobales Caldisphaeraceae Caldisphaera Caldisphaera lagunensis
32619614 32619614 PRJNA1068513_S_NODE_13720_length_231_cov_2.822785_g13674_i0 PRJNA1068513 13720 231 2.822785 6.52063335 Methanothermobacter 145260 Archaea Archaea 92 1.31e-20   NR WP_112094136.1 680118 g13674 i0 57.3 3.87012987012987 75 32 97.4 0 1 225 176 250 WP_112094136.1 fumarylacetoacetate hydrolase family protein [Methanothermobacter tenebrarum] diamond 894 92 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanothermobacter Methanothermobacter tenebrarum

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