RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA657860 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
625432 625432 PRJNA657860_P_NODE_2001_length_216_cov_1.720670_g1945_i0 PRJNA657860 2001 216 1.72067 3.7166472 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g1945 i0 94.595 0.685185185185185 37 0 16 2 29 63 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
1901611 1901611 PRJNA657860_P_NODE_1462_length_268_cov_1.722944_g1406_i0 PRJNA657860 1462 268 1.722944 4.61748992 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 490 4.39e-134   NTclustered gi|1535914814|ref|XR_003474832.1| 6956 g1406 i0 99.627 95.3619402985075 268 1 100 0 1 268 4402 4669 PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA blastn 25557 490 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
1901617 1901617 PRJNA657860_P_NODE_2062_length_212_cov_1.520000_g2006_i0 PRJNA657860 2062 212 1.52 3.2224 Osmia bicornis 1437190 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2186541134|ref|XM_029192913.2| 1437191 g2006 i0 100 0.400943396226415 29 0 14 0 7 35 4645 4617 PREDICTED: Osmia bicornis bicornis broad-complex core protein isoforms 1/2/3/4/5-like (LOC114878764), transcript variant X1, mRNA blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Megachilidae Osmia Osmia bicornis
2436592 2436592 PRJNA657860_P_NODE_2882_length_175_cov_0.963768_g2826_i0 PRJNA657860 2882 175 0.963768 1.686594 Endomychidae 196997 Arthropoda Arthropoda 110 8.63e-20   NTclustered gi|298578706|gb|GQ302256.1| 764669 g2826 i0 83.077 36.5885714285714 130 13 74 6 42 171 1857 1977 Mychothenus tropicalis 28S ribosomal RNA gene, partial sequence blastn 6403 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Endomychidae Mychothenus Mychothenus tropicalis
10829675 10829675 PRJNA657860_P_NODE_2049_length_213_cov_1.136364_g1993_i0 PRJNA657860 2049 213 1.136364 2.42045532 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 383 5.8499999999999996e-102   NTclustered gi|1535914814|ref|XR_003474832.1| 6956 g1993 i0 99.061 100.004694835681 213 2 100 0 1 213 2884 3096 PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA blastn 21301 383 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
12104805 12104805 PRJNA657860_P_NODE_3130_length_166_cov_22.968992_g3074_i0 PRJNA657860 3130 166 22.968992 38.128526720000004 Palaemon carinicauda 392227 Arthropoda Arthropoda 307 2.69e-79   NTclustered gi|2804965385|ref|XR_011039251.1| 392227 g3074 i0 100 11.6024096385542 166 0 100 0 1 166 2215 2050 PREDICTED: Palaemon carinicauda large subunit ribosomal RNA (LOC137615559), rRNA blastn 1926 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
17739283 17739283 PRJNA657860_P_NODE_2374_length_195_cov_1.436709_g2318_i0 PRJNA657860 2374 195 1.436709 2.80158255 Decapoda 6683 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|2695709220|ref|XM_063733175.1| 29960 g2318 i0 96.774 0.461538461538462 31 1 16 0 9 39 477 447 PREDICTED: Penaeus indicus late histone H1-like (LOC134766315), mRNA blastn 90 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus indicus
18477748 18477748 PRJNA657860_P_NODE_2875_length_175_cov_1.115942_g2819_i0 PRJNA657860 2875 175 1.115942 1.9528985 Oropus castaneus 1542260 Arthropoda Arthropoda 252 1.3499999999999999e-62   NTclustered gi|693465081|gb|KJ845131.1| 1542260 g2819 i0 92.614 47.9657142857143 176 12 100 1 1 175 206 31 Oropus castaneus voucher DDM1158 28S ribosomal RNA gene, partial sequence blastn 8394 252 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Oropus Oropus castaneus
19752445 19752445 PRJNA657860_P_NODE_1416_length_273_cov_1.665254_g1360_i0 PRJNA657860 1416 273 1.665254 4.54614342 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 499 7.45e-137   NTclustered gi|1535914814|ref|XR_003474832.1| 6956 g1360 i0 99.634 99.970695970696 273 1 100 0 1 273 341 69 PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA blastn 27292 499 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
20287735 20287735 PRJNA657860_P_NODE_3716_length_152_cov_1.330435_g3660_i0 PRJNA657860 3716 152 1.330435 2.0222612 Tyrophagus 41443 Arthropoda Arthropoda 279 5.24e-71   NTclustered gi|2289995532|dbj|LC687605.1| 59818 g3660 i0 100 8.92763157894737 151 0 99 0 1 151 5 155 Tyrophagus putrescentiae KAT_04 gene for 28S rRNA, partial sequence blastn 1357 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
22302709 22302709 PRJNA657860_P_NODE_1418_length_273_cov_0.949153_g1362_i0 PRJNA657860 1418 273 0.949153 2.59118769 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 490 4.479999999999998e-134   NTclustered gi|386696384|gb|JQ000557.1| 6956 g1362 i0 98.901 29.5347985347985 273 3 100 0 1 273 520 792 Dermatophagoides pteronyssinus voucher UMMZ BMOC 08-0912-029 AD1427 28S ribosomal RNA gene, partial sequence blastn 8063 490 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
22838804 22838804 PRJNA657860_P_NODE_1858_length_228_cov_11.497382_g1802_i0 PRJNA657860 1858 228 11.497382 26.21403096 Palaemon 117982 Arthropoda Arthropoda 377 2.95e-100   NTclustered gi|255964837|gb|GQ369793.1| 496079 g1802 i0 96.507 100.464912280702 229 7 100 1 1 228 1828 2056 Exopalaemon cf. modestus Taihu Lake 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 22906 377 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon cf. modestus Taihu Lake
24851688 24851688 PRJNA657860_P_NODE_1740_length_239_cov_1.514851_g1684_i0 PRJNA657860 1740 239 1.514851 3.62049389 Pollicipes pollicipes 41117 Arthropoda Arthropoda 180 9.44e-41   NTclustered gi|1929185115|ref|XM_037232595.1| 41117 g1684 i0 80.672 30.6652719665272 238 41 99 4 3 239 1649 1416 PREDICTED: Pollicipes pollicipes eukaryotic translation elongation factor 2-like (LOC119109058), mRNA blastn 7329 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
24851693 24851693 PRJNA657860_P_NODE_2260_length_200_cov_2.128834_g2204_i0 PRJNA657860 2260 200 2.128834 4.257668 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g2204 i0 96.875 0.32 32 1 16 0 160 191 24059124 24059155 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops

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