RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJNA1166865 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1039641 1039641 PRJNA1166865_P_NODE_79681_length_249_cov_0.875000_g79440_i0 PRJNA1166865 79681 249 0.875 2.17875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.023   NTclustered gi|551582468|ref|XM_005776637.1| 280463 g79440 i0 100 0.590361445783133 28 0 11 0 142 169 257 284 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 147 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2863584 2863584 PRJNA1166865_P_NODE_36783_length_358_cov_1.347368_g36542_i0 PRJNA1166865 36783 358 1.347368 4.82357744 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 350 1.07e-91   NTclustered gi|551605616|ref|XM_005784143.1| 280463 g36542 i0 84.615 92.0586592178771 351 54 98 0 8 358 1454 1104 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 32957 350 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13066239 13066239 PRJNA1166865_P_NODE_33651_length_373_cov_1.026667_g33410_i0 PRJNA1166865 33651 373 1.026667 3.82946791 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 220 9.19e-53   NTclustered gi|551560604|ref|XM_005767144.1| 280463 g33410 i0 84.188 2.65415549597855 234 30 62 7 127 359 1310 1083 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 990 220 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13067497 13067497 PRJNA1166865_P_NODE_8411_length_727_cov_16.964832_g8198_i0 PRJNA1166865 8411 727 16.964832 123.33432864 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 104 1.98e-17   NTclustered gi|551538436|ref|XM_005757713.1| 280463 g8198 i0 72.063 3.37138927097662 383 95 52 8 273 652 256 629 Emiliania huxleyi CCMP1516 60S ribosomal protein L10a partial mRNA blastn 2451 104 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16890724 16890724 PRJNA1166865_P_NODE_73394_length_254_cov_1.701657_g73153_i0 PRJNA1166865 73394 254 1.701657 4.32220878 Isochrysis galbana 37099 Haptophyta other_Eukaryota 178 3.65e-40   NTclustered gi|926485563|gb|KP892617.1| 37099 g73153 i0 83.163 21.7204724409449 196 32 77 1 12 206 2006 1811 Isochrysis galbana adaptor protein complex 1 or 2 subunit beta (AP12B) gene, partial cds blastn 5517 178 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
18164415 18164415 PRJNA1166865_P_NODE_39115_length_348_cov_1.254545_g38874_i0 PRJNA1166865 39115 348 1.254545 4.3658166 Raphidiophrys sp. Whale Bay 299893 Root_unresolved Root_unresolved 137 8.85e-28   NTclustered gi|55469146|gb|AY749619.1| 299893 g38874 i0 79.911 18.1350574712644 224 15 58 15 146 348 843 1057 Raphidiophrys sp. Whale Bay 18S ribosomal RNA gene, partial sequence blastn 6311 137 1 Eukaryota Haptista     Centroplasthelida Pterocystida Raphidiophryidae Raphidiophrys Raphidiophrys sp. Whale Bay

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