RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA737474 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
25569752 25569752 PRJNA737474b_S_NODE_43897_length_247_cov_2.149425_g42858_i0 PRJNA737474 43897 247 2.149425 5.30907975 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 108 4.7e-19   NTclustered gi|219129759|ref|XM_002185013.1| 556484 g42858 i0 93.151 3.04048582995951 73 5 30 0 21 93 409 481 Phaeodactylum tricornutum CCAP 1055/1 calmoduline (CaM1), mRNA blastn 751 108 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25584474 25584474 PRJNA737474g_S_NODE_204737_length_276_cov_1.305419_g203443_i0 PRJNA737474 204737 276 1.305419 3.60295644 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 87.9 6.96e-13   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g203443 i0 77.326 2.40579710144928 172 23 62 7 61 230 46645 46488 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 664 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
25718474 25718474 PRJNA737474g_S_NODE_114706_length_316_cov_1.534979_g113412_i0 PRJNA737474 114706 316 1.534979 4.85053364 Pseudo-nitzschia hainanensis 2775602 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.74e-14   NTclustered gi|2839792208|gb|PQ512806.1| 2775602 g113412 i0 88.312 0.623417721518987 77 9 24 0 157 233 4821 4897 Pseudo-nitzschia hainanensis isolate CNS00090 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 197 93.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia hainanensis
25986296 25986296 PRJNA737474f_S_NODE_179948_length_256_cov_2.950820_g179270_i0 PRJNA737474 179948 256 2.95082 7.5540992 Craticula sp. RGastineau-2 2862135 SAR_Eukaryotes SAR_Eukaryotes 99 2.95e-16   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g179270 i0 83.636 71.84375 110 13 42 5 78 185 55120 55014 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 18392 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a
26250285 26250285 PRJNA737474b_S_NODE_42462_length_250_cov_2.700565_g41423_i0 PRJNA737474 42462 250 2.700565 6.7514125 Coscinodiscus wailesii 671091 SAR_Eukaryotes SAR_Eukaryotes 185 2.14e-42   NTclustered gi|2088246177|ref|NC_057078.1| 671091 g41423 i0 85.027 81.968 187 23 74 5 3 187 27521 27338 Coscinodiscus wailesii mitochondrion, complete genome blastn 20492 185 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii

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