RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJDB3785" and tax_clade = "Apusozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • Apusozoa · 4 ✖

bioproject 1

  • PRJDB3785 · 4 ✖

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
17860825 17860825 PRJDB3785_S_NODE_8795_length_254_cov_1.707317_g8642_i0 PRJDB3785 8795 254 1.707317 4.33658518 Thecamonas trahens 529818 Root_unresolved Root_unresolved 204 6.02e-48   NTclustered gi|923132712|ref|XM_013904368.1| 461836 g8642 i0 81.275 14.1850393700787 251 47 99 0 4 254 867 617 Thecamonas trahens ATCC 50062 actin-like protein 3 (AMSG_03466), partial mRNA blastn 3603 204 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
26900067 26900067 PRJDB3785_S_NODE_10781_length_231_cov_0.840659_g10628_i0 PRJDB3785 10781 231 0.840659 1.94192229 root 1 Root_unresolved Root_unresolved 67.4 4.45e-11   NR XP_013752722.1 461836 g10628 i0 42.5 2.84415584415584 73 41 94.8 1 227 9 189 260 XP_013752722.1 uncharacterized protein AMSG_11369 [Thecamonas trahens ATCC 50062] diamond 657 67.4 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
28864047 28864047 PRJDB3785_S_NODE_26708_length_162_cov_0.876106_g26555_i0 PRJDB3785 26708 162 0.876106 1.41929172 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 67.8 1.67e-11   NR XP_013761312.1 461836 g26555 i0 63 1 54 18 96.3 2 157 2 330 383 XP_013761312.1 carboxylic ester hydrolase [Thecamonas trahens ATCC 50062] diamond 162 67.8 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
29868634 29868634 PRJDB3785_S_NODE_26791_length_161_cov_3.125000_g26638_i0 PRJDB3785 26791 161 3.125 5.03125 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.1 1.5e-16   NR XP_013754328.1 461836 g26638 i0 69.8 5.8695652173913 53 16 98.8 0 2 160 68 120 XP_013754328.1 60S ribosomal protein L7 [Thecamonas trahens ATCC 50062] diamond 945 80.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);;