RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA675042" 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

  • PRJNA675042 · 5 ✖

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
3720134 3720134 PRJNA675042_P_NODE_87083_length_272_cov_1.547739_g86633_i0 PRJNA675042 87083 272 1.547739 4.20985008 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 481 2.69e-131   NTclustered gi|1862846707|emb|LR812489.1| 186038 g86633 i0 98.535 99.9595588235294 273 3 100 1 1 272 6581 6309 Fragilariopsis kerguelensis, rDNA tandem repeat intergenic spacer region, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2 and 28S ribosomal RNA gene, complete sequence blastn 27189 484 0.993801652892562 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
10850109 10850109 PRJNA675042_P_NODE_13129_length_461_cov_4.842784_g12679_i0 PRJNA675042 13129 461 4.842784 22.32523424 Nitzschia amphibia 304200 SAR_Eukaryotes SAR_Eukaryotes 721 0   NTclustered gi|56398975|emb|AJ867277.1| 304200 g12679 i0 98.765 89.9479392624729 405 5 100 0 1 405 405 1 Nitzschia amphibia partial 18S rRNA gene, strain FDCC L602 blastn 41466 721 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia amphibia
12126339 12126339 PRJNA675042_P_NODE_4750_length_640_cov_4.435626_g4326_i0 PRJNA675042 4750 640 4.435626 28.3880064 Nitzschia supralitorea 303403 SAR_Eukaryotes SAR_Eukaryotes 1088 0   NTclustered gi|2088232410|ref|NC_056788.1| 303403 g4326 i0 97.348 99.009375 641 16 100 1 1 640 37837 37197 Nitzschia supralitorea isolate SZCZR1828 mitochondrion, complete genome blastn 63366 1088 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia supralitorea
21049279 21049279 PRJNA675042_P_NODE_2537_length_837_cov_14.859948_g2160_i0 PRJNA675042 2537 837 14.859948 124.37776476 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 791 0   NTclustered gi|2209416098|gb|ON014997.1| 303405 g2160 i0 98.866 99.4086021505376 441 4 100 1 397 837 59 498 Nitzschia inconspicua clone CBac2018010 large subunit ribosomal RNA gene, partial sequence blastn 83205 791 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
22845843 22845843 PRJNA675042_P_NODE_8438_length_529_cov_5.752193_g7995_i0 PRJNA675042 8438 529 5.752193 30.42910097 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 145 8.33e-30   NTclustered gi|2202538974|gb|OM891880.1| 355634 g7995 i0 87.805 23.7939508506616 123 15 23 0 39 161 3709 3831 Navicula arenaria 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 12587 145 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria

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