RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14175 · 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
25611041 25611041 PRJEB14175_P_NODE_65009_length_459_cov_2.592965_g62752_i0 PRJEB14175 65009 459 2.592965 11.90170935 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 496 1.7099999999999998e-135   NTclustered gi|551551158|ref|XM_005762979.1| 280463 g62752 i0 91.033 191.821350762527 368 31 80 2 86 452 695 329 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 88046 501 0.99001996007984 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25911334 25911334 PRJEB14175_P_NODE_145732_length_282_cov_2.624434_g143465_i0 PRJEB14175 145732 282 2.624434 7.40090388 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 73.1 2e-8   NTclustered gi|259419564|emb|FN392579.1| 2703868 g143465 i0 83.333 1.23758865248227 84 8 29 6 175 255 187 107 Imantonia rotunda partial mRNA for 60S ribosomal protein L3, contig 19007 blastn 349 73.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
25919868 25919868 PRJEB14175_P_NODE_79924_length_408_cov_20.121037_g77662_i0 PRJEB14175 79924 408 20.121037 82.09383096 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 52.8 0.039   NTclustered gi|551570948|ref|XM_005771335.1| 280463 g77662 i0 100 0.137254901960784 28 0 7 0 117 144 24 51 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 56 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25920663 25920663 PRJEB14175_P_NODE_94380_length_370_cov_12.365696_g92114_i0 PRJEB14175 94380 370 12.365696 45.7530752 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 165 4.33e-36   NTclustered gi|551624444|ref|XM_005792404.1| 280463 g92114 i0 85.093 20.8783783783784 161 24 44 0 68 228 36 196 Emiliania huxleyi CCMP1516 ribosomal protein S8 partial mRNA blastn 7725 165 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);;