RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA801875" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA801875 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1221748 1221748 PRJNA801875_P_NODE_4261_length_158_cov_2.821138_g4158_i0 PRJNA801875 4261 158 2.821138 4.45739804 Metazoa 33208 Chordata Chordata 63.9 6.03e-6   NTclustered gi|1835613316|ref|XM_033917946.1| 260995 g4158 i0 93.023 2.6012658227848098 43 3 27 0 66 108 388 346 PREDICTED: Geotrypetes seraphini ribosomal protein S25 (RPS25), mRNA blastn 411 63.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Gymnophiona Dermophiidae Geotrypetes Geotrypetes seraphini
3773513 3773513 PRJNA801875_P_NODE_2663_length_208_cov_1.352601_g2560_i0 PRJNA801875 2663 208 1.352601 2.81341008 Metazoa 33208 Chordata Chordata 54.7 0.005   NTclustered gi|57863195|gb|AC108908.16| 10090 g2560 i0 100 2.0625 29 0 14 0 26 54 175613 175641 Mus musculus chromosome 7, clone RP23-179K7, complete sequence blastn 429 54.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
7179413 7179413 PRJNA801875_P_NODE_4046_length_163_cov_1.156250_g3943_i0 PRJNA801875 4046 163 1.15625 1.8846875 Mus musculus 10090 Chordata Chordata 58.4 2.92e-4   NTclustered gi|52839791|gb|AC108393.10| 10090 g3943 i0 100 22.6503067484663 31 0 19 0 59 89 90361 90391 Mus musculus chromosome 3, clone RP23-388A19, complete sequence blastn 3692 58.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
8454072 8454072 PRJNA801875_P_NODE_4147_length_161_cov_0.849206_g4044_i0 PRJNA801875 4147 161 0.849206 1.36722166 Apodemus sylvaticus 10129 Chordata Chordata 54.7 0.004   NTclustered gi|2330874509|ref|XM_052191938.1| 10129 g4044 i0 100 0.180124223602484 29 0 18 0 1 29 608 580 PREDICTED: Apodemus sylvaticus nucleolin (Ncl), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Apodemus Apodemus sylvaticus
16103601 16103601 PRJNA801875_P_NODE_3173_length_186_cov_1.165563_g3070_i0 PRJNA801875 3173 186 1.165563 2.16794718 Sitta europaea 50251 Chordata Chordata 52.8 0.016   NTclustered gi|2917598300|emb|OZ228662.1| 50251 g3070 i0 100 0.150537634408602 28 0 15 0 90 117 9505584 9505611 Sitta europaea genome assembly, chromosome: 8 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Aves Passeriformes Sittidae Sitta Sitta europaea

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