RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1067443" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1067443 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
2732163 2732163 PRJNA1067443_P_NODE_4543_length_367_cov_9.850340_g4525_i0 PRJNA1067443 4543 367 9.85034 36.1507478 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g4525 i0 100 0.0762942779291553 28 0 8 0 39 66 23317845 23317818 Satyrium ilicis genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
5284272 5284272 PRJNA1067443_P_NODE_20005_length_245_cov_0.895349_g19987_i0 PRJNA1067443 20005 245 0.895349 2.19360505 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 62.1 3.67e-5   NTclustered gi|2237320238|ref|XM_048134236.1| 1035111 g19987 i0 92.857 0.17142857142857101 42 3 17 0 50 91 3182 3223 PREDICTED: Leguminivora glycinivorella RNA polymerase-associated protein CTR9 homolog (LOC125229406), mRNA blastn 42 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
10384785 10384785 PRJNA1067443_P_NODE_19349_length_246_cov_0.890173_g19331_i0 PRJNA1067443 19349 246 0.890173 2.18982558 Drosophila montana 40370 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2721905550|ref|XM_064687820.1| 40370 g19331 i0 100 0.113821138211382 28 0 11 0 30 57 1034 1007 PREDICTED: Drosophila montana ras-like protein 2 (Ras64B), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila montana
12935303 12935303 PRJNA1067443_P_NODE_24391_length_200_cov_7.393701_g24373_i0 PRJNA1067443 24391 200 7.393701 14.787402 Bemisia tabaci 7038 Arthropoda Arthropoda 52.8 0.017   NTclustered gi|1101370597|ref|XM_019061133.1| 7038 g24373 i0 96.875 0.16 32 0 16 1 2 33 937 967 PREDICTED: Bemisia tabaci uncharacterized LOC109043815 (LOC109043815), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
18033259 18033259 PRJNA1067443_P_NODE_21315_length_243_cov_0.905882_g21297_i0 PRJNA1067443 21315 243 0.905882 2.20129326 Anopheles nili 185578 Arthropoda Arthropoda 63.9 1.01e-5   NTclustered gi|2449506146|ref|XM_053822357.1| 185578 g21297 i0 97.368 1.09053497942387 38 0 15 1 200 236 4647 4610 PREDICTED: Anopheles nili uncharacterized LOC128728720 (LOC128728720), mRNA blastn 265 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
18033260 18033260 PRJNA1067443_P_NODE_21335_length_243_cov_0.905882_g21317_i0 PRJNA1067443 21335 243 0.905882 2.20129326 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 267 7.19e-67   NTclustered gi|1535902535|ref|XM_027350222.1| 6956 g21317 i0 100 1.27572016460905 144 0 59 0 61 204 1260 1117 PREDICTED: Dermatophagoides pteronyssinus ubiquitin carboxyl-terminal hydrolase MINDY-1-like (LOC113799567), mRNA blastn 310 267 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
19307089 19307089 PRJNA1067443_P_NODE_20476_length_244_cov_1.725146_g20458_i0 PRJNA1067443 20476 244 1.725146 4.20935624 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 429 8.699999999999998e-116   NTclustered gi|641654571|ref|XM_008181035.1| 7029 g20458 i0 98.361 8.55327868852459 244 4 100 0 1 244 2358 2115 PREDICTED: Acyrthosiphon pisum uncharacterized LOC103308142 (LOC103308142), mRNA blastn 2087 429 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
21858359 21858359 PRJNA1067443_P_NODE_23098_length_237_cov_5.932927_g23080_i0 PRJNA1067443 23098 237 5.932927 14.06103699 Artemia franciscana 6661 Arthropoda Arthropoda 95.3 3.48e-15   NTclustered gi|2743062923|ref|XM_065700419.1| 6661 g23080 i0 100 0.215189873417722 51 0 22 0 163 213 6225 6175 PREDICTED: Artemia franciscana zinc finger protein 184-like (LOC136024888), mRNA blastn 51 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21858523 21858523 PRJNA1067443_P_NODE_7438_length_312_cov_3.025105_g7420_i0 PRJNA1067443 7438 312 3.025105 9.4383276 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g7420 i0 100 0.272435897435897 29 0 9 0 284 312 56 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
21858567 21858567 PRJNA1067443_P_NODE_898_length_588_cov_18.330097_g880_i0 PRJNA1067443 898 588 18.330097 107.78097036 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.016   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g880 i0 100 0.049319727891156503 29 0 5 0 560 588 56 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
23133585 23133585 PRJNA1067443_P_NODE_1119_length_557_cov_11.371901_g1101_i0 PRJNA1067443 1119 557 11.371901 63.34148857 Aphis gossypii 80765 Arthropoda Arthropoda 121 1.48e-22   NTclustered gi|2288459457|ref|XR_007606345.1| 80765 g1101 i0 92.045 0.315978456014363 88 3 15 3 135 220 369 454 PREDICTED: Aphis gossypii uncharacterized LOC126552892 (LOC126552892), transcript variant X2, ncRNA blastn 176 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii

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