contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23695401 | 23695401 | PRJNA760976_P_NODE_9759_length_454_cov_0.994751_g9440_i0 | PRJNA760976 | 9759 | 454 | 0.994751 | 4.51616954 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 146 | 1.49e-38 | NR | XP_019618263.1 | 7741 | g9440 | i0 | 53.1 | 2.65638766519824 | 128 | 56 | 84.6 | 1 | 69 | 452 | 318 | 441 | XP_019618263.1 PREDICTED: protein disulfide-isomerase A3-like [Branchiostoma belcheri] | diamond | 1206 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 26895130 | 26895130 | PRJNA760976_P_NODE_36021_length_283_cov_0.990476_g35700_i0 | PRJNA760976 | 36021 | 283 | 0.990476 | 2.80304708 | Microtus ochrogaster | 79684 | Chordata | Chordata | 81.6 | 1.31e-15 | NR | KAH0516971.1 | 79684 | g35700 | i0 | 46.5 | 1.04946996466431 | 99 | 46 | 99.6 | 3 | 1 | 282 | 927 | 1023 | KAH0516971.1 Protein inturned [Microtus ochrogaster] | diamond | 297 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Microtus | Microtus ochrogaster | |
| 27053219 | 27053219 | PRJNA760976_P_NODE_33762_length_290_cov_0.981567_g33441_i0 | PRJNA760976 | 33762 | 290 | 0.981567 | 2.8465443 | Bufo bufo | 8384 | Chordata | Chordata | 61.2 | 7.65e-10 | NR | XP_040261850.1 | 8384 | g33441 | i0 | 32.1 | 0.837931034482759 | 81 | 55 | 83.8 | 0 | 46 | 288 | 1 | 81 | XP_040261850.1 selenoprotein W [Bufo bufo] | diamond | 243 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 27157271 | 27157271 | PRJNA760976_P_NODE_17302_length_367_cov_1.030612_g16981_i0 | PRJNA760976 | 17302 | 367 | 1.030612 | 3.78234604 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 6.73e-39 | NR | XP_067960906.1 | 7769 | g16981 | i0 | 58.2 | 24.6948228882834 | 122 | 50 | 99.7 | 1 | 367 | 2 | 14 | 134 | XP_067960906.1 small ribosomal subunit protein eS8 [Myxine glutinosa] | diamond | 9063 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28136811 | 28136811 | PRJNA760976_P_NODE_49865_length_248_cov_0.862857_g49544_i0 | PRJNA760976 | 49865 | 248 | 0.862857 | 2.13988536 | Passeriformes | 9126 | Chordata | Chordata | 65.5 | 2.77e-10 | NR | NXE92262.1 | 47692 | g49544 | i0 | 53.7 | 16.5 | 54 | 25 | 65.3 | 0 | 246 | 85 | 25 | 78 | NXE92262.1 RDHE2 dehydrogenase [Menura novaehollandiae] | diamond | 4092 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Menuridae | Menura | Menura novaehollandiae | |
| 29705273 | 29705273 | PRJNA760976_P_NODE_54010_length_243_cov_0.905882_g53689_i0 | PRJNA760976 | 54010 | 243 | 0.905882 | 2.20129326 | Crypturellus soui | 458187 | Chordata | Chordata | 55.8 | 4.84e-7 | NR | NWI21827.1 | 458187 | g53689 | i0 | 41.9 | 0.91358024691358 | 74 | 42 | 91.4 | 1 | 3 | 224 | 144 | 216 | NWI21827.1 NARE ribosyltransferase [Crypturellus soui] | diamond | 222 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Tinamiformes | Tinamidae | Crypturellus | Crypturellus soui | |
| 29778437 | 29778437 | PRJNA760976_P_NODE_52651_length_244_cov_1.350877_g52330_i0 | PRJNA760976 | 52651 | 244 | 1.350877 | 3.29613988 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.9 | 1.41e-15 | NR | KAG6926061.1 | 8475 | g52330 | i0 | 52.9 | 26.7172131147541 | 68 | 32 | 83.6 | 0 | 238 | 35 | 470 | 537 | KAG6926061.1 amine oxidase, copper containing 1 [Chelydra serpentina] | diamond | 6519 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Chelydridae | Chelydra | Chelydra serpentina | ||
| 29904993 | 29904993 | PRJNA760976_P_NODE_31371_length_297_cov_1.986607_g31050_i0 | PRJNA760976 | 31371 | 297 | 1.986607 | 5.90022279 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.44e-30 | NR | XP_035699884.1 | 7739 | g31050 | i0 | 70.7 | 9.94949494949495 | 82 | 24 | 82.8 | 0 | 52 | 297 | 2 | 83 | XP_035699884.1 40S ribosomal protein S12 [Branchiostoma floridae] | diamond | 2955 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30369562 | 30369562 | PRJNA760976_P_NODE_52912_length_244_cov_0.894737_g52591_i0 | PRJNA760976 | 52912 | 244 | 0.894737 | 2.18315828 | Apodemus speciosus | 105296 | Chordata | Chordata | 53.9 | 1.47e-7 | NR | GAB1303385.1 | 105296 | g52591 | i0 | 60.5 | 0.959016393442623 | 38 | 15 | 46.7 | 0 | 228 | 115 | 19 | 56 | GAB1303385.1 hypothetical protein APTSU1_001863100 [Apodemus speciosus] | diamond | 234 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 30495603 | 30495603 | PRJNA760976_P_NODE_43053_length_263_cov_1.584211_g42732_i0 | PRJNA760976 | 43053 | 263 | 1.584211 | 4.16647493 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 45.4 | 0.00521 | NR | CAH1244312.1 | 7740 | g42732 | i0 | 47.6 | 3.18250950570342 | 42 | 22 | 47.9 | 0 | 109 | 234 | 245 | 286 | CAH1244312.1 DAW1 [Branchiostoma lanceolatum] | diamond | 837 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 30590164 | 30590164 | PRJNA760976_P_NODE_15433_length_382_cov_1.339806_g15112_i0 | PRJNA760976 | 15433 | 382 | 1.339806 | 5.11805892 | Pelodiscus sinensis | 13735 | Chordata | Chordata | 44.3 | 0.0461 | NR | XP_014434391.2 | 13735 | g15112 | i0 | 35.8 | 1.24869109947644 | 53 | 34 | 41.6 | 0 | 74 | 232 | 180 | 232 | XP_014434391.2 uncharacterized protein C11orf16 homolog isoform X4 [Pelodiscus sinensis] | diamond | 477 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Trionychidae | Pelodiscus | Pelodiscus sinensis | ||
| 30631366 | 30631366 | PRJNA760976_P_NODE_51613_length_245_cov_1.750000_g51292_i0 | PRJNA760976 | 51613 | 245 | 1.75 | 4.2875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 98.6 | 4.06e-22 | NR | XP_067964356.1 | 7769 | g51292 | i0 | 65.8 | 10.8367346938776 | 73 | 25 | 89.4 | 0 | 24 | 242 | 82 | 154 | XP_067964356.1 ornithine decarboxylase-like isoform X2 [Myxine glutinosa] | diamond | 2655 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 30631367 | 30631367 | PRJNA760976_P_NODE_54793_length_242_cov_1.721893_g54472_i0 | PRJNA760976 | 54793 | 242 | 1.721893 | 4.16698106 | Metazoa | 33208 | Chordata | Chordata | 53.5 | 5.89e-6 | NR | XP_058686275.1 | 48891 | g54472 | i0 | 37.7 | 11.3181818181818 | 77 | 45 | 91.7 | 1 | 224 | 3 | 387 | 463 | XP_058686275.1 macrophage mannose receptor 1-like [Poecile atricapillus] | diamond | 2739 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Paridae | Poecile | Poecile atricapillus | |
| 30716515 | 30716515 | PRJNA760976_P_NODE_44914_length_258_cov_2.324324_g44593_i0 | PRJNA760976 | 44914 | 258 | 2.324324 | 5.99675592 | Bombina bombina | 8345 | Chordata | Chordata | 50.4 | 8.38e-5 | NR | XP_053561527.1 | 8345 | g44593 | i0 | 36.1 | 0.965116279069767 | 83 | 44 | 96.5 | 2 | 5 | 253 | 354 | 427 | XP_053561527.1 rac GTPase-activating protein 1 [Bombina bombina] | diamond | 249 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 31032876 | 31032876 | PRJNA760976_P_NODE_54375_length_243_cov_0.870588_g54054_i0 | PRJNA760976 | 54375 | 243 | 0.870588 | 2.11552884 | Tachyglossus aculeatus | 9261 | Chordata | Chordata | 73.6 | 5.21e-13 | NR | XP_038627859.1 | 9261 | g54054 | i0 | 50 | 1.97530864197531 | 80 | 35 | 98.8 | 1 | 242 | 3 | 664 | 738 | XP_038627859.1 xanthine dehydrogenase/oxidase-like [Tachyglossus aculeatus] | diamond | 480 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Tachyglossidae | Tachyglossus | Tachyglossus aculeatus | |
| 31064412 | 31064412 | PRJNA760976_P_NODE_26395_length_316_cov_3.057613_g26074_i0 | PRJNA760976 | 26395 | 316 | 3.057613 | 9.66205708 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 97.1 | 7.8e-21 | NR | CAK8689709.1 | 159417 | g26074 | i0 | 59.6 | 0.987341772151899 | 104 | 42 | 98.7 | 0 | 315 | 4 | 664 | 767 | CAK8689709.1 unnamed protein product [Clavelina lepadiformis] | diamond | 312 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31064413 | 31064413 | PRJNA760976_P_NODE_31395_length_297_cov_1.883929_g31074_i0 | PRJNA760976 | 31395 | 297 | 1.883929 | 5.59526913 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 120 | 3.1199999999999997e-31 | NR | CAH1233360.1 | 7740 | g31074 | i0 | 62.8 | 4.31313131313131 | 86 | 32 | 86.9 | 0 | 37 | 294 | 154 | 239 | CAH1233360.1 HSD17B8 [Branchiostoma lanceolatum] | diamond | 1281 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 31105332 | 31105332 | PRJNA760976_P_NODE_41775_length_266_cov_2.844560_g41454_i0 | PRJNA760976 | 41775 | 266 | 2.84456 | 7.5665296 | Squamata | 8509 | Chordata | Chordata | 43.9 | 0.02 | NR | XP_015274526.1 | 146911 | g41454 | i0 | 35 | 2.90977443609023 | 60 | 36 | 67.7 | 2 | 192 | 13 | 1434 | 1490 | XP_015274526.1 PREDICTED: LOW QUALITY PROTEIN: multiple epidermal growth factor-like domains protein 8, partial [Gekko japonicus] | diamond | 774 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 31199828 | 31199828 | PRJNA760976_P_NODE_30175_length_302_cov_0.986900_g29854_i0 | PRJNA760976 | 30175 | 302 | 0.9869 | 2.980438 | Metazoa | 33208 | Chordata | Chordata | 109 | 1.67e-28 | NR | AAN52380.1 | 7741 | g29854 | i0 | 70.2 | 15.6059602649007 | 84 | 25 | 83.4 | 0 | 45 | 296 | 1 | 84 | AAN52380.1 ribosomal protein L35 [Branchiostoma belcheri] | diamond | 4713 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31421636 | 31421636 | PRJNA760976_P_NODE_53276_length_244_cov_0.865497_g52955_i0 | PRJNA760976 | 53276 | 244 | 0.865497 | 2.11181268 | Chordata | 7711 | Chordata | Chordata | 62.4 | 4.53e-9 | NR | KAK4815109.1 | 33587 | g52955 | i0 | 41.7 | 27.1598360655738 | 72 | 31 | 79.9 | 2 | 195 | 1 | 292 | 359 | KAK4815109.1 hypothetical protein QYF61_015592 [Mycteria americana] | diamond | 6627 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 31927712 | 31927712 | PRJNA760976_P_NODE_34857_length_286_cov_1.483568_g34536_i0 | PRJNA760976 | 34857 | 286 | 1.483568 | 4.24300448 | root | 1 | Root_unresolved | Root_unresolved | 147 | 1.1e-42 | NR | EFB25891.1 | 9646 | g34536 | i0 | 85.2 | 92.013986013986 | 88 | 13 | 92.3 | 0 | 265 | 2 | 30 | 117 | EFB25891.1 hypothetical protein PANDA_004337, partial [Ailuropoda melanoleuca] | diamond | 26316 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 32212596 | 32212596 | PRJNA760976_P_NODE_56918_length_241_cov_0.869048_g56597_i0 | PRJNA760976 | 56918 | 241 | 0.869048 | 2.09440568 | Opisthokonta | 33154 | Chordata | Chordata | 57.8 | 1.83e-7 | NR | XP_056422133.1 | 327740 | g56597 | i0 | 43.9 | 7.20746887966805 | 66 | 36 | 80.9 | 1 | 5 | 199 | 399 | 464 | XP_056422133.1 F-box/LRR-repeat protein 4 isoform X2 [Hyla sarda] | diamond | 1737 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Hyla | Hyla sarda | |
| 32875425 | 32875425 | PRJNA760976_P_NODE_55300_length_242_cov_0.887574_g54979_i0 | PRJNA760976 | 55300 | 242 | 0.887574 | 2.14792908 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 7.859999999999998e-32 | NR | CBY12761.1 | 34765 | g54979 | i0 | 69.2 | 25.7107438016529 | 78 | 24 | 96.7 | 0 | 235 | 2 | 79 | 156 | CBY12761.1 unnamed protein product [Oikopleura dioica] | diamond | 6222 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica |
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);;