RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 17 ✖

bioproject 1

  • PRJNA312107 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
377636 377636 PRJNA312107_P_NODE_26761_length_152_cov_2.194175_g26595_i0 PRJNA312107 26761 152 2.194175 3.335146 Tumidella tumida 1357781 Plants Plants 265 1.47e-66   NTclustered gi|523583543|gb|KC145440.1| 1357781 g26595 i0 98.039 99.5131578947368 153 2 100 1 1 152 818 970 Sphaeropleales sp. KF-2013d strain SAG 2265 28S ribosomal RNA gene, partial sequence blastn 15126 265 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Tumidellaceae Tumidella Tumidella tumida
1063641 1063641 PRJNA312107_P_NODE_13701_length_197_cov_2.148649_g13535_i0 PRJNA312107 13701 197 2.148649 4.23283853 Eukaryota 2759 Plants Plants 337 4.21e-88   NTclustered gi|1160446|emb|Z28970.1| 34157 g13535 i0 97.462 100 197 5 100 0 1 197 1847 2043 G.planctonica 5.8S, 18S and 26S rRNA genes blastn 19700 337 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Gloeotilopsis Gloeotilopsis planctonica
2338845 2338845 PRJNA312107_P_NODE_16662_length_179_cov_1.530769_g16496_i0 PRJNA312107 16662 179 1.530769 2.74007651 Eukaryota 2759 Plants Plants 326 8.09e-85   NTclustered gi|1189013852|gb|MF034633.1| 43939 g16496 i0 99.441 100 179 1 100 0 1 179 1065 887 Hazenia basiliensis strain ULVO-15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 17900 326 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Hazeniaceae Hazenia Hazenia basiliensis
2928174 2928174 PRJNA312107_P_NODE_15223_length_187_cov_2.224638_g15057_i0 PRJNA312107 15223 187 2.224638 4.16007306 Desmochloris halophila 138176 Plants Plants 281 1.8800000000000002e-71   NTclustered gi|371782086|emb|HE610118.1| 138176 g15057 i0 94.086 100.743315508021 186 10 99 1 1 186 2607 2791 Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 blastn 18839 281 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
4891454 4891454 PRJNA312107_P_NODE_17564_length_174_cov_1.440000_g17398_i0 PRJNA312107 17564 174 1.44 2.5056 Chlorellaceae 35461 Plants Plants 278 2.22e-70   NTclustered gi|254798615|ref|NC_012978.1| 3074 g17398 i0 95.402 167.632183908046 174 8 100 0 1 174 93575 93748 Parachlorella kessleri chloroplast, complete genome blastn 29168 278 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Parachlorella Parachlorella kessleri
5480988 5480988 PRJNA312107_P_NODE_10465_length_223_cov_1.856322_g10299_i0 PRJNA312107 10465 223 1.856322 4.13959806 Sarcinofilum mucosum 141643 Plants Plants 363 8.049999999999997e-96   NTclustered gi|1197510887|ref|NC_034709.1| 141643 g10299 i0 95.964 52.6502242152466 223 9 100 0 1 223 151164 150942 Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome blastn 11741 363 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Sarcinofilaceae Sarcinofilum Sarcinofilum mucosum
8716237 8716237 PRJNA312107_P_NODE_17027_length_177_cov_1.351562_g16861_i0 PRJNA312107 17027 177 1.351562 2.39226474 Tetradesmus 91192 Plants Plants 285 1.3499999999999998e-72   NTclustered gi|1240946771|gb|KX756229.1| 3088 g16861 i0 99.363 120.858757062147 157 1 89 0 1 157 82384 82228 Tetradesmus obliquus chloroplast, complete genome blastn 21392 285 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Tetradesmus Tetradesmus obliquus
8716253 8716253 PRJNA312107_P_NODE_6507_length_278_cov_2.427948_g6341_i0 PRJNA312107 6507 278 2.427948 6.74969544 Ulothrix 43940 Plants Plants 503 5.88e-138   NTclustered gi|1616636|emb|Z47999.1| 43941 g6341 i0 99.281 100.007194244604 278 2 100 0 1 278 862 585 U.zonata 5.8S, 18S and 26S rRNA genes blastn 27802 503 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Ulothrix Ulothrix zonata
11266831 11266831 PRJNA312107_P_NODE_15609_length_185_cov_1.507353_g15443_i0 PRJNA312107 15609 185 1.507353 2.78860305 root 1 Root_unresolved Root_unresolved 230 6.799999999999999e-56   NTclustered gi|1279575454|gb|MF683078.1| 44745 g15443 i0 92.073 350.589189189189 164 12 89 1 22 185 2673 2835 Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 64859 230 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
11856174 11856174 PRJNA312107_P_NODE_11670_length_212_cov_2.668712_g11504_i0 PRJNA312107 11670 212 2.668712 5.65766944 Ulothrix zonata 43941 Plants Plants 375 9.74e-100   NTclustered gi|530445654|emb|HE860533.1| 43941 g11504 i0 98.585 97.7311320754717 212 3 100 0 1 212 231 20 Ulothrix zonata partial 28S rRNA gene, isolate Q19 blastn 20719 375 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Ulothrix Ulothrix zonata
11856189 11856189 PRJNA312107_P_NODE_15670_length_185_cov_1.095588_g15504_i0 PRJNA312107 15670 185 1.095588 2.0268378 Chlamydomonas reinhardtii 3055 Plants Plants 52.8 0.016   NTclustered gi|2082239373|ref|XM_001699987.2| 3055 g15504 i0 100 0.151351351351351 28 0 15 0 118 145 138 111 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g097900v5), mRNA blastn 28 52.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
13131417 13131417 PRJNA312107_P_NODE_5811_length_294_cov_2.000000_g5645_i0 PRJNA312107 5811 294 2 5.88 Desmochloris halophila 138176 Plants Plants 453 6.400000000000001e-123   NTclustered gi|371782086|emb|HE610118.1| 138176 g5645 i0 94.558 68.2210884353742 294 15 100 1 1 294 3692 3984 Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 blastn 20057 453 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
15680335 15680335 PRJNA312107_P_NODE_18933_length_169_cov_0.866667_g18767_i0 PRJNA312107 18933 169 0.866667 1.46466723 Trebouxia aggregata 160068 Plants Plants 137 3.79e-28   NTclustered gi|162134245|gb|EU123948.1| 160068 g18767 i0 92.632 0.562130177514793 95 7 56 0 1 95 15308 15214 Trebouxia aggregata strain SAG 219-1d ribosomal protein S2 (rps2) gene, complete cds; tRNA-Met (trnMe(cau)) and large subunit ribosomal RNA (rnl) genes, complete sequence; putative site-specific DNA endonuclease (orf365) gene, complete cds; small subunit ribosomal RNA (rns) and tRNA-Met (trnMf(cau)) genes, complete sequence; cytochrome c oxidase subunit 1 (cox1), putative site-specific DNA endonuclease (orf335), and putative site-specific DNA endonuclease (orf256) genes, complete cds; tRNA-Phe (trnF(gaa)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; and apocytochrome b (cob) and putative site-specific DNA endonuclease (orf334) genes, complete cds; mitochondrial blastn 95 137 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia aggregata
18914991 18914991 PRJNA312107_P_NODE_8955_length_239_cov_2.552632_g8789_i0 PRJNA312107 8955 239 2.552632 6.10079048 Tupiellaceae 2682567 Plants Plants 442 1.0899999999999994e-119   NTclustered gi|557844178|gb|KF144222.1| 160070 g8789 i0 100 100.012552301255 239 0 100 0 1 239 352 114 Tupiella akineta isolate WB20 18S ribosomal RNA gene, partial sequence blastn 23903 442 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Tupiellaceae Tupiella Tupiella akineta
19503547 19503547 PRJNA312107_P_NODE_17036_length_177_cov_1.218750_g16870_i0 PRJNA312107 17036 177 1.21875 2.1571875 Sarcinofilum mucosum 141643 Plants Plants 322 1.03e-83   NTclustered gi|1197510887|ref|NC_034709.1| 141643 g16870 i0 99.435 103.762711864407 177 1 100 0 1 177 149496 149320 Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome blastn 18366 322 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Sarcinofilaceae Sarcinofilum Sarcinofilum mucosum
20189722 20189722 PRJNA312107_P_NODE_25096_length_163_cov_0.912281_g24930_i0 PRJNA312107 25096 163 0.912281 1.48701803 Tetradesmus 91192 Plants Plants 298 1.58e-76   NTclustered gi|2576955160|gb|OR551481.1| 113531 g24930 i0 100 35.0552147239264 161 0 99 0 3 163 5703 5543 Tetradesmus distendus culture FBCC:A1020 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 5714 298 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Tetradesmus Tetradesmus distendus
20779073 20779073 PRJNA312107_P_NODE_15317_length_187_cov_1.159420_g15151_i0 PRJNA312107 15317 187 1.15942 2.1681154 Desmochloris halophila 138176 Plants Plants 305 1.11e-78   NTclustered gi|371782086|emb|HE610118.1| 138176 g15151 i0 96.237 99.4652406417112 186 7 99 0 2 187 1840 1655 Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 blastn 18600 305 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila

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