RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA565584 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1135389 1135389 PRJNA565584_P_NODE_72321_length_349_cov_1.978261_g71170_i0 PRJNA565584 72321 349 1.978261 6.90413089 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 610 4.34e-170   NTclustered gi|2328365172|ref|NC_067848.1| 97227 g71170 i0 98.276 196.959885386819 348 6 99 0 2 349 72668 73015 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome blastn 68739 610 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
4383805 4383805 PRJNA565584_P_NODE_21524_length_680_cov_1.751236_g20405_i0 PRJNA565584 21524 680 1.751236 11.9084048 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 505 4.329999999999999e-138   NTclustered gi|657012367|gb|KF302531.1| 2850 g20405 i0 90.39 69.7205882352941 385 35 56 2 133 516 393 10 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 47410 505 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6932629 6932629 PRJNA565584_P_NODE_117386_length_283_cov_1.985714_g116234_i0 PRJNA565584 117386 283 1.985714 5.61957062 Luticola higleri 3064430 SAR_Eukaryotes SAR_Eukaryotes 420 6.21e-113   NTclustered gi|2553043243|gb|OR352033.1| 3064430 g116234 i0 93.357 93.2826855123675 286 15 100 2 1 283 395 111 Luticola higleri isolate D299_001 small subunit ribosomal RNA gene, partial sequence blastn 26399 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola higleri
8209642 8209642 PRJNA565584_P_NODE_30207_length_556_cov_5.592133_g29059_i0 PRJNA565584 30207 556 5.592133 31.09225948 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 241 1.09e-58   NTclustered gi|657012369|gb|KF302532.1| 2850 g29059 i0 86.636 0.390287769784173 217 29 39 0 231 447 226 10 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 217 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17133940 17133940 PRJNA565584_P_NODE_213294_length_241_cov_0.916667_g212142_i0 PRJNA565584 213294 241 0.916667 2.20916747 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 148 2.69e-31   NTclustered gi|219111198|ref|XM_002177315.1| 556484 g212142 i0 80.513 21.8713692946058 195 36 80 2 3 196 280 87 Phaeodactylum tricornutum CCAP 1055/1 protein heat shock protein Hsp70 (HSP70A), mRNA blastn 5271 148 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19684419 19684419 PRJNA565584_P_NODE_96456_length_304_cov_3.415584_g95304_i0 PRJNA565584 96456 304 3.415584 10.38337536 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 556 4.919999999999999e-154   NTclustered gi|1803023461|gb|MN937452.1| 2850 g95304 i0 99.671 198.730263157895 304 1 100 0 1 304 68538 68841 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 60414 556 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22232058 22232058 PRJNA565584_P_NODE_13618_length_893_cov_7.017073_g12611_i0 PRJNA565584 13618 893 7.017073 62.66246189 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 416 2.77e-111   NTclustered gi|657012367|gb|KF302531.1| 2850 g12611 i0 87.328 58.5307950727884 363 46 41 0 282 644 385 23 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 52268 416 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25360044 25360044 PRJNA565584_P_NODE_104840_length_292_cov_1.406393_g103688_i0 PRJNA565584 104840 292 1.406393 4.10666756 Cymbellales 97224 SAR_Eukaryotes SAR_Eukaryotes 507 4.81e-139   NTclustered gi|1418587827|ref|NC_038001.1| 186043 g103688 i0 97.952 107.325342465753 293 5 100 1 1 292 106407 106115 Entomoneis sp. chloroplast, complete genome blastn 31339 512 0.990234375 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

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