RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 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
609554 609554 PRJNA638724_P_NODE_5181_length_280_cov_2.444444_g5095_i0 PRJNA638724 5181 280 2.444444 6.8444432 Artemia franciscana 6661 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2743022418|ref|XM_065726568.1| 6661 g5095 i0 90.698 0.871428571428571 43 0 14 2 33 72 1819 1778 PREDICTED: Artemia franciscana xylulose kinase-like (LOC136041807), transcript variant X4, mRNA blastn 244 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
1885771 1885771 PRJNA638724_P_NODE_7942_length_231_cov_3.607595_g7856_i0 PRJNA638724 7942 231 3.607595 8.33354445 Cymothoe herminia 1210388 Arthropoda Arthropoda 411 2.9599999999999995e-110   NTclustered gi|2307882115|gb|MW186585.1| 1210388 g7856 i0 99.123 104.441558441558 228 2 99 0 1 228 6530 6303 Cymothoe herminia voucher 17LW02125 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 24126 411 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Cymothoe Cymothoe herminia
12088993 12088993 PRJNA638724_P_NODE_7350_length_243_cov_0.905882_g7264_i0 PRJNA638724 7350 243 0.905882 2.20129326 Artemia franciscana 6661 Arthropoda Arthropoda 431 2.4099999999999995e-116   NTclustered gi|2743074984|ref|XM_065706698.1| 6661 g7264 i0 100 4.75308641975309 233 0 96 0 1 233 952 720 PREDICTED: Artemia franciscana uncharacterized LOC136028794 (LOC136028794), mRNA blastn 1155 431 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
17733188 17733188 PRJNA638724_P_NODE_4154_length_307_cov_2.799145_g4068_i0 PRJNA638724 4154 307 2.799145 8.59337515 Timema 61471 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1947819235|emb|OD566261.1| 61472 g4068 i0 100 0.188925081433225 29 0 9 0 250 278 111505 111477 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani

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