RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB12366" 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

  • PRJEB12366 · 4 ✖

analysis 1

  • diamond · 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
27349334 27349334 PRJEB12366_P_NODE_19523_length_154_cov_1.344538_g19333_i0 PRJEB12366 19523 154 1.344538 2.07058852 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 95.5 2.9e-21   NR GFH57778.1 426638 g19333 i0 78.4 2.98051948051948 51 11 99.4 0 1 153 449 499 GFH57778.1 acetyl-coenzyme a synthetase [Chaetoceros tenuissimus] diamond 459 95.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31265360 31265360 PRJEB12366_S_NODE_3755_length_157_cov_2.409836_g3747_i0 PRJEB12366 3755 157 2.409836 3.78344252 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.00286   NR EJK58442.1 159749 g3747 i0 87 0.439490445859873 23 3 43.9 0 40 108 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31834452 31834452 PRJEB12366_P_NODE_10777_length_228_cov_2.056995_g10587_i0 PRJEB12366 10777 228 2.056995 4.6899486 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.22e-5   NR KAL3944215.1 3061772 g10587 i0 39 2.02631578947368 77 37 100 2 1 228 51 118 KAL3944215.1 MAG: hypothetical protein SGBAC_001712 [Bacillariaceae sp.] diamond 462 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32334855 32334855 PRJEB12366_P_NODE_7059_length_300_cov_1.241509_g6869_i0 PRJEB12366 7059 300 1.241509 3.724527 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.4 5.08e-20   NR KAL3823683.1 382380 g6869 i0 73.2 1.68 56 15 56 0 299 132 109 164 KAL3823683.1 hypothetical protein ACHAXA_007254 [Cyclostephanos tholiformis] diamond 504 90.1 0.992230854605993 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis

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