RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA379145" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA379145 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
400750 400750 PRJNA379145_P_NODE_23181_length_529_cov_2.034274_g21201_i0 PRJNA379145 23181 529 2.034274 10.76130946 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 150 4.05e-41   NR MES1911029.1 1215613 g21201 i0 53.8 0.88468809073724 156 66 86.2 3 3 458 152 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 468 150 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
8726700 8726700 PRJNA379145_P_NODE_34767_length_355_cov_2.130435_g32621_i0 PRJNA379145 34767 355 2.130435 7.56304425 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 155 7.52e-44   NR MES1911029.1 1215613 g32621 i0 65.6 1.05633802816901 125 31 95.5 1 342 4 1 125 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 375 155 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
16978039 16978039 PRJNA379145_P_NODE_23074_length_531_cov_1.718876_g21099_i0 PRJNA379145 23074 531 1.718876 9.12723156 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 244 1.89e-78   NR ADK26624.1 323453 g21099 i0 69.1 1.00564971751412 178 49 99.4 2 529 2 13 186 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 534 244 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
18252535 18252535 PRJNA379145_P_NODE_41355_length_292_cov_1.362934_g39204_i0 PRJNA379145 41355 292 1.362934 3.97976728 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 138 4.5299999999999997e-39   NR MES1913389.1 1215613 g39204 i0 60.8 4.98287671232877 97 38 99.7 0 291 1 68 164 MES1913389.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1455 138 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19526618 19526618 PRJNA379145_P_NODE_30256_length_413_cov_1.721053_g28136_i0 PRJNA379145 30256 413 1.721053 7.10794889 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 112 1.25e-27   NR MES1912193.1 1215613 g28136 i0 59.8 2.47699757869249 107 43 77.7 0 91 411 6 112 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 1023 112 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24025744 24025744 PRJNA379145_P_NODE_17099_length_669_cov_8.069182_g15368_i0 PRJNA379145 17099 669 8.069182 53.98282758 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 285 1.0799999999999999e-94   NR BBE07970.1 1928728 g15368 i0 69.6 17.4260089686099 194 56 87 1 61 642 1 191 BBE07970.1 Ras-related protein Rac1 [Paulinella micropora] diamond 11658 285 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
27707228 27707228 PRJNA379145_P_NODE_62384_length_180_cov_7.006803_g60230_i0 PRJNA379145 62384 180 7.006803 12.6122454 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94.4 5.919999999999999e-24   NR MES1911722.1 1215613 g60230 i0 78.8 0.866666666666667 52 11 86.7 0 174 19 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 94.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28274954 28274954 PRJNA379145_P_NODE_17526_length_657_cov_2.658654_g15772_i0 PRJNA379145 17526 657 2.658654 17.46735678 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 161 3.25e-44   NR MES1910251.1 1215613 g15772 i0 77.1 1.31506849315068 96 21 43.8 1 1 288 189 283 MES1910251.1 hypothetical protein [Cercozoa sp. M6MM] diamond 864 161 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28938209 28938209 PRJNA379145_P_NODE_14968_length_737_cov_1.899148_g13360_i0 PRJNA379145 14968 737 1.899148 13.99672076 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 125 5.76e-31   NR MES1909203.1 1215613 g13360 i0 44.8 0.924016282225237 116 64 47.2 0 373 720 82 197 MES1909203.1 hypothetical protein [Cercozoa sp. M6MM] diamond 681 125 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29853928 29853928 PRJNA379145_P_NODE_70671_length_158_cov_1.456000_g68516_i0 PRJNA379145 70671 158 1.456 2.30048 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.8 1.6e-19   NR MES1911722.1 1215613 g68516 i0 75.5 0.930379746835443 49 12 93 0 10 156 1 49 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 147 82.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30043341 30043341 PRJNA379145_P_NODE_72071_length_154_cov_8.214876_g69916_i0 PRJNA379145 72071 154 8.214876 12.65090904 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.6 7.87e-22   NR MES1911722.1 1215613 g69916 i0 79.6 0.954545454545455 49 10 95.5 0 148 2 1 49 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 147 88.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30706786 30706786 PRJNA379145_P_NODE_38534_length_316_cov_1.833922_g36383_i0 PRJNA379145 38534 316 1.833922 5.79519352 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.09e-16   NR MES1908489.1 1215613 g36383 i0 82.6 0.873417721518987 46 8 43.7 0 314 177 394 439 MES1908489.1 hypothetical protein [Cercozoa sp. M6MM] diamond 276 85.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30991308 30991308 PRJNA379145_P_NODE_21414_length_564_cov_2.291902_g19501_i0 PRJNA379145 21414 564 2.291902 12.92632728 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82 1.64e-15   NR MES1906886.1 1215613 g19501 i0 54.3 1.23936170212766 81 35 43.1 1 244 2 115 193 MES1906886.1 hypothetical protein [Cercozoa sp. M6MM] diamond 699 82 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31338824 31338824 PRJNA379145_P_NODE_24296_length_508_cov_2.618947_g22284_i0 PRJNA379145 24296 508 2.618947 13.30425076 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 138 6.56e-37   NR ADK26624.1 323453 g22284 i0 75.3 0.501968503937008 85 21 50.2 0 2 256 192 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 255 138 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
31749932 31749932 PRJNA379145_P_NODE_3257_length_1574_cov_43.150552_g2816_i0 PRJNA379145 3257 1574 43.150552 679.18968848 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 270 1.89e-83   NR MES1914135.1 1215613 g2816 i0 56.3 0.466963151207116 245 98 46.3 3 960 232 21 258 MES1914135.1 hypothetical protein [Cercozoa sp. M6MM] diamond 735 270 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32129938 32129938 PRJNA379145_P_NODE_34298_length_360_cov_2.522936_g32153_i0 PRJNA379145 34298 360 2.522936 9.0825696 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 61.2 7.27e-9   NR MES1908819.1 1215613 g32153 i0 48.3 0.483333333333333 58 30 48.3 0 95 268 57 114 MES1908819.1 hypothetical protein [Cercozoa sp. M6MM] diamond 174 61.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32730186 32730186 PRJNA379145_P_NODE_36700_length_334_cov_1.435216_g34552_i0 PRJNA379145 36700 334 1.435216 4.79362144 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 102 5.3e-24   NR MES1909203.1 1215613 g34552 i0 53 4.54491017964072 100 44 87.1 2 15 305 122 221 MES1909203.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1518 102 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32761559 32761559 PRJNA379145_P_NODE_18980_length_621_cov_1.891156_g17153_i0 PRJNA379145 18980 621 1.891156 11.74407876 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 173 1.95e-51   NR AAT09077.1 227086 g17153 i0 63 1.33816425120773 138 51 66.7 0 617 204 16 153 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 831 173 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);;