RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA177642" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA177642 · 3 ✖

analysis 1

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
28684746 28684746 PRJNA177642_P_NODE_8227_length_423_cov_2.251269_g7022_i0 PRJNA177642 8227 423 2.251269 9.52286787 Ridgeia piscesae 27915 Annelida Annelida 62.8 3.69e-10   NR KAK2189865.1 27915 g7022 i0 50 0.382978723404255 54 27 38.3 0 395 234 9 62 KAK2189865.1 hypothetical protein NP493_95g04006 [Ridgeia piscesae] diamond 162 62.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
32083185 32083185 PRJNA177642_P_NODE_15878_length_179_cov_1.726667_g14653_i0 PRJNA177642 15878 179 1.726667 3.09073393 Metazoa 33208 Annelida Annelida 45.4 0.00177   NR CAH1797088.1 6347 g14653 i0 42.9 5.64804469273743 42 23 68.7 1 1 123 99 140 CAH1797088.1 unnamed protein product [Owenia fusiformis] diamond 1011 45.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
32097060 32097060 PRJNA177642_P_NODE_6798_length_513_cov_1.605372_g5641_i0 PRJNA177642 6798 513 1.605372 8.23555836 Ridgeia piscesae 27915 Annelida Annelida 62.8 7.96e-10   NR KAK2189865.1 27915 g5641 i0 50 0.315789473684211 54 27 31.6 0 485 324 9 62 KAK2189865.1 hypothetical protein NP493_95g04006 [Ridgeia piscesae] diamond 162 62.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae

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