RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA495391 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
4935666 4935666 PRJNA495391_S_NODE_48884_length_176_cov_18.085106_g47832_i0 PRJNA495391 48884 176 18.085106 31.82978656 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 318 1.3299999999999995e-82   NTclustered gi|72398633|gb|DQ093370.1| 29207 g47832 i0 99.432 99.9261363636364 176 0 100 1 1 176 785 611 Stephanodiscus hantzschii strain CCAP 1079/4 18S small subunit ribosomal RNA gene, partial sequence blastn 17587 318 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
5579472 5579472 PRJNA495391_S_NODE_19825_length_269_cov_8.927350_g18773_i0 PRJNA495391 19825 269 8.92735 24.0145715 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 497 2.63e-136   NTclustered gi|168145881|emb|AM710515.1| 431330 g18773 i0 100 100.762081784387 269 0 100 0 1 269 25 293 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 27105 497 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
6854747 6854747 PRJNA495391_S_NODE_64446_length_156_cov_2.471074_g63394_i0 PRJNA495391 64446 156 2.471074 3.85487544 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 161 2.05e-35   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g63394 i0 85.987 68.5641025641026 157 15 100 6 1 156 4851 4701 Naviculales sp. strain SZCZO2114 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 10696 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
11310644 11310644 PRJNA495391_S_NODE_51469_length_172_cov_2.715328_g50417_i0 PRJNA495391 51469 172 2.715328 4.67036416 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 246 6.17e-61   NTclustered gi|2632235341|gb|OR922723.1| 35128 g50417 i0 96.026 87.5930232558139 151 6 88 0 1 151 3829 3679 Thalassiosira pseudonana strain AGSB0188 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 15066 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
12586201 12586201 PRJNA495391_S_NODE_34690_length_207_cov_1.622093_g33638_i0 PRJNA495391 34690 207 1.622093 3.35773251 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 383 5.65e-102   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g33638 i0 100 198.400966183575 207 0 100 0 1 207 69399 69605 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 41069 383 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
15778946 15778946 PRJNA495391_S_NODE_34093_length_208_cov_4.815029_g33041_i0 PRJNA495391 34093 208 4.815029 10.01526032 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 252 1.67e-62   NTclustered gi|146762526|gb|EF553458.1| 2850 g33041 i0 88.517 100.302884615385 209 23 100 1 1 208 4342 4134 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 20863 252 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17685010 17685010 PRJNA495391_S_NODE_31494_length_216_cov_2.259669_g30442_i0 PRJNA495391 31494 216 2.259669 4.88088504 root 1 Root_unresolved Root_unresolved 348 2.1700000000000002e-91   NTclustered gi|74325165|ref|NC_007405.1| 35128 g30442 i0 96.244 92.6296296296296 213 7 98 1 1 212 14881 15093 Thalassiosira pseudonana mitochondrion, complete genome blastn 20008 348 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18327417 18327417 PRJNA495391_S_NODE_13535_length_325_cov_2.289655_g12483_i0 PRJNA495391 13535 325 2.289655 7.44137875 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 416 9.399999999999999e-112   NTclustered gi|1419234869|dbj|AP018512.1| 303400 g12483 i0 94.776 98.1261538461538 268 13 82 1 55 322 4800 5066 Nitzschia palea NIES-2729 mitochondrial DNA, nearly complete genome blastn 31891 416 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
19602647 19602647 PRJNA495391_S_NODE_49596_length_175_cov_2.628571_g48544_i0 PRJNA495391 49596 175 2.628571 4.59999925 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 307 2.8500000000000004e-79   NTclustered gi|2288719593|gb|OL415007.1| 2018706 g48544 i0 98.286 99.2857142857143 175 3 100 0 1 175 16729 16903 Haslea tsukamotoi isolate Jiaozhou Bay in China chloroplast, complete genome blastn 17375 307 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
22152422 22152422 PRJNA495391_S_NODE_17118_length_289_cov_5.413386_g16066_i0 PRJNA495391 17118 289 5.413386 15.64468554 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 381 2.9999999999999997e-101   NTclustered gi|2444483253|gb|OP718170.1| 97227 g16066 i0 91.135 100.515570934256 282 24 98 1 8 289 5476 5196 Gomphonema parvulum mitochondrion, complete genome blastn 29049 381 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
24701842 24701842 PRJNA495391_S_NODE_17840_length_283_cov_5.697581_g16788_i0 PRJNA495391 17840 283 5.697581 16.12415423 Skeletonema grevillei 371681 SAR_Eukaryotes SAR_Eukaryotes 472 1.6899999999999998e-128   NTclustered gi|2739942915|dbj|LC814775.1| 371681 g16788 i0 97.143 104.247349823322 280 7 99 1 1 280 33184 33462 Skeletonema grevillei NIES-2840 mitochondrial DNA, complete genome blastn 29502 472 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei

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