RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA756891" 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

  • PRJNA756891 · 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
2008007 2008007 PRJNA756891_P_NODE_12822_length_249_cov_1.750000_g12753_i0 PRJNA756891 12822 249 1.75 4.3575 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 294 3.39e-75   NTclustered gi|238617602|gb|FJ973377.1| 188950 g12753 i0 88.048 61.7791164658635 251 27 100 3 1 249 2977 2728 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 15383 294 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
10130911 10130911 PRJNA756891_P_NODE_2588_length_519_cov_1.033632_g2520_i0 PRJNA756891 2588 519 1.033632 5.36455008 Cercozoa 136419 SAR_Eukaryotes SAR_Eukaryotes 383 1.5899999999999998e-101   NTclustered gi|302563026|dbj|AB546336.1| 39717 g2520 i0 80.19 50.6339113680154 525 90 100 11 1 519 750 234 Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds blastn 26279 383 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
16034680 16034680 PRJNA756891_P_NODE_6953_length_326_cov_1.083004_g6884_i0 PRJNA756891 6953 326 1.083004 3.53059304 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 134 1.06e-26   NTclustered gi|1315527746|gb|MF034898.1| 2065209 g6884 i0 84.783 2.97852760736196 138 15 42 5 70 205 1267 1400 Phytocercomonas venanatans actin gene, complete cds blastn 971 134 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans

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