RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 5 ✖

bioproject 1

  • PRJNA591000 · 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
27490557 27490557 PRJNA591000_P_NODE_6003_length_586_cov_5.403950_g4739_i0 PRJNA591000 6003 586 5.40395 31.667147 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 131 1.3899999999999998e-32   NR MEM0462392.1 2972665 g4739 i0 42.6 0.829351535836177 162 76 82.9 4 77 562 152 296 MEM0462392.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 486 131 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
28690517 28690517 PRJNA591000_P_NODE_1307_length_1044_cov_29.208867_g924_i0 PRJNA591000 1307 1044 29.208867 304.94057148 Candidatus Methanomethylicaceae archaeon 2282146 Archaea Archaea 79.3 1.6e-14   NR MEM4203788.1 3058293 g924 i0 42 0.252873563218391 88 51 25.3 0 28 291 1 88 MEM4203788.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] diamond 264 79.3 1 Archaea   Thermoproteati Candidatus Methanomethylicota Candidatus Methanomethylicia Candidatus Methanomethylicales Candidatus Methanomethylicaceae   Candidatus Methanomethylicaceae archaeon
30237676 30237676 PRJNA591000_P_NODE_3272_length_775_cov_5.408847_g2523_i0 PRJNA591000 3272 775 5.408847 41.91856425 Nitrososphaerales archaeon 2268197 Archaea Archaea 45.8 0.0278   NR MEM3097556.1 2268197 g2523 i0 50 0.139354838709677 36 18 13.9 0 88 195 98 133 MEM3097556.1 hypothetical protein [Nitrososphaerales archaeon] diamond 108 45.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
30996039 30996039 PRJNA591000_P_NODE_8634_length_473_cov_5.367117_g7105_i0 PRJNA591000 8634 473 5.367117 25.38646341 Nitrosopumilus sp. 2024843 Archaea Archaea 115 2.17e-26   NR MEK0324841.1 2024843 g7105 i0 46.2 0.837209302325581 132 71 83.7 0 73 468 242 373 MEK0324841.1 DNA polymerase [Nitrosopumilus sp.] diamond 396 115 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
31343716 31343716 PRJNA591000_P_NODE_5576_length_617_cov_2.865646_g4396_i0 PRJNA591000 5576 617 2.865646 17.68103582 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 105 2.4899999999999998e-23   NR HXF90561.1 2507556 g4396 i0 41.9 0.627228525121556 129 67 58.8 3 370 8 18 146 HXF90561.1 class I SAM-dependent methyltransferase [Candidatus Nitrosotenuis sp.] diamond 387 105 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.

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