RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA512489" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA512489 · 12 ✖

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
1761829 1761829 PRJNA512489_S_NODE_1882_length_151_cov_21.490741_g1877_i0 PRJNA512489 1882 151 21.490741 32.45101891 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 235 1.14e-57   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g1877 i0 94.702 84.0993377483444 151 8 100 0 1 151 35481195 35481045 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 12699 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
3037665 3037665 PRJNA512489_S_NODE_1423_length_166_cov_11.487805_g1418_i0 PRJNA512489 1423 166 11.487805 19.0697563 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 302 1.2500000000000001e-77   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g1418 i0 99.398 101.753012048193 166 1 100 0 1 166 35481366 35481201 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 16891 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
3037690 3037690 PRJNA512489_S_NODE_683_length_208_cov_9.648485_g678_i0 PRJNA512489 683 208 9.648485 20.0688488 Frankliniella occidentalis 133901 Arthropoda Arthropoda 93.5 1.07e-14   NTclustered gi|2347671737|ref|XR_008011287.1| 133901 g678 i0 87.805 0.394230769230769 82 6 38 4 4 83 149 228 PREDICTED: Frankliniella occidentalis uncharacterized LOC127749676 (LOC127749676), ncRNA blastn 82 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
10039419 10039419 PRJNA512489_S_NODE_848_length_194_cov_18.125828_g843_i0 PRJNA512489 848 194 18.125828 35.16410632 Curculionidae 7042 Arthropoda Arthropoda 357 3.17e-94   NTclustered gi|1456042518|gb|MH433232.1| 334572 g843 i0 100 103.469072164948 193 0 99 0 1 193 925 733 Ceutorhynchus rapae voucher ZFMK:TIS-3641 28S ribosomal RNA gene, partial sequence blastn 20073 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus rapae
11965388 11965388 PRJNA512489_S_NODE_730_length_203_cov_14.718750_g725_i0 PRJNA512489 730 203 14.71875 29.8790625 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 359 9.31e-95   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g725 i0 98.522 100.773399014778 203 3 100 0 1 203 35484072 35483870 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 20457 359 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
14515555 14515555 PRJNA512489_S_NODE_1452_length_165_cov_11.262295_g1447_i0 PRJNA512489 1452 165 11.262295 18.58278675 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 305 9.59e-79   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g1447 i0 100 107.290909090909 165 0 100 0 1 165 35480863 35481027 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 17703 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
17688749 17688749 PRJNA512489_S_NODE_174_length_331_cov_19.111111_g169_i0 PRJNA512489 174 331 19.111111 63.25777741 Curculionidae 7042 Arthropoda Arthropoda 595 1.1499999999999998e-165   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g169 i0 99.39 101.7583081571 328 2 99 0 1 328 35484207 35484534 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 33682 601 0.990016638935108 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
23439067 23439067 PRJNA512489_S_NODE_259_length_289_cov_14.447154_g254_i0 PRJNA512489 259 289 14.447154 41.75227506 Stromboscerini gen. sp. DDM-2009 638916 Arthropoda Arthropoda 481 2.88e-131   NTclustered gi|228014403|gb|FJ867717.1| 638916 g254 i0 96.587 104.951557093426 293 5 100 5 1 289 1515 1806 Stromboscerini gen. sp. DDM-2009 28S ribosomal RNA gene, partial sequence blastn 30331 481 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae   Stromboscerini gen. sp. DDM-2009
24062805 24062805 PRJNA512489_S_NODE_159_length_340_cov_9.276094_g154_i0 PRJNA512489 159 340 9.276094 31.5387196 Curculionidae 7042 Arthropoda Arthropoda 617 2.5299999999999994e-172   NTclustered gi|82936759|emb|AJ849998.1| 202040 g154 i0 99.412 103.776470588235 340 2 100 0 1 340 345 6 Mogulones geographicus partial 18S rRNA gene blastn 35284 617 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Mogulones Mogulones geographicus
24062816 24062816 PRJNA512489_S_NODE_659_length_210_cov_28.712575_g654_i0 PRJNA512489 659 210 28.712575 60.2964075 Curculionidae 7042 Arthropoda Arthropoda 377 2.68e-100   NTclustered gi|82936759|emb|AJ849998.1| 202040 g654 i0 99.048 100.419047619048 210 2 100 0 1 210 1575 1366 Mogulones geographicus partial 18S rRNA gene blastn 21088 377 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Mogulones Mogulones geographicus
24712678 24712678 PRJNA512489_S_NODE_100_length_389_cov_12.115607_g95_i0 PRJNA512489 100 389 12.115607 47.12971123 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 706 0   NTclustered gi|2918376596|emb|OZ238015.1| 307131 g95 i0 99.485 152.246786632391 388 2 99 0 2 389 35480643 35480256 Ceutorhynchus obstrictus genome assembly, chromosome: 6 blastn 59224 706 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
24712708 24712708 PRJNA512489_S_NODE_760_length_201_cov_12.215190_g755_i0 PRJNA512489 760 201 12.21519 24.5525319 Hylastes brunneus 1117389 Arthropoda Arthropoda 366 5.5e-97   NTclustered gi|632797227|gb|KJ531068.1| 1117389 g755 i0 99.502 99.9502487562189 201 1 100 0 1 201 879 1079 Hylastes brunneus 18S ribosomal RNA gene, partial sequence blastn 20090 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Hylastes Hylastes brunneus

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