RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "blastn", bioproject = "PRJNA751877" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA751877 · 27 ✖

analysis 1

  • blastn · 27 ✖
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
726461 726461 PRJNA751877_P_NODE_27861_length_244_cov_0.900585_g27739_i0 PRJNA751877 27861 244 0.900585 2.1974274 Ixodes scapularis 6945 Arthropoda Arthropoda 435 1.87e-117   NTclustered gi|2064670535|ref|XM_042287363.1| 6945 g27739 i0 98.77 2 244 3 100 0 1 244 5461 5218 PREDICTED: Ixodes scapularis triple functional domain protein (LOC8035715), transcript variant X1, mRNA blastn 488 435 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
2002283 2002283 PRJNA751877_P_NODE_17822_length_279_cov_1.344660_g17700_i0 PRJNA751877 17822 279 1.34466 3.7516014 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919544426|emb|OZ238354.1| 1002887 g17700 i0 96.97 0.118279569892473 33 1 12 0 22 54 19566860 19566892 Glaucopsyche melanops genome assembly, chromosome: 13 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
2002447 2002447 PRJNA751877_P_NODE_25682_length_247_cov_0.885057_g25560_i0 PRJNA751877 25682 247 0.885057 2.18609079 Drosophila melanogaster 7227 Arthropoda Arthropoda 438 1.4699999999999995e-118   NTclustered gi|429892446|gb|KC116043.1| 7227 g25560 i0 98.78 45.1295546558704 246 3 99 0 1 246 1554 1309 Drosophila melanogaster isolate 3894 KRIMP (krimp) gene, complete cds blastn 11147 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
5830145 5830145 PRJNA751877_P_NODE_3425_length_492_cov_2.164678_g3303_i0 PRJNA751877 3425 492 2.164678 10.65021576 Agapeta hamana 1100904 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g3303 i0 94.286 0.0711382113821138 35 2 7 0 249 283 16934804 16934838 Agapeta hamana genome assembly, chromosome: 4 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
7104940 7104940 PRJNA751877_P_NODE_17486_length_281_cov_1.384615_g17364_i0 PRJNA751877 17486 281 1.384615 3.89076815 Penaeus vannamei 6689 Arthropoda Arthropoda 171 6.849999999999999e-38   NTclustered gi|1386778413|gb|MG878889.1| 6689 g17364 i0 78.014 64.1281138790036 282 54 100 4 1 281 2536 2262 Litopenaeus vannamei glyceraldehyde-3-phosphate dehydrogenase (GAPDH) gene, partial cds blastn 18020 171 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
7105195 7105195 PRJNA751877_P_NODE_28126_length_244_cov_0.900585_g28004_i0 PRJNA751877 28126 244 0.900585 2.1974274 Drosophila melanogaster 7227 Arthropoda Arthropoda 451 1.86e-122   NTclustered gi|151300111|gb|EF671165.1| 7227 g28004 i0 100 56.0573770491803 244 0 100 0 1 244 575 818 Drosophila melanogaster strain hf1 2R12 locus genomic sequence blastn 13678 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
9654822 9654822 PRJNA751877_P_NODE_21908_length_253_cov_0.827778_g21786_i0 PRJNA751877 21908 253 0.827778 2.09427834 Triatoma infestans 30076 Arthropoda Arthropoda 73.1 1.76e-8   NTclustered gi|50981802|gb|AY588537.1| 30076 g21786 i0 93.75 0.189723320158103 48 3 19 0 205 252 1 48 Triatoma infestans clone TiF04 microsatellite sequence blastn 48 73.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Reduviidae Triatoma Triatoma infestans
9654906 9654906 PRJNA751877_P_NODE_25608_length_247_cov_0.885057_g25486_i0 PRJNA751877 25608 247 0.885057 2.18609079 Agapeta hamana 1100904 Arthropoda Arthropoda 139 1.67e-28   NTclustered gi|2918376516|emb|OZ237970.1| 1100904 g25486 i0 86.047 49.4251012145749 129 18 52 0 101 229 8055480 8055352 Agapeta hamana genome assembly, chromosome: 10 blastn 12208 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
9654971 9654971 PRJNA751877_P_NODE_28548_length_243_cov_0.905882_g28426_i0 PRJNA751877 28548 243 0.905882 2.20129326 Achroia grisella 688607 Arthropoda Arthropoda 449 6.65e-122   NTclustered gi|2569448142|ref|XR_009358057.1| 688607 g28426 i0 100 98.2222222222222 243 0 100 0 1 243 332 90 PREDICTED: Achroia grisella large subunit ribosomal RNA (LOC131854525), rRNA blastn 23868 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Achroia Achroia grisella
9654999 9654999 PRJNA751877_P_NODE_30088_length_241_cov_0.916667_g29966_i0 PRJNA751877 30088 241 0.916667 2.20916747 Anopheles nili 185578 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2449504900|ref|XM_053821756.1| 185578 g29966 i0 100 0.116182572614108 28 0 12 0 190 217 1652 1625 PREDICTED: Anopheles nili coiled-coil domain-containing protein 93 (LOC128727811), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
9655014 9655014 PRJNA751877_P_NODE_3628_length_483_cov_1.212195_g3506_i0 PRJNA751877 3628 483 1.212195 5.85490185 Procambarus clarkii 6728 Arthropoda Arthropoda 76.8 2.79e-9   NTclustered gi|2837616735|ref|XM_069319495.1| 6728 g3506 i0 94 1.51552795031056 50 3 10 0 60 109 525 476 PREDICTED: Procambarus clarkii pulmonary surfactant-associated protein D-like (LOC138359793), mRNA blastn 732 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
10128930 10128930 PRJNA751877_P_NODE_26728_length_245_cov_1.784884_g26606_i0 PRJNA751877 26728 245 1.784884 4.3729658 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1962688803|emb|OE191254.1| 61474 g26606 i0 100 0.342857142857143 28 0 11 0 192 219 4450 4423 2_Tcm_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
10930299 10930299 PRJNA751877_P_NODE_23069_length_250_cov_0.870056_g22947_i0 PRJNA751877 23069 250 0.870056 2.17514 Culex pipiens 7175 Arthropoda Arthropoda 409 1.17e-109   NTclustered gi|2415561470|ref|XM_052709306.1| 42434 g22947 i0 96.735 20.448 245 8 98 0 6 250 724 480 PREDICTED: Culex pipiens pallens uncharacterized LOC128093236 (LOC128093236), mRNA blastn 5112 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
10930344 10930344 PRJNA751877_P_NODE_24729_length_248_cov_0.880000_g24607_i0 PRJNA751877 24729 248 0.88 2.1824 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 67.6 8.01e-7   NTclustered gi|2237289378|ref|XM_048140232.1| 1035111 g24607 i0 97.5 0.818548387096774 40 0 16 1 14 52 6472 6511 PREDICTED: Leguminivora glycinivorella sodium channel protein para-like (LOC125234054), mRNA blastn 203 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
10930389 10930389 PRJNA751877_P_NODE_26229_length_246_cov_0.890173_g26107_i0 PRJNA751877 26229 246 0.890173 2.18982558 Culex pipiens 7175 Arthropoda Arthropoda 407 4.12e-109   NTclustered gi|2415560281|ref|XR_008211975.1| 42434 g26107 i0 96.371 6.01626016260163 248 7 100 1 1 246 2607 2854 PREDICTED: Culex pipiens pallens uncharacterized LOC128092752 (LOC128092752), ncRNA blastn 1480 407 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
10930478 10930478 PRJNA751877_P_NODE_30089_length_241_cov_0.916667_g29967_i0 PRJNA751877 30089 241 0.916667 2.20916747 Culex pipiens 7175 Arthropoda Arthropoda 316 6.97e-82   NTclustered gi|2415576269|ref|XM_039580450.2| 42434 g29967 i0 90.417 1.99585062240664 240 23 99 0 1 240 1142 903 PREDICTED: Culex pipiens pallens FAST kinase domain-containing protein 3, mitochondrial-like (LOC120418151), mRNA blastn 481 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
11403948 11403948 PRJNA751877_P_NODE_19329_length_269_cov_2.076531_g19207_i0 PRJNA751877 19329 269 2.076531 5.58586839 Culex 7174 Arthropoda Arthropoda 82.4 3.14e-11   NTclustered gi|1949611507|ref|XR_005278359.1| 7176 g19207 i0 89.231 2.38661710037175 65 7 24 0 21 85 118 182 Culex quinquefasciatus strain JHB chromosome 3 blastn 642 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
14755250 14755250 PRJNA751877_P_NODE_24192_length_249_cov_0.875000_g24070_i0 PRJNA751877 24192 249 0.875 2.17875 Notodromas monacha 399045 Arthropoda Arthropoda 433 6.89e-117   NTclustered gi|1938065787|emb|OA890044.1| 399045 g24070 i0 97.992 7.5863453815261 249 5 100 0 1 249 6598 6846 Notodromas monacha blastn 1889 433 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
16029111 16029111 PRJNA751877_P_NODE_26893_length_245_cov_0.895349_g26771_i0 PRJNA751877 26893 245 0.895349 2.19360505 Homalodisca vitripennis 197043 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2196600067|ref|XM_046806066.1| 197043 g26771 i0 100 0.228571428571429 28 0 11 0 215 242 5757 5730 PREDICTED: Homalodisca vitripennis uncharacterized LOC124355109 (LOC124355109), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
19853611 19853611 PRJNA751877_P_NODE_30036_length_241_cov_0.916667_g29914_i0 PRJNA751877 30036 241 0.916667 2.20916747 Timema californicum 61474 Arthropoda Arthropoda 440 3.959999999999999e-119   NTclustered gi|1962660513|emb|OE179524.1| 61474 g29914 i0 99.585 48.7095435684647 241 1 100 0 1 241 40388 40628 2_Tcm_b3v08 blastn 11739 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
20326493 20326493 PRJNA751877_P_NODE_15196_length_296_cov_1.726457_g15074_i0 PRJNA751877 15196 296 1.726457 5.11031272 Insecta 50557 Arthropoda Arthropoda 547 2.8799999999999986e-151   NTclustered gi|47174960|gb|AY252169.1| 236623 g15074 i0 100 100.14527027027 296 0 100 0 1 296 531 236 Nysius sp. WCW-2003 18S ribosomal RNA gene, partial sequence blastn 29643 547 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Lygaeidae Nysius Nysius sp. WCW-2003
21128795 21128795 PRJNA751877_P_NODE_17337_length_282_cov_1.215311_g17215_i0 PRJNA751877 17337 282 1.215311 3.42717702 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2919605778|emb|OZ238392.1| 204503 g17215 i0 100 0.099290780141844 28 0 10 0 248 275 6794781 6794754 Charissa obscurata genome assembly, chromosome: 26 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
21128877 21128877 PRJNA751877_P_NODE_21337_length_256_cov_2.912568_g21215_i0 PRJNA751877 21337 256 2.912568 7.45617408 Medioppia subpectinata 1979941 Arthropoda Arthropoda 60.2 1.39e-4   NTclustered gi|1962536607|emb|OC867504.1| 1979941 g21215 i0 100 0.125 32 0 13 0 69 100 713 744 Medioppia subpectinata blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
24151888 24151888 PRJNA751877_P_NODE_25519_length_247_cov_0.885057_g25397_i0 PRJNA751877 25519 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 451 1.88e-122   NTclustered gi|1938020297|emb|OA886007.1| 399045 g25397 i0 99.595 21.8218623481781 247 1 100 0 1 247 23945 23699 Notodromas monacha blastn 5390 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
24952755 24952755 PRJNA751877_P_NODE_17760_length_279_cov_1.864078_g17638_i0 PRJNA751877 17760 279 1.864078 5.20077762 Stigmella sp. PopulusCO 1927284 Arthropoda Arthropoda 193 1.45e-44   NTclustered gi|1114663992|gb|KX284497.1| 1927284 g17638 i0 80.392 30.594982078853 255 48 91 2 5 258 362 109 Stigmella sp. PopulusCO isocitrate dehydrogenase gene, partial cds blastn 8536 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nepticulidae Stigmella Stigmella sp. PopulusCO
24953004 24953004 PRJNA751877_P_NODE_28740_length_243_cov_0.905882_g28618_i0 PRJNA751877 28740 243 0.905882 2.20129326 Culex pipiens 7175 Arthropoda Arthropoda 202 2.0599999999999995e-47   NTclustered gi|2415558706|ref|XM_039596170.2| 42434 g28618 i0 100 1.58024691358025 109 0 79 0 1 109 309 201 PREDICTED: Culex pipiens pallens flavin reductase (NADPH) (LOC120431012), mRNA blastn 384 202 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
24953044 24953044 PRJNA751877_P_NODE_30020_length_241_cov_0.916667_g29898_i0 PRJNA751877 30020 241 0.916667 2.20916747 Culex pipiens 7175 Arthropoda Arthropoda 60.2 1.3e-4   NTclustered gi|2415586612|ref|XM_039587233.2| 42434 g29898 i0 100 0.265560165975104 32 0 13 0 127 158 5255 5286 PREDICTED: Culex pipiens pallens sodium-dependent phosphate transporter 2 (LOC120423429), transcript variant X1, mRNA blastn 64 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens

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