RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA638724" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA638724 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
5713211 5713211 PRJNA638724_P_NODE_1785_length_441_cov_4.127717_g1699_i0 PRJNA638724 1785 441 4.127717 18.20323197 Sphaerodactylus townsendi 933632 Chordata Chordata 52.8 0.043   NTclustered gi|2247582609|ref|XR_007243838.1| 933632 g1699 i0 100 0.253968253968254 28 0 6 0 47 74 2705 2678 PREDICTED: Sphaerodactylus townsendi uncharacterized LOC125428457 (LOC125428457), transcript variant X1, ncRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Sphaerodactylidae Sphaerodactylus Sphaerodactylus townsendi
15912473 15912473 PRJNA638724_P_NODE_8473_length_203_cov_6.207692_g8387_i0 PRJNA638724 8473 203 6.207692 12.60161476 Apteryx mantelli 2696672 Chordata Chordata 54.7 0.005   NTclustered gi|840016890|emb|LK066393.1| 202946 g8387 i0 100 0.142857142857143 29 0 14 0 104 132 207549 207577 Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold1803 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Chordata Aves Apterygiformes Apterygidae Apteryx Apteryx mantelli
17187526 17187526 PRJNA638724_P_NODE_6894_length_248_cov_0.880000_g6808_i0 PRJNA638724 6894 248 0.88 2.1824 Ovis aries 9940 Chordata Chordata 148 2.7799999999999998e-31   NTclustered gi|2606972120|ref|XM_060416601.1| 9940 g6808 i0 90.909 42.5967741935484 110 10 44 0 1 110 26798 26907 PREDICTED: Ovis aries uncharacterized LOC132659897 (LOC132659897), mRNA blastn 10564 148 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis aries
24835901 24835901 PRJNA638724_P_NODE_5220_length_279_cov_3.699029_g5134_i0 PRJNA638724 5220 279 3.699029 10.32029091 Polypterus senegalus 55291 Chordata Chordata 351 2.26e-92   NTclustered gi|1993937637|ref|XM_039741126.1| 55291 g5134 i0 89.606 18.405017921147 279 26 99 3 1 277 1174 1451 PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA blastn 5135 351 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Polypterus Polypterus senegalus

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