RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA207719 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
2917690 2917690 PRJNA207719_P_NODE_423_length_320_cov_4.683849_g403_i0 PRJNA207719 423 320 4.683849 14.9883168 Diachasmimorpha longicaudata 58733 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2706563836|ref|XM_064133652.1| 58733 g403 i0 100 0.18125 29 0 9 0 143 171 1181 1209 PREDICTED: Diachasmimorpha longicaudata protein enabled homolog (LOC135168991), transcript variant X2, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
2917691 2917691 PRJNA207719_P_NODE_963_length_194_cov_1.866667_g943_i0 PRJNA207719 963 194 1.866667 3.62133398 Anopheles crucians 869064 Arthropoda Arthropoda 187 4.4e-43   NTclustered gi|301641479|gb|GQ981467.1| 869064 g943 i0 84.021 34.4639175257732 194 31 100 0 1 194 163 356 Anopheles crucians actin mRNA, partial cds blastn 6686 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles crucians
4884001 4884001 PRJNA207719_P_NODE_844_length_211_cov_3.868132_g824_i0 PRJNA207719 844 211 3.868132 8.16175852 Drosophila 7215 Arthropoda Arthropoda 346 7.59e-91   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g824 i0 100 88.6255924170616 187 0 89 0 1 187 2930 2744 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 18700 346 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
6158750 6158750 PRJNA207719_P_NODE_285_length_400_cov_4.679245_g265_i0 PRJNA207719 285 400 4.679245 18.71698 Drosophila 7215 Arthropoda Arthropoda 691 0   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g265 i0 97.007 104.2575 401 10 99 1 1 399 41 441 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 41703 691 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
7433936 7433936 PRJNA207719_P_NODE_1066_length_181_cov_3.006579_g1046_i0 PRJNA207719 1066 181 3.006579 5.44190799 Artemia 6660 Arthropoda Arthropoda 335 1.36e-87   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1046 i0 100 12.4696132596685 181 0 100 0 1 181 444 624 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 2257 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
9984128 9984128 PRJNA207719_P_NODE_488_length_296_cov_6.273408_g468_i0 PRJNA207719 488 296 6.273408 18.56928768 Drosophila 7215 Arthropoda Arthropoda 547 2.8799999999999986e-151   NTclustered gi|1829471642|ref|XR_004460549.1| 7226 g468 i0 100 100 296 0 100 0 1 296 1506 1801 PREDICTED: Drosophila mauritiana large subunit ribosomal RNA (LOC117149830), rRNA blastn 29600 547 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
11259247 11259247 PRJNA207719_P_NODE_409_length_326_cov_6.643098_g389_i0 PRJNA207719 409 326 6.643098 21.65649948 Drosophila 7215 Arthropoda Arthropoda 603 6.749999999999998e-168   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g389 i0 100 100 326 0 100 0 1 326 3359 3034 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 32600 603 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
11259248 11259248 PRJNA207719_P_NODE_869_length_207_cov_4.398876_g849_i0 PRJNA207719 869 207 4.398876 9.10567332 Artemia 6660 Arthropoda Arthropoda 383 5.65e-102   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g849 i0 100 100.647342995169 207 0 100 0 1 207 1650 1444 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 20834 383 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12534643 12534643 PRJNA207719_P_NODE_310_length_382_cov_5.050992_g290_i0 PRJNA207719 310 382 5.050992 19.29478944 Drosophila 7215 Arthropoda Arthropoda 695 0   NTclustered gi|1509833704|ref|XR_003408257.1| 7220 g290 i0 99.476 100 382 2 100 0 1 382 790 1171 PREDICTED: Drosophila erecta small subunit ribosomal RNA (LOC113564718), rRNA blastn 38200 695 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
13120877 13120877 PRJNA207719_P_NODE_1151_length_172_cov_2.804196_g1131_i0 PRJNA207719 1151 172 2.804196 4.82321712 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 75 3.08e-9   NTclustered gi|2919531121|emb|OZ238343.1| 1002887 g1131 i0 97.674 15.5755813953488 43 1 26 0 88 130 24557450 24557492 Glaucopsyche melanops genome assembly, chromosome: 2 blastn 2679 75 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
13809442 13809442 PRJNA207719_P_NODE_211_length_473_cov_7.828829_g191_i0 PRJNA207719 211 473 7.828829 37.03036117 Drosophila 7215 Arthropoda Arthropoda 809 0   NTclustered gi|1829471572|ref|XR_004460481.1| 7226 g191 i0 97.886 100 473 0 100 1 1 473 1851 2313 PREDICTED: Drosophila mauritiana large subunit ribosomal RNA (LOC117149730), rRNA blastn 47300 809 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
17633646 17633646 PRJNA207719_P_NODE_254_length_427_cov_7.954774_g234_i0 PRJNA207719 254 427 7.954774 33.96688498 Drosophila 7215 Arthropoda Arthropoda 789 0   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g234 i0 100 100 427 0 100 0 1 427 3915 3489 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 42700 789 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
18218731 18218731 PRJNA207719_P_NODE_1195_length_166_cov_3.226277_g1175_i0 PRJNA207719 1195 166 3.226277 5.35561982 Pseudocyphomyia mimetica 343712 Arthropoda Arthropoda 110 8.13e-20   NTclustered gi|75386873|gb|DQ168671.1| 343712 g1175 i0 86.275 71.8072289156626 102 12 61 2 66 166 102 2 Pseudocyphomyia mimetica voucher CB0114 elongation factor-1 alpha gene, partial cds blastn 11920 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Pseudocyphomyia Pseudocyphomyia mimetica
21457775 21457775 PRJNA207719_P_NODE_417_length_322_cov_3.116041_g397_i0 PRJNA207719 417 322 3.116041 10.03365202 Drosophila 7215 Arthropoda Arthropoda 527 4.119999999999998e-145   NTclustered gi|1509833743|ref|XR_003408286.1| 7220 g397 i0 96.865 99.0683229813665 319 1 99 1 4 322 366 57 PREDICTED: Drosophila erecta small subunit ribosomal RNA (LOC113564751), rRNA blastn 31900 527 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
21457776 21457776 PRJNA207719_P_NODE_637_length_250_cov_3.570136_g617_i0 PRJNA207719 637 250 3.570136 8.92534 Artemia 6660 Arthropoda Arthropoda 457 4.1099999999999985e-124   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g617 i0 99.6 98.012 250 1 100 0 1 250 1022 773 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 24503 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21457777 21457777 PRJNA207719_P_NODE_817_length_216_cov_3.160428_g797_i0 PRJNA207719 817 216 3.160428 6.82652448 Artemia 6660 Arthropoda Arthropoda 394 2.75e-105   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g797 i0 99.537 27.7268518518519 216 1 100 0 1 216 2399 2184 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 5989 394 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22732811 22732811 PRJNA207719_P_NODE_458_length_308_cov_3.265233_g438_i0 PRJNA207719 458 308 3.265233 10.05691764 Drosophila 7215 Arthropoda Arthropoda 569 6.419999999999998e-158   NTclustered gi|1509833716|ref|XR_003408266.1| 7220 g438 i0 100 100 308 0 100 0 1 308 1215 908 PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA blastn 30800 569 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta

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