RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1237888", tax_clade = "Sar" 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

  • PRJNA1237888 · 4 ✖

analysis 1

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
1621281 1621281 PRJNA1237888_S_NODE_2962_length_235_cov_2.419355_g2912_i0 PRJNA1237888 2962 235 2.419355 5.68548425 Licmophora juergensii 210598 SAR_Eukaryotes SAR_Eukaryotes 401 1.8199999999999993e-107   NTclustered gi|2862228907|gb|PQ645541.1| 210598 g2912 i0 97.447 99.9744680851064 235 6 100 0 1 235 3028 3262 Licmophora juergensii isolate AGSB0420 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23494 401 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Licmophoraceae Licmophora Licmophora juergensii
4173836 4173836 PRJNA1237888_S_NODE_764_length_453_cov_3.990099_g714_i0 PRJNA1237888 764 453 3.990099 18.07514847 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 730 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g714 i0 95.796 198.066225165563 452 19 99 0 1 452 121071 121522 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 89724 730 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
5450135 5450135 PRJNA1237888_S_NODE_285_length_673_cov_4.065705_g248_i0 PRJNA1237888 285 673 4.065705 27.36219465 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 669 0   NTclustered gi|146762526|gb|EF553458.1| 2850 g248 i0 91.296 73.7221396731055 494 37 73 6 1 492 4071 4560 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 49615 669 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14375680 14375680 PRJNA1237888_S_NODE_5712_length_173_cov_1.717742_g5662_i0 PRJNA1237888 5712 173 1.717742 2.97169366 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 287 3.6600000000000005e-73   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g5662 i0 97.605 196.398843930636 167 4 97 0 7 173 120932 121098 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 33977 287 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.

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