RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 6 ✖

bioproject 1

  • PRJEB12237 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_phylum 0

tax_kingdom 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
7672882 7672882 PRJEB12237_P_NODE_307_length_1246_cov_5.184145_g230_i0 PRJEB12237 307 1246 5.184145 64.5944467 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 385 3.75e-129   NR XP_013760592.1 461836 g230 i0 64.6 0.76083467094703106 316 102 75.4 4 1197 259 31 339 XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] diamond 948 385 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
27127404 27127404 PRJEB12237_P_NODE_2302_length_467_cov_1.655093_g2107_i0 PRJEB12237 2302 467 1.655093 7.72928431 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 86.7 2.64e-18   NR XP_013758370.1 461836 g2107 i0 39.7 0.745182012847966 116 69 73.9 1 465 121 33 148 XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] diamond 348 86.7 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
28801351 28801351 PRJEB12237_P_NODE_8008_length_195_cov_1.500000_g7812_i0 PRJEB12237 8008 195 1.5 2.925 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 77.4 2.07e-15   NR XP_013759670.1 461836 g7812 i0 53.1 1.96923076923077 64 30 98.5 0 194 3 162 225 XP_013759670.1 countin-2 [Thecamonas trahens ATCC 50062] diamond 384 77.4 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
29615800 29615800 PRJEB12237_P_NODE_9810_length_171_cov_1.169118_g9614_i0 PRJEB12237 9810 171 1.169118 1.99919178 root 1 Root_unresolved Root_unresolved 82 9.79e-17   NR XP_013758464.1 461836 g9614 i0 68.5 2.98245614035088 54 17 94.7 0 2 163 229 282 XP_013758464.1 beta-keto acyl reductase [Thecamonas trahens ATCC 50062] diamond 510 82.8 0.990338164251208 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
30033109 30033109 PRJEB12237_P_NODE_6971_length_215_cov_1.777778_g6775_i0 PRJEB12237 6971 215 1.777778 3.8222227 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 87.4 3.41e-18   NR XP_013753190.1 461836 g6775 i0 53.4 1.01860465116279 73 28 96.3 2 215 9 304 374 XP_013753190.1 uncharacterized protein AMSG_12392 [Thecamonas trahens ATCC 50062] diamond 219 87.4 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
31170179 31170179 PRJEB12237_P_NODE_12075_length_151_cov_1.025862_g11879_i0 PRJEB12237 12075 151 1.025862 1.54905162 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 60.1 8.03e-9   NR XP_013753190.1 461836 g11879 i0 46.3 1.0728476821192101 54 23 99.3 2 2 151 323 374 XP_013753190.1 uncharacterized protein AMSG_12392 [Thecamonas trahens ATCC 50062] diamond 162 60.1 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens

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