RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA763243 · 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
12685014 12685014 PRJNA763243_P_NODE_68190_length_228_cov_2.051613_g67844_i0 PRJNA763243 68190 228 2.051613 4.67767764 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 102 1.99e-17   NTclustered gi|111559331|gb|DQ790066.1| 1037239 g67844 i0 92.857 36.2412280701754 70 5 31 0 1 70 1065 996 Terebellides stroemi 28S large subunit ribosomal RNA gene, partial sequence blastn 8263 102 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Trichobranchidae Terebellides Terebellides stroemii
21145734 21145734 PRJNA763243_P_NODE_34797_length_291_cov_2.059633_g34451_i0 PRJNA763243 34797 291 2.059633 5.99353203 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g34451 i0 94.595 0.25085910652921 37 0 12 2 148 182 13278400 13278364 Hirudo verbana genome assembly, chromosome: 1 blastn 73 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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