RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 3 ✖

bioproject 1

  • PRJNA690592 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
671331 671331 PRJNA690592_S_NODE_189981_length_250_cov_0.870056_g188967_i0 PRJNA690592 189981 250 0.870056 2.17514 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 104 6.16e-18   NTclustered gi|551552431|ref|XM_005763543.1| 280463 g188967 i0 86.458 4.496 96 11 38 2 109 203 517 423 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1124 104 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7050427 7050427 PRJNA690592_S_NODE_47586_length_449_cov_1.757979_g46572_i0 PRJNA690592 47586 449 1.757979 7.89332571 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 257 8.590000000000001e-64   NTclustered gi|259419561|emb|FN392576.1| 2703868 g46572 i0 77.934 22.9376391982183 426 84 94 7 1 421 58 478 Imantonia rotunda partial mRNA for 60S ribosomal protein L19, contig 25573 blastn 10299 257 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
17249659 17249659 PRJNA690592_S_NODE_46654_length_453_cov_1.660526_g45640_i0 PRJNA690592 46654 453 1.660526 7.52218278 Heterophrys marina 256678 Root_unresolved Root_unresolved 296 1.84e-75   NTclustered gi|375582578|gb|JQ245082.1| 256678 g45640 i0 78.995 64.7218543046358 438 82 96 9 1 433 451 19 Heterophrys marina elongation factor-like protein gene, partial cds blastn 29319 296 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Heterophrys Heterophrys marina

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