RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA688931" 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

  • PRJNA688931 · 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
1944410 1944410 PRJNA688931_P_NODE_15822_length_259_cov_1.380952_g15609_i0 PRJNA688931 15822 259 1.380952 3.57666568 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 164 6.48e-50   NR ADK47156.1 323453 g15609 i0 94.2 0.996138996138996 86 5 99.6 0 259 2 9 94 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 258 164 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
17246393 17246393 PRJNA688931_P_NODE_28214_length_191_cov_2.260563_g28001_i0 PRJNA688931 28214 191 2.260563 4.31767533 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 119 5.04e-33   NR ADK26622.1 323453 g28001 i0 93.7 0.989528795811518 63 4 99 0 1 189 14 76 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 189 119 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
27998446 27998446 PRJNA688931_P_NODE_24445_length_207_cov_1.050633_g24232_i0 PRJNA688931 24445 207 1.050633 2.17481031 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.4 9.47e-18   NR MES1911297.1 1215613 g24232 i0 74.5 0.681159420289855 47 12 68.1 0 47 187 106 152 MES1911297.1 hypothetical protein [Cercozoa sp. M6MM] diamond 141 82.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28167743 28167743 PRJNA688931_P_NODE_19925_length_229_cov_1.727778_g19712_i0 PRJNA688931 19925 229 1.727778 3.95661162 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 8.42e-26   NR AAY21202.1 227086 g19712 i0 71.6 5.77729257641921 74 21 96.9 0 222 1 40 113 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 1323 103 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28977215 28977215 PRJNA688931_P_NODE_27068_length_196_cov_1.408163_g26855_i0 PRJNA688931 27068 196 1.408163 2.75999948 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.4 4.5e-4   NR MES1916150.1 1215613 g26855 i0 41 0.933673469387755 61 34 93.4 1 2 184 15 73 MES1916150.1 hypothetical protein [Cercozoa sp. M6MM] diamond 183 47.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30208428 30208428 PRJNA688931_P_NODE_7272_length_403_cov_1.720339_g7059_i0 PRJNA688931 7272 403 1.720339 6.93296617 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.22e-4   NR MES1907423.1 1215613 g7059 i0 30.2 0.937965260545906 126 72 89.3 5 366 7 83 198 MES1907423.1 hypothetical protein [Cercozoa sp. M6MM] diamond 378 50.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30745808 30745808 PRJNA688931_P_NODE_24434_length_207_cov_1.170886_g24221_i0 PRJNA688931 24434 207 1.170886 2.42373402 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.48e-5   NR MES1913617.1 1215613 g24221 i0 47.1 0.739130434782609 51 26 73.9 1 207 55 124 173 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 50.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31251317 31251317 PRJNA688931_P_NODE_37335_length_167_cov_0.872881_g37122_i0 PRJNA688931 37335 167 0.872881 1.45771127 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 61.2 3.92e-9   NR MES1910094.1 1215613 g37122 i0 49.1 7.94011976047904 57 23 97 2 5 166 126 179 MES1910094.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1326 61.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31642291 31642291 PRJNA688931_P_NODE_16276_length_255_cov_1.276699_g16063_i0 PRJNA688931 16276 255 1.276699 3.25558245 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.41e-9   NR MES1915500.1 1215613 g16063 i0 40.5 6.91764705882353 74 44 87.1 0 227 6 185 258 MES1915500.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1764 63.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32232293 32232293 PRJNA688931_P_NODE_30878_length_182_cov_1.721805_g30665_i0 PRJNA688931 30878 182 1.721805 3.1336851 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 119 4.44e-33   NR ADK26622.1 323453 g30665 i0 93.2 0.972527472527473 59 4 97.3 0 181 5 70 128 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 177 119 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
32358855 32358855 PRJNA688931_P_NODE_16779_length_250_cov_2.815920_g16566_i0 PRJNA688931 16779 250 2.81592 7.0398 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.1 3.1e-8   NR MES1916036.1 1215613 g16566 i0 39.1 2.496 69 42 82.8 0 217 11 6 74 MES1916036.1 hypothetical protein [Cercozoa sp. M6MM] diamond 624 60.1 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);;