RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 12 ✖

bioproject 1

  • PRJNA438687 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
5538945 5538945 PRJNA438687_S_NODE_1605_length_328_cov_15.450512_g1515_i0 PRJNA438687 1605 328 15.450512 50.67767936 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 171 8.16e-38   NTclustered gi|194146360|gb|EU616327.1| 171259 g1515 i0 85.455 49.0884146341463 165 23 50 1 1 165 757 594 Uncultured haptophyte clone MV5_19_190 28S ribosomal RNA gene, partial sequence blastn 16101 171 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
5539082 5539082 PRJNA438687_S_NODE_7825_length_154_cov_5.008403_g7735_i0 PRJNA438687 7825 154 5.008403 7.71294062 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 141 2.62e-29   NTclustered gi|61187370|gb|AY752991.1| 299901 g7735 i0 98.734 56.6103896103896 79 1 51 0 1 79 2056 1978 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 8718 141 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
6813155 6813155 PRJNA438687_S_NODE_786_length_403_cov_6.657609_g697_i0 PRJNA438687 786 403 6.657609 26.83016427 Pterocystis tropica 299886 Root_unresolved Root_unresolved 556 6.72e-154   NTclustered gi|61187375|gb|AY752993.1| 299886 g697 i0 95.184 86.0893300248139 353 15 87 2 1 352 2465 2114 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 34694 556 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
10639130 10639130 PRJNA438687_S_NODE_1349_length_344_cov_11.294498_g1259_i0 PRJNA438687 1349 344 11.294498 38.85307312 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 110 1.9e-19   NTclustered gi|61187370|gb|AY752991.1| 299901 g1259 i0 82.443 27.5261627906977 131 17 38 5 213 342 2681 2556 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 9469 110 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
10639239 10639239 PRJNA438687_S_NODE_6209_length_176_cov_2.638298_g6119_i0 PRJNA438687 6209 176 2.638298 4.64340448 Phaeocystis antarctica 33657 Haptophyta other_Eukaryota 60.2 8.87e-5   NTclustered gi|9885782|gb|AF289040.1|AF289040 33657 g6119 i0 94.737 0.215909090909091 38 2 22 0 84 121 1493 1530 Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence blastn 38 60.2 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis antarctica
12569994 12569994 PRJNA438687_S_NODE_2430_length_284_cov_3.244980_g2340_i0 PRJNA438687 2430 284 3.24498 9.2157432 Pavlovaceae 418969 Haptophyta other_Eukaryota 433 8.01e-117   NTclustered gi|330423575|gb|JF714237.1| 1000985 g2340 i0 100 82.4577464788732 234 0 82 0 51 284 748 981 Pavlova sp. AC248 18S ribosomal RNA gene, partial sequence blastn 23418 433 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova sp. EMB-2011
13189063 13189063 PRJNA438687_S_NODE_8031_length_152_cov_1.991453_g7941_i0 PRJNA438687 8031 152 1.991453 3.02700856 Pavlova gyrans 44452 Haptophyta other_Eukaryota 182 1.52e-41   NTclustered gi|238617593|gb|FJ973368.1| 44452 g7941 i0 88.816 78.2631578947368 152 12 98 5 1 149 1697 1846 Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence blastn 11896 182 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova gyrans
15738041 15738041 PRJNA438687_S_NODE_7413_length_159_cov_2.298387_g7323_i0 PRJNA438687 7413 159 2.298387 3.65443533 Acanthocystis nichollsi 299881 Root_unresolved Root_unresolved 167 4.51e-37   NTclustered gi|1093394850|gb|KX640005.1| 299881 g7323 i0 85.311 111.383647798742 177 8 100 7 1 159 908 732 Acanthocystis nichollsi clone 281.30 18S ribosomal RNA gene, partial sequence blastn 17710 167 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis nichollsi
18286987 18286987 PRJNA438687_S_NODE_535_length_447_cov_3.072816_g452_i0 PRJNA438687 535 447 3.072816 13.73548752 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 122 3.25e-23   NTclustered gi|2528217843|gb|OR196765.1| 2837474 g452 i0 80.745 21.0469798657718 161 27 36 4 167 325 1549 1391 Meringosphaera mediterranea isolate S11 large subunit ribosomal RNA gene, partial sequence blastn 9408 122 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
19561206 19561206 PRJNA438687_S_NODE_3136_length_252_cov_52.981567_g3046_i0 PRJNA438687 3136 252 52.981567 133.51354884 Polyplacocystis symmetrica 299904 Root_unresolved Root_unresolved 320 5.67e-83   NTclustered gi|55469145|gb|AY749618.1| 299904 g3046 i0 99.435 46.4166666666667 177 0 70 1 76 252 128 303 Polyplacocystis symmetrica 18S ribosomal RNA gene, partial sequence blastn 11697 320 1 Eukaryota Haptista     Centroplasthelida Pterocystida Raphidiophryidae Polyplacocystis Polyplacocystis symmetrica
22111873 22111873 PRJNA438687_S_NODE_1078_length_370_cov_13.758209_g988_i0 PRJNA438687 1078 370 13.758209 50.9053733 Polyplacocystis symmetrica 299904 Root_unresolved Root_unresolved 562 1.31e-155   NTclustered gi|55469145|gb|AY749618.1| 299904 g988 i0 96.491 46.7648648648649 342 8 92 4 3 344 1144 807 Polyplacocystis symmetrica 18S ribosomal RNA gene, partial sequence blastn 17303 562 1 Eukaryota Haptista     Centroplasthelida Pterocystida Raphidiophryidae Polyplacocystis Polyplacocystis symmetrica
23387526 23387526 PRJNA438687_S_NODE_5019_length_198_cov_7.680982_g4929_i0 PRJNA438687 5019 198 7.680982 15.20834436 Heterophryidae sp. 1 VVZ-2016 1795049 Root_unresolved Root_unresolved 348 1.95e-91   NTclustered gi|985769340|gb|KU178909.1| 1795049 g4929 i0 98.485 88.1919191919192 198 2 100 1 1 198 1274 1078 Heterophryidae sp. 1 VVZ-2016 18S ribosomal RNA gene, partial sequence blastn 17462 348 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae   Heterophryidae sp. 1 VVZ-2016

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