RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA358049", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA358049 · 6 ✖

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
11276382 11276382 PRJNA358049_S_NODE_3589_length_314_cov_10.343396_g3541_i0 PRJNA358049 3589 314 10.343396 32.47826344 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 553 6.609999999999998e-153   NTclustered gi|18698478|gb|AF417679.1| 186032 g3541 i0 98.408 99.7898089171974 314 5 100 0 1 314 351 38 Navicula cf. erifuga strain Navicula large subunit ribosomal RNA gene, partial sequence blastn 31334 558 0.991039426523297 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cf. erifuga
15100914 15100914 PRJNA358049_S_NODE_18772_length_161_cov_2.535714_g18724_i0 PRJNA358049 18772 161 2.535714 4.08249954 Fragilaria 33644 SAR_Eukaryotes SAR_Eukaryotes 261 2.04e-65   NTclustered gi|18698483|gb|AF417684.1| 185980 g18724 i0 98 93.9192546583851 150 3 93 0 10 159 137 286 Fragilaria capucina strain M1767 large subunit ribosomal RNA gene, partial sequence blastn 15121 261 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
18250263 18250263 PRJNA358049_S_NODE_17955_length_163_cov_1.807018_g17907_i0 PRJNA358049 17955 163 1.807018 2.94543934 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 243 7.51e-60   NTclustered gi|168145881|emb|AM710515.1| 431330 g17907 i0 97.857 69.4662576687117 140 3 86 0 15 154 474 335 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 11323 243 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
20800222 20800222 PRJNA358049_S_NODE_4917_length_273_cov_9.196429_g4869_i0 PRJNA358049 4917 273 9.196429 25.10625117 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 496 9.63e-136   NTclustered gi|168145881|emb|AM710515.1| 431330 g4869 i0 99.631 99.7838827838828 271 1 99 0 3 273 27 297 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 27241 496 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
24024866 24024866 PRJNA358049_S_NODE_14979_length_173_cov_2.435484_g14931_i0 PRJNA358049 14979 173 2.435484 4.21338732 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 281 1.7e-71   NTclustered gi|2301268953|ref|NC_066075.1| 355634 g14931 i0 100 173.28323699422 152 0 88 0 1 152 9969 9818 Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome blastn 29978 281 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
32824514 32824514 PRJNA358049_S_NODE_12980_length_184_cov_1.762963_g12932_i0 PRJNA358049 12980 184 1.762963 3.24385192 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 84.3 5.25e-19   NR CAB9499426.1 568900 g12932 i0 97.6 1.33695652173913 41 1 66.8 0 168 46 97 137 CAB9499426.1 40S ribosomal protein S15a [Seminavis robusta] diamond 246 84.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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