RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA688931", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA688931 · 21 ✖

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
668504 668504 PRJNA688931_P_NODE_29761_length_186_cov_1.459854_g29548_i0 PRJNA688931 29761 186 1.459854 2.71532844 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 159 9.11e-35   NTclustered gi|238617605|gb|FJ973380.1| 45107 g29548 i0 86.275 28.8709677419355 153 13 80 5 1 149 1647 1795 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 5370 159 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
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
5772001 5772001 PRJNA688931_P_NODE_13985_length_277_cov_1.982456_g13772_i0 PRJNA688931 13985 277 1.982456 5.49140312 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 121 6.89e-23   NTclustered gi|1315527750|gb|MF034900.1| 2065209 g13772 i0 85.593 47.2851985559567 118 13 43 2 1 118 8749 8862 Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 13098 121 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
5772011 5772011 PRJNA688931_P_NODE_15445_length_262_cov_2.023474_g15232_i0 PRJNA688931 15445 262 2.023474 5.30150188 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 246 1.02e-60   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g15232 i0 83.895 41.8129770992366 267 33 100 10 1 262 3986 3725 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 10955 246 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
7556027 7556027 PRJNA688931_P_NODE_39426_length_165_cov_0.896552_g39213_i0 PRJNA688931 39426 165 0.896552 1.4793108 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 305 9.59e-79   NTclustered gi|1002343613|gb|KU738491.1| 175275 g39213 i0 100 96.6727272727273 165 0 100 0 1 165 40 204 Uncultured Cercozoa clone OTU_433 18S ribosomal RNA gene, partial sequence blastn 15951 305 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
8321609 8321609 PRJNA688931_P_NODE_24027_length_209_cov_0.968750_g23814_i0 PRJNA688931 24027 209 0.96875 2.0246875 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 326 9.78e-85   NTclustered gi|238617605|gb|FJ973380.1| 45107 g23814 i0 94.737 96.2248803827751 209 11 100 0 1 209 1642 1434 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 20111 326 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
12147820 12147820 PRJNA688931_P_NODE_27790_length_193_cov_1.430556_g27577_i0 PRJNA688931 27790 193 1.430556 2.76097308 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 139 1.2399999999999999e-28   NTclustered gi|160337355|gb|EF455774.1| 439948 g27577 i0 90.476 8.32124352331606 105 10 54 0 89 193 465 361 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 1606 139 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
14697639 14697639 PRJNA688931_P_NODE_9172_length_351_cov_2.059603_g8959_i0 PRJNA688931 9172 351 2.059603 7.22920653 Bodomorpha sp. HFCC 927 1043717 SAR_Eukaryotes SAR_Eukaryotes 477 4.619999999999999e-130   NTclustered gi|336245481|gb|HM536172.1| 1043717 g8959 i0 91.218 99.97150997151 353 27 100 4 1 351 1297 1647 Bodomorpha sp. HFCC 927 18S ribosomal RNA gene, partial sequence blastn 35090 477 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 927
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
17246474 17246474 PRJNA688931_P_NODE_37934_length_166_cov_1.435897_g37721_i0 PRJNA688931 37934 166 1.435897 2.38358902 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 169 1.32e-37   NTclustered gi|160337400|gb|EF455798.1| 439948 g37721 i0 84.94 98.6084337349398 166 25 100 0 1 166 650 485 Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds blastn 16369 169 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
21580288 21580288 PRJNA688931_P_NODE_40677_length_164_cov_0.904348_g40464_i0 PRJNA688931 40677 164 0.904348 1.48313072 Imbricatea 1736114 SAR_Eukaryotes SAR_Eukaryotes 71.3 3.78e-8   NTclustered gi|290760486|gb|GQ144689.1| 361427 g40464 i0 97.561 7.21341463414634 41 1 25 0 124 164 2257 2297 Protaspis grandis large subunit ribosomal RNA gene, partial sequence blastn 1183 71.3 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Protaspis Protaspis grandis
24894690 24894690 PRJNA688931_P_NODE_27440_length_194_cov_2.703448_g27227_i0 PRJNA688931 27440 194 2.703448 5.24468912 uncultured Bodomorpha 1586269 SAR_Eukaryotes SAR_Eukaryotes 305 1.16e-78   NTclustered gi|1723854301|gb|MN323309.1| 1586269 g27227 i0 100 92.5721649484536 165 0 85 0 1 165 162 326 Uncultured Bodomorpha clone OTU0038 small subunit ribosomal RNA gene, partial sequence blastn 17959 305 1 Eukaryota Sar   Cercozoa   Glissomonadida     uncultured Bodomorpha
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);;