RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1167252" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1167252 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27880976 27880976 PRJNA1167252_P_NODE_18665_length_282_cov_1.866029_g18392_i0 PRJNA1167252 18665 282 1.866029 5.26220178 Hymenoptera 7399 Arthropoda Arthropoda 147 2.6099999999999993e-43   NR XP_001600769.1 7425 g18392 i0 70.7 2.91489361702128 92 27 97.9 0 278 3 40 131 XP_001600769.1 general odorant-binding protein 69a [Nasonia vitripennis] diamond 822 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
28335381 28335381 PRJNA1167252_P_NODE_29246_length_242_cov_0.923077_g28973_i0 PRJNA1167252 29246 242 0.923077 2.23384634 Folsomia candida 158441 Arthropoda Arthropoda 65.1 4.94e-10   NR OXA63021.1 158441 g28973 i0 64.4 2.29338842975207 45 16 55.8 0 2 136 179 223 OXA63021.1 Aminopeptidase N [Folsomia candida] diamond 555 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
28903519 28903519 PRJNA1167252_P_NODE_24608_length_250_cov_0.881356_g24335_i0 PRJNA1167252 24608 250 0.881356 2.20339 Eretmocerus hayati 131215 Arthropoda Arthropoda 120 5.72e-30   NR KAJ8664880.1 131215 g24335 i0 67.1 0.984 82 27 98.4 0 5 250 409 490 KAJ8664880.1 hypothetical protein QAD02_006542 [Eretmocerus hayati] diamond 246 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Aphelinidae Eretmocerus Eretmocerus hayati
29851075 29851075 PRJNA1167252_P_NODE_22731_length_253_cov_0.866667_g22458_i0 PRJNA1167252 22731 253 0.866667 2.19266751 Uroleucon formosanum 796250 Arthropoda Arthropoda 99.4 5.28e-22   NR KAL4141829.1 796250 g22458 i0 56.6 0.984189723320158 83 36 98.4 0 250 2 619 701 KAL4141829.1 hypothetical protein QTP88_004386 [Uroleucon formosanum] diamond 249 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
31482123 31482123 PRJNA1167252_P_NODE_28816_length_243_cov_0.917647_g28543_i0 PRJNA1167252 28816 243 0.917647 2.22988221 Aphis 80764 Arthropoda Arthropoda 101 9.45e-23   NR XP_050053398.1 80765 g28543 i0 72.3 3.20987654320988 65 18 80.2 0 241 47 238 302 XP_050053398.1 PDZ and LIM domain protein Zasp isoform X1 [Aphis gossypii] diamond 780 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
32853158 32853158 PRJNA1167252_P_NODE_18500_length_284_cov_0.777251_g18227_i0 PRJNA1167252 18500 284 0.777251 2.20739284 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 45.8 0.00476   NR KFM67879.1 407821 g18227 i0 48.7 0.823943661971831 39 20 41.2 0 278 162 20 58 KFM67879.1 Zinc finger protein 346, partial [Stegodyphus mimosarum] diamond 234 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum

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