RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA493632 · 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
4294823 4294823 PRJNA493632_P_NODE_671904_length_237_cov_4.085366_g668463_i0 PRJNA493632 671904 237 4.085366 9.68231742 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 52.8 0.021   NTclustered gi|551559913|ref|XM_005766799.1| 280463 g668463 i0 100 0.118143459915612 28 0 12 0 147 174 708 681 Emiliania huxleyi CCMP1516 type II DNA topoisomerase VI subunit A 2 (Top6A), partial mRNA blastn 28 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10670785 10670785 PRJNA493632_P_NODE_620109_length_243_cov_2.376471_g616668_i0 PRJNA493632 620109 243 2.376471 5.77482453 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 73.1 1.68e-8   NTclustered gi|551542608|ref|XM_005759434.1| 280463 g616668 i0 93.878 1.08641975308642 49 1 21 2 3 51 1277 1231 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 264 73.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22141010 22141010 PRJNA493632_P_NODE_472578_length_257_cov_2.429348_g469139_i0 PRJNA493632 472578 257 2.429348 6.24342436 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 183 7.949999999999997e-42   NTclustered gi|259419544|emb|FN392559.1| 2703868 g469139 i0 82.407 7.93774319066148 216 32 83 5 8 220 258 46 Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 blastn 2040 183 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
23411344 23411344 PRJNA493632_P_NODE_168319_length_369_cov_2.368243_g164892_i0 PRJNA493632 168319 369 2.368243 8.73881667 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 54.7 0.01   NTclustered gi|551609071|ref|XM_005785712.1| 280463 g164892 i0 94.444 0.173441734417344 36 1 9 1 27 61 1699 1734 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 64 54.7 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);;