RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Brachiopoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Brachiopoda · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA641707 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
614744 614744 PRJNA641707_P_NODE_275061_length_172_cov_5.056911_g272398_i0 PRJNA641707 275061 172 5.056911 8.69788692 Lingula anatina 7574 Brachiopoda other_Eukaryota 89.8 1.1e-13   NTclustered gi|919028090|ref|XM_013542430.1| 7574 g272398 i0 88.889 2.53488372093023 72 8 42 0 101 172 1038 1109 PREDICTED: Lingula anatina segment polarity protein dishevelled homolog DVL-3 (LOC106164491), transcript variant X2, mRNA blastn 436 89.8 1 Eukaryota Opisthokonta Metazoa Brachiopoda Lingulata Lingulida Lingulidae Lingula Lingula anatina
4445127 4445127 PRJNA641707_P_NODE_87744_length_246_cov_6.142132_g85081_i0 PRJNA641707 87744 246 6.142132 15.10964472 Lingula anatina 7574 Brachiopoda other_Eukaryota 75 4.74e-9   NTclustered gi|919026746|ref|XM_013541705.1| 7574 g85081 i0 94 0.203252032520325 50 1 20 2 160 208 780 828 PREDICTED: Lingula anatina acyl-CoA dehydrogenase family member 11 (LOC106163962), mRNA blastn 50 75 1 Eukaryota Opisthokonta Metazoa Brachiopoda Lingulata Lingulida Lingulidae Lingula Lingula anatina
19739567 19739567 PRJNA641707_P_NODE_186196_length_199_cov_7.540000_g183533_i0 PRJNA641707 186196 199 7.54 15.0046 Lingula anatina 7574 Brachiopoda other_Eukaryota 52.8 0.017   NTclustered gi|919058507|ref|XM_013555679.1| 7574 g183533 i0 100 0.844221105527638 28 0 14 0 172 199 3970 3997 PREDICTED: Lingula anatina myosin-IIIb (LOC106174232), transcript variant X2, mRNA blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Brachiopoda Lingulata Lingulida Lingulidae Lingula Lingula anatina

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