RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA914897 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
4723340 4723340 PRJNA914897_P_NODE_18524_length_399_cov_1.944785_g18102_i0 PRJNA914897 18524 399 1.944785 7.75969215 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 481 4.11e-131   NTclustered gi|238617605|gb|FJ973380.1| 45107 g18102 i0 88.529 100.734335839599 401 40 100 5 1 399 1186 1582 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 40193 481 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
20377318 20377318 PRJNA914897_P_NODE_6476_length_776_cov_1.428165_g6101_i0 PRJNA914897 6476 776 1.428165 11.0825604 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 163 3.4399999999999996e-35   NTclustered gi|238617607|gb|FJ973382.1| 39717 g6101 i0 94.34 21.6005154639175 106 6 24 0 664 769 1348 1243 Paulinella chromatophora strain MO88/a 28S ribosomal RNA gene, partial sequence blastn 16762 163 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
22572018 22572018 PRJNA914897_P_NODE_34018_length_265_cov_1.421875_g33594_i0 PRJNA914897 34018 265 1.421875 3.76796875 Bodomorpha sp. HFCC55 624126 SAR_Eukaryotes SAR_Eukaryotes 479 9.38e-131   NTclustered gi|225216790|gb|FJ176705.1| 624126 g33594 i0 99.245 2 265 2 100 0 1 265 706 442 Bodomorpha sp. 28S ribosomal RNA gene, partial sequence blastn 530 479 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC55

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