RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA688414" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688414 · 9 ✖
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
4494906 4494906 PRJNA688414_P_NODE_3844_length_305_cov_1.344828_g3810_i0 PRJNA688414 3844 305 1.344828 4.1017254 Macrobrachium nipponense 159736 Arthropoda Arthropoda 564 2.95e-156   NTclustered gi|2725689177|gb|PP747059.1| 159736 g3810 i0 100 89.8885245901639 305 0 100 0 1 305 11629 11933 Macrobrachium nipponense isolate CH3 mitochondrion, complete genome blastn 27416 564 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
4494918 4494918 PRJNA688414_P_NODE_4444_length_288_cov_1.297674_g4410_i0 PRJNA688414 4444 288 1.297674 3.73730112 Nasonia vitripennis 7425 Arthropoda Arthropoda 483 7.969999999999997e-132   NTclustered gi|1787460855|ref|XR_004228245.1| 7425 g4410 i0 96.875 100.319444444444 288 9 100 0 1 288 3549 3836 PREDICTED: Nasonia vitripennis large subunit ribosomal RNA (LOC116418148), rRNA blastn 28892 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
8320133 8320133 PRJNA688414_P_NODE_4727_length_280_cov_2.579710_g4693_i0 PRJNA688414 4727 280 2.57971 7.223188 Timema shepardi 629360 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|1937840122|emb|OC001265.1| 629360 g4693 i0 94.286 0.125 35 1 13 1 177 211 25425 25458 2_Tsi_b3v08 blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema shepardi
10871081 10871081 PRJNA688414_P_NODE_6829_length_249_cov_0.886364_g6795_i0 PRJNA688414 6829 249 0.886364 2.20704636 Triops longicaudatus 58777 Arthropoda Arthropoda 193 1.27e-44   NTclustered gi|37703988|gb|AY305524.1| 58777 g6795 i0 84.615 77.7028112449799 195 28 78 2 1 194 1490 1683 Triops longicaudatus voucher Tlo elongation factor-2 mRNA, partial cds blastn 19348 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Notostraca Triopsidae Triops Triops longicaudatus
12146327 12146327 PRJNA688414_P_NODE_1910_length_408_cov_2.229851_g1876_i0 PRJNA688414 1910 408 2.229851 9.09779208 Macrobrachium nipponense 159736 Arthropoda Arthropoda 725 0   NTclustered gi|2708619464|ref|XR_010313755.1| 159736 g1876 i0 98.547 6.31372549019608 413 0 99 4 1 407 5210 5622 PREDICTED: Macrobrachium nipponense large subunit ribosomal RNA (LOC135211762), rRNA blastn 2576 725 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
12146431 12146431 PRJNA688414_P_NODE_7630_length_245_cov_0.906977_g7596_i0 PRJNA688414 7630 245 0.906977 2.22209365 Macrobrachium nipponense 159736 Arthropoda Arthropoda 436 5.229999999999999e-118   NTclustered gi|2708619464|ref|XR_010313755.1| 159736 g7596 i0 98.776 4.11836734693878 245 3 100 0 1 245 3753 3509 PREDICTED: Macrobrachium nipponense large subunit ribosomal RNA (LOC135211762), rRNA blastn 1009 436 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
21069429 21069429 PRJNA688414_P_NODE_4937_length_275_cov_1.727723_g4903_i0 PRJNA688414 4937 275 1.727723 4.75123825 Harmonia axyridis 115357 Arthropoda Arthropoda 508 1.2499999999999999e-139   NTclustered gi|2170079298|ref|XR_006749713.1| 115357 g4903 i0 100 99.9927272727273 275 0 100 0 1 275 3939 3665 PREDICTED: Harmonia axyridis large subunit ribosomal RNA (LOC123688014), rRNA blastn 27498 508 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
24128782 24128782 PRJNA688414_P_NODE_4299_length_291_cov_1.747706_g4265_i0 PRJNA688414 4299 291 1.747706 5.08582446 Macrobrachium 6696 Arthropoda Arthropoda 538 1.6999999999999994e-148   NTclustered gi|1678196571|gb|MN017960.1| 159736 g4265 i0 100 99.9553264604811 291 0 100 0 1 291 505 215 Macrobrachium nipponense isolate A36 small subunit ribosomal RNA gene, partial sequence blastn 29087 538 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
31883834 31883834 PRJNA688414_P_NODE_5577_length_259_cov_1.629032_g5543_i0 PRJNA688414 5577 259 1.629032 4.21919288 Ixodes persulcatus 34615 Arthropoda Arthropoda 80.1 3.05e-15   NR CAL6253559.1 34615 g5543 i0 50 2.95366795366795 64 32 74.1 0 3 194 408 471 CAL6253559.1 unnamed protein product, partial [Ixodes persulcatus] diamond 765 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus

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