RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA1011844", 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 · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1011844 · 15 ✖

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
156632 156632 PRJNA1011844_P_NODE_17961_length_1335_cov_29.049921_g10580_i2 PRJNA1011844 17961 1335 29.049921 387.81644535 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 7.85e-15   NR MES1908556.1 1215613 g10580 i2 37.3 0.530337078651685 118 68 25.8 3 1176 832 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
1430620 1430620 PRJNA1011844_P_NODE_118122_length_286_cov_3.262911_g109546_i0 PRJNA1011844 118122 286 3.262911 9.33192546 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 239 1.89e-58   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g109546 i0 83.577 18.2692307692308 274 25 94 11 11 280 3750 4007 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 5225 239 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
2706233 2706233 PRJNA1011844_P_NODE_125503_length_275_cov_6.519802_g116925_i0 PRJNA1011844 125503 275 6.519802 17.9294555 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 483 7.559999999999998e-132   NTclustered gi|48727806|gb|AY620296.1| 175275 g116925 i0 99.251 95.6472727272727 267 2 97 0 8 274 106 372 Uncultured cercozoan clone 13-1.8 small subunit ribosomal RNA gene, partial sequence blastn 26303 483 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
6534779 6534779 PRJNA1011844_P_NODE_17926_length_1337_cov_30.992089_g10580_i1 PRJNA1011844 17926 1337 30.992089 414.36422993 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 7.85e-15   NR MES1908556.1 1215613 g10580 i1 37.3 0.529543754674645 118 68 25.8 3 427 771 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
9083929 9083929 PRJNA1011844_P_NODE_160128_length_242_cov_0.911243_g151548_i0 PRJNA1011844 160128 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 6.77e-32   NR MES1910618.1 1215613 g151548 i0 82.9 3.76859504132231 76 13 94.2 0 231 4 263 338 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 912 124 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
11635032 11635032 PRJNA1011844_P_NODE_167770_length_232_cov_2.207547_g159189_i0 PRJNA1011844 167770 232 2.207547 5.12150904 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 106 8.3e-25   NR AAP72162.1 188940 g159189 i0 78.6 3.62068965517241 70 15 90.5 0 21 230 440 509 AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] diamond 840 107 0.990654205607477 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
12909477 12909477 PRJNA1011844_P_NODE_1171_length_3933_cov_21.106477_g720_i0 PRJNA1011844 1171 3933 21.106477 830.11774041 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 589 7.059999999999999e-175   NR MES1910123.1 1215613 g720 i0 36.1 0.859649122807018 1127 622 80.2 33 3158 3 135 1238 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3381 589 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19281752 19281752 PRJNA1011844_P_NODE_14536_length_1497_cov_27.622191_g10580_i0 PRJNA1011844 14536 1497 27.622191 413.50419927 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.1e-14   NR MES1908556.1 1215613 g10580 i0 37.3 0.472945891783567 118 68 23 3 587 931 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19281879 19281879 PRJNA1011844_P_NODE_154576_length_245_cov_1.720930_g145996_i0 PRJNA1011844 154576 245 1.72093 4.2162785 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 333 7.049999999999999e-87   NTclustered gi|238617605|gb|FJ973380.1| 45107 g145996 i0 91.983 93.4408163265306 237 19 97 0 6 242 1603 1367 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 22893 333 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
23108308 23108308 PRJNA1011844_P_NODE_129139_length_271_cov_0.984848_g120561_i0 PRJNA1011844 129139 271 0.984848 2.66893808 Cercomonas sp. HFCC574 458880 SAR_Eukaryotes SAR_Eukaryotes 355 1.69e-93   NTclustered gi|161015720|gb|EF681954.1| 458880 g120561 i0 91.538 13.5719557195572 260 19 95 2 13 269 311 570 Cercomonas sp. HFCC574 28S ribosomal RNA gene, partial sequence blastn 3678 355 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. HFCC574
24381806 24381806 PRJNA1011844_P_NODE_110040_length_302_cov_5.567686_g101465_i0 PRJNA1011844 110040 302 5.567686 16.81441172 Paracercomonas sp. 1979800 SAR_Eukaryotes SAR_Eukaryotes 527 3.8299999999999985e-145   NTclustered gi|1326162414|gb|MG775634.1| 1979800 g101465 i0 100 92.6788079470199 285 0 94 0 8 292 1014 730 Paracercomonas sp. strain SF61_P_Poa small subunit ribosomal RNA gene, partial sequence blastn 27989 527 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas sp.
27192695 27192695 PRJNA1011844_P_NODE_4022_length_2588_cov_18.984493_g720_i1 PRJNA1011844 4022 2588 18.984493 491.31867884 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 286 8.42e-77   NR MES1910123.1 1215613 g720 i1 31.3 0.85548686244204 738 422 77.8 26 2026 14 135 854 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 2214 286 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31203309 31203309 PRJNA1011844_P_NODE_15155_length_1465_cov_14.145833_g720_i2 PRJNA1011844 15155 1465 14.145833 207.23645345 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 413 6.589999999999998e-125   NR MES1910123.1 1215613 g720 i2 48.1 1.00955631399317 493 241 98.9 8 1451 3 751 1238 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1479 413 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32406040 32406040 PRJNA1011844_P_NODE_37799_length_800_cov_14.004127_g30203_i0 PRJNA1011844 37799 800 14.004127 112.033016 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 55.8 9.06e-5   NR MES1910975.1 1215613 g30203 i0 29.9 0.43875 117 80 43.5 2 359 706 540 655 MES1910975.1 hypothetical protein [Cercozoa sp. M6MM] diamond 351 55.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32902670 32902670 PRJNA1011844_P_NODE_108040_length_307_cov_3.820513_g99467_i0 PRJNA1011844 108040 307 3.820513 11.72897491 Hondaea 2315209 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.07e-10   NR MES1910575.1 1215613 g99467 i0 65.1 1.69055374592834 43 15 42 0 25 153 141 183 MES1910575.1 hypothetical protein [Cercozoa sp. M6MM] diamond 519 65.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);;