RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJEB25789" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB25789 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
6089835 6089835 PRJEB25789_S_NODE_6405_length_362_cov_1.124567_g6326_i0 PRJEB25789 6405 362 1.124567 4.07093254 Demospongiae 6042 Porifera other_Eukaryota 58.4 7.38e-4   NTclustered gi|2644120949|gb|OM729606.2| 85783 g6326 i0 89.13 0.889502762430939 46 5 13 0 71 116 19210 19165 Acanthella acuta mitochondrion, complete genome blastn 322 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Bubarida Dictyonellidae Acanthella Acanthella acuta
17564356 17564356 PRJEB25789_S_NODE_1234_length_736_cov_17.042232_g1163_i0 PRJEB25789 1234 736 17.042232 125.43082752 Metazoa 33208 Porifera other_Eukaryota 496 2.83e-135   NTclustered gi|2732902391|ref|XM_065339131.1| 27933 g1163 i0 80.841 86.5788043478261 642 113 87 8 100 736 1186 550 PREDICTED: Sycon ciliatum actin-3-like (LOC135826522), mRNA blastn 63722 496 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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