RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA929952" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJNA929952 · 6 ✖

analysis 1

tax_phylum 0

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
2184507 2184507 PRJNA929952_P_NODE_19922_length_212_cov_2.644809_g18628_i0 PRJNA929952 19922 212 2.644809 5.60699508 Pterocystis tropica 299886 Root_unresolved Root_unresolved 204 4.86e-48   NTclustered gi|61187375|gb|AY752993.1| 299886 g18628 i0 84.615 3.80660377358491 221 17 100 10 1 212 445 657 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 807 204 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
2184541 2184541 PRJNA929952_P_NODE_8662_length_404_cov_2.890667_g7402_i0 PRJNA929952 8662 404 2.890667 11.67829468 Pterocystis tropica 299886 Root_unresolved Root_unresolved 209 2.17e-49   NTclustered gi|61187375|gb|AY752993.1| 299886 g7402 i0 93.197 13.779702970297 147 3 54 3 118 264 2254 2115 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 5567 209 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
10183506 10183506 PRJNA929952_P_NODE_8968_length_396_cov_1.961853_g7703_i0 PRJNA929952 8968 396 1.961853 7.76893788 Pterocystis 238775 Root_unresolved Root_unresolved 259 2.08e-64   NTclustered gi|55469134|gb|AY749607.1| 299882 g7703 i0 90.431 52.8787878787879 209 3 51 4 1 202 898 700 Pterocystis sp. Oxford2 18S ribosomal RNA gene, partial sequence blastn 20940 259 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis sp. Oxford2
12388346 12388346 PRJNA929952_P_NODE_8730_length_402_cov_1.627346_g7469_i0 PRJNA929952 8730 402 1.627346 6.54193092 Pterocystis borysthenica 2966623 Root_unresolved Root_unresolved 139 2.88e-28   NTclustered gi|2278124228|gb|OP104322.1| 2966623 g7469 i0 98.718 36.5820895522388 78 1 38 0 1 78 922 845 Pterocystis borysthenica strain HF-51 small subunit ribosomal RNA gene, partial sequence blastn 14706 139 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis borysthenica
17487428 17487428 PRJNA929952_P_NODE_21514_length_187_cov_5.949367_g20220_i0 PRJNA929952 21514 187 5.949367 11.12531629 Acanthocystis sp. Oxford4 299877 Root_unresolved Root_unresolved 191 3.25e-44   NTclustered gi|55469154|gb|AY749627.1| 299877 g20220 i0 85.561 65.3475935828877 187 21 99 5 1 186 2058 2239 Acanthocystis sp. Oxford4 18S ribosomal RNA gene, partial sequence blastn 12220 191 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Oxford4
22586168 22586168 PRJNA929952_P_NODE_7798_length_433_cov_10.472772_g6560_i0 PRJNA929952 7798 433 10.472772 45.34710276 uncultured Centroheliozoa 315785 Root_unresolved Root_unresolved 348 4.7600000000000004e-91   NTclustered gi|316926521|gb|GU479949.1| 315785 g6560 i0 82.022 32.4434180138568 445 46 100 27 1 433 1011 589 Uncultured centroheliozoan clone PR1_4E_11 18S ribosomal RNA gene, partial sequence blastn 14048 348 1 Eukaryota Haptista     Centroplasthelida       uncultured Centroheliozoa

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