RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA911178 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2166826 2166826 PRJNA911178_P_NODE_127022_length_327_cov_1.204724_g124550_i0 PRJNA911178 127022 327 1.204724 3.93944748 Fallacia pygmaea 1003054 SAR_Eukaryotes SAR_Eukaryotes 435 2.61e-117   NTclustered gi|329342907|gb|HQ912298.1| 1003054 g124550 i0 91.223 97.8165137614679 319 28 98 0 1 319 876 558 Fallacia pygmaea strain UTEX FD294 PsbC (psbC) gene, partial cds; chloroplast blastn 31986 435 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Fallacia Fallacia pygmaea
2525702 2525702 PRJNA911178_P_NODE_23202_length_699_cov_17.402556_g20942_i0 PRJNA911178 23202 699 17.402556 121.64386644 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 1199 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g20942 i0 97.974 196.032904148784 691 14 99 0 1 691 68897 68207 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 137027 1199 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
3443111 3443111 PRJNA911178_P_NODE_21903_length_719_cov_16.292570_g19678_i0 PRJNA911178 21903 719 16.29257 117.1435783 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1256 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g19678 i0 98.324 197.173852573018 716 12 99 0 2 717 121521 120806 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 141768 1256 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
6353815 6353815 PRJNA911178_P_NODE_169705_length_289_cov_1.393519_g167232_i0 PRJNA911178 169705 289 1.393519 4.02726991 Diploneis 1003045 SAR_Eukaryotes SAR_Eukaryotes 374 5.029999999999998e-99   NTclustered gi|1402371742|gb|MH063987.1| 2126179 g167232 i0 90.21 99.4186851211073 286 28 99 0 1 286 351 66 Diploneis parca strain KSA2015-49 oval-ED-2 photosystem II subunit C (psbC) gene, partial cds; chloroplast blastn 28732 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diploneidaceae Diploneis Diploneis parca
8902724 8902724 PRJNA911178_P_NODE_180587_length_282_cov_35.583732_g178114_i0 PRJNA911178 180587 282 35.583732 100.34612424 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 455 1.7e-123   NTclustered gi|2202538965|gb|OM891871.1| 515483 g178114 i0 97.048 94.1808510638298 271 6 96 1 5 275 3379 3647 Psammodictyon constrictum 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 26559 455 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
9820866 9820866 PRJNA911178_P_NODE_302028_length_231_cov_2.765823_g299554_i0 PRJNA911178 302028 231 2.765823 6.38905113 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 351 1.8199999999999998e-92   NTclustered gi|2444483253|gb|OP718170.1| 97227 g299554 i0 94.69 102.532467532468 226 12 98 0 1 226 7981 7756 Gomphonema parvulum mitochondrion, complete genome blastn 23685 351 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
13646962 13646962 PRJNA911178_P_NODE_61351_length_446_cov_61.206434_g58902_i0 PRJNA911178 61351 446 61.206434 272.98069564 Mayamaea atomus 431391 SAR_Eukaryotes SAR_Eukaryotes 675 0   NTclustered gi|168145942|emb|AM710599.1| 431391 g58902 i0 94.713 94.2017937219731 435 22 97 1 13 446 14 448 Mayamaea atomus partial 28S rRNA gene, strain AT-199Gel01 blastn 42014 675 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea atomus
16194313 16194313 PRJNA911178_P_NODE_13293_length_918_cov_2.726627_g11432_i0 PRJNA911178 13293 918 2.726627 25.03043586 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 1415 0   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g11432 i0 94.725 122.906318082789 910 48 99 0 9 918 89436 90345 Eunotia naegelii chloroplast, complete genome blastn 112828 1415 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
16195561 16195561 PRJNA911178_P_NODE_27533_length_645_cov_68.487762_g25206_i0 PRJNA911178 27533 645 68.487762 441.7460649 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 915 0   NTclustered gi|146762526|gb|EF553458.1| 2850 g25206 i0 92.512 99.7457364341085 641 45 99 3 6 645 3908 4546 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 64336 915 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20377038 20377038 PRJNA911178_P_NODE_82596_length_391_cov_87.270440_g80129_i0 PRJNA911178 82596 391 87.27044 341.2274204 Sellaphora 216740 SAR_Eukaryotes SAR_Eukaryotes 684 0   NTclustered gi|134143232|gb|EF151962.1| 216741 g80129 i0 99.468 95.6649616368287 376 2 96 0 15 390 2 377 Sellaphora pupula clone RBG1 18S ribosomal RNA gene, partial sequence blastn 37405 689 0.992743105950653 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora pupula

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