RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB58983 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
1399190 1399190 PRJEB58983_P_NODE_17422_length_308_cov_1.974468_g17007_i0 PRJEB58983 17422 308 1.974468 6.08136144 Nomia melanderi 2448451 Arthropoda Arthropoda 169 2.7399999999999997e-37   NTclustered gi|1789206943|ref|XM_031986552.1| 2448451 g17007 i0 77.627 8.34415584415584 295 55 94 9 18 307 736 448 PREDICTED: Nomia melanderi NADH-ubiquinone oxidoreductase subunit 8 (LOC116431312), mRNA blastn 2570 169 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Nomia Nomia melanderi
1399439 1399439 PRJEB58983_P_NODE_28342_length_251_cov_11.792135_g27927_i0 PRJEB58983 28342 251 11.792135 29.59825885 Cataglyphis hispanica 1086592 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2296745386|ref|XM_050597976.1| 1086592 g27927 i0 96.774 0.247011952191235 31 1 12 0 54 84 4598 4568 PREDICTED: Cataglyphis hispanica period circadian protein (LOC126852801), transcript variant X1, mRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cataglyphis Cataglyphis hispanica
1399516 1399516 PRJEB58983_P_NODE_31962_length_243_cov_1.264706_g31547_i0 PRJEB58983 31962 243 1.264706 3.07323558 Ceriodaphnia reticulata 302197 Arthropoda Arthropoda 209 1.23e-49   NTclustered gi|2488162594|emb|OC980139.1| 302197 g31547 i0 86.082 0.798353909465021 194 27 80 0 8 201 260 67 Ceriodaphnia reticulata EOG090X01G2 gene for EOG090X01G2 blastn 194 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
2674715 2674715 PRJEB58983_P_NODE_12263_length_359_cov_62.751748_g11848_i0 PRJEB58983 12263 359 62.751748 225.27877532 Hyalella azteca 294128 Arthropoda Arthropoda 658 0   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g11848 i0 100 77.0111420612813 356 0 99 0 4 359 364 9 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 27647 658 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
2674932 2674932 PRJEB58983_P_NODE_22883_length_275_cov_1.425743_g22468_i0 PRJEB58983 22883 275 1.425743 3.92079325 Ceriodaphnia reticulata 302197 Arthropoda Arthropoda 182 3.09e-41   NTclustered gi|2488162594|emb|OC980139.1| 302197 g22468 i0 85.549 3.44727272727273 173 25 63 0 6 178 2767 2939 Ceriodaphnia reticulata EOG090X01G2 gene for EOG090X01G2 blastn 948 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
6503391 6503391 PRJEB58983_P_NODE_5526_length_522_cov_18.167038_g5113_i0 PRJEB58983 5526 522 18.167038 94.83193836 Hyalella azteca 294128 Arthropoda Arthropoda 953 0   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g5113 i0 99.617 98.5708812260536 522 2 100 0 1 522 846 325 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 51454 953 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
8645258 8645258 PRJEB58983_P_NODE_31887_length_243_cov_1.694118_g31472_i0 PRJEB58983 31887 243 1.694118 4.11670674 Bombus 28641 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2304183524|ref|XM_050630029.1| 85661 g31472 i0 100 1.49794238683128 28 0 12 0 125 152 2750 2777 PREDICTED: Bombus huntii nuclear factor NF-kappa-B p100 subunit (LOC126871341), transcript variant X5, mRNA blastn 364 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
9052505 9052505 PRJEB58983_P_NODE_9768_length_399_cov_2.371166_g9354_i0 PRJEB58983 9768 399 2.371166 9.46095234 Scylla paramamosain 85552 Arthropoda Arthropoda 52.8 0.038   NTclustered gi|2705082143|ref|XM_064007180.1| 85552 g9354 i0 100 0.0701754385964912 28 0 7 0 264 291 853 826 PREDICTED: Scylla paramamosain homeobox protein 13-like (LOC135102253), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
11603254 11603254 PRJEB58983_P_NODE_2030_length_888_cov_23.074847_g1681_i0 PRJEB58983 2030 888 23.074847 204.90464136 Nothopoda sp. 3037786 Arthropoda Arthropoda 163 3.97e-35   NTclustered gi|2474862534|gb|OQ737114.1| 3037786 g1681 i0 92.241 13.4234234234234 116 7 13 2 184 297 2842 2727 Nothopoda sp. large subunit ribosomal RNA gene, partial sequence blastn 11920 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Nothopoda Nothopoda sp.
12878340 12878340 PRJEB58983_P_NODE_16531_length_315_cov_3.859504_g16116_i0 PRJEB58983 16531 315 3.859504 12.1574376 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g16116 i0 94.595 0.46984126984127 37 0 11 2 83 117 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
15427252 15427252 PRJEB58983_P_NODE_22073_length_279_cov_1.373786_g21658_i0 PRJEB58983 22073 279 1.373786 3.83286294 Anastrepha obliqua 95512 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2474067817|ref|XM_054888155.1| 95512 g21658 i0 96.97 0.473118279569892 33 0 11 1 86 117 938 970 PREDICTED: Anastrepha obliqua probable nuclear hormone receptor HR38 (LOC129248559), transcript variant X4, mRNA blastn 132 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha obliqua
15427361 15427361 PRJEB58983_P_NODE_27213_length_255_cov_2.538462_g26798_i0 PRJEB58983 27213 255 2.538462 6.4730781 Palaemon carinicauda 392227 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2804901849|ref|XM_068369417.1| 392227 g26798 i0 94.286 0.137254901960784 35 1 13 1 174 207 365 399 PREDICTED: Palaemon carinicauda skin secretory protein xP2-like (LOC137637138), mRNA blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
16701848 16701848 PRJEB58983_P_NODE_5834_length_509_cov_2.692661_g5421_i0 PRJEB58983 5834 509 2.692661 13.70564449 Daphnia carinata 120202 Arthropoda Arthropoda 370 1.21e-97   NTclustered gi|2577075302|ref|XM_057525616.2| 120202 g5421 i0 80.039 93.7170923379175 516 89 100 12 1 509 1231 723 PREDICTED: Daphnia carinata ATP synthase subunit alpha, mitochondrial-like (LOC130704142), mRNA blastn 47702 370 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia carinata
18843703 18843703 PRJEB58983_P_NODE_19315_length_294_cov_1.411765_g18900_i0 PRJEB58983 19315 294 1.411765 4.1505891 root 1 Root_unresolved Root_unresolved 58.4 5.86e-4   NTclustered gi|2304139023|ref|XM_050623139.1| 85661 g18900 i0 100 5.49659863945578 31 0 11 0 34 64 190 160 PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA blastn 1616 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
19250482 19250482 PRJEB58983_P_NODE_24696_length_266_cov_3.264249_g24281_i0 PRJEB58983 24696 266 3.264249 8.68290234 Pseudophacopteron tuberculatum 2591580 Arthropoda Arthropoda 220 6.3e-53   NTclustered gi|1694459262|gb|MH758029.1| 2591580 g24281 i0 93.836 86.4736842105263 146 9 91 0 121 266 247 102 Pseudophacopteron tuberculatum isolate 112 28S ribosomal RNA gene, partial sequence blastn 23002 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phacopteronidae Pseudophacopteron Pseudophacopteron tuberculatum
20118718 20118718 PRJEB58983_P_NODE_6936_length_469_cov_3.333333_g6522_i0 PRJEB58983 6936 469 3.333333 15.63333177 Diptera 7147 Arthropoda Arthropoda 147 2.03e-30   NTclustered gi|2453174031|ref|XR_008455619.1| 28586 g6522 i0 88.618 26.3134328358209 123 10 26 4 1 121 1119 999 PREDICTED: Anastrepha ludens large subunit ribosomal RNA (LOC128870932), rRNA blastn 12341 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha ludens
24350783 24350783 PRJEB58983_P_NODE_27120_length_256_cov_1.229508_g26705_i0 PRJEB58983 27120 256 1.229508 3.14754048 Hyalella azteca 294128 Arthropoda Arthropoda 473 4.189999999999999e-129   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g26705 i0 100 94.8671875 256 0 100 0 1 256 1139 884 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 24286 473 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
24350853 24350853 PRJEB58983_P_NODE_30660_length_246_cov_1.115607_g30245_i0 PRJEB58983 30660 246 1.115607 2.74439322 Artemia franciscana 6661 Arthropoda Arthropoda 60.2 1.33e-4   NTclustered gi|2743040614|ref|XM_065716537.1| 6661 g30245 i0 97.143 0.284552845528455 35 1 14 0 17 51 2633 2667 PREDICTED: Artemia franciscana junctophilin-1-like (LOC136034974), transcript variant X2, mRNA blastn 70 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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