RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJDB14275" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 5 ✖

bioproject 1

  • PRJDB14275 · 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
27443592 27443592 PRJDB14275_P_NODE_2983_length_359_cov_1.615625_g2924_i0 PRJDB14275 2983 359 1.615625 5.80009375 Candidatus Micrarchaeia archaeon 3018267 Archaea Archaea 67 3.39e-10   NR HUB58959.1 3018267 g2924 i0 30.9 0.919220055710306 110 75 91.1 1 348 22 194 303 HUB58959.1 DUF4238 domain-containing protein [Candidatus Micrarchaeia archaeon] diamond 330 67 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia       Candidatus Micrarchaeia archaeon
28485241 28485241 PRJDB14275_P_NODE_5667_length_201_cov_0.993827_g5608_i0 PRJDB14275 5667 201 0.993827 1.99759227 archaeon 1906665 Archaea Archaea 117 9.13e-30   NR NCQ51651.1 1906665 g5608 i0 78.8 0.985074626865672 66 14 98.5 0 3 200 258 323 NCQ51651.1 radical SAM protein [archaeon] diamond 198 117 1 Archaea               archaeon
29489548 29489548 PRJDB14275_P_NODE_5530_length_205_cov_1.668675_g5471_i0 PRJDB14275 5530 205 1.668675 3.42078375 root 1 Root_unresolved Root_unresolved 75.1 1.24e-14   NR NCQ51472.1 1906665 g5471 i0 61.8 2.76585365853659 55 20 79 1 44 205 16 70 NCQ51472.1 arylesterase [archaeon] diamond 567 75.1 1 Archaea               archaeon
32207927 32207927 PRJDB14275_P_NODE_5998_length_192_cov_1.052288_g5939_i0 PRJDB14275 5998 192 1.052288 2.02039296 root 1 Root_unresolved Root_unresolved 43.1 0.0143   NR NIT79663.1 1906666 g5939 i0 42.1 1.25 38 22 59.4 0 189 76 500 537 NIT79663.1 hypothetical protein [Thermoplasmata archaeon] diamond 240 43.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32372108 32372108 PRJDB14275_P_NODE_6719_length_175_cov_1.205882_g6660_i0 PRJDB14275 6719 175 1.205882 2.1102935 archaeon 1906665 Archaea Archaea 85.1 7.34e-18   NR NCQ51808.1 1906665 g6660 i0 63.6 0.942857142857143 55 20 94.3 0 3 167 232 286 NCQ51808.1 hypothetical protein [archaeon] diamond 165 85.1 1 Archaea               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);;