RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA473201 · 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
444027 444027 PRJNA473201_P_NODE_52001_length_287_cov_1.373832_g51259_i0 PRJNA473201 52001 287 1.373832 3.94289784 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 255 1.88e-63   NTclustered gi|657012369|gb|KF302532.1| 2850 g51259 i0 88.571 0.731707317073171 210 24 73 0 75 284 226 17 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 210 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5547780 5547780 PRJNA473201_P_NODE_59485_length_267_cov_40.067010_g58743_i0 PRJNA473201 59485 267 40.06701 106.9789167 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 69.4 2.43e-7   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g58743 i0 76.154 0.973782771535581 130 31 49 0 1 130 8137 8266 Asterionella formosa chloroplast, complete genome blastn 260 69.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
15746695 15746695 PRJNA473201_P_NODE_52173_length_286_cov_20.446009_g51431_i0 PRJNA473201 52173 286 20.446009 58.47558574 Psammoneis obaidii 1706219 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.22e-5   NTclustered gi|1418588230|ref|NC_038004.1| 1706219 g51431 i0 95 0.947552447552448 40 2 14 0 1 40 59710 59749 Psammoneis obaidii chloroplast, complete genome blastn 271 63.9 1 Eukaryota Sar   Bacillariophyta Mediophyceae Triceratiales Plagiogrammaceae Psammoneis Psammoneis obaidii
23396335 23396335 PRJNA473201_P_NODE_58539_length_270_cov_1.436548_g57797_i0 PRJNA473201 58539 270 1.436548 3.8786796 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 106 1.87e-18   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g57797 i0 84.762 29.8444444444444 105 16 39 0 36 140 9675 9571 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 8058 106 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis

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