contig_metadata
9 rows where bioproject = "PRJNA397736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4907909 | 4907909 | PRJNA397736_S_NODE_184_length_676_cov_32.989181_g167_i0 | PRJNA397736 | 184 | 676 | 32.989181 | 223.00686356 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 0.001 | NTclustered | gi|2304139023|ref|XM_050623139.1| | 85661 | g167 | i0 | 100 | 1.78994082840237 | 31 | 0 | 5 | 0 | 468 | 498 | 160 | 190 | PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA | blastn | 1210 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Bombus | Bombus huntii | |
| 8065467 | 8065467 | PRJNA397736_S_NODE_287_length_556_cov_17.252372_g214_i2 | PRJNA397736 | 287 | 556 | 17.252372 | 95.92318832 | Demodex environmental sample | 1856688 | Arthropoda | Arthropoda | 752 | 0 | NTclustered | gi|1040064834|gb|KU363928.1| | 1856688 | g214 | i2 | 91.47 | 98.089928057554 | 551 | 42 | 99 | 4 | 8 | 556 | 1 | 548 | Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence | blastn | 54538 | 752 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex environmental sample | |
| 10616031 | 10616031 | PRJNA397736_S_NODE_1009_length_286_cov_3.747082_g973_i0 | PRJNA397736 | 1009 | 286 | 3.747082 | 10.71665452 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 527 | 3.5999999999999986e-145 | NTclustered | gi|357966808|gb|JF499929.1| | 6973 | g973 | i0 | 100 | 96.1398601398601 | 285 | 0 | 99 | 0 | 2 | 286 | 841 | 557 | Blattella germanica isolate GRI-D22-2a small subunit ribosomal RNA gene, partial sequence | blastn | 27496 | 527 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 13165892 | 13165892 | PRJNA397736_S_NODE_851_length_311_cov_5.645390_g815_i0 | PRJNA397736 | 851 | 311 | 5.64539 | 17.5571629 | Pseudoterpna coronillaria | 1007376 | Arthropoda | Arthropoda | 60.2 | 1.74e-4 | NTclustered | gi|2918369770|emb|OZ237837.1| | 1007376 | g815 | i0 | 89.583 | 0.154340836012862 | 48 | 3 | 15 | 2 | 261 | 308 | 5854513 | 5854558 | Pseudoterpna coronillaria genome assembly, chromosome: 12 | blastn | 48 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Geometridae | Pseudoterpna | Pseudoterpna coronillaria | |
| 18263782 | 18263782 | PRJNA397736_S_NODE_155_length_739_cov_27.492958_g140_i0 | PRJNA397736 | 155 | 739 | 27.492958 | 203.17295962 | Penaeus chinensis | 139456 | Arthropoda | Arthropoda | 95.1 | 2.87e-18 | NR | XP_047497450.1 | 139456 | g140 | i0 | 41.4 | 2.77266576454668 | 157 | 64 | 52.4 | 3 | 739 | 353 | 430 | 586 | XP_047497450.1 heat shock 70 kDa protein cognate 4-like [Penaeus chinensis] | diamond | 2049 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus chinensis | |
| 19537996 | 19537996 | PRJNA397736_S_NODE_236_length_620_cov_19.473773_g214_i0 | PRJNA397736 | 236 | 620 | 19.473773 | 120.7373926 | Demodex environmental sample | 1856688 | Arthropoda | Arthropoda | 942 | 0 | NTclustered | gi|1040064834|gb|KU363928.1| | 1856688 | g214 | i0 | 95.159 | 97.6290322580645 | 599 | 26 | 96 | 3 | 17 | 613 | 598 | 1 | Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence | blastn | 60530 | 942 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex environmental sample | |
| 19537998 | 19537998 | PRJNA397736_S_NODE_816_length_318_cov_4.148789_g780_i0 | PRJNA397736 | 816 | 318 | 4.148789 | 13.19314902 | Platynothrus peltifer | 128015 | Arthropoda | Arthropoda | 52.8 | 0.03 | NTclustered | gi|2579718317|gb|CP133306.1| | 128015 | g780 | i0 | 100 | 0.0880503144654088 | 28 | 0 | 9 | 0 | 3 | 30 | 19738402 | 19738375 | Platynothrus peltifer isolate 155_3 chromosome 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Camisiidae | Platynothrus | Platynothrus peltifer | |
| 27755777 | 27755777 | PRJNA397736_S_NODE_3064_length_150_cov_4.223140_g3028_i0 | PRJNA397736 | 3064 | 150 | 4.22314 | 6.33471 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 41.2 | 0.0363 | NR | XP_071512935.1 | 150431 | g3028 | i0 | 39.6 | 1.86 | 48 | 29 | 96 | 0 | 6 | 149 | 131 | 178 | XP_071512935.1 glycylpeptide N-tetradecanoyltransferase 2 isoform X4 [Panulirus ornatus] | diamond | 279 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Palinuridae | Panulirus | Panulirus ornatus | |
| 32035263 | 32035263 | PRJNA397736_S_NODE_2718_length_161_cov_2.113636_g2682_i0 | PRJNA397736 | 2718 | 161 | 2.113636 | 3.40295396 | Polypedilum vanderplanki | 319348 | Arthropoda | Arthropoda | 45.1 | 0.00118 | NR | KAG5669625.1 | 319348 | g2682 | i0 | 40 | 1.02484472049689 | 55 | 31 | 98.8 | 1 | 161 | 3 | 27 | 81 | KAG5669625.1 hypothetical protein PVAND_017510 [Polypedilum vanderplanki] | diamond | 165 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Polypedilum | Polypedilum vanderplanki |
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);;