RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA543299" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 12 ✖

bioproject 1

  • PRJNA543299 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26761276 26761276 PRJNA543299_P_NODE_21401_length_166_cov_0.871795_g21244_i0 PRJNA543299 21401 166 0.871795 1.4471797 Methanosarcina sp. 2213 Archaea Archaea 85.5 6.280000000000001e-19   NR HET8686576.1 2213 g21244 i0 79.6 0.975903614457831 54 10 97.6 1 3 164 51 103 HET8686576.1 ERF family protein [Methanosarcina sp.] diamond 162 85.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
27282496 27282496 PRJNA543299_P_NODE_26103_length_161_cov_0.910714_g25946_i0 PRJNA543299 26103 161 0.910714 1.46624954 root 1 Root_unresolved Root_unresolved 63.5 9.24e-11   NR MEK6885171.1 2026764 g25946 i0 49.1 1.97515527950311 53 27 98.8 0 1 159 49 101 MEK6885171.1 hypothetical protein [Nanoarchaeota archaeon] diamond 318 63.9 0.993740219092332 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
27330879 27330879 PRJNA543299_P_NODE_20363_length_167_cov_0.864407_g20206_i0 PRJNA543299 20363 167 0.864407 1.44355969 archaeon 1906665 Archaea Archaea 45.1 7.02e-4   NR MCP4763926.1 1906665 g20206 i0 41.5 0.952095808383233 53 31 95.2 0 159 1 28 80 MCP4763926.1 hypothetical protein [archaeon] diamond 159 45.1 1 Archaea               archaeon
27330880 27330880 PRJNA543299_P_NODE_22183_length_165_cov_0.879310_g22026_i0 PRJNA543299 22183 165 0.87931 1.4508615 Methanoregulaceae archaeon 2485498 Archaea Archaea 54.3 1.04e-6   NR MDD1710164.1 2485498 g22026 i0 47.2 1.92727272727273 53 28 96.4 0 164 6 49 101 MDD1710164.1 DEAD/DEAH box helicase [Methanoregulaceae archaeon] diamond 318 54.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon
28372683 28372683 PRJNA543299_P_NODE_14606_length_196_cov_2.074830_g14449_i0 PRJNA543299 14606 196 2.07483 4.0666668 archaeon 1906665 Archaea Archaea 79.3 2.53e-15   NR NDB29541.1 1906665 g14449 i0 70.2 1.85204081632653 57 17 87.2 0 172 2 423 479 NDB29541.1 hypothetical protein [archaeon] diamond 363 79.3 1 Archaea               archaeon
28499221 28499221 PRJNA543299_P_NODE_23147_length_164_cov_0.886957_g22990_i0 PRJNA543299 23147 164 0.886957 1.45460948 Methanosarcina sp. 2213 Archaea Archaea 62 8.76e-10   NR HET8686002.1 2213 g22990 i0 62.2 1.70121951219512 45 17 82.3 0 29 163 74 118 HET8686002.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Methanosarcina sp.] diamond 279 62 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
28846205 28846205 PRJNA543299_P_NODE_23908_length_163_cov_0.894737_g23751_i0 PRJNA543299 23908 163 0.894737 1.45842131 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 83.6 5.17e-17   NR MCK5602728.1 2026773 g23751 i0 70.4 1.98773006134969 54 16 99.4 0 163 2 569 622 MCK5602728.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 324 83.6 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30394306 30394306 PRJNA543299_P_NODE_25893_length_161_cov_0.910714_g25736_i0 PRJNA543299 25893 161 0.910714 1.46624954 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 47 6.66e-5   NR MEM4271259.1 2026773 g25736 i0 65.5 0.540372670807453 29 10 54 0 159 73 66 94 MEM4271259.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 87 47 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30709714 30709714 PRJNA543299_P_NODE_24414_length_163_cov_0.894737_g24257_i0 PRJNA543299 24414 163 0.894737 1.45842131 Nitrososphaerota archaeon 2026795 Archaea Archaea 96.3 1.11e-21   NR MDE1868057.1 2026795 g24257 i0 81.6 0.901840490797546 49 9 90.2 0 162 16 261 309 MDE1868057.1 hypothetical protein [Nitrososphaerota archaeon] diamond 147 96.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31135080 31135080 PRJNA543299_P_NODE_19435_length_170_cov_1.685950_g19278_i0 PRJNA543299 19435 170 1.68595 2.866115 root 1 Root_unresolved Root_unresolved 45.8 0.00109   NR MAG27506.1 2026773 g19278 i0 34.6 1.83529411764706 52 34 91.8 0 164 9 211 262 MAG27506.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 312 45.8 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
32132835 32132835 PRJNA543299_P_NODE_13058_length_207_cov_1.291139_g12901_i0 PRJNA543299 13058 207 1.291139 2.67265773 archaeon 1906665 Archaea Archaea 50.4 4.61e-5   NR NDB54942.1 1906665 g12901 i0 42.6 2.39130434782609 54 30 76.8 1 7 165 620 673 NDB54942.1 hypothetical protein [archaeon] diamond 495 50.4 1 Archaea               archaeon
32464116 32464116 PRJNA543299_P_NODE_22419_length_165_cov_0.879310_g22262_i0 PRJNA543299 22419 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 53.5 1.11e-6   NR UCH72515.1 2268204 g22262 i0 55.1 1.81818181818182 49 20 85.5 1 6 146 54 102 UCH72515.1 MAG: HD domain-containing protein [Thermoplasmatales archaeon] diamond 300 53.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon

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