contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26936895 | 26936895 | PRJNA917598_P_NODE_49462_length_326_cov_1.217391_g48518_i0 | PRJNA917598 | 49462 | 326 | 1.217391 | 3.96869466 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 160 | 6.079999999999999e-46 | NR | XP_021036129.1 | 10089 | g48518 | i0 | 79.4 | 661.960122699386 | 107 | 20 | 96.6 | 1 | 325 | 11 | 232 | 338 | XP_021036129.1 uncharacterized protein LOC110308115 [Mus caroli] | diamond | 215799 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus caroli | |
| 27853157 | 27853157 | PRJNA917598_P_NODE_72384_length_267_cov_1.319588_g71440_i0 | PRJNA917598 | 72384 | 267 | 1.319588 | 3.52329996 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.8 | 1.85e-8 | NR | XDA78288.1 | 9940 | g71440 | i0 | 44.3 | 2.80898876404494 | 70 | 39 | 78.7 | 0 | 56 | 265 | 48 | 117 | XDA78288.1 hypothetical protein R6Z07_008468 [Ovis aries] | diamond | 750 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 28042710 | 28042710 | PRJNA917598_P_NODE_93985_length_242_cov_0.911243_g93041_i0 | PRJNA917598 | 93985 | 242 | 0.911243 | 2.20520806 | Chordata | 7711 | Chordata | Chordata | 49.7 | 1.28e-4 | NR | KAB0374057.1 | 9886 | g93041 | i0 | 57.5 | 4.95867768595041 | 40 | 17 | 49.6 | 0 | 39 | 158 | 408 | 447 | KAB0374057.1 hypothetical protein FD755_014313 [Muntiacus reevesi] | diamond | 1200 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 28098478 | 28098478 | PRJNA917598_P_NODE_94285_length_242_cov_0.911243_g93341_i0 | PRJNA917598 | 94285 | 242 | 0.911243 | 2.20520806 | Phallusia mammillata | 59560 | Chordata | Chordata | 63.5 | 1.72e-9 | NR | CAB3243811.1 | 59560 | g93341 | i0 | 44.4 | 4.06611570247934 | 72 | 26 | 73.1 | 3 | 200 | 24 | 348 | 418 | CAB3243811.1 extended synaptotagmin-2 [Phallusia mammillata] | diamond | 984 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 28484739 | 28484739 | PRJNA917598_P_NODE_66846_length_278_cov_1.482927_g65902_i0 | PRJNA917598 | 66846 | 278 | 1.482927 | 4.12253706 | Anura | 8342 | Chordata | Chordata | 64.7 | 1.06e-9 | NR | CAH2306950.1 | 61616 | g65902 | i0 | 46.4 | 3.79856115107914 | 69 | 33 | 70.1 | 1 | 219 | 25 | 81 | 149 | CAH2306950.1 poly(A)-specific ribonuclease PARN isoform X1 [Pelobates cultripes] | diamond | 1056 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pelobatidae | Pelobates | Pelobates cultripes | |
| 28824483 | 28824483 | PRJNA917598_P_NODE_78688_length_252_cov_2.418994_g77744_i0 | PRJNA917598 | 78688 | 252 | 2.418994 | 6.09586488 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 45.4 | 0.00465 | NR | XP_028676012.2 | 27687 | g77744 | i0 | 36.9 | 0.773809523809524 | 65 | 38 | 73.8 | 1 | 187 | 2 | 86 | 150 | XP_028676012.2 toll-like receptor 5 isoform X2 [Erpetoichthys calabaricus] | diamond | 195 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 29235243 | 29235243 | PRJNA917598_P_NODE_30889_length_414_cov_1.803519_g29945_i0 | PRJNA917598 | 30889 | 414 | 1.803519 | 7.46656866 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0385 | NR | KAG2471189.1 | 55291 | g29945 | i0 | 57.1 | 0.253623188405797 | 35 | 15 | 25.4 | 0 | 222 | 326 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29235300 | 29235300 | PRJNA917598_P_NODE_87909_length_246_cov_0.890173_g86965_i0 | PRJNA917598 | 87909 | 246 | 0.890173 | 2.18982558 | Dromiciops gliroides | 33562 | Chordata | Chordata | 68.6 | 2.63e-11 | NR | XP_043827924.1 | 33562 | g86965 | i0 | 51.5 | 0.804878048780488 | 66 | 32 | 80.5 | 0 | 28 | 225 | 41 | 106 | XP_043827924.1 cathepsin W [Dromiciops gliroides] | diamond | 198 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Microbiotheria | Microbiotheriidae | Dromiciops | Dromiciops gliroides | |
| 29266594 | 29266594 | PRJNA917598_P_NODE_93529_length_242_cov_1.414201_g92585_i0 | PRJNA917598 | 93529 | 242 | 1.414201 | 3.42236642 | Ranitomeya imitator | 111125 | Chordata | Chordata | 82.4 | 3.33e-16 | NR | XP_069585547.1 | 111125 | g92585 | i0 | 48.6 | 5.3801652892562 | 72 | 37 | 89.3 | 0 | 224 | 9 | 113 | 184 | XP_069585547.1 uncharacterized protein [Ranitomeya imitator] | diamond | 1302 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29361559 | 29361559 | PRJNA917598_P_NODE_85549_length_247_cov_1.643678_g84605_i0 | PRJNA917598 | 85549 | 247 | 1.643678 | 4.05988466 | Cricetulus griseus | 10029 | Chordata | Chordata | 69.7 | 1.91e-13 | NR | ERE84900.1 | 10029 | g84605 | i0 | 57.6 | 0.801619433198381 | 66 | 27 | 80.2 | 1 | 245 | 48 | 18 | 82 | ERE84900.1 hypothetical protein H671_2g5618 [Cricetulus griseus] | diamond | 198 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 29361573 | 29361573 | PRJNA917598_P_NODE_95989_length_241_cov_0.916667_g95045_i0 | PRJNA917598 | 95989 | 241 | 0.916667 | 2.20916747 | Myxine glutinosa | 7769 | Chordata | Chordata | 43.5 | 0.0192 | NR | XP_067982332.1 | 7769 | g95045 | i0 | 46.5 | 1.58091286307054 | 43 | 23 | 53.5 | 0 | 219 | 91 | 95 | 137 | XP_067982332.1 putative protein MSS51 homolog, mitochondrial [Myxine glutinosa] | diamond | 381 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 29968744 | 29968744 | PRJNA917598_P_NODE_89311_length_245_cov_0.895349_g88367_i0 | PRJNA917598 | 89311 | 245 | 0.895349 | 2.19360505 | Opisthokonta | 33154 | Chordata | Chordata | 84.3 | 7.55e-17 | NR | XP_031754060.1 | 8364 | g88367 | i0 | 44.4 | 18.6244897959184 | 81 | 42 | 95.5 | 1 | 244 | 11 | 262 | 342 | XP_031754060.1 protein kinase C delta type-like [Xenopus tropicalis] | diamond | 4563 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30814508 | 30814508 | PRJNA917598_P_NODE_85914_length_247_cov_0.885057_g84970_i0 | PRJNA917598 | 85914 | 247 | 0.885057 | 2.18609079 | Petromyzon marinus | 7757 | Chordata | Chordata | 84 | 8.93e-17 | NR | XP_032818483.1 | 7757 | g84970 | i0 | 45.9 | 2.7085020242915 | 74 | 38 | 89.9 | 1 | 223 | 2 | 104 | 175 | XP_032818483.1 phytanoyl-CoA dioxygenase, peroxisomal-like [Petromyzon marinus] | diamond | 669 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 31004144 | 31004144 | PRJNA917598_P_NODE_26694_length_446_cov_4.691689_g25750_i0 | PRJNA917598 | 26694 | 446 | 4.691689 | 20.92493294 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 134 | 6.889999999999998e-35 | NR | XP_051791274.1 | 27687 | g25750 | i0 | 77.8 | 5.50224215246637 | 90 | 19 | 59.9 | 1 | 405 | 139 | 115 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2454 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 31390883 | 31390883 | PRJNA917598_P_NODE_93996_length_242_cov_0.911243_g93052_i0 | PRJNA917598 | 93996 | 242 | 0.911243 | 2.20520806 | Chondrichthyes | 7777 | Chordata | Chordata | 56.6 | 4.77e-7 | NR | XP_043529898.1 | 36176 | g93052 | i0 | 48.1 | 8.05785123966942 | 81 | 37 | 96.7 | 3 | 242 | 9 | 176 | 254 | XP_043529898.1 probable E3 ubiquitin-protein ligase HERC3 [Chiloscyllium plagiosum] | diamond | 1950 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium plagiosum | |
| 31770255 | 31770255 | PRJNA917598_P_NODE_81517_length_250_cov_0.870056_g80573_i0 | PRJNA917598 | 81517 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 2.75e-4 | NR | CAH1242630.1 | 7740 | g80573 | i0 | 37.5 | 4.476 | 72 | 43 | 85.2 | 2 | 227 | 15 | 2315 | 2385 | CAH1242630.1 Hypp6913 [Branchiostoma lanceolatum] | diamond | 1119 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 31794373 | 31794373 | PRJNA917598_P_NODE_23437_length_478_cov_5.748148_g22495_i0 | PRJNA917598 | 23437 | 478 | 5.748148 | 27.47614744 | Rattus norvegicus | 10116 | Chordata | Chordata | 50.1 | 0.00118 | NR | AAS66221.1 | 10116 | g22495 | i0 | 30.2 | 0.872384937238494 | 139 | 73 | 81 | 8 | 422 | 36 | 1070 | 1194 | AAS66221.1 LRRG00130 [Rattus norvegicus] | diamond | 417 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 31864974 | 31864974 | PRJNA917598_P_NODE_85317_length_248_cov_0.880000_g84373_i0 | PRJNA917598 | 85317 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 72.8 | 1.06e-12 | NR | XP_041047780.1 | 13397 | g84373 | i0 | 43.9 | 2.96370967741935 | 82 | 43 | 99.2 | 2 | 3 | 248 | 1494 | 1572 | XP_041047780.1 A disintegrin and metalloproteinase with thrombospondin motifs 9-like isoform X1 [Carcharodon carcharias] | diamond | 735 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Lamniformes | Alopiidae | Carcharodon | Carcharodon carcharias | |
| 32047796 | 32047796 | PRJNA917598_P_NODE_66878_length_278_cov_1.443902_g65934_i0 | PRJNA917598 | 66878 | 278 | 1.443902 | 4.01404756 | Engystomops pustulosus | 76066 | Chordata | Chordata | 44.7 | 0.00172 | NR | KAG8543241.1 | 76066 | g65934 | i0 | 53.3 | 1.40287769784173 | 45 | 17 | 44.2 | 1 | 242 | 120 | 28 | 72 | KAG8543241.1 hypothetical protein GDO81_025125 [Engystomops pustulosus] | diamond | 390 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32498220 | 32498220 | PRJNA917598_P_NODE_94739_length_242_cov_0.893491_g93795_i0 | PRJNA917598 | 94739 | 242 | 0.893491 | 2.16224822 | Metazoa | 33208 | Chordata | Chordata | 107 | 6.23e-25 | NR | DBA16989.1 | 30357 | g93795 | i0 | 61.3 | 9.91735537190083 | 80 | 23 | 99.2 | 1 | 1 | 240 | 174 | 245 | DBA16989.1 TPA: hypothetical protein GDO54_002509 [Pyxicephalus adspersus] | diamond | 2400 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pyxicephalidae | Pyxicephalus | Pyxicephalus adspersus |
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);;