RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA876641" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA876641 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3403797 3403797 PRJNA876641_P_NODE_11343_length_274_cov_2.248756_g11269_i0 PRJNA876641 11343 274 2.248756 6.16159144 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 183 8.549999999999997e-42   NTclustered gi|551624794|ref|XM_005792543.1| 280463 g11269 i0 88.667 18.3540145985401 150 17 55 0 11 160 242 93 Emiliania huxleyi CCMP1516 40S ribosomal protein S14 partial mRNA blastn 5029 183 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14881313 14881313 PRJNA876641_P_NODE_6032_length_329_cov_1.570312_g5958_i0 PRJNA876641 6032 329 1.570312 5.16632648 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 254 7.91e-63   NTclustered gi|259475615|emb|FN392423.1| 2792838 g5958 i0 81.388 65.112462006079 317 53 95 5 1 314 451 138 Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S23, contig D2-M13 blastn 21422 254 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
23805395 23805395 PRJNA876641_P_NODE_21319_length_244_cov_0.900585_g21245_i0 PRJNA876641 21319 244 0.900585 2.1974274 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 126 1.28e-24   NTclustered gi|551559227|ref|XM_005766494.1| 280463 g21245 i0 77.406 22.1188524590164 239 36 94 17 15 244 656 427 Emiliania huxleyi CCMP1516 putative ABC transporter partial mRNA blastn 5397 126 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25079301 25079301 PRJNA876641_P_NODE_2340_length_460_cov_1.705426_g2266_i0 PRJNA876641 2340 460 1.705426 7.8449596 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 255 3.17e-63   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g2266 i0 85.141 8.13260869565217 249 37 54 0 20 268 145 393 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 3741 255 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);;