RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJEB56699" 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

  • PRJEB56699 · 11 ✖

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
124579 124579 PRJEB56699_P_NODE_6161_length_172_cov_1.951049_g5931_i0 PRJEB56699 6161 172 1.951049 3.35580428 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 84.2 5.12e-12   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g5931 i0 76.19 24.2209302325581 168 35 97 4 7 172 5526 5362 Haslea avium 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 4166 84.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
992053 992053 PRJEB56699_P_NODE_6661_length_151_cov_2.270492_g6431_i0 PRJEB56699 6661 151 2.270492 3.42844292 Thalassiosiraceae 29202 SAR_Eukaryotes SAR_Eukaryotes 279 5.19e-71   NTclustered gi|1169296926|gb|KY364696.1| 29205 g6431 i0 100 99.9867549668874 151 0 100 0 1 151 3761 3611 Cyclotella meneghiniana 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 15098 279 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
2267279 2267279 PRJEB56699_P_NODE_6322_length_164_cov_2.355556_g6092_i0 PRJEB56699 6322 164 2.355556 3.86311184 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 276 7.46e-70   NTclustered gi|1783235058|gb|MN276191.1| 210602 g6092 i0 96.951 197.487804878049 164 5 100 0 1 164 98407 98244 Nanofrustulum shiloi strain SZCZM404 chloroplast, complete genome blastn 32388 276 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Staurosiraceae Nanofrustulum Nanofrustulum shiloi
5227147 5227147 PRJEB56699_P_NODE_2645_length_338_cov_3.763754_g2415_i0 PRJEB56699 2645 338 3.763754 12.72148852 Cymbella tumida 882190 SAR_Eukaryotes SAR_Eukaryotes 579 1.1799999999999999e-160   NTclustered gi|2162236538|gb|OL780393.1| 882190 g2415 i0 99.373 74.4881656804734 319 2 94 0 1 319 319 1 Cymbella tumida strain CBac2019069 large subunit ribosomal RNA gene, partial sequence blastn 25177 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Cymbella Cymbella tumida
9051825 9051825 PRJEB56699_P_NODE_1568_length_462_cov_8.974596_g1358_i0 PRJEB56699 1568 462 8.974596 41.46263352 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 734 0   NTclustered gi|66571059|emb|AJ878485.1| 29205 g1358 i0 99.261 97.4025974025974 406 3 99 0 57 462 529 124 Cyclotella meneghiniana partial 28S rRNA gene, strain AT-51.12 blastn 45000 734 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
9051828 9051828 PRJEB56699_P_NODE_208_length_1244_cov_3.762140_g144_i0 PRJEB56699 208 1244 3.76214 46.8010216 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 593 1.6799999999999996e-164   NTclustered gi|1169296926|gb|KY364696.1| 29205 g144 i0 95.913 27.5192926045016 367 14 30 1 878 1244 3913 4278 Cyclotella meneghiniana 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 34234 593 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
9051832 9051832 PRJEB56699_P_NODE_6588_length_154_cov_2.296000_g6358_i0 PRJEB56699 6588 154 2.296 3.53584 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 191 2.57e-44   NTclustered gi|146762526|gb|EF553458.1| 2850 g6358 i0 88.961 102.623376623377 154 17 100 0 1 154 4078 4231 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 15804 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12471006 12471006 PRJEB56699_P_NODE_3370_length_285_cov_2.156250_g3140_i0 PRJEB56699 3370 285 2.15625 6.1453125 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g3140 i0 88.889 4.23157894736842 45 5 16 0 109 153 51172 51216 Nitzschia reversa mitochondrion, complete genome blastn 1206 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
12471008 12471008 PRJEB56699_P_NODE_4550_length_223_cov_7.237113_g4320_i0 PRJEB56699 4550 223 7.237113 16.13876199 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 401 1.7099999999999992e-107   NTclustered gi|2316016826|gb|OL855988.1| 59812 g4320 i0 99.103 198.017937219731 223 2 100 0 1 223 10580 10802 Lithodesmium undulatum chloroplast, complete genome blastn 44158 401 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
12878205 12878205 PRJEB56699_P_NODE_2331_length_366_cov_6.017804_g2103_i0 PRJEB56699 2331 366 6.017804 22.02516264 Navicula capitatoradiata 431397 SAR_Eukaryotes SAR_Eukaryotes 667 0   NTclustered gi|168145917|emb|AM710568.1| 431397 g2103 i0 99.454 97.6256830601093 366 2 100 0 1 366 102 467 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 35731 667 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
20525531 20525531 PRJEB56699_P_NODE_4337_length_232_cov_5.699507_g4107_i0 PRJEB56699 4337 232 5.699507 13.22285624 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 412 8.26e-111   NTclustered gi|1169296926|gb|KY364696.1| 29205 g4107 i0 98.712 87.9439655172414 233 2 100 1 1 232 5610 5842 Cyclotella meneghiniana 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 20403 412 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus

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