RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB82358" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB82358 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
7793239 7793239 PRJEB82358_P_NODE_9887_length_315_cov_2.599174_g9876_i0 PRJEB82358 9887 315 2.599174 8.1873981 Hyperolius riggenbachi 752182 Chordata Chordata 52.8 0.029   NTclustered gi|2801417439|ref|XM_068274716.1| 752182 g9876 i0 96.875 0.101587301587302 32 0 10 1 201 231 1894 1863 PREDICTED: Hyperolius riggenbachi beta-4C adrenergic receptor-like (LOC137562906), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Hyperoliidae Hyperolius Hyperolius riggenbachi
10343831 10343831 PRJEB82358_P_NODE_23949_length_196_cov_10.609756_g23938_i0 PRJEB82358 23949 196 10.609756 20.79512176 Bos javanicus 9906 Chordata Chordata 248 2.0099999999999997e-61   NTclustered gi|2633695114|ref|XR_009739007.1| 9906 g23938 i0 96.078 300.760204081633 153 4 77 2 46 196 1020 868 PREDICTED: Bos javanicus uncharacterized LOC133255677 (LOC133255677), transcript variant X2, ncRNA blastn 58949 248 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos javanicus
14169243 14169243 PRJEB82358_P_NODE_21792_length_218_cov_5.772414_g21781_i0 PRJEB82358 21792 218 5.772414 12.58386252 Bubalus bubalis 89462 Chordata Chordata 333 6.149999999999999e-87   NTclustered gi|2128315095|ref|XM_006056336.3| 89462 g21781 i0 97.449 40.0596330275229 196 4 89 1 24 218 312 117 PREDICTED: Bubalus bubalis phosphorylase kinase regulatory subunit alpha 2 (PHKA2), transcript variant X1, mRNA blastn 8733 333 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bubalus Bubalus bubalis
16717574 16717574 PRJEB82358_P_NODE_23294_length_202_cov_8.023256_g23283_i0 PRJEB82358 23294 202 8.023256 16.20697712 Lampetra planeri 7750 Chordata Chordata 52.8 0.018   NTclustered gi|2814964231|emb|OZ078336.2| 7750 g23283 i0 100 0.415841584158416 28 0 14 0 37 64 15291749 15291776 Lampetra planeri genome assembly, chromosome: 13 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Hyperoartia Petromyzontiformes Petromyzontidae Lampetra Lampetra planeri
17575392 17575392 PRJEB82358_P_NODE_7014_length_365_cov_2.821918_g7003_i0 PRJEB82358 7014 365 2.821918 10.3000007 Orectolobiformes 30503 Chordata Chordata 52.8 0.035   NTclustered gi|2618641569|ref|XR_009644699.1| 170820 g7003 i0 100 0.383561643835616 28 0 8 0 1 28 148 121 PREDICTED: Hemiscyllium ocellatum uncharacterized LOC132815721 (LOC132815721), transcript variant X2, ncRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Orectolobiformes Hemiscylliidae Hemiscyllium Hemiscyllium ocellatum
17992351 17992351 PRJEB82358_P_NODE_20135_length_232_cov_2.880503_g20124_i0 PRJEB82358 20135 232 2.880503 6.68276696 Canis lupus 9612 Chordata Chordata 52.8 0.021   NTclustered gi|45736810|gb|AC147680.4| 9615 g20124 i0 100 0.120689655172414 28 0 12 0 35 62 71596 71569 Canis Familiaris, clone XX-10H12, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Canidae Canis Canis lupus

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