RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA637328" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA637328 · 3 ✖

analysis 1

  • diamond · 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
28975884 28975884 PRJNA637328_P_NODE_11648_length_279_cov_4.000000_g11172_i0 PRJNA637328 11648 279 4 11.16 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 106 2.6799999999999998e-24   NR KAI2512668.1 210448 g11172 i0 71.6 0.720430107526882 67 17 69.9 2 277 83 848 914 KAI2512668.1 hypothetical protein MHU86_1664 [Fragilaria crotonensis] diamond 201 106 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29303932 29303932 PRJNA637328_P_NODE_14309_length_262_cov_1.849765_g13832_i0 PRJNA637328 14309 262 1.849765 4.8463843 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 79 8.27e-15   NR EJK71780.1 159749 g13832 i0 43.2 4.93511450381679 88 48 98.5 1 259 2 287 374 EJK71780.1 hypothetical protein THAOC_06746, partial [Thalassiosira oceanica] diamond 1293 79 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29354770 29354770 PRJNA637328_P_NODE_19849_length_235_cov_2.844086_g19372_i0 PRJNA637328 19849 235 2.844086 6.6836021 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.21e-16   NR KAI2502670.1 210448 g19372 i0 73.1 1.32765957446809 52 14 66.4 0 234 79 216 267 KAI2502670.1 GDP-mannose 4-6 dehydratase [Fragilaria crotonensis] diamond 312 81.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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