RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA637219" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA637219 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1885060 1885060 PRJNA637219_S_NODE_7522_length_189_cov_2.185714_g7477_i0 PRJNA637219 7522 189 2.185714 4.13099946 Conticribra weissflogii 1577725 SAR_Eukaryotes SAR_Eukaryotes 100 5.71e-17   NTclustered gi|193875927|gb|EU810336.1| 1577725 g7477 i0 87.356 0.46031746031746 87 11 46 0 102 188 1252 1166 Thalassiosira weissflogii translation elongation factor 1A-like mRNA, partial cds blastn 87 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Conticribra Conticribra weissflogii
3159786 3159786 PRJNA637219_S_NODE_5743_length_209_cov_1.900000_g5698_i0 PRJNA637219 5743 209 1.9 3.971 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 246 7.83e-61   NTclustered gi|2996370|emb|AJ000967.1| 29204 g5698 i0 88.725 0.976076555023923 204 20 96 3 1 201 528 731 Cyclotella cryptica mRNA for fucoxanthin chlorophyll a/c binding protein, fcp5 blastn 204 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
8261907 8261907 PRJNA637219_S_NODE_10927_length_167_cov_0.864407_g10882_i0 PRJNA637219 10927 167 0.864407 1.44355969 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 276 7.64e-70   NTclustered gi|1169296926|gb|KY364696.1| 29205 g10882 i0 96.407 93.5089820359281 167 6 100 0 1 167 4015 4181 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 15616 276 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
14637755 14637755 PRJNA637219_S_NODE_392_length_602_cov_8.372514_g349_i0 PRJNA637219 392 602 8.372514 50.40253428 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 350 1.89e-91   NTclustered gi|657012367|gb|KF302531.1| 2850 g349 i0 86.52 18.5083056478405 319 41 53 2 1 318 68 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11142 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17186807 17186807 PRJNA637219_S_NODE_6514_length_200_cov_1.284768_g6469_i0 PRJNA637219 6514 200 1.284768 2.569536 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.22e-11   NTclustered gi|66968231|gb|DQ060240.1| 2853 g6469 i0 85 0.8 80 12 40 0 121 200 2259 2180 Cylindrotheca fusiformis chloroplast fucoxanthin chlorophyll a/c-binding protein precursor (cffcpA-1A) gene, complete cds; nuclear gene for chloroplast product blastn 160 82.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
22285959 22285959 PRJNA637219_S_NODE_6938_length_195_cov_1.397260_g6893_i0 PRJNA637219 6938 195 1.39726 2.724657 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 316 5.41e-82   NTclustered gi|74325165|ref|NC_007405.1| 35128 g6893 i0 95.897 97.5076923076923 195 8 100 0 1 195 12594 12400 Thalassiosira pseudonana mitochondrion, complete genome blastn 19014 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23561468 23561468 PRJNA637219_S_NODE_6679_length_198_cov_1.369128_g6634_i0 PRJNA637219 6679 198 1.369128 2.71087344 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 115 2.16e-21   NTclustered gi|223993504|ref|XM_002286400.1| 296543 g6634 i0 94.595 1.16161616161616 74 4 37 0 125 198 649 576 Thalassiosira pseudonana CCMP1335 fucoxanthin chlorophyll a/c protein 8 (Lhcf9), mRNA blastn 230 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana

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