RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1175041" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1175041 · 8 ✖

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
317002 317002 PRJNA1175041_P_NODE_53101_length_417_cov_1.648256_g50234_i0 PRJNA1175041 53101 417 1.648256 6.87322752 Orussus abietinus 222816 Arthropoda Arthropoda 60.2 2.4e-4   NTclustered gi|817211424|ref|XM_012426425.1| 222816 g50234 i0 97.143 0.90167865707434 35 1 8 0 338 372 160 126 PREDICTED: Orussus abietinus FH1/FH2 domain-containing protein 3 (LOC105700527), transcript variant X9, mRNA blastn 376 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Orussidae Orussus Orussus abietinus
5420156 5420156 PRJNA1175041_P_NODE_65445_length_348_cov_0.760000_g62577_i0 PRJNA1175041 65445 348 0.76 2.6448 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g62577 i0 100 0.0804597701149425 28 0 8 0 217 244 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
6694949 6694949 PRJNA1175041_P_NODE_60866_length_370_cov_1.319865_g57998_i0 PRJNA1175041 60866 370 1.319865 4.8835005 Timema bartmani 61472 Arthropoda Arthropoda 169 3.3499999999999996e-37   NTclustered gi|1947867998|emb|OD570649.1| 61472 g57998 i0 79.752 21.1162162162162 242 41 64 5 77 311 1927 1687 4_Tbi_b3v08 blastn 7813 169 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
9244731 9244731 PRJNA1175041_P_NODE_43688_length_499_cov_0.934272_g40824_i0 PRJNA1175041 43688 499 0.934272 4.66201728 Halyomorpha halys 286706 Arthropoda Arthropoda 52.8 0.049   NTclustered gi|2782086965|ref|XR_010844081.1| 286706 g40824 i0 100 0.336673346693387 28 0 6 0 348 375 447 474 PREDICTED: Halyomorpha halys Homeodomain interacting protein kinase (Hipk), transcript variant X5, misc_RNA blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
14346529 14346529 PRJNA1175041_P_NODE_91292_length_262_cov_1.608466_g88424_i0 PRJNA1175041 91292 262 1.608466 4.21418092 Samia ricini 63990 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2883229981|dbj|AP038900.1| 63990 g88424 i0 94.286 0.133587786259542 35 1 13 1 34 67 20404477 20404443 Samia ricini White GU1 DNA, chromosome 05, complete sequence blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
19443015 19443015 PRJNA1175041_P_NODE_57456_length_389_cov_1.354430_g54588_i0 PRJNA1175041 57456 389 1.35443 5.2687327 Drosophila virilis 7244 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|2867934052|ref|XM_015170985.3| 7244 g54588 i0 100 0.616966580976864 30 0 8 0 83 112 4803 4832 PREDICTED: Drosophila virilis retinal degeneration B (rdgB), transcript variant X5, mRNA blastn 240 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila virilis
23269501 23269501 PRJNA1175041_P_NODE_80959_length_291_cov_1.197248_g78091_i0 PRJNA1175041 80959 291 1.197248 3.48399168 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g78091 i0 100 4.75257731958763 30 0 10 0 191 220 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
24542494 24542494 PRJNA1175041_P_NODE_106720_length_240_cov_0.910180_g103852_i0 PRJNA1175041 106720 240 0.91018 2.184432 Timema cristinae 61476 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1947403926|emb|OC367705.1| 61476 g103852 i0 100 0.116666666666667 28 0 12 0 95 122 643 616 3_Tce_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae

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