RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 9 ✖

bioproject 1

  • PRJNA683669 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
7043647 7043647 PRJNA683669_P_NODE_25506_length_254_cov_1.276243_g25274_i0 PRJNA683669 25506 254 1.276243 3.24165722 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 54.7 0.006   NTclustered gi|551575531|ref|XM_005773431.1| 280463 g25274 i0 100 0.228346456692913 29 0 11 0 63 91 499 471 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 58 54.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8318261 8318261 PRJNA683669_P_NODE_927_length_1280_cov_2.299917_g811_i0 PRJNA683669 927 1280 2.299917 29.4389376 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 58.4 0.003   NTclustered gi|551614809|ref|XM_005788253.1| 280463 g811 i0 97.143 0.02734375 35 0 3 1 491 525 718 751 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 35 58.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13418995 13418995 PRJNA683669_P_NODE_32051_length_243_cov_1.811765_g31819_i0 PRJNA683669 32051 243 1.811765 4.40258895 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 63.9 1.01e-5   NTclustered gi|551611365|ref|XM_005786718.1| 280463 g31819 i0 89.796 0.316872427983539 49 5 20 0 41 89 1618 1666 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 77 63.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
15967759 15967759 PRJNA683669_P_NODE_32813_length_242_cov_1.686391_g32581_i0 PRJNA683669 32813 242 1.686391 4.08106622 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 224 4.369999999999999e-54   NTclustered gi|551577383|ref|XM_005774261.1| 280463 g32581 i0 83.75 42.7809917355372 240 36 99 1 1 240 688 452 Emiliania huxleyi CCMP1516 enolase (ENO1), mRNA blastn 10353 224 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17242981 17242981 PRJNA683669_P_NODE_454_length_1665_cov_3.229899_g389_i0 PRJNA683669 454 1665 3.229899 53.77781835 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 699 0   NTclustered gi|551584285|ref|XM_005777484.1| 280463 g389 i0 81.136 49.5333333333333 880 158 53 8 496 1371 907 32 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 82473 699 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17242983 17242983 PRJNA683669_P_NODE_4674_length_600_cov_7.705882_g4449_i0 PRJNA683669 4674 600 7.705882 46.235292 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 106 4.49e-18   NTclustered gi|551583056|ref|XM_005776908.1| 280463 g4449 i0 82.906 0.39 117 20 20 0 41 157 278 394 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 234 106 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18516939 18516939 PRJNA683669_P_NODE_12195_length_370_cov_1.555556_g11964_i0 PRJNA683669 12195 370 1.555556 5.7555572 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 52.8 0.035   NTclustered gi|551550893|ref|XM_005762884.1| 280463 g11964 i0 100 0.0756756756756757 28 0 8 0 137 164 294 267 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18517026 18517026 PRJNA683669_P_NODE_22135_length_276_cov_0.886700_g21903_i0 PRJNA683669 22135 276 0.8867 2.447292 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 230 1.0899999999999995e-55   NTclustered gi|551605616|ref|XM_005784143.1| 280463 g21903 i0 85.088 77.4673913043478 228 30 82 4 19 244 663 438 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 21381 230 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24891074 24891074 PRJNA683669_P_NODE_19200_length_294_cov_1.656109_g18968_i0 PRJNA683669 19200 294 1.656109 4.86896046 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 163 1.21e-35   NTclustered gi|551620139|ref|XM_005790596.1| 280463 g18968 i0 77.419 3.32312925170068 310 47 100 13 1 294 852 550 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 977 163 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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