RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1249535 · 3 ✖

analysis 1

  • blastn · 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
9980443 9980443 PRJNA1249535_S_NODE_101508_length_373_cov_4.323333_g98125_i0 PRJNA1249535 101508 373 4.323333 16.12603209 Guinardia 216800 SAR_Eukaryotes SAR_Eukaryotes 206 2.5699999999999997e-48   NTclustered gi|2074156200|gb|MW413905.1| 216802 g98125 i0 78.443 69.2734584450402 334 59 88 11 46 373 24795 24469 Guinardia delicatula mitochondrion, complete genome blastn 25839 207 0.995169082125604 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
11837082 11837082 PRJNA1249535_S_NODE_51910_length_471_cov_4.924623_g48558_i0 PRJNA1249535 51910 471 4.924623 23.19497433 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 58.4 0.001   NTclustered gi|1191023013|gb|AC275650.1| 186039 g48558 i0 100 0.0658174097664544 31 0 7 0 299 329 28062 28092 Fragilariopsis cylindrus clone JGIFOGY-41D18, complete sequence blastn 31 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
23310044 23310044 PRJNA1249535_S_NODE_315839_length_244_cov_4.304094_g312456_i0 PRJNA1249535 315839 244 4.304094 10.50198936 Skeletonema ardens 371682 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|2739942899|dbj|LC814759.1| 371682 g312456 i0 100 0.114754098360656 28 0 11 0 69 96 63935 63962 Skeletonema ardens NIES-2837 chloroplast DNA, complete genome blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema ardens

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