contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB25789" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3849239 | 3849239 | PRJEB25789_S_NODE_10544_length_299_cov_1.955752_g10465_i0 | PRJEB25789 | 10544 | 299 | 1.955752 | 5.84769848 | Mycteria americana | 33587 | Chordata | Chordata | 136 | 3.5299999999999996e-35 | NR | KAK4805410.1 | 33587 | g10465 | i0 | 64.9 | 0.973244147157191 | 97 | 34 | 97.3 | 0 | 292 | 2 | 137 | 233 | KAK4805410.1 hypothetical protein QYF61_000003 [Mycteria americana] | diamond | 291 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 8639588 | 8639588 | PRJEB25789_S_NODE_11607_length_289_cov_1.069444_g11528_i0 | PRJEB25789 | 11607 | 289 | 1.069444 | 3.09069316 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 99 | 1.03e-21 | NR | CAK8696199.1 | 159417 | g11528 | i0 | 50.5 | 1.88927335640138 | 91 | 45 | 94.5 | 0 | 280 | 8 | 260 | 350 | CAK8696199.1 unnamed protein product [Clavelina lepadiformis] | diamond | 546 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 26621599 | 26621599 | PRJEB25789_S_NODE_5541_length_383_cov_1.522581_g5462_i0 | PRJEB25789 | 5541 | 383 | 1.522581 | 5.83148523 | Pteronotus mesoamericanus | 1884717 | Chordata | Chordata | 44.3 | 0.0488 | NR | XP_054441532.1 | 1884717 | g5462 | i0 | 30.8 | 0.814621409921671 | 104 | 68 | 80.7 | 2 | 335 | 27 | 96 | 196 | XP_054441532.1 sp110 nuclear body protein [Pteronotus mesoamericanus] | diamond | 312 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Mormoopidae | Pteronotus | Pteronotus mesoamericanus | |
| 26875271 | 26875271 | PRJEB25789_S_NODE_12621_length_280_cov_1.024155_g12542_i0 | PRJEB25789 | 12621 | 280 | 1.024155 | 2.867634 | Grus americana | 9117 | Chordata | Chordata | 45.1 | 0.00833 | NR | XP_054663541.1 | 9117 | g12542 | i0 | 48.9 | 1.00714285714286 | 47 | 20 | 46.1 | 1 | 277 | 149 | 220 | 266 | XP_054663541.1 class I histocompatibility antigen, F10 alpha chain-like isoform X4 [Grus americana] | diamond | 282 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus americana | |
| 26963256 | 26963256 | PRJEB25789_S_NODE_7102_length_347_cov_1.105839_g7023_i0 | PRJEB25789 | 7102 | 347 | 1.105839 | 3.83726133 | Metazoa | 33208 | Chordata | Chordata | 107 | 3.75e-26 | NR | CAB3265696.1 | 59560 | g7023 | i0 | 55.6 | 1.91066282420749 | 108 | 46 | 93.4 | 1 | 345 | 22 | 92 | 197 | CAB3265696.1 60S ribosomal protein L13-like [Phallusia mammillata] | diamond | 663 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 27349497 | 27349497 | PRJEB25789_S_NODE_20163_length_241_cov_0.863095_g20084_i0 | PRJEB25789 | 20163 | 241 | 0.863095 | 2.08005895 | Lonchura striata | 40157 | Chordata | Chordata | 43.9 | 0.00645 | NR | OWK64301.1 | 40157 | g20084 | i0 | 94.4 | 0.224066390041494 | 18 | 1 | 22.4 | 0 | 54 | 1 | 1 | 18 | OWK64301.1 hypothetical protein RLOC_00013581 [Lonchura striata] | diamond | 54 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Lonchura | Lonchura striata | |
| 27658771 | 27658771 | PRJEB25789_S_NODE_14364_length_266_cov_1.145078_g14285_i0 | PRJEB25789 | 14364 | 266 | 1.145078 | 3.04590748 | Aves | 8782 | Chordata | Chordata | 55.5 | 1.25e-7 | NR | XP_009283026.1 | 9233 | g14285 | i0 | 78.6 | 3.41729323308271 | 42 | 9 | 47.4 | 0 | 3 | 128 | 50 | 91 | XP_009283026.1 PREDICTED: interferon alpha-inducible protein 27-like protein 2A [Aptenodytes forsteri] | diamond | 909 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Aptenodytes | Aptenodytes forsteri | |
| 27690528 | 27690528 | PRJEB25789_S_NODE_3064_length_493_cov_2.235714_g2985_i0 | PRJEB25789 | 3064 | 493 | 2.235714 | 11.02207002 | Aves | 8782 | Chordata | Chordata | 208 | 2.62e-63 | NR | CAC43066.1 | 8839 | g2985 | i0 | 61.6 | 7.92292089249493 | 164 | 61 | 99.8 | 1 | 2 | 493 | 196 | 357 | CAC43066.1 immunoglobulin alpha heavy chain, partial [Anas platyrhynchos] | diamond | 3906 | 209 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas platyrhynchos | |
| 28043915 | 28043915 | PRJEB25789_S_NODE_11885_length_286_cov_1.366197_g11806_i0 | PRJEB25789 | 11885 | 286 | 1.366197 | 3.90732342 | Hirundo rustica rustica | 333673 | Chordata | Chordata | 82 | 9.8e-16 | NR | RMC01090.1 | 333673 | g11806 | i0 | 64.6 | 0.681818181818182 | 65 | 23 | 68.2 | 0 | 1 | 195 | 529 | 593 | RMC01090.1 hypothetical protein DUI87_22356 [Hirundo rustica rustica] | diamond | 195 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Hirundinidae | Hirundo | Hirundo rustica | |
| 28801514 | 28801514 | PRJEB25789_S_NODE_17688_length_248_cov_0.880000_g17609_i0 | PRJEB25789 | 17688 | 248 | 0.88 | 2.1824 | Willisornis vidua | 1566151 | Chordata | Chordata | 59.3 | 5.74e-8 | NR | KAJ7418145.1 | 1566151 | g17609 | i0 | 42.9 | 8.55241935483871 | 63 | 36 | 76.2 | 0 | 200 | 12 | 41 | 103 | KAJ7418145.1 Raftlin-2 [Willisornis vidua] | diamond | 2121 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Thamnophilidae | Willisornis | Willisornis vidua | |
| 29432865 | 29432865 | PRJEB25789_S_NODE_18590_length_245_cov_0.895349_g18511_i0 | PRJEB25789 | 18590 | 245 | 0.895349 | 2.19360505 | Grus japonensis | 30415 | Chordata | Chordata | 94 | 3.11e-20 | NR | GAB0202245.1 | 30415 | g18511 | i0 | 56 | 1.02857142857143 | 84 | 34 | 99.2 | 2 | 244 | 2 | 141 | 224 | GAB0202245.1 immunoglobulin lambda-like polypeptide 1 [Grus japonensis] | diamond | 252 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 29584316 | 29584316 | PRJEB25789_S_NODE_11990_length_285_cov_1.283019_g11911_i0 | PRJEB25789 | 11990 | 285 | 1.283019 | 3.65660415 | Aves | 8782 | Chordata | Chordata | 128 | 2.53e-32 | NR | KAK4805410.1 | 33587 | g11911 | i0 | 65.1 | 1.81052631578947 | 86 | 30 | 90.5 | 0 | 284 | 27 | 506 | 591 | KAK4805410.1 hypothetical protein QYF61_000003 [Mycteria americana] | diamond | 516 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 29685449 | 29685449 | PRJEB25789_S_NODE_9010_length_317_cov_1.631148_g8931_i0 | PRJEB25789 | 9010 | 317 | 1.631148 | 5.17073916 | Haliaeetus albicilla | 8969 | Chordata | Chordata | 58.5 | 5.82e-8 | NR | XP_069630785.1 | 8969 | g8931 | i0 | 67.3 | 0.984227129337539 | 104 | 34 | 98.4 | 0 | 315 | 4 | 61 | 164 | XP_069630785.1 apolipoprotein E-like [Haliaeetus albicilla] | diamond | 312 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Accipitridae | Haliaeetus | Haliaeetus albicilla | |
| 30001737 | 30001737 | PRJEB25789_S_NODE_5211_length_393_cov_3.237500_g5132_i0 | PRJEB25789 | 5211 | 393 | 3.2375 | 12.723375 | Mycteria americana | 33587 | Chordata | Chordata | 186 | 2.72e-53 | NR | KAK4805410.1 | 33587 | g5132 | i0 | 68.9 | 0.931297709923664 | 122 | 38 | 93.1 | 0 | 388 | 23 | 470 | 591 | KAK4805410.1 hypothetical protein QYF61_000003 [Mycteria americana] | diamond | 366 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 30444068 | 30444068 | PRJEB25789_S_NODE_10653_length_298_cov_1.671111_g10574_i0 | PRJEB25789 | 10653 | 298 | 1.671111 | 4.97991078 | Nestor notabilis | 176057 | Chordata | Chordata | 144 | 1.1e-39 | NR | KFQ46330.1 | 176057 | g10574 | i0 | 66 | 0.976510067114094 | 97 | 33 | 97.7 | 0 | 296 | 6 | 154 | 250 | KFQ46330.1 Ig alpha-1 chain C region, partial [Nestor notabilis] | diamond | 291 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittacidae | Nestor | Nestor notabilis | |
| 30823064 | 30823064 | PRJEB25789_S_NODE_20354_length_235_cov_2.845679_g20275_i0 | PRJEB25789 | 20354 | 235 | 2.845679 | 6.68734565 | Lonchura striata | 40157 | Chordata | Chordata | 46.2 | 8.44e-4 | NR | OWK60384.1 | 40157 | g20275 | i0 | 91.7 | 0.306382978723404 | 24 | 2 | 30.6 | 0 | 234 | 163 | 126 | 149 | OWK60384.1 hypothetical protein RLOC_00001944 [Lonchura striata] | diamond | 72 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Lonchura | Lonchura striata | |
| 31613393 | 31613393 | PRJEB25789_S_NODE_19096_length_244_cov_0.859649_g19017_i0 | PRJEB25789 | 19096 | 244 | 0.859649 | 2.09754356 | Phaenicophaeus curvirostris | 33595 | Chordata | Chordata | 161 | 4.04e-44 | NR | XP_069724114.1 | 33595 | g19017 | i0 | 91.4 | 0.995901639344262 | 81 | 7 | 99.6 | 0 | 2 | 244 | 362 | 442 | XP_069724114.1 protein NYNRIN-like [Phaenicophaeus curvirostris] | diamond | 243 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Cuculiformes | Cuculidae | Phaenicophaeus | Phaenicophaeus curvirostris | |
| 31708267 | 31708267 | PRJEB25789_S_NODE_8877_length_319_cov_0.955285_g8798_i0 | PRJEB25789 | 8877 | 319 | 0.955285 | 3.04735915 | Grus japonensis | 30415 | Chordata | Chordata | 43.5 | 0.0499 | NR | GAB0200635.1 | 30415 | g8798 | i0 | 44.7 | 0.442006269592476 | 47 | 26 | 44.2 | 0 | 284 | 144 | 612 | 658 | GAB0200635.1 mucin-16 [Grus japonensis] | diamond | 141 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 32303272 | 32303272 | PRJEB25789_S_NODE_8219_length_328_cov_1.800000_g8140_i0 | PRJEB25789 | 8219 | 328 | 1.8 | 5.904 | root | 1 | Root_unresolved | Root_unresolved | 163 | 8.819999999999998e-48 | NR | ETE62347.1 | 8665 | g8140 | i0 | 74.3 | 34.8109756097561 | 109 | 28 | 99.7 | 0 | 1 | 327 | 144 | 252 | ETE62347.1 NADH dehydrogenase [ubiquinone] iron-sulfur protein 2, mitochondrial [Ophiophagus hannah] | diamond | 11418 | 164 | 0.99390243902439 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Ophiophagus | Ophiophagus hannah | |
| 32309721 | 32309721 | PRJEB25789_S_NODE_11279_length_292_cov_1.054795_g11200_i0 | PRJEB25789 | 11279 | 292 | 1.054795 | 3.0800014 | Hypanus sabinus | 79690 | Chordata | Chordata | 66.2 | 3.62e-10 | NR | XP_059816063.1 | 79690 | g11200 | i0 | 37.4 | 1.86986301369863 | 91 | 52 | 88.4 | 1 | 292 | 35 | 114 | 204 | XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus] | diamond | 546 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 32372876 | 32372876 | PRJEB25789_S_NODE_6339_length_363_cov_2.041379_g6260_i0 | PRJEB25789 | 6339 | 363 | 2.041379 | 7.41020577 | Struthio camelus | 8801 | Chordata | Chordata | 155 | 6.5499999999999986e-43 | NR | AFA41928.1 | 8801 | g6260 | i0 | 60.4 | 2.66115702479339 | 106 | 42 | 87.6 | 0 | 13 | 330 | 327 | 432 | AFA41928.1 immunoglobulin A heavy chain constant region secretory form, partial [Struthio camelus] | diamond | 966 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Struthioniformes | Struthionidae | Struthio | Struthio camelus | |
| 32492964 | 32492964 | PRJEB25789_S_NODE_15199_length_260_cov_0.994652_g15120_i0 | PRJEB25789 | 15199 | 260 | 0.994652 | 2.5860952 | Pelecaniformes | 9205 | Chordata | Chordata | 114 | 3.5399999999999992e-31 | NR | QCI31823.1 | 128390 | g15120 | i0 | 63.1 | 6.87692307692308 | 84 | 31 | 96.9 | 0 | 254 | 3 | 2 | 85 | QCI31823.1 MHC class I antigen, partial [Nipponia nippon] | diamond | 1788 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Pelecaniformes | Threskiornithidae | Nipponia | Nipponia nippon |
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);;