RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA662254 · 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
7539812 7539812 PRJNA662254_P_NODE_22966_length_343_cov_28.644444_g22315_i0 PRJNA662254 22966 343 28.644444 98.25044292 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 346 1.33e-90   NTclustered gi|769741|emb|X86093.1| 39594 g22315 i0 95.434 64.4139941690962 219 7 64 1 2 220 761 546 Allogromia sp. 18S rRNA gene blastn 22094 348 0.994252873563218 Eukaryota Sar   Foraminifera       Allogromia Allogromia sp.
8281473 8281473 PRJNA662254_P_NODE_41887_length_259_cov_1.655914_g41236_i0 PRJNA662254 41887 259 1.655914 4.28881726 Lieberkuehnia wageneri 1884994 SAR_Eukaryotes SAR_Eukaryotes 479 9.13e-131   NTclustered gi|1379128909|gb|MH235221.1| 1884994 g41236 i0 100 67.8108108108108 259 0 100 0 1 259 683 941 Lieberkuehnia wageneri isolate 10456 small subunit ribosomal RNA gene, partial sequence blastn 17563 479 1 Eukaryota Sar   Foraminifera     Lieberkuehniidae Lieberkuehnia Lieberkuehnia wageneri
21563872 21563872 PRJNA662254_P_NODE_15177_length_421_cov_4.640805_g14526_i0 PRJNA662254 15177 421 4.640805 19.53778905 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 230 1.7399999999999995e-55   NTclustered gi|998623043|dbj|LC049322.1| 51039 g14526 i0 94.156 14.3942992874109 154 4 36 3 1 150 3541 3693 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 6060 230 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
21563876 21563876 PRJNA662254_P_NODE_16517_length_403_cov_3.003030_g15866_i0 PRJNA662254 16517 403 3.00303 12.1022109 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 257 7.630000000000001e-64   NTclustered gi|998623043|dbj|LC049322.1| 51039 g15866 i0 91.534 38.0570719602978 189 13 47 2 172 359 4029 4215 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 15337 257 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
25388358 25388358 PRJNA662254_P_NODE_19100_length_374_cov_44.784053_g18449_i0 PRJNA662254 19100 374 44.784053 167.49235822 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 193 2.01e-44   NTclustered gi|643022|emb|X78521.1| 35210 g18449 i0 95.798 43.2005347593583 119 5 89 0 256 374 2855 2737 R.elatiana complete gene of large subunit rRNA blastn 16157 193 1 Eukaryota Sar   Foraminifera   Rotaliida Rotaliidae Rotaliella Rotaliella elatiana

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