RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 11 ✖

tax_clade 1

bioproject 1

  • PRJEB14803 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
21698148 21698148 PRJEB14803_P_NODE_27138_length_211_cov_1.454545_g26672_i0 PRJEB14803 27138 211 1.454545 3.06908995 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 77.8 7.45e-15   NR MES1909649.1 1215613 g26672 i0 69.6 1.63507109004739 56 17 79.6 0 42 209 6 61 MES1909649.1 Fructose-bisphosphate aldolase 6, cytosolic [Cercozoa sp. M6MM] diamond 345 77.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26652950 26652950 PRJEB14803_P_NODE_20901_length_251_cov_2.032407_g20435_i0 PRJEB14803 20901 251 2.032407 5.10134157 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.43e-6   NR MES1915844.1 1215613 g20435 i0 48.9 1.75697211155378 45 23 53.8 0 136 2 2 46 MES1915844.1 hypothetical protein [Cercozoa sp. M6MM] diamond 441 53.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27033077 27033077 PRJEB14803_P_NODE_41162_length_162_cov_10.937008_g40696_i0 PRJEB14803 41162 162 10.937008 17.71795296 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.38e-18   NR MES1911722.1 1215613 g40696 i0 72.9 0.888888888888889 48 13 88.9 0 157 14 1 48 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 144 80.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27602036 27602036 PRJEB14803_P_NODE_47584_length_150_cov_1.043478_g47118_i0 PRJEB14803 47584 150 1.043478 1.565217 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00295   NR MES1908756.1 1215613 g47118 i0 40.9 0.88 44 26 88 0 2 133 388 431 MES1908756.1 hypothetical protein [Cercozoa sp. M6MM] diamond 132 44.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28233058 28233058 PRJEB14803_P_NODE_41246_length_162_cov_1.889764_g40780_i0 PRJEB14803 41246 162 1.889764 3.06141768 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 69.7 2.48e-13   NR ADK47156.1 323453 g40780 i0 72.1 0.796296296296296 43 12 79.6 0 32 160 1 43 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 129 69.7 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29811860 29811860 PRJEB14803_P_NODE_40811_length_163_cov_1.921875_g40345_i0 PRJEB14803 40811 163 1.921875 3.13265625 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 66.2 6.23e-11   NR MES1907262.1 1215613 g40345 i0 58.5 2.9079754601227 53 22 97.5 0 161 3 611 663 MES1907262.1 hypothetical protein [Cercozoa sp. M6MM] diamond 474 66.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30127597 30127597 PRJEB14803_P_NODE_14572_length_319_cov_1.672535_g14106_i0 PRJEB14803 14572 319 1.672535 5.33538665 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 98.2 1.87e-22   NR MES1911396.1 1215613 g14106 i0 45.3 0.893416927899687 95 49 89.3 1 22 306 141 232 MES1911396.1 hypothetical protein [Cercozoa sp. M6MM] diamond 285 98.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30222616 30222616 PRJEB14803_P_NODE_35272_length_179_cov_1.277778_g34806_i0 PRJEB14803 35272 179 1.277778 2.28722262 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 77.4 2.56e-15   NR MES1907718.1 1215613 g34806 i0 62.7 0.988826815642458 59 22 98.9 0 3 179 17 75 MES1907718.1 hypothetical protein [Cercozoa sp. M6MM] diamond 177 77.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32587761 32587761 PRJEB14803_P_NODE_13179_length_340_cov_2.114754_g12714_i0 PRJEB14803 13179 340 2.114754 7.1901636 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.3 4.71e-17   NR MES1915627.1 1215613 g12714 i0 50.7 2.57647058823529 73 36 64.4 0 327 109 355 427 MES1915627.1 hypothetical protein [Cercozoa sp. M6MM] diamond 876 87 0.991954022988506 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32594065 32594065 PRJEB14803_P_NODE_18300_length_274_cov_3.543933_g17834_i0 PRJEB14803 18300 274 3.543933 9.71037642 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.5 6.4e-16   NR MES1916707.1 1215613 g17834 i0 50.7 1.5 67 33 73.4 0 252 52 180 246 MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] diamond 411 80.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32625336 32625336 PRJEB14803_P_NODE_23840_length_230_cov_1.641026_g23374_i0 PRJEB14803 23840 230 1.641026 3.7743598 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 75.9 1.56e-15   NR MES1914773.1 1215613 g23374 i0 68 0.652173913043478 50 16 65.2 0 229 80 72 121 MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] diamond 150 75.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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