contig_metadata
14 rows where bioproject = "PRJNA393181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2353875 | 2353875 | PRJNA393181_S_NODE_29062_length_209_cov_2.406977_g28956_i0 | PRJNA393181 | 29062 | 209 | 2.406977 | 5.03058193 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 8.46e-6 | NTclustered | gi|2488167516|emb|OC981260.1| | 77745 | g28956 | i0 | 100 | 17.4401913875598 | 34 | 0 | 16 | 0 | 176 | 209 | 55 | 22 | Chydorus sphaericus partial EOG090X09DZ gene for EOG090X09DZ | blastn | 3645 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Chydoridae | Chydorus | Chydorus sphaericus | |
| 2960738 | 2960738 | PRJNA393181_S_NODE_11083_length_362_cov_4.800000_g10977_i0 | PRJNA393181 | 11083 | 362 | 4.8 | 17.376 | Chelidurella thaleri | 2546182 | Arthropoda | Arthropoda | 52.8 | 0.034 | NTclustered | gi|2919610158|emb|OZ238415.1| | 2546182 | g10977 | i0 | 100 | 0.0773480662983425 | 28 | 0 | 8 | 0 | 300 | 327 | 2961648 | 2961675 | Chelidura thaleri genome assembly, chromosome: 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Dermaptera | Forficulidae | Chelidurella | Chelidurella thaleri | |
| 4237756 | 4237756 | PRJNA393181_S_NODE_37564_length_176_cov_2.805755_g37458_i0 | PRJNA393181 | 37564 | 176 | 2.805755 | 4.9381288 | Timema douglasi | 61478 | Arthropoda | Arthropoda | 270 | 3.77e-68 | NTclustered | gi|1936766486|emb|OA594500.1| | 61478 | g37458 | i0 | 94.886 | 1 | 176 | 3 | 100 | 2 | 1 | 176 | 1598 | 1429 | 1_Tdi_b3v08 | blastn | 176 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema douglasi | |
| 6788816 | 6788816 | PRJNA393181_S_NODE_9286_length_395_cov_26.025140_g9180_i0 | PRJNA393181 | 9286 | 395 | 26.02514 | 102.799303 | Mythimna separata | 271217 | Arthropoda | Arthropoda | 54.7 | 0.011 | NTclustered | gi|443609450|dbj|AB778567.1| | 271217 | g9180 | i0 | 100 | 0.144303797468354 | 29 | 0 | 7 | 0 | 10 | 38 | 53 | 81 | Mythimna separata PsIAP mRNA for inhibitor of apoptosis protein, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Mythimna | Mythimna separata | |
| 10614608 | 10614608 | PRJNA393181_S_NODE_40349_length_168_cov_1.977099_g40243_i0 | PRJNA393181 | 40349 | 168 | 1.977099 | 3.32152632 | Callophrys avis | 700180 | Arthropoda | Arthropoda | 52.8 | 0.014 | NTclustered | gi|2918385993|emb|OZ238089.1| | 700180 | g40243 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 133 | 160 | 11333872 | 11333899 | Callophrys avis genome assembly, chromosome: 22 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Callophrys | Callophrys avis | |
| 11889718 | 11889718 | PRJNA393181_S_NODE_4510_length_532_cov_2.157576_g4406_i0 | PRJNA393181 | 4510 | 532 | 2.157576 | 11.47830432 | Anarta stigmosa | 1869462 | Arthropoda | Arthropoda | 54.7 | 0.015 | NTclustered | gi|2918376569|emb|OZ237994.1| | 1869462 | g4406 | i0 | 96.875 | 0.0601503759398496 | 32 | 1 | 6 | 0 | 136 | 167 | 766035 | 766004 | Anarta stigmosa genome assembly, chromosome: 18 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Anarta | Anarta stigmosa | |
| 13832080 | 13832080 | PRJNA393181_S_NODE_41531_length_165_cov_1.218750_g41425_i0 | PRJNA393181 | 41531 | 165 | 1.21875 | 2.0109375 | Metazoa | 33208 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|2867932872|ref|XM_015171214.3| | 7244 | g41425 | i0 | 100 | 2.5030303030303 | 30 | 0 | 18 | 0 | 136 | 165 | 1050 | 1021 | PREDICTED: Drosophila virilis Dorsal switch protein 1 (Dsp1), transcript variant X2, mRNA | blastn | 413 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila virilis | |
| 15713688 | 15713688 | PRJNA393181_S_NODE_6313_length_467_cov_9.806977_g6207_i0 | PRJNA393181 | 6313 | 467 | 9.806977 | 45.79858259 | Mythimna separata | 271217 | Arthropoda | Arthropoda | 54.7 | 0.013 | NTclustered | gi|443609450|dbj|AB778567.1| | 271217 | g6207 | i0 | 100 | 0.0620985010706638 | 29 | 0 | 6 | 0 | 430 | 458 | 81 | 53 | Mythimna separata PsIAP mRNA for inhibitor of apoptosis protein, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Mythimna | Mythimna separata | |
| 16988249 | 16988249 | PRJNA393181_S_NODE_41914_length_164_cov_1.228346_g41808_i0 | PRJNA393181 | 41914 | 164 | 1.228346 | 2.01448744 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 52.8 | 0.014 | NTclustered | gi|1964708817|emb|OC858617.1| | 1979941 | g41808 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 60 | 87 | 5040 | 5067 | Medioppia subpectinata | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 20811948 | 20811948 | PRJNA393181_S_NODE_22277_length_247_cov_2.247619_g22171_i0 | PRJNA393181 | 22277 | 247 | 2.247619 | 5.55161893 | Timema douglasi | 61478 | Arthropoda | Arthropoda | 435 | 1.9e-117 | NTclustered | gi|1936766486|emb|OA594500.1| | 61478 | g22171 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 1869 | 1623 | 1_Tdi_b3v08 | blastn | 247 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema douglasi | |
| 20812271 | 20812271 | PRJNA393181_S_NODE_35277_length_184_cov_1.850340_g35171_i0 | PRJNA393181 | 35277 | 184 | 1.85034 | 3.4046256 | root | 1 | Root_unresolved | Root_unresolved | 57 | 1.59e-7 | NR | VVC97936.1 | 189913 | g35171 | i0 | 69 | 11.0217391304348 | 42 | 12 | 68.5 | 1 | 126 | 1 | 92 | 132 | VVC97936.1 unnamed protein product [Leptidea sinapis] | diamond | 2028 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Pieridae | Leptidea | Leptidea sinapis | |
| 23362387 | 23362387 | PRJNA393181_S_NODE_20679_length_258_cov_2.457014_g20573_i0 | PRJNA393181 | 20679 | 258 | 2.457014 | 6.33909612 | Maniola hyperantus | 2795564 | Arthropoda | Arthropoda | 54.7 | 0.007 | NTclustered | gi|2839044039|ref|XM_034974608.2| | 2795564 | g20573 | i0 | 100 | 0.449612403100775 | 29 | 0 | 11 | 0 | 161 | 189 | 886 | 914 | PREDICTED: Maniola hyperantus transmembrane protein 94-like protein l(2)k05819 (l(2)k05819), transcript variant X1, mRNA | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Nymphalidae | Maniola | Maniola hyperantus | |
| 30896957 | 30896957 | PRJNA393181_S_NODE_18574_length_275_cov_2.457983_g18468_i0 | PRJNA393181 | 18574 | 275 | 2.457983 | 6.75945325 | Polyplax serrata | 468196 | Arthropoda | Arthropoda | 64.7 | 4.56e-10 | NR | KAK6619586.1 | 468196 | g18468 | i0 | 75 | 0.698181818181818 | 32 | 8 | 34.9 | 0 | 3 | 98 | 183 | 214 | KAK6619586.1 hypothetical protein RUM43_012343 [Polyplax serrata] | diamond | 192 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Polyplacidae | Polyplax | Polyplax serrata | |
| 31592470 | 31592470 | PRJNA393181_S_NODE_34216_length_188_cov_1.291391_g34110_i0 | PRJNA393181 | 34216 | 188 | 1.291391 | 2.42781508 | Clunio marinus | 568069 | Arthropoda | Arthropoda | 116 | 1.04e-29 | NR | CRL02559.1 | 568069 | g34110 | i0 | 85.5 | 0.98936170212766 | 62 | 9 | 98.9 | 0 | 186 | 1 | 251 | 312 | CRL02559.1 CLUMA_CG015843, isoform A [Clunio marinus] | diamond | 186 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Clunio | Clunio marinus |
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);;