RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA597223 · 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
5673010 5673010 PRJNA597223_P_NODE_51805_length_193_cov_3.360759_g49959_i0 PRJNA597223 51805 193 3.360759 6.48626487 Nitzschia dissipatoides 3068544 SAR_Eukaryotes SAR_Eukaryotes 263 7.059999999999999e-66   NTclustered gi|2721954655|gb|OR464351.1| 3068544 g49959 i0 90.206 134.466321243523 194 15 100 2 1 193 91124 91314 Nitzschia dissipatoides plastid, complete genome blastn 25952 263 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipatoides
10069421 10069421 PRJNA597223_P_NODE_78168_length_160_cov_1.328000_g76322_i0 PRJNA597223 78168 160 1.328 2.1248 Chaetoceros 49237 SAR_Eukaryotes SAR_Eukaryotes 84.2 4.71e-12   NTclustered gi|2862228897|gb|PQ645531.1| 240364 g76322 i0 94.444 33.28125 54 3 34 0 1 54 2660 2713 Chaetoceros neogracilis isolate AGSB0402 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 5325 84.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros neogracilis
23521929 23521929 PRJNA597223_P_NODE_86139_length_151_cov_3.844828_g84293_i0 PRJNA597223 86139 151 3.844828 5.80569028 Chaetoceros curvisetus 230516 SAR_Eukaryotes SAR_Eukaryotes 200 4.16e-47   NTclustered gi|2043890832|gb|MZ267687.1| 230516 g84293 i0 91.724 96.4172185430464 145 10 96 1 7 151 2729 2587 Chaetoceros curvisetus isolate CNS00516 large subunit ribosomal RNA gene, partial sequence blastn 14559 200 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros curvisetus

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