RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA421571" 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

  • PRJNA421571 · 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
10628165 10628165 PRJNA421571_P_NODE_89429_length_255_cov_2.241758_g86880_i0 PRJNA421571 89429 255 2.241758 5.7164829 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 62.1 3.85e-5   NTclustered gi|551625712|ref|XM_005792906.1| 280463 g86880 i0 100 1.36470588235294 33 0 13 0 143 175 333 301 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 348 62.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11903124 11903124 PRJNA421571_P_NODE_90730_length_253_cov_1.244444_g88181_i0 PRJNA421571 90730 253 1.244444 3.14844332 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 296 9.609999999999999e-76   NTclustered gi|551610661|ref|XM_005786381.1| 280463 g88181 i0 87.795 99.8142292490119 254 29 100 2 1 253 1099 847 Emiliania huxleyi CCMP1516 putative actin (ACT-2), mRNA blastn 25253 296 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
15726377 15726377 PRJNA421571_P_NODE_66713_length_315_cov_0.954545_g64164_i0 PRJNA421571 66713 315 0.954545 3.00681675 Pavlova gyrans 44452 Haptophyta other_Eukaryota 202 2.7699999999999996e-47   NTclustered gi|149212474|gb|EF455740.1| 44452 g64164 i0 81.746 64.1873015873016 252 36 78 9 22 267 10 257 Pavlova gyrans alpha-tubulin gene, partial cds blastn 20219 202 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova gyrans
20824287 20824287 PRJNA421571_P_NODE_27257_length_636_cov_3.204263_g24757_i0 PRJNA421571 27257 636 3.204263 20.37911268 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 422 4.18e-113   NTclustered gi|551573512|ref|XM_005772503.1| 280463 g24757 i0 82.773 54.2185534591195 476 78 75 4 116 589 497 24 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 34483 422 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);;