RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA939370 · 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
914619 914619 PRJNA939370_S_NODE_1941_length_196_cov_1.102041_g1889_i0 PRJNA939370 1941 196 1.102041 2.16000036 Protaspis grandis 361427 SAR_Eukaryotes SAR_Eukaryotes 180 7.45e-41   NTclustered gi|290760486|gb|GQ144689.1| 361427 g1889 i0 83.684 46.4081632653061 190 31 97 0 6 195 1805 1994 Protaspis grandis large subunit ribosomal RNA gene, partial sequence blastn 9096 180 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Protaspis Protaspis grandis
2190064 2190064 PRJNA939370_S_NODE_3162_length_162_cov_1.265487_g3110_i0 PRJNA939370 3162 162 1.265487 2.05008894 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 250 4.45e-62   NTclustered gi|161015657|gb|EF666122.1| 466266 g3110 i0 94.512 101.364197530864 164 5 100 3 1 162 184 23 Cercomonas crassicauda 28S ribosomal RNA gene, partial sequence blastn 16421 250 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda
12393852 12393852 PRJNA939370_S_NODE_990_length_285_cov_6.067797_g938_i0 PRJNA939370 990 285 6.067797 17.29322145 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 117 9.2e-22   NTclustered gi|238617602|gb|FJ973377.1| 188950 g938 i0 84.252 26.1052631578947 127 13 44 4 3 127 2658 2779 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 7440 117 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima

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