RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA400391" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 19 ✖

bioproject 1

  • PRJNA400391 · 19 ✖

analysis 1

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
413965 413965 PRJNA400391_S_NODE_1261_length_331_cov_15.831081_g1200_i0 PRJNA400391 1261 331 15.831081 52.40087811 Oxnerella micra 1147772 Root_unresolved Root_unresolved 134 1.08e-26   NTclustered gi|375582525|gb|JQ245080.1| 1147772 g1200 i0 89.091 17.2809667673716 110 9 43 2 223 330 1650 1758 Oxnerella micra 28S ribosomal RNA gene, partial sequence blastn 5720 134 1 Eukaryota Haptista     Centroplasthelida Pterocystida Oxnerellidae Oxnerella Oxnerella micra
413990 413990 PRJNA400391_S_NODE_2101_length_274_cov_18.037657_g2040_i0 PRJNA400391 2101 274 18.037657 49.42318018 Pterocystis striata 3114439 Root_unresolved Root_unresolved 215 3.03e-51   NTclustered gi|2648770732|gb|PP146518.1| 3114439 g2040 i0 82.374 98.9051094890511 278 19 99 19 1 271 53 307 Pterocystis striata clone HF_59Z small subunit ribosomal RNA gene, partial sequence blastn 27100 215 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis striata
1688919 1688919 PRJNA400391_S_NODE_4502_length_188_cov_33.254902_g4441_i0 PRJNA400391 4502 188 33.254902 62.51921576 Oxnerella micra 1147772 Root_unresolved Root_unresolved 185 1.52e-42   NTclustered gi|375582525|gb|JQ245080.1| 1147772 g4441 i0 100 53.7340425531915 100 0 53 0 89 188 1060 961 Oxnerella micra 28S ribosomal RNA gene, partial sequence blastn 10102 185 1 Eukaryota Haptista     Centroplasthelida Pterocystida Oxnerellidae Oxnerella Oxnerella micra
2356444 2356444 PRJNA400391_S_NODE_2142_length_272_cov_37.025316_g2081_i0 PRJNA400391 2142 272 37.025316 100.70885952 Acanthocystis 299834 Root_unresolved Root_unresolved 300 8.07e-77   NTclustered gi|55469157|gb|AY749630.1| 299835 g2081 i0 95.699 59.8529411764706 186 8 68 0 87 272 1110 1295 Acanthocystis spinifera 18S ribosomal RNA gene, partial sequence blastn 16280 303 0.99009900990099 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis spinifera
2964786 2964786 PRJNA400391_S_NODE_2103_length_274_cov_11.317992_g2042_i0 PRJNA400391 2103 274 11.317992 31.01129808 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 158 5.1799999999999986e-34   NTclustered gi|2526806206|gb|OR195152.1| 2837474 g2042 i0 85.443 20.3576642335766 158 16 58 4 1 158 2379 2529 Meringosphaera mediterranea isolate S2 large subunit ribosomal RNA gene, partial sequence blastn 5578 158 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
2964878 2964878 PRJNA400391_S_NODE_823_length_378_cov_8.793003_g762_i0 PRJNA400391 823 378 8.793003 33.23755134 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 150 1.2399999999999998e-31   NTclustered gi|194146360|gb|EU616327.1| 171259 g762 i0 85.135 39.015873015873 148 21 39 1 1 148 740 594 Uncultured haptophyte clone MV5_19_190 28S ribosomal RNA gene, partial sequence blastn 14748 150 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
3631864 3631864 PRJNA400391_S_NODE_4023_length_201_cov_5.680723_g3962_i0 PRJNA400391 4023 201 5.680723 11.41825323 Acanthocystis 299834 Root_unresolved Root_unresolved 159 1e-34   NTclustered gi|55469157|gb|AY749630.1| 299835 g3962 i0 93.578 50.8805970149254 109 4 53 3 4 110 1531 1424 Acanthocystis spinifera 18S ribosomal RNA gene, partial sequence blastn 10227 159 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis spinifera
6791816 6791816 PRJNA400391_S_NODE_4126_length_198_cov_6.638037_g4065_i0 PRJNA400391 4126 198 6.638037 13.14331326 Acanthocystis turfacea 1278266 Root_unresolved Root_unresolved 113 7.76e-21   NTclustered gi|1093394937|gb|KX640092.1| 1278266 g4065 i0 100 34.6969696969697 61 0 56 0 138 198 806 866 Acanthocystis turfacea clone 287.1 18S ribosomal RNA gene, partial sequence blastn 6870 113 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis turfacea
6791843 6791843 PRJNA400391_S_NODE_5506_length_168_cov_12.300752_g5445_i0 PRJNA400391 5506 168 12.300752 20.66526336 Oxnerella micra 1147772 Root_unresolved Root_unresolved 148 1.75e-31   NTclustered gi|375582525|gb|JQ245080.1| 1147772 g5445 i0 89.431 46.7321428571429 123 5 73 3 46 168 574 460 Oxnerella micra 28S ribosomal RNA gene, partial sequence blastn 7851 148 1 Eukaryota Haptista     Centroplasthelida Pterocystida Oxnerellidae Oxnerella Oxnerella micra
7458979 7458979 PRJNA400391_S_NODE_3926_length_203_cov_4.541667_g3865_i0 PRJNA400391 3926 203 4.541667 9.21958401 Pterocystida 2607628 Root_unresolved Root_unresolved 171 4.68e-38   NTclustered gi|61187375|gb|AY752993.1| 299886 g3865 i0 95.327 42.871921182266 107 5 69 0 1 107 2993 3099 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 8703 171 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
9342275 9342275 PRJNA400391_S_NODE_5068_length_175_cov_8.085714_g5007_i0 PRJNA400391 5068 175 8.085714 14.1499995 uncultured Centroheliozoa 315785 Root_unresolved Root_unresolved 316 4.74e-82   NTclustered gi|157781164|gb|EU143988.1| 315785 g5007 i0 100 94.64 171 0 98 0 5 175 2 172 Uncultured centroheliozoan clone EB17.116 18S ribosomal RNA gene, partial sequence blastn 16562 316 1 Eukaryota Haptista     Centroplasthelida       uncultured Centroheliozoa
10617970 10617970 PRJNA400391_S_NODE_3189_length_225_cov_3.805263_g3128_i0 PRJNA400391 3189 225 3.805263 8.56184175 uncultured Centroheliozoa 315785 Root_unresolved Root_unresolved 361 2.9299999999999993e-95   NTclustered gi|157781164|gb|EU143988.1| 315785 g3128 i0 95.946 99.4888888888889 222 9 99 0 1 222 138 359 Uncultured centroheliozoan clone EB17.116 18S ribosomal RNA gene, partial sequence blastn 22385 361 1 Eukaryota Haptista     Centroplasthelida       uncultured Centroheliozoa
12559716 12559716 PRJNA400391_S_NODE_3110_length_228_cov_5.455959_g3049_i0 PRJNA400391 3110 228 5.455959 12.43958652 Pterocystida 2607628 Root_unresolved Root_unresolved 87.9 5.57e-13   NTclustered gi|61187375|gb|AY752993.1| 299886 g3049 i0 75 19.8815789473684 236 35 100 17 1 228 2692 2473 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 4533 87.9 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
12559758 12559758 PRJNA400391_S_NODE_6570_length_151_cov_15.284483_g6509_i0 PRJNA400391 6570 151 15.284483 23.079569330000002 Khitsovia 2983006 Root_unresolved Root_unresolved 167 4.22e-37   NTclustered gi|2008117308|gb|MW775192.1| 2201270 g6509 i0 87.662 97.7483443708609 154 5 99 10 3 151 373 229 Centroheliozoa sp. isolate UC99 small subunit ribosomal RNA gene, partial sequence blastn 14760 167 1 Eukaryota Haptista     Centroplasthelida       Centroheliozoa sp.
15108837 15108837 PRJNA400391_S_NODE_6412_length_154_cov_1.226891_g6351_i0 PRJNA400391 6412 154 1.226891 1.88941214 Centroplasthelida 193537 Root_unresolved Root_unresolved 117 4.42e-22   NTclustered gi|55469147|gb|AY749620.1| 299870 g6351 i0 95.89 11.7857142857143 73 1 46 1 1 71 1008 936 Acanthocystis sp. Oxford1 18S ribosomal RNA gene, partial sequence blastn 1815 117 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Oxford1
15716775 15716775 PRJNA400391_S_NODE_3573_length_213_cov_15.505618_g3512_i0 PRJNA400391 3573 213 15.505618 33.02696634 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 263 7.95e-66   NTclustered gi|2526806206|gb|OR195152.1| 2837474 g3512 i0 98.026 96.6948356807512 152 1 88 1 1 152 2625 2774 Meringosphaera mediterranea isolate S2 large subunit ribosomal RNA gene, partial sequence blastn 20596 263 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
16991569 16991569 PRJNA400391_S_NODE_1774_length_293_cov_15.779070_g1713_i0 PRJNA400391 1774 293 15.77907 46.2326751 Oxnerella micra 1147772 Root_unresolved Root_unresolved 475 1.3599999999999999e-129   NTclustered gi|375582525|gb|JQ245080.1| 1147772 g1713 i0 96.528 101.98976109215 288 8 98 2 6 293 1120 1405 Oxnerella micra 28S ribosomal RNA gene, partial sequence blastn 29883 475 1 Eukaryota Haptista     Centroplasthelida Pterocystida Oxnerellidae Oxnerella Oxnerella micra
17658600 17658600 PRJNA400391_S_NODE_4274_length_194_cov_6.534591_g4213_i0 PRJNA400391 4274 194 6.534591 12.67710654 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 117 5.85e-22   NTclustered gi|61187375|gb|AY752993.1| 299886 g4213 i0 87.619 46.6340206185567 105 8 72 4 92 194 1893 1994 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 9047 117 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
22090543 22090543 PRJNA400391_S_NODE_4218_length_196_cov_1.714286_g4157_i0 PRJNA400391 4218 196 1.714286 3.36000056 Pterocystis tropica 299886 Root_unresolved Root_unresolved 195 2.66e-45   NTclustered gi|61187375|gb|AY752993.1| 299886 g4157 i0 92.308 11.234693877551 143 2 72 4 6 147 2248 2114 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 2202 195 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica

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