RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 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
2426322 2426322 PRJNA630162_P_NODE_108222_length_181_cov_0.954545_g106699_i0 PRJNA630162 108222 181 0.954545 1.72772645 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 87.9 4.21e-13   NTclustered gi|998623043|dbj|LC049322.1| 51039 g106699 i0 92.063 5.69613259668508 63 3 34 2 51 112 4248 4309 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 1031 87.9 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
4430346 4430346 PRJNA630162_P_NODE_76204_length_206_cov_1.700637_g74681_i0 PRJNA630162 76204 206 1.700637 3.50331222 Trochammina sp. 37356 SAR_Eukaryotes SAR_Eukaryotes 246 7.7e-61   NTclustered gi|619567|emb|Z30147.1| 37356 g74681 i0 89.691 57.2572815533981 194 18 94 2 3 196 1742 1551 T.sp. gene for 28S ribosomal RNA blastn 11795 246 1 Eukaryota Sar   Foraminifera   Textulariida Trochamminidae Trochammina Trochammina sp.
5706436 5706436 PRJNA630162_P_NODE_93665_length_189_cov_2.714286_g92142_i0 PRJNA630162 93665 189 2.714286 5.13000054 Foraminifera environmental sample 185789 SAR_Eukaryotes SAR_Eukaryotes 283 5.28e-72   NTclustered gi|28194285|gb|AF474144.1| 185789 g92142 i0 95 52.4656084656085 180 9 95 0 1 180 769 590 Uncultured Foraminifera clone Cha 5A4 small subunit ribosomal RNA gene, partial sequence blastn 9916 283 1 Eukaryota Sar   Foraminifera         Foraminifera environmental sample
13355612 13355612 PRJNA630162_P_NODE_106711_length_181_cov_3.242424_g105188_i0 PRJNA630162 106711 181 3.242424 5.86878744 Allogromida sp. 2 MH-2012 1238470 SAR_Eukaryotes SAR_Eukaryotes 150 5.299999999999999e-32   NTclustered gi|559105587|emb|HE998686.1| 1238470 g105188 i0 81.868 1.00552486187845 182 29 99 4 2 180 704 884 Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323 blastn 182 150 1 Eukaryota Sar   Foraminifera         Allogromida sp. 2 MH-2012
13356323 13356323 PRJNA630162_P_NODE_27751_length_345_cov_2.479730_g26229_i0 PRJNA630162 27751 345 2.47973 8.5550685 Allogromida sp. 2 MH-2012 1238470 SAR_Eukaryotes SAR_Eukaryotes 326 1.74e-84   NTclustered gi|559105587|emb|HE998686.1| 1238470 g26229 i0 92.952 67.6434782608696 227 10 81 4 121 345 352 574 Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323 blastn 23337 326 1 Eukaryota Sar   Foraminifera         Allogromida sp. 2 MH-2012
22828570 22828570 PRJNA630162_P_NODE_125578_length_171_cov_2.950820_g124055_i0 PRJNA630162 125578 171 2.95082 5.0459022 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 182 1.75e-41   NTclustered gi|259090635|gb|FJ705892.1| 674485 g124055 i0 99.01 59.6432748538012 101 1 59 0 2 102 2233 2133 Rotaliida sp. F20 small subunit ribosomal RNA gene, complete sequence blastn 10199 183 0.994535519125683 Eukaryota Sar   Foraminifera   Rotaliida     Rotaliida sp. F20
23554172 23554172 PRJNA630162_P_NODE_130879_length_169_cov_1.500000_g129356_i0 PRJNA630162 130879 169 1.5 2.535 Allogromida sp. 2 MH-2012 1238470 SAR_Eukaryotes SAR_Eukaryotes 126 8.2e-25   NTclustered gi|559105587|emb|HE998686.1| 1238470 g129356 i0 84.091 0.781065088757396 132 19 77 2 2 131 884 753 Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323 blastn 132 126 1 Eukaryota Sar   Foraminifera         Allogromida sp. 2 MH-2012

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