RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1111082" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1111082 · 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
20616463 20616463 PRJNA1111082_P_NODE_237_length_1095_cov_3.184932_g211_i0 PRJNA1111082 237 1095 3.184932 34.8750054 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 244 1.7100000000000004e-59   NTclustered gi|2074156200|gb|MW413905.1| 216802 g211 i0 72.698 40.6283105022831 945 180 82 51 106 1003 23689 24602 Guinardia delicatula mitochondrion, complete genome blastn 44488 244 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
28741532 28741532 PRJNA1111082_P_NODE_10067_length_256_cov_1.442623_g10022_i0 PRJNA1111082 10067 256 1.442623 3.69311488 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.57e-18   NR KAL3939949.1 3061772 g10022 i0 72.2 3.10546875 54 15 63.3 0 1 162 80 133 KAL3939949.1 MAG: hypothetical protein SGBAC_005406, partial [Bacillariaceae sp.] diamond 795 84.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30162331 30162331 PRJNA1111082_P_NODE_11912_length_245_cov_1.755814_g11867_i0 PRJNA1111082 11912 245 1.755814 4.3017443 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 174 3.0699999999999997e-48   NR KAI2510964.1 210448 g11867 i0 97.5 0.991836734693878 81 2 99.2 0 1 243 91 171 KAI2510964.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 243 174 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);;