RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB3181 · 6 ✖

analysis 1

  • blastn · 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
56050 56050 PRJEB3181_P_NODE_7801_length_302_cov_3.450185_g7539_i0 PRJEB3181 7801 302 3.450185 10.4195587 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 115 3.5400000000000006e-21   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g7539 i0 77.103 29.1192052980132 214 40 69 7 95 302 5601 5391 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 8794 115 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
1330216 1330216 PRJEB3181_P_NODE_1142_length_569_cov_155.524164_g1001_i0 PRJEB3181 1142 569 155.524164 884.93249316 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 99 7.11e-16   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g1001 i0 79.87 1.30755711775044 154 16 27 8 60 211 46505 46645 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 744 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
12809481 12809481 PRJEB3181_P_NODE_21491_length_176_cov_2.289655_g21226_i0 PRJEB3181 21491 176 2.289655 4.0297928 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 139 1.11e-28   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g21226 i0 81.183 37.4659090909091 186 24 100 10 1 176 32424 32240 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 6594 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
15358030 15358030 PRJEB3181_P_NODE_113_length_1178_cov_65.511770_g83_i0 PRJEB3181 113 1178 65.51177 771.7286506 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 222 8.65e-53   NTclustered gi|2074156200|gb|MW413905.1| 216802 g83 i0 78.01 37.0288624787776 382 64 31 15 36 405 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43620 222 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
21732636 21732636 PRJEB3181_P_NODE_118_length_1165_cov_54.198413_g83_i1 PRJEB3181 118 1165 54.198413 631.41151145 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 222 8.55e-53   NTclustered gi|2074156200|gb|MW413905.1| 216802 g83 i1 78.01 37.4420600858369 382 64 32 15 36 405 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43620 222 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
21732670 21732670 PRJEB3181_P_NODE_198_length_1004_cov_18.943474_g149_i0 PRJEB3181 198 1004 18.943474 190.19247896 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 158 2.1e-33   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g149 i0 75.401 24.7529880478088 374 67 36 19 24 387 27552 27910 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 24852 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia

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