RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA206070" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA206070 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1640991 1640991 PRJNA206070_S_NODE_15842_length_252_cov_7.353488_g13966_i0 PRJNA206070 15842 252 7.353488 18.53078976 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 364 2.58e-96   NTclustered gi|829158923|ref|XM_012796529.1| 312017 g13966 i0 97.209 3.54365079365079 215 6 85 0 9 223 50 264 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 893 364 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
4883641 4883641 PRJNA206070_S_NODE_25384_length_171_cov_3.223881_g23508_i0 PRJNA206070 25384 171 3.223881 5.51283651 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 305 9.96e-79   NTclustered gi|662012956|ref|NC_024084.1| 163516 g23508 i0 98.83 198.976608187135 171 2 100 0 1 171 71839 72009 Leptocylindrus danicus chloroplast, complete genome blastn 34025 305 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus danicus
5469770 5469770 PRJNA206070_S_NODE_25625_length_170_cov_2.338346_g23749_i0 PRJNA206070 25625 170 2.338346 3.9751882 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 237 3.6600000000000005e-58   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g23749 i0 91.765 10.9294117647059 170 14 100 0 1 170 220 51 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1858 237 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
5469841 5469841 PRJNA206070_S_NODE_29625_length_155_cov_3.220339_g27749_i0 PRJNA206070 29625 155 3.220339 4.99152545 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 182 1.56e-41   NTclustered gi|11466252|ref|NC_000862.1| 5908 g27749 i0 87.821 15.4516129032258 156 18 100 1 1 155 366 211 Tetrahymena pyriformis mitochondrion, complete genome blastn 2395 182 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
6158303 6158303 PRJNA206070_S_NODE_15565_length_257_cov_1.131818_g13689_i0 PRJNA206070 15565 257 1.131818 2.90877226 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 411 3.349999999999999e-110   NTclustered gi|15027629|ref|NC_003029.1| 5911 g13689 i0 95.72 49.1011673151751 257 8 99 3 1 256 32973 33227 Tetrahymena thermophila mitochondrion, complete genome blastn 12619 411 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8019932 8019932 PRJNA206070_S_NODE_31127_length_151_cov_2.052632_g29251_i0 PRJNA206070 31127 151 2.052632 3.09947432 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 267 4.04e-67   NTclustered gi|114329902|ref|NC_008339.1| 5907 g29251 i0 98.667 19.7350993377483 150 2 99 0 2 151 2089 1940 Tetrahymena pigmentosa mitochondrion, complete genome blastn 2980 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
11259039 11259039 PRJNA206070_S_NODE_9069_length_416_cov_2.923483_g7196_i0 PRJNA206070 9069 416 2.923483 12.16168928 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 708 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g7196 i0 97.356 42.0528846153846 416 11 100 0 1 416 633 218 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 17494 708 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
15669021 15669021 PRJNA206070_S_NODE_16133_length_248_cov_2.767773_g14257_i0 PRJNA206070 16133 248 2.767773 6.86407704 Tetrahymena sp. KGE15 1200497 SAR_Eukaryotes SAR_Eukaryotes 440 4.0999999999999997e-119   NTclustered gi|523704203|emb|HE861887.1| 1200497 g14257 i0 98.785 99.8991935483871 247 3 99 0 2 248 632 386 Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 blastn 24775 440 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena sp. KGE15
17633312 17633312 PRJNA206070_S_NODE_26554_length_166_cov_1.984496_g24678_i0 PRJNA206070 26554 166 1.984496 3.29426336 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 285 1.26e-72   NTclustered gi|2778381911|gb|PQ010276.1| 189737 g24678 i0 97.59 198.006024096386 166 4 100 0 1 166 12608 12443 Pseudo-nitzschia galaxiae isolate CNS01103 chloroplast, complete genome blastn 32869 285 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
19492448 19492448 PRJNA206070_S_NODE_28736_length_158_cov_1.917355_g26860_i0 PRJNA206070 28736 158 1.917355 3.0294209 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 257 2.58e-64   NTclustered gi|114329902|ref|NC_008339.1| 5907 g26860 i0 96.203 18 158 5 100 1 1 158 2383 2227 Tetrahymena pigmentosa mitochondrion, complete genome blastn 2844 257 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
23318569 23318569 PRJNA206070_S_NODE_28759_length_158_cov_1.611570_g26883_i0 PRJNA206070 28759 158 1.61157 2.5462806 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|145530919|ref|XM_001451195.1| 5888 g26883 i0 94.444 0.227848101265823 36 1 23 1 90 125 7631 7665 Paramecium tetraurelia uncharacterized protein (GSPATT00018152001), partial mRNA blastn 36 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
24592722 24592722 PRJNA206070_S_NODE_28700_length_158_cov_2.190083_g26824_i0 PRJNA206070 28700 158 2.190083 3.46033114 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 259 7.17e-65   NTclustered gi|2088238071|ref|NC_056910.1| 88167 g26824 i0 96.203 103.740506329114 158 6 100 0 1 158 14836 14679 Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome blastn 16391 259 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis

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