RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
13356001 13356001 PRJNA630162_P_NODE_152431_length_164_cov_0.904348_g150908_i0 PRJNA630162 152431 164 0.904348 1.48313072 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94.4 1.6700000000000001e-22   NR MES1914063.1 1215613 g150908 i0 80.8 2.85365853658537 52 10 95.1 0 159 4 133 184 MES1914063.1 Arf GTPase arf1 [Cercozoa sp. M6MM] diamond 468 94.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
15904389 15904389 PRJNA630162_P_NODE_117373_length_176_cov_1.188976_g115850_i0 PRJNA630162 117373 176 1.188976 2.09259776 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 99.4 1.75e-22   NR MES1909201.1 1215613 g115850 i0 82.1 3.85227272727273 56 9 95.5 1 9 176 632 686 MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] diamond 678 99.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27965009 27965009 PRJNA630162_P_NODE_141625_length_166_cov_2.435897_g140102_i0 PRJNA630162 141625 166 2.435897 4.04358902 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 78.6 2.26e-15   NR AAO89069.1 227086 g140102 i0 69.8 0.957831325301205 53 16 95.8 0 6 164 87 139 AAO89069.1 cytosolic class I fructose-1,6-bisphosphate aldolase [Bigelowiella natans] diamond 159 78.6 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
29101783 29101783 PRJNA630162_P_NODE_114328_length_177_cov_2.210938_g112805_i0 PRJNA630162 114328 177 2.210938 3.91336026 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84.3 2.22e-18   NR MES1912850.1 1215613 g112805 i0 67.9 0.949152542372881 56 18 94.9 0 171 4 121 176 MES1912850.1 Ras-related protein Rab-5A [Cercozoa sp. M6MM] diamond 168 84.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29322649 29322649 PRJNA630162_P_NODE_140909_length_167_cov_0.881356_g139386_i0 PRJNA630162 140909 167 0.881356 1.47186452 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 45.8 1.43e-4   NR MES1916909.1 1215613 g139386 i0 54.5 1.58083832335329 44 20 79 0 133 2 32 75 MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] diamond 264 45.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29985906 29985906 PRJNA630162_P_NODE_138331_length_167_cov_1.686441_g136808_i0 PRJNA630162 138331 167 1.686441 2.81635647 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 68.6 7.17e-12   NR MES1913008.1 1215613 g136808 i0 56.9 3.01796407185629 58 21 97 1 2 163 183 240 MES1913008.1 hypothetical protein [Cercozoa sp. M6MM] diamond 504 68.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30807368 30807368 PRJNA630162_P_NODE_118194_length_175_cov_2.111111_g116671_i0 PRJNA630162 118194 175 2.111111 3.69444425 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.9 2.14e-16   NR MES1911029.1 1215613 g116671 i0 71.4 0.96 56 16 96 0 170 3 86 141 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 168 80.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31376368 31376368 PRJNA630162_P_NODE_126796_length_171_cov_1.450820_g125273_i0 PRJNA630162 126796 171 1.45082 2.4809022 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.02e-16   NR ADK26624.1 323453 g125273 i0 72.7 0.964912280701754 55 15 96.5 0 6 170 139 193 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 165 81.3 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
31692549 31692549 PRJNA630162_P_NODE_149577_length_164_cov_3.095652_g148054_i0 PRJNA630162 149577 164 3.095652 5.07686928 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 61.2 4.68e-10   NR AAT09102.1 227086 g148054 i0 52.9 0.932926829268293 51 24 93.3 0 10 162 40 90 AAT09102.1 cysteine proteinase, partial [Bigelowiella natans] diamond 153 61.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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