contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26945881 | 26945881 | PRJNA1199330_P_NODE_39342_length_329_cov_3.636719_g38643_i0 | PRJNA1199330 | 39342 | 329 | 3.636719 | 11.96480551 | Engystomops pustulosus | 76066 | Chordata | Chordata | 46.2 | 6.75e-4 | NR | KAG8536220.1 | 76066 | g38643 | i0 | 70.4 | 0.729483282674772 | 27 | 8 | 24.6 | 0 | 249 | 329 | 43 | 69 | KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] | diamond | 240 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 27103983 | 27103983 | PRJNA1199330_P_NODE_101142_length_252_cov_2.413408_g100443_i0 | PRJNA1199330 | 101142 | 252 | 2.413408 | 6.08178816 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.9 | 0.0153 | NR | KAG2457475.1 | 55291 | g100443 | i0 | 78.3 | 1.0952380952381 | 23 | 5 | 27.4 | 0 | 88 | 20 | 17 | 39 | KAG2457475.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 276 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27103991 | 27103991 | PRJNA1199330_P_NODE_20442_length_453_cov_1.589474_g19748_i0 | PRJNA1199330 | 20442 | 453 | 1.589474 | 7.20031722 | Scyliorhinus torazame | 75743 | Chordata | Chordata | 194 | 3.230000000000001e-59 | NR | GCB75411.1 | 75743 | g19748 | i0 | 58.4 | 31.5695364238411 | 149 | 62 | 98.7 | 0 | 448 | 2 | 86 | 234 | GCB75411.1 hypothetical protein [Scyliorhinus torazame] | diamond | 14301 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus torazame | |
| 27420490 | 27420490 | PRJNA1199330_P_NODE_70523_length_281_cov_2.096154_g69824_i0 | PRJNA1199330 | 70523 | 281 | 2.096154 | 5.89019274 | Zosterops borbonicus | 364589 | Chordata | Chordata | 76.6 | 2.53e-14 | NR | TRZ07114.1 | 364589 | g69824 | i0 | 73.9 | 0.491103202846975 | 46 | 11 | 48 | 1 | 137 | 3 | 214 | 259 | TRZ07114.1 hypothetical protein HGM15179_019993 [Zosterops borbonicus] | diamond | 138 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Zosteropidae | Zosterops | Zosterops borbonicus | |
| 28209366 | 28209366 | PRJNA1199330_P_NODE_108866_length_247_cov_1.758621_g108167_i0 | PRJNA1199330 | 108866 | 247 | 1.758621 | 4.34379387 | Styela clava | 7725 | Chordata | Chordata | 50.4 | 6.15e-5 | NR | XP_039254237.1 | 7725 | g108167 | i0 | 35.6 | 1.7246963562753 | 73 | 44 | 86.2 | 2 | 217 | 5 | 28 | 99 | XP_039254237.1 transmembrane protein 147-like [Styela clava] | diamond | 426 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 28354685 | 28354685 | PRJNA1199330_P_NODE_82746_length_270_cov_1.583756_g82047_i0 | PRJNA1199330 | 82746 | 270 | 1.583756 | 4.2761412 | Chordata | 7711 | Chordata | Chordata | 117 | 6.59e-32 | NR | NP_001089777.1 | 8355 | g82047 | i0 | 98.3 | 25.8111111111111 | 58 | 1 | 64.4 | 0 | 1 | 174 | 51 | 108 | NP_001089777.1 uncharacterized protein LOC734842 [Xenopus laevis] | diamond | 6969 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 28620173 | 28620173 | PRJNA1199330_P_NODE_45487_length_312_cov_2.966527_g44788_i0 | PRJNA1199330 | 45487 | 312 | 2.966527 | 9.25556424 | Caretta caretta | 8467 | Chordata | Chordata | 64.3 | 1.77e-10 | NR | CAM4564118.1 | 8467 | g44788 | i0 | 54.4 | 1.66346153846154 | 57 | 26 | 54.8 | 0 | 129 | 299 | 55 | 111 | CAM4564118.1 unnamed protein product [Caretta caretta] | diamond | 519 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 28683321 | 28683321 | PRJNA1199330_P_NODE_35867_length_345_cov_4.077206_g35168_i0 | PRJNA1199330 | 35867 | 345 | 4.077206 | 14.0663607 | Bombina bombina | 8345 | Chordata | Chordata | 76.3 | 2.37e-14 | NR | XP_053576036.1 | 8345 | g35168 | i0 | 44.2 | 2.51304347826087 | 95 | 42 | 82.6 | 2 | 287 | 3 | 13 | 96 | XP_053576036.1 tRNA 2'-phosphotransferase 1 isoform X2 [Bombina bombina] | diamond | 867 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 28872530 | 28872530 | PRJNA1199330_P_NODE_87168_length_266_cov_1.455959_g86469_i0 | PRJNA1199330 | 87168 | 266 | 1.455959 | 3.87285094 | Balaenoptera acutorostrata | 9767 | Chordata | Chordata | 82 | 7.1e-16 | NR | XP_057400032.1 | 9767 | g86469 | i0 | 67.9 | 0.631578947368421 | 56 | 18 | 63.2 | 0 | 266 | 99 | 258 | 313 | XP_057400032.1 L-2-hydroxyglutarate dehydrogenase, mitochondrial isoform X1 [Balaenoptera acutorostrata] | diamond | 168 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera acutorostrata | |
| 29018118 | 29018118 | PRJNA1199330_P_NODE_29488_length_380_cov_2.944625_g28792_i0 | PRJNA1199330 | 29488 | 380 | 2.944625 | 11.189575 | Hexanchiformes | 30495 | Chordata | Chordata | 59.3 | 2.81e-7 | NR | XP_070726670.1 | 55135 | g28792 | i0 | 36 | 1.40526315789474 | 89 | 57 | 70.3 | 0 | 379 | 113 | 886 | 974 | XP_070726670.1 NACHT, LRR and PYD domains-containing protein 3-like isoform X2 [Pristiophorus japonicus] | diamond | 534 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Pristiophoridae | Pristiophorus | Pristiophorus japonicus | ||
| 29062187 | 29062187 | PRJNA1199330_P_NODE_32988_length_360_cov_2.174216_g32291_i0 | PRJNA1199330 | 32988 | 360 | 2.174216 | 7.8271776 | Engystomops pustulosus | 76066 | Chordata | Chordata | 45.8 | 0.0105 | NR | KAG8578345.1 | 76066 | g32291 | i0 | 29.2 | 0.8 | 96 | 59 | 77.5 | 3 | 360 | 82 | 263 | 352 | KAG8578345.1 hypothetical protein GDO81_010459 [Engystomops pustulosus] | diamond | 288 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 29175829 | 29175829 | PRJNA1199330_P_NODE_118849_length_236_cov_2.957055_g118150_i0 | PRJNA1199330 | 118849 | 236 | 2.957055 | 6.9786498 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 1.01e-9 | NR | XP_019631582.1 | 7741 | g118150 | i0 | 53.6 | 2.75847457627119 | 56 | 24 | 71.2 | 1 | 182 | 15 | 9 | 62 | XP_019631582.1 PREDICTED: zinc metalloproteinase nas-14-like [Branchiostoma belcheri] | diamond | 651 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29175834 | 29175834 | PRJNA1199330_P_NODE_72609_length_279_cov_2.446602_g71910_i0 | PRJNA1199330 | 72609 | 279 | 2.446602 | 6.82601958 | Metazoa | 33208 | Chordata | Chordata | 47 | 0.00115 | NR | ETE63361.1 | 8665 | g71910 | i0 | 37.7 | 2.76344086021505 | 53 | 33 | 57 | 0 | 276 | 118 | 33 | 85 | ETE63361.1 Kelch-like protein 20, partial [Ophiophagus hannah] | diamond | 771 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Ophiophagus | Ophiophagus hannah | |
| 29396671 | 29396671 | PRJNA1199330_P_NODE_70629_length_281_cov_1.923077_g69930_i0 | PRJNA1199330 | 70629 | 281 | 1.923077 | 5.40384637 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 6.64e-24 | NR | XP_001506524.2 | 9258 | g69930 | i0 | 63.7 | 14.199288256227801 | 91 | 30 | 94 | 2 | 14 | 277 | 113 | 203 | XP_001506524.2 calmodulin-1 [Ornithorhynchus anatinus] | diamond | 3990 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus | |
| 29977679 | 29977679 | PRJNA1199330_P_NODE_102411_length_251_cov_3.415730_g101712_i0 | PRJNA1199330 | 102411 | 251 | 3.41573 | 8.5734823 | Rhineura floridana | 261503 | Chordata | Chordata | 43.1 | 0.031 | NR | XP_061464887.1 | 261503 | g101712 | i0 | 45.7 | 0.418326693227092 | 35 | 19 | 41.8 | 0 | 122 | 18 | 1380 | 1414 | XP_061464887.1 thrombospondin type-1 domain-containing protein 7B [Rhineura floridana] | diamond | 105 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Rhineuridae | Rhineura | Rhineura floridana | |
| 29996833 | 29996833 | PRJNA1199330_P_NODE_9711_length_670_cov_4.403685_g9057_i0 | PRJNA1199330 | 9711 | 670 | 4.403685 | 29.5046895 | Chordata | 7711 | Chordata | Chordata | 52.8 | 4.34e-4 | NR | XP_010215796.1 | 94827 | g9057 | i0 | 29.9 | 1.93432835820896 | 67 | 44 | 30 | 2 | 209 | 9 | 412 | 475 | XP_010215796.1 PREDICTED: kelch-like protein 23 [Tinamus guttatus] | diamond | 1296 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Tinamiformes | Tinamidae | Tinamus | Tinamus guttatus | |
| 30198719 | 30198719 | PRJNA1199330_P_NODE_86912_length_266_cov_1.616580_g86213_i0 | PRJNA1199330 | 86912 | 266 | 1.61658 | 4.3001028 | Neotoma lepida | 56216 | Chordata | Chordata | 73.9 | 4.11e-13 | NR | OBS80384.1 | 56216 | g86213 | i0 | 56.1 | 46.8270676691729 | 57 | 25 | 64.3 | 0 | 264 | 94 | 295 | 351 | OBS80384.1 hypothetical protein A6R68_21410 [Neotoma lepida] | diamond | 12456 | 74.3 | 0.994616419919246 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Neotoma | Neotoma lepida | |
| 30660160 | 30660160 | PRJNA1199330_P_NODE_99133_length_254_cov_1.585635_g98434_i0 | PRJNA1199330 | 99133 | 254 | 1.585635 | 4.0275129 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 0.00259 | NR | XP_066439908.1 | 57060 | g98434 | i0 | 31 | 6.93307086614173 | 84 | 53 | 99.2 | 2 | 3 | 254 | 29 | 107 | XP_066439908.1 cadherin-16 [Eleutherodactylus coqui] | diamond | 1761 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 31526432 | 31526432 | PRJNA1199330_P_NODE_92956_length_260_cov_2.272727_g92257_i0 | PRJNA1199330 | 92956 | 260 | 2.272727 | 5.9090902 | Rattus norvegicus | 10116 | Chordata | Chordata | 57.8 | 2.28e-7 | NR | NP_001388787.1 | 10116 | g92257 | i0 | 38.8 | 3.92307692307692 | 85 | 38 | 98.1 | 2 | 256 | 2 | 141 | 211 | NP_001388787.1 similar to putative protein kinase [Rattus norvegicus] | diamond | 1020 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 32063940 | 32063940 | PRJNA1199330_P_NODE_100798_length_252_cov_4.273743_g100099_i0 | PRJNA1199330 | 100798 | 252 | 4.273743 | 10.76983236 | Amazona aestiva | 12930 | Chordata | Chordata | 43.9 | 0.0166 | NR | KQK80754.1 | 12930 | g100099 | i0 | 36.4 | 0.785714285714286 | 66 | 37 | 72.6 | 2 | 6 | 188 | 1377 | 1442 | KQK80754.1 von Willebrand factor D and EGF [Amazona aestiva] | diamond | 198 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittacidae | Amazona | Amazona aestiva | |
| 32317486 | 32317486 | PRJNA1199330_P_NODE_108119_length_248_cov_0.891429_g107420_i0 | PRJNA1199330 | 108119 | 248 | 0.891429 | 2.21074392 | Mus caroli | 10089 | Chordata | Chordata | 58.2 | 3.62e-8 | NR | XP_029331409.1 | 10089 | g107420 | i0 | 86.1 | 0.435483870967742 | 36 | 5 | 43.5 | 0 | 109 | 216 | 1 | 36 | XP_029331409.1 formin-like protein 20 [Mus caroli] | diamond | 108 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus caroli | |
| 32507273 | 32507273 | PRJNA1199330_P_NODE_108879_length_247_cov_1.729885_g108180_i0 | PRJNA1199330 | 108879 | 247 | 1.729885 | 4.27281595 | Staurois parvus | 386267 | Chordata | Chordata | 67.4 | 2.36e-12 | NR | CAI9618505.1 | 386267 | g108180 | i0 | 41.2 | 1.03238866396761 | 85 | 45 | 99.6 | 2 | 247 | 2 | 10 | 92 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 255 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32683443 | 32683443 | PRJNA1199330_P_NODE_114100_length_243_cov_2.582353_g113401_i0 | PRJNA1199330 | 114100 | 243 | 2.582353 | 6.27511779 | Aves | 8782 | Chordata | Chordata | 95.9 | 7.670000000000001e-21 | NR | XP_025967646.2 | 8790 | g113401 | i0 | 60.5 | 50.962962962963 | 81 | 25 | 98.8 | 2 | 4 | 243 | 67 | 141 | XP_025967646.2 F-actin-monooxygenase MICAL1 [Dromaius novaehollandiae] | diamond | 12384 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Casuariiformes | Dromaiidae | Dromaius | Dromaius novaehollandiae | |
| 32759200 | 32759200 | PRJNA1199330_P_NODE_112740_length_244_cov_2.602339_g112041_i0 | PRJNA1199330 | 112740 | 244 | 2.602339 | 6.34970716 | Engystomops pustulosus | 76066 | Chordata | Chordata | 58.5 | 5.97e-9 | NR | KAG8534610.1 | 76066 | g112041 | i0 | 39.4 | 2.59426229508197 | 71 | 41 | 84.8 | 1 | 36 | 242 | 29 | 99 | KAG8534610.1 hypothetical protein GDO81_019014, partial [Engystomops pustulosus] | diamond | 633 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus |
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);;