RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1072736" 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

  • PRJNA1072736 · 4 ✖

analysis 1

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
2737521 2737521 PRJNA1072736_S_NODE_4763_length_178_cov_4.407407_g4758_i0 PRJNA1072736 4763 178 4.407407 7.84518446 Euproctis chrysorrhoea 987934 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|2918369809|emb|OZ237915.1| 987934 g4758 i0 100 0.157303370786517 28 0 16 0 143 170 25572360 25572333 Euproctis chrysorrhoea genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Euproctis Euproctis chrysorrhoea
7839583 7839583 PRJNA1072736_S_NODE_667_length_349_cov_2.705882_g662_i0 PRJNA1072736 667 349 2.705882 9.44352818 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2920024403|emb|OZ239125.1| 3086104 g662 i0 100 0.0802292263610315 28 0 8 0 5 32 12416224 12416251 Leiobunum subalpinum genome assembly, chromosome: 8 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
12940706 12940706 PRJNA1072736_S_NODE_2971_length_211_cov_2.577381_g2966_i0 PRJNA1072736 2971 211 2.577381 5.43827391 Longitarsus dorsalis 346795 Arthropoda Arthropoda 62.1 3.08e-5   NTclustered gi|2918386060|emb|OZ238103.1| 346795 g2966 i0 91.111 0.213270142180095 45 4 21 0 43 87 53372271 53372227 Longitarsus dorsalis genome assembly, chromosome: 10 blastn 45 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
16763882 16763882 PRJNA1072736_S_NODE_4274_length_185_cov_14.330986_g4269_i0 PRJNA1072736 4274 185 14.330986 26.5123241 Lutzomyia longipalpis 7200 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2500586479|ref|XR_008750134.1| 7200 g4269 i0 100 0.502702702702703 29 0 16 0 157 185 689 717 PREDICTED: Lutzomyia longipalpis troponin C-like (LOC129786533), transcript variant X2, misc_RNA blastn 93 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis

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