contig_metadata
18 rows where bioproject = "PRJNA492363", tax_kingdom = "Metazoa" and tax_phylum = "Arthropoda"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25566409 | 25566409 | PRJNA492363_S_NODE_4593_length_415_cov_23495.915254_g3772_i0 | PRJNA492363 | 4593 | 415 | 23495.915254 | 97508.0483041 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 514 | 4.23e-141 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g3772 | i0 | 94.595 | 202.824096385542 | 333 | 16 | 80 | 2 | 84 | 415 | 842 | 511 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 84172 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 25566981 | 25566981 | PRJNA492363_S_NODE_80625_length_213_cov_1.263158_g79804_i0 | PRJNA492363 | 80625 | 213 | 1.263158 | 2.69052654 | Apis florea | 7463 | Arthropoda | Arthropoda | 54.7 | 0.005 | NTclustered | gi|1787269715|ref|XM_012493280.2| | 7463 | g79804 | i0 | 96.875 | 0.150234741784038 | 32 | 1 | 15 | 0 | 74 | 105 | 5081 | 5112 | PREDICTED: Apis florea DNA-directed RNA polymerase II subunit RPB1 (LOC100870960), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Apis | Apis florea | |
| 25702820 | 25702820 | PRJNA492363_S_NODE_6626_length_357_cov_1.675676_g5805_i0 | PRJNA492363 | 6626 | 357 | 1.675676 | 5.98216332 | Chelidura thaleri | 2546182 | Arthropoda | Arthropoda | 58.4 | 7.26e-4 | NTclustered | gi|2919607494|emb|OZ238404.1| | 2546182 | g5805 | i0 | 97.143 | 0.0980392156862745 | 35 | 0 | 10 | 1 | 322 | 355 | 20947551 | 20947517 | Chelidura thaleri genome assembly, chromosome: 5 | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Dermaptera | Forficulidae | Chelidurella | Chelidurella thaleri | |
| 25837771 | 25837771 | PRJNA492363_S_NODE_10139_length_302_cov_34512.058091_g9318_i0 | PRJNA492363 | 10139 | 302 | 34512.058091 | 104226.41543482 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 333 | 8.969999999999998e-87 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g9318 | i0 | 94.064 | 268.086092715232 | 219 | 13 | 73 | 0 | 1 | 219 | 511 | 729 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 80962 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 25896960 | 25896960 | PRJNA492363_S_NODE_11891_length_282_cov_2.606335_g11070_i0 | PRJNA492363 | 11891 | 282 | 2.606335 | 7.3498647 | Caerostris darwini | 1538125 | Arthropoda | Arthropoda | 68.6 | 5.96e-12 | NR | GIY80821.1 | 1538125 | g11070 | i0 | 43.4 | 0.882978723404255 | 83 | 39 | 88.3 | 2 | 29 | 277 | 14 | 88 | GIY80821.1 astacin, partial [Caerostris darwini] | diamond | 249 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Caerostris | Caerostris darwini | |
| 25973991 | 25973991 | PRJNA492363_S_NODE_10140_length_302_cov_34509.423237_g9319_i0 | PRJNA492363 | 10140 | 302 | 34509.423237 | 104218.45817574 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 339 | 1.93e-88 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g9319 | i0 | 94.521 | 269.543046357616 | 219 | 12 | 73 | 0 | 84 | 302 | 729 | 511 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 81402 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 25975375 | 25975375 | PRJNA492363_S_NODE_79908_length_214_cov_1.444444_g79087_i0 | PRJNA492363 | 79908 | 214 | 1.444444 | 3.09111016 | Oppiella nova | 334625 | Arthropoda | Arthropoda | 52.8 | 0.019 | NTclustered | gi|1962603429|emb|OC928711.1| | 334625 | g79087 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 121 | 148 | 3006 | 2979 | Oppiella nova | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Oppiella | Oppiella nova | |
| 26111229 | 26111229 | PRJNA492363_S_NODE_6973_length_349_cov_10.479167_g6152_i0 | PRJNA492363 | 6973 | 349 | 10.479167 | 36.57229283 | Satyrium ilicis | 876074 | Arthropoda | Arthropoda | 52.8 | 0.033 | NTclustered | gi|2918386088|emb|OZ238121.1| | 876074 | g6152 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 50 | 77 | 23317845 | 23317818 | Satyrium ilicis genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Satyrium | Satyrium ilicis | |
| 26111342 | 26111342 | PRJNA492363_S_NODE_76941_length_218_cov_1.477707_g76120_i0 | PRJNA492363 | 76941 | 218 | 1.477707 | 3.22140126 | Drosophila melanogaster | 7227 | Arthropoda | Arthropoda | 359 | 1.01e-94 | NTclustered | gi|364503167|gb|AC246463.1| | 7227 | g76120 | i0 | 100 | 56.6009174311927 | 194 | 0 | 89 | 0 | 1 | 194 | 87494 | 87687 | Drosophila melanogaster clone BACR09H16, complete sequence | blastn | 12339 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila melanogaster | |
| 26247577 | 26247577 | PRJNA492363_S_NODE_79142_length_215_cov_26.844156_g78321_i0 | PRJNA492363 | 79142 | 215 | 26.844156 | 57.7149354 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 65.8 | 2.43e-6 | NTclustered | gi|1832334880|gb|MK599468.1| | 6687 | g78321 | i0 | 100 | 0.683720930232558 | 35 | 0 | 16 | 0 | 1 | 35 | 87 | 121 | Penaeus monodon C-type lectin mRNA, complete cds | blastn | 147 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 26248035 | 26248035 | PRJNA492363_S_NODE_97110_length_203_cov_0.901408_g96289_i0 | PRJNA492363 | 97110 | 203 | 0.901408 | 1.82985824 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 200 | 5.97e-47 | NTclustered | gi|2743064511|ref|XR_010617067.1| | 6661 | g96289 | i0 | 86.243 | 93.3251231527094 | 189 | 21 | 92 | 4 | 6 | 191 | 6327 | 6141 | PREDICTED: Artemia franciscana uncharacterized LOC136025328 (LOC136025328), transcript variant X2, ncRNA | blastn | 18945 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 26305180 | 26305180 | PRJNA492363_S_NODE_10918_length_293_cov_1.120690_g10097_i0 | PRJNA492363 | 10918 | 293 | 1.12069 | 3.2836217 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 4.51e-5 | NTclustered | gi|1936621120|emb|LR906378.1| | 69355 | g10097 | i0 | 100 | 4.37883959044369 | 33 | 0 | 11 | 0 | 132 | 164 | 3327 | 3359 | Darwinula stevensoni | blastn | 1283 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 26382149 | 26382149 | PRJNA492363_S_NODE_11599_length_285_cov_1.312500_g10778_i0 | PRJNA492363 | 11599 | 285 | 1.3125 | 3.740625 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 351 | 2.32e-92 | NTclustered | gi|1962550220|emb|OC881529.1| | 1979941 | g10778 | i0 | 91.44 | 23.9122807017544 | 257 | 20 | 90 | 2 | 1 | 256 | 681 | 426 | Medioppia subpectinata | blastn | 6815 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 26383096 | 26383096 | PRJNA492363_S_NODE_607_length_10231_cov_6.866765_g189_i0 | PRJNA492363 | 607 | 10231 | 6.866765 | 702.53872715 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 1387 | 0 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g189 | i0 | 92.812 | 24.8436125500929 | 960 | 65 | 100 | 4 | 9105 | 10062 | 958 | 1 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 254175 | 1387 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 26518983 | 26518983 | PRJNA492363_S_NODE_3800_length_453_cov_17906.168367_g2979_i0 | PRJNA492363 | 3800 | 453 | 17906.168367 | 81114.94270251 | Darwinula stevensoni | 69355 | Arthropoda | Arthropoda | 252 | 4.03e-62 | NTclustered | gi|1936765782|emb|LR917903.1| | 69355 | g2979 | i0 | 80.734 | 140.78587196468 | 327 | 59 | 72 | 4 | 85 | 409 | 410 | 734 | Darwinula stevensoni | blastn | 63776 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 26519373 | 26519373 | PRJNA492363_S_NODE_67072_length_225_cov_1.170732_g66251_i0 | PRJNA492363 | 67072 | 225 | 1.170732 | 2.634147 | Cimex lectularius | 79782 | Arthropoda | Arthropoda | 52.8 | 0.02 | NTclustered | gi|1351631453|ref|XM_014391711.2| | 79782 | g66251 | i0 | 100 | 0.373333333333333 | 28 | 0 | 12 | 0 | 25 | 52 | 3759 | 3732 | PREDICTED: Cimex lectularius uncharacterized LOC106665351 (LOC106665351), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cimicidae | Cimex | Cimex lectularius | |
| 26519780 | 26519780 | PRJNA492363_S_NODE_8624_length_322_cov_26542.287356_g7803_i0 | PRJNA492363 | 8624 | 322 | 26542.287356 | 85466.16528632 | Darwinula stevensoni | 69355 | Arthropoda | Arthropoda | 259 | 1.66e-64 | NTclustered | gi|1936954524|emb|LR928027.1| | 69355 | g7803 | i0 | 89.655 | 189.894409937888 | 203 | 21 | 63 | 0 | 85 | 287 | 609 | 811 | Darwinula stevensoni | blastn | 61146 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 33037884 | 33037884 | PRJNA492363_S_NODE_95268_length_204_cov_0.895105_g94447_i0 | PRJNA492363 | 95268 | 204 | 0.895105 | 1.8260142 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 89.7 | 6.21e-19 | NR | XP_049848600.1 | 7010 | g94447 | i0 | 75.9 | 3.91176470588235 | 54 | 13 | 79.4 | 0 | 163 | 2 | 183 | 236 | XP_049848600.1 116 kDa U5 small nuclear ribonucleoprotein component-like [Schistocerca gregaria] | diamond | 798 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria |
Advanced export
JSON shape: default, array, newline-delimited
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);;