RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA509429" 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

  • PRJNA509429 · 4 ✖

analysis 1

  • diamond · 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
11963954 11963954 PRJNA509429_P_NODE_30430_length_222_cov_1.427807_g29602_i0 PRJNA509429 30430 222 1.427807 3.16973154 Artemia franciscana 6661 Arthropoda Arthropoda 144 1.03e-42   NR KAK2709965.1 6661 g29602 i0 90.4 3.94594594594595 73 7 98.6 0 221 3 23 95 KAK2709965.1 hypothetical protein QYM36_013593 [Artemia franciscana] diamond 876 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30898776 30898776 PRJNA509429_P_NODE_24334_length_262_cov_4.198238_g23506_i0 PRJNA509429 24334 262 4.198238 10.99938356 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 42.7 0.033   NR CAL4151257.1 48144 g23506 i0 27 0.847328244274809 74 52 82.4 1 220 5 41 114 CAL4151257.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 222 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
31783778 31783778 PRJNA509429_P_NODE_11417_length_426_cov_3.649616_g10599_i0 PRJNA509429 11417 426 3.649616 15.54736416 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 53.9 1.22e-5   NR CAL4151257.1 48144 g10599 i0 33 0.661971830985915 94 61 64.8 1 61 336 47 140 CAL4151257.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 282 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
32637607 32637607 PRJNA509429_P_NODE_47440_length_160_cov_0.960000_g46612_i0 PRJNA509429 47440 160 0.96 1.536 Artemia franciscana 6661 Arthropoda Arthropoda 96.7 1.5100000000000001e-22   NR KAK2720214.1 6661 g46612 i0 86.5 0.975 52 7 97.5 0 3 158 118 169 KAK2720214.1 hypothetical protein QYM36_004193 [Artemia franciscana] diamond 156 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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