RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA753112" 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

  • PRJNA753112 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
5832458 5832458 PRJNA753112_P_NODE_18165_length_318_cov_3.163265_g17823_i0 PRJNA753112 18165 318 3.163265 10.0591827 Chelidurella thaleri 2546182 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919609222|emb|OZ238411.1| 2546182 g17823 i0 100 0.0911949685534591 29 0 9 0 260 288 4184148 4184120 Chelidura thaleri genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
9657601 9657601 PRJNA753112_P_NODE_30388_length_249_cov_0.886364_g30046_i0 PRJNA753112 30388 249 0.886364 2.20704636 Darwinula stevensoni 69355 Arthropoda Arthropoda 195 3.5399999999999996e-45   NTclustered gi|1936654543|emb|LR947198.1| 69355 g30046 i0 90.604 0.598393574297189 149 11 59 3 104 249 101 249 Darwinula stevensoni blastn 149 195 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
10932826 10932826 PRJNA753112_P_NODE_16089_length_338_cov_2.109434_g15747_i0 PRJNA753112 16089 338 2.109434 7.12988692 Darwinula stevensoni 69355 Arthropoda Arthropoda 272 2.25e-68   NTclustered gi|1936726837|emb|LR952475.1| 69355 g15747 i0 83.278 3.32544378698225 299 47 88 3 40 338 458 163 Darwinula stevensoni blastn 1124 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
12208551 12208551 PRJNA753112_P_NODE_29810_length_250_cov_2.604520_g29468_i0 PRJNA753112 29810 250 2.60452 6.5113 Entomobrya sp. 1 FZ-2013 1304845 Arthropoda Arthropoda 451 1.91e-122   NTclustered gi|472455965|gb|KC236319.1| 1304845 g29468 i0 99.2 100.848 250 2 100 0 1 250 98 347 Entomobrya sp. 1 FZ-2013 28S ribosomal RNA gene, partial sequence blastn 25212 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Entomobryidae Entomobrya Entomobrya sp. 1 FZ-2013
13955411 13955411 PRJNA753112_P_NODE_11891_length_394_cov_1.152648_g11549_i0 PRJNA753112 11891 394 1.152648 4.54143312 Tyrophagus 41443 Arthropoda Arthropoda 701 0   NTclustered gi|1912461452|gb|MN857506.1| 59818 g11549 i0 98.731 37.0253807106599 394 5 100 0 1 394 4632 4239 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 14588 701 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
14757969 14757969 PRJNA753112_P_NODE_28472_length_254_cov_1.723757_g28130_i0 PRJNA753112 28472 254 1.723757 4.37834278 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2919559730|emb|OZ238369.1| 204503 g28130 i0 96.774 0.122047244094488 31 1 12 0 161 191 13587230 13587260 Charissa obscurata genome assembly, chromosome: 3 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
14758192 14758192 PRJNA753112_P_NODE_8872_length_457_cov_1.617188_g8530_i0 PRJNA753112 8872 457 1.617188 7.39054916 Linepithema humile 83485 Arthropoda Arthropoda 52.8 0.044   NTclustered gi|2788948857|ref|XR_010888252.1| 83485 g8530 i0 100 0.0612691466083151 28 0 6 0 52 79 327 300 PREDICTED: Linepithema humile uncharacterized lncRNA (LOC136997530), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Linepithema Linepithema humile
21603676 21603676 PRJNA753112_P_NODE_16517_length_334_cov_1.632184_g16175_i0 PRJNA753112 16517 334 1.632184 5.45149456 root 1 Root_unresolved Root_unresolved 58.4 6.77e-4   NTclustered gi|805796039|ref|XM_012287789.1| 143995 g16175 i0 100 4.08982035928144 31 0 9 0 302 332 2504 2534 PREDICTED: Megachile rotundata putative thiamine transporter SLC35F3 (LOC100879637), transcript variant X4, mRNA blastn 1366 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megachilidae Megachile Megachile rotundata

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