RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA322517" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA322517 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
4216515 4216515 PRJNA322517_P_NODE_2544_length_295_cov_7.654472_g2522_i0 PRJNA322517 2544 295 7.654472 22.5806924 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 318 2.439999999999999e-82   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g2522 i0 86.486 43.3050847457627 296 33 99 6 1 294 3719 4009 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 12775 318 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
8042508 8042508 PRJNA322517_P_NODE_2887_length_264_cov_1.395349_g2865_i0 PRJNA322517 2887 264 1.395349 3.68372136 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 466 7.27e-127   NTclustered gi|512134091|gb|KC575315.1| 175275 g2865 i0 98.485 99.8371212121212 264 4 100 0 1 264 40 303 Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence blastn 26357 466 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
16966610 16966610 PRJNA322517_P_NODE_3194_length_238_cov_1.349206_g3172_i0 PRJNA322517 3194 238 1.349206 3.21111028 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 350 6.77e-92   NTclustered gi|238617605|gb|FJ973380.1| 45107 g3172 i0 93.249 100.575630252101 237 16 99 0 1 237 1191 1427 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 23937 350 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
19515113 19515113 PRJNA322517_P_NODE_3256_length_234_cov_1.718919_g3234_i0 PRJNA322517 3256 234 1.718919 4.02227046 Glissomonad sp. Panama103 563749 SAR_Eukaryotes SAR_Eukaryotes 411 3e-110   NTclustered gi|219524909|gb|EU709272.1| 563749 g3234 i0 98.291 99.982905982906 234 4 100 0 1 234 870 637 Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence blastn 23396 411 1 Eukaryota Sar   Cercozoa         Glissomonad sp. Panama103

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