RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1240804 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
12528498 12528498 PRJNA1240804_P_NODE_109190_length_169_cov_0.866667_g108824_i0 PRJNA1240804 109190 169 0.866667 1.46466723 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 94.7 5.13e-21   NR KAL3924210.1 3061772 g108824 i0 95.7 4.08284023668639 46 2 81.7 0 7 144 284 329 KAL3924210.1 MAG: hypothetical protein SGILL_001187 [Bacillariaceae sp.] diamond 690 94.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30533927 30533927 PRJNA1240804_P_NODE_114453_length_168_cov_0.873950_g114087_i0 PRJNA1240804 114453 168 0.87395 1.468236 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 86.3 2.89e-18   NR EJK44957.1 159749 g114087 i0 80.4 2.75 51 10 91.1 0 3 155 270 320 EJK44957.1 hypothetical protein THAOC_36465 [Thalassiosira oceanica] diamond 462 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30660365 30660365 PRJNA1240804_P_NODE_73093_length_191_cov_1.457746_g72727_i0 PRJNA1240804 73093 191 1.457746 2.78429486 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.59e-22   NR KAL3762442.1 259834 g72727 i0 80.7 3.59685863874346 57 11 89.5 0 15 185 584 640 KAL3762442.1 hypothetical protein ACHAWU_008145 [Discostella pseudostelligera] diamond 687 99.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31115876 31115876 PRJNA1240804_P_NODE_133495_length_165_cov_0.896552_g133129_i0 PRJNA1240804 133495 165 0.896552 1.4793108 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 95.9 6.63e-23   NR KAG7355908.1 303405 g133129 i0 100 0.909090909090909 50 0 90.9 0 16 165 5 54 KAG7355908.1 chlorophyll A-B binding protein [Nitzschia inconspicua] diamond 150 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31969968 31969968 PRJNA1240804_P_NODE_110618_length_169_cov_0.866667_g110252_i0 PRJNA1240804 110618 169 0.866667 1.46466723 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.74e-7   NR KAG7366549.1 303405 g110252 i0 60.5 0.674556213017751 38 15 67.5 0 4 117 404 441 KAG7366549.1 hypothetical protein IV203_029219 [Nitzschia inconspicua] diamond 114 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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