RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1073005", tax_phylum = "Bacillariophyta" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 3 ✖

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1073005 · 3 ✖

analysis 1

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
7393678 7393678 PRJNA1073005_P_NODE_5086_length_422_cov_1.263610_g4967_i0 PRJNA1073005 5086 422 1.26361 5.3324342 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 89.8 3.1e-13   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g4967 i0 98.039 7.03080568720379 51 1 12 0 321 371 33791 33841 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 2967 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
15489607 15489607 PRJNA1073005_P_NODE_1193_length_1045_cov_1.737654_g1117_i0 PRJNA1073005 1193 1045 1.737654 18.1584843 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 294 1.6e-74   NTclustered gi|2074156200|gb|MW413905.1| 216802 g1117 i0 74.827 50.3837320574163 723 147 75 28 1 703 24572 23865 Guinardia delicatula mitochondrion, complete genome blastn 52651 294 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
21863839 21863839 PRJNA1073005_P_NODE_7378_length_307_cov_2.286325_g7259_i0 PRJNA1073005 7378 307 2.286325 7.01901775 Extubocellulus spinifer 265572 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.69e-14   NTclustered gi|2632235321|gb|OR922703.1| 265572 g7259 i0 79.021 0.931596091205212 143 24 47 6 165 307 5288 5424 Extubocellulus spinifer strain AGSB0090 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 286 93.5 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Extubocellulus Extubocellulus spinifer

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