RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Micrarchaeota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Micrarchaeota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27823654 27823654 PRJEB64798_P_NODE_180264_length_174_cov_4.032000_g178498_i0 PRJEB64798 180264 174 4.032 7.01568 Candidatus Micrarchaeota archaeon CG1_ 2250274 Archaea Archaea 40 0.0294   NR OIO20839.1 1805247 g178498 i0 47.4 0.655172413793103 38 20 65.5 0 38 151 29 66 OIO20839.1 MAG: hypothetical protein AUJ17_05870 [Candidatus Micrarchaeota archaeon CG1_02_47_40] diamond 114 40 1 Archaea   Nanobdellati Candidatus Micrarchaeota         Candidatus Micrarchaeota archaeon CG1_02_47_40
29464919 29464919 PRJEB64798_P_NODE_184290_length_172_cov_11.398374_g182524_i0 PRJEB64798 184290 172 11.398374 19.60520328 Candidatus Anstonellaceae archaeon 2886383 Archaea Archaea 94.7 3.19e-22   NR MEM4554856.1 2886383 g182524 i0 80 0.959302325581395 55 11 95.9 0 167 3 19 73 MEM4554856.1 HK97 family phage prohead protease [Candidatus Anstonellaceae archaeon] diamond 165 94.7 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia Candidatus Anstonellales Candidatus Anstonellaceae   Candidatus Anstonellaceae archaeon
30697246 30697246 PRJEB64798_P_NODE_67554_length_236_cov_2.331551_g65789_i0 PRJEB64798 67554 236 2.331551 5.50246036 Candidatus Bilamarchaeum sp. 3070761 Archaea Archaea 61.6 3e-9   NR HSB46947.1 3070761 g65789 i0 53 0.838983050847458 66 31 83.9 0 200 3 1 66 HSB46947.1 aquaporin [Candidatus Bilamarchaeum sp.] diamond 198 61.6 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia Candidatus Anstonellales Candidatus Bilamarchaeaceae Candidatus Bilamarchaeum Candidatus Bilamarchaeum sp.
32657266 32657266 PRJEB64798_P_NODE_223740_length_161_cov_3.714286_g221974_i0 PRJEB64798 223740 161 3.714286 5.98000046 Candidatus Micrarchaeota archaeon 2250274 Archaea Archaea 62 1.93e-9   NR NYZ74718.1 2250274 g221974 i0 59.2 3.83850931677019 49 18 87.6 1 13 153 45 93 NYZ74718.1 hypothetical protein [Candidatus Micrarchaeota archaeon] diamond 618 62 1 Archaea   Nanobdellati Candidatus Micrarchaeota         Candidatus Micrarchaeota archaeon
32689007 32689007 PRJEB64798_P_NODE_236560_length_156_cov_5.822430_g234794_i0 PRJEB64798 236560 156 5.82243 9.0829908 Candidatus Anstonellaceae archaeon 2886383 Archaea Archaea 44.3 0.00336   NR MEM3362261.1 2886383 g234794 i0 38 0.961538461538462 50 31 96.2 0 7 156 123 172 MEM3362261.1 hypothetical protein [Candidatus Anstonellaceae archaeon] diamond 150 44.3 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia Candidatus Anstonellales Candidatus Anstonellaceae   Candidatus Anstonellaceae 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);;