RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 3 ✖

bioproject 1

  • PRJNA849822 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
2114210 2114210 PRJNA849822_P_NODE_8582_length_516_cov_1.505643_g8410_i0 PRJNA849822 8582 516 1.505643 7.76911788 Thecamonas trahens 529818 Root_unresolved Root_unresolved 244 7.769999999999999e-60   NTclustered gi|923134252|ref|XM_013905138.1| 461836 g8410 i0 77.99 32.015503875969 418 72 78 15 112 516 198 608 Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA blastn 16520 244 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
5061612 5061612 PRJNA849822_P_NODE_9844_length_477_cov_2.702970_g9671_i0 PRJNA849822 9844 477 2.70297 12.8931669 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 296 1.94e-75   NTclustered gi|923119727|ref|XM_013897883.1| 461836 g9671 i0 89.956 67.6457023060797 229 23 48 0 148 376 13 241 Thecamonas trahens ATCC 50062 ubiquitin-60S ribosomal protein L40 (AMSG_10625), partial mRNA blastn 32267 296 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
9766631 9766631 PRJNA849822_P_NODE_22248_length_307_cov_1.418803_g22074_i0 PRJNA849822 22248 307 1.418803 4.35572521 Thecamonas trahens 529818 Root_unresolved Root_unresolved 252 2.63e-62   NTclustered gi|923133140|ref|XM_013904582.1| 461836 g22074 i0 82.517 67.5765472312704 286 50 93 0 2 287 31 316 Thecamonas trahens ATCC 50062 Ras-like protein rasG (AMSG_03185), partial mRNA blastn 20746 252 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);;