contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26639562 | 26639562 | PRJNA700095_P_NODE_29121_length_315_cov_1.479339_g27857_i0 | PRJNA700095 | 29121 | 315 | 1.479339 | 4.65991785 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 71.2 | 8.54e-12 | NR | XP_066300029.1 | 7740 | g27857 | i0 | 42.5 | 0.828571428571429 | 87 | 39 | 73.3 | 3 | 1 | 231 | 441 | 526 | XP_066300029.1 tyrosinase-like [Branchiostoma lanceolatum] | diamond | 261 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 26777620 | 26777620 | PRJNA700095_P_NODE_51361_length_251_cov_0.865169_g50097_i0 | PRJNA700095 | 51361 | 251 | 0.865169 | 2.17157419 | Chordata | 7711 | Chordata | Chordata | 152 | 6.4e-44 | NR | XP_064408421.1 | 7897 | g50097 | i0 | 97.6 | 752.95219123506 | 83 | 2 | 99.2 | 0 | 249 | 1 | 123 | 205 | XP_064408421.1 nascent polypeptide-associated complex subunit alpha isoform X5 [Latimeria chalumnae] | diamond | 188991 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 26797893 | 26797893 | PRJNA700095_P_NODE_20841_length_385_cov_2.477564_g19577_i0 | PRJNA700095 | 20841 | 385 | 2.477564 | 9.5386214 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 3.57e-6 | NR | CAI9557087.1 | 386267 | g19577 | i0 | 63.9 | 0.561038961038961 | 36 | 11 | 26.5 | 1 | 163 | 62 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27398940 | 27398940 | PRJNA700095_P_NODE_54763_length_248_cov_1.354286_g53499_i0 | PRJNA700095 | 54763 | 248 | 1.354286 | 3.35862928 | Rostratula benghalensis | 118793 | Chordata | Chordata | 43.1 | 0.0297 | NR | NXJ71424.1 | 118793 | g53499 | i0 | 35 | 0.725806451612903 | 60 | 37 | 72.6 | 1 | 16 | 195 | 726 | 783 | NXJ71424.1 Z804B protein [Rostratula benghalensis] | diamond | 180 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Rostratulidae | Rostratula | Rostratula benghalensis | |
| 27441828 | 27441828 | PRJNA700095_P_NODE_48803_length_256_cov_1.262295_g47539_i0 | PRJNA700095 | 48803 | 256 | 1.262295 | 3.2314752 | root | 1 | Root_unresolved | Root_unresolved | 104 | 5.48e-24 | NR | XP_042197619.1 | 7868 | g47539 | i0 | 55.3 | 27.41015625 | 85 | 36 | 99.6 | 1 | 256 | 2 | 264 | 346 | XP_042197619.1 copine-3 isoform X1 [Callorhinchus milii] | diamond | 7017 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 27462117 | 27462117 | PRJNA700095_P_NODE_21823_length_374_cov_1.780731_g20559_i0 | PRJNA700095 | 21823 | 374 | 1.780731 | 6.65993394 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0286 | NR | KAG2471189.1 | 55291 | g20559 | i0 | 57.1 | 0.280748663101604 | 35 | 15 | 28.1 | 0 | 174 | 278 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28072967 | 28072967 | PRJNA700095_P_NODE_40585_length_274_cov_1.885572_g39321_i0 | PRJNA700095 | 40585 | 274 | 1.885572 | 5.16646728 | Squamata | 8509 | Chordata | Chordata | 55.1 | 2.41e-6 | NR | ETE61160.1 | 8665 | g39321 | i0 | 39.4 | 22.7408759124088 | 99 | 43 | 98.5 | 4 | 5 | 274 | 191 | 281 | ETE61160.1 Pleckstrin-likey domain-containing family A member 1, partial [Ophiophagus hannah] | diamond | 6231 | 55.5 | 0.992792792792793 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Ophiophagus | Ophiophagus hannah | |
| 28125009 | 28125009 | PRJNA700095_P_NODE_10825_length_587_cov_7.813230_g9585_i0 | PRJNA700095 | 10825 | 587 | 7.81323 | 45.8636601 | Gekko japonicus | 146911 | Chordata | Chordata | 124 | 5.06e-29 | NR | XP_015284848.1 | 146911 | g9585 | i0 | 57.3 | 0.981260647359455 | 96 | 41 | 49.1 | 0 | 359 | 72 | 14 | 109 | XP_015284848.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Gekko japonicus] | diamond | 576 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 28219479 | 28219479 | PRJNA700095_P_NODE_13866_length_503_cov_3.644186_g12607_i0 | PRJNA700095 | 13866 | 503 | 3.644186 | 18.33025558 | Balaenoptera physalus | 9770 | Chordata | Chordata | 50.1 | 2.04e-4 | NR | KAB0401909.1 | 9770 | g12607 | i0 | 37.6 | 0.554671968190855 | 93 | 53 | 53.7 | 3 | 186 | 455 | 13 | 103 | KAB0401909.1 hypothetical protein E2I00_017869, partial [Balaenoptera physalus] | diamond | 279 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 28693576 | 28693576 | PRJNA700095_P_NODE_68347_length_230_cov_2.898089_g67082_i0 | PRJNA700095 | 68347 | 230 | 2.898089 | 6.6656047 | Galeopterus variegatus | 482537 | Chordata | Chordata | 46.6 | 0.00112 | NR | XP_008566368.1 | 482537 | g67082 | i0 | 62.9 | 0.456521739130435 | 35 | 13 | 45.7 | 0 | 19 | 123 | 1 | 35 | XP_008566368.1 PREDICTED: apolipoprotein D-like [Galeopterus variegatus] | diamond | 105 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Dermoptera | Cynocephalidae | Galeopterus | Galeopterus variegatus | |
| 28851003 | 28851003 | PRJNA700095_P_NODE_28288_length_320_cov_2.165992_g27024_i0 | PRJNA700095 | 28288 | 320 | 2.165992 | 6.9311744 | Phallusia mammillata | 59560 | Chordata | Chordata | 45.1 | 0.0137 | NR | CAB3266418.1 | 59560 | g27024 | i0 | 35.6 | 1.640625 | 59 | 36 | 55.3 | 1 | 193 | 17 | 456 | 512 | CAB3266418.1 SET and MYND domain-containing protein 4-like [Phallusia mammillata] | diamond | 525 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 28977649 | 28977649 | PRJNA700095_P_NODE_10968_length_583_cov_1.968627_g9727_i0 | PRJNA700095 | 10968 | 583 | 1.968627 | 11.47709541 | Polypterus senegalus | 55291 | Chordata | Chordata | 62.8 | 1.16e-7 | NR | XP_039593442.1 | 55291 | g9727 | i0 | 29.7 | 0.936535162950257 | 182 | 106 | 92.1 | 5 | 4 | 540 | 432 | 594 | XP_039593442.1 syndetin isoform X3 [Polypterus senegalus] | diamond | 546 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29083522 | 29083522 | PRJNA700095_P_NODE_19888_length_396_cov_3.894737_g18625_i0 | PRJNA700095 | 19888 | 396 | 3.894737 | 15.42315852 | Opisthokonta | 33154 | Chordata | Chordata | 119 | 2.91e-30 | NR | XP_008120216.2 | 28377 | g18625 | i0 | 54.4 | 10.219696969697 | 125 | 48 | 94.7 | 4 | 392 | 18 | 153 | 268 | XP_008120216.2 sepiapterin reductase isoform X2 [Anolis carolinensis] | diamond | 4047 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dactyloidae | Anolis | Anolis carolinensis | |
| 29083523 | 29083523 | PRJNA700095_P_NODE_24488_length_348_cov_1.938182_g23224_i0 | PRJNA700095 | 24488 | 348 | 1.938182 | 6.74487336 | Metazoa | 33208 | Chordata | Chordata | 73.2 | 2.57e-12 | NR | NP_001071903.1 | 7719 | g23224 | i0 | 38.5 | 5.10344827586207 | 96 | 54 | 81 | 3 | 11 | 292 | 140 | 232 | NP_001071903.1 zinc finger protein [Ciona intestinalis] | diamond | 1776 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29556871 | 29556871 | PRJNA700095_P_NODE_3350_length_1069_cov_1.994980_g2559_i0 | PRJNA700095 | 3350 | 1069 | 1.99498 | 21.3263362 | Opisthokonta | 33154 | Chordata | Chordata | 86.3 | 3.07e-14 | NR | NP_001400500.1 | 10090 | g2559 | i0 | 28 | 3.03367633302152 | 239 | 136 | 65.1 | 6 | 232 | 927 | 433 | 642 | NP_001400500.1 SWI/SNF complex subunit SMARCC1 isoform 4 [Mus musculus] | diamond | 3243 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29703329 | 29703329 | PRJNA700095_P_NODE_47350_length_259_cov_1.241935_g46086_i0 | PRJNA700095 | 47350 | 259 | 1.241935 | 3.21661165 | Calypte anna | 9244 | Chordata | Chordata | 42.7 | 0.0349 | NR | KFP00376.1 | 9244 | g46086 | i0 | 43.2 | 0.857142857142857 | 37 | 21 | 42.9 | 0 | 148 | 258 | 5 | 41 | KFP00376.1 TPR and ankyrin repeat-containing protein 1, partial [Calypte anna] | diamond | 222 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apodiformes | Trochilidae | Calypte | Calypte anna | |
| 29956362 | 29956362 | PRJNA700095_P_NODE_32531_length_299_cov_1.938053_g31267_i0 | PRJNA700095 | 32531 | 299 | 1.938053 | 5.79477847 | Protopterus annectens | 7888 | Chordata | Chordata | 63.2 | 4e-9 | NR | XP_043912117.1 | 7888 | g31267 | i0 | 45.2 | 0.732441471571906 | 73 | 40 | 73.2 | 0 | 299 | 81 | 245 | 317 | XP_043912117.1 fibronectin type 3 and ankyrin repeat domains protein 1 isoform X2 [Protopterus annectens] | diamond | 219 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 29967625 | 29967625 | PRJNA700095_P_NODE_50291_length_252_cov_4.497207_g49027_i0 | PRJNA700095 | 50291 | 252 | 4.497207 | 11.33296164 | Chordata | 7711 | Chordata | Chordata | 50.8 | 5.89e-5 | NR | XP_042326313.1 | 8520 | g49027 | i0 | 77.3 | 2.0952380952381 | 22 | 5 | 26.2 | 0 | 1 | 66 | 514 | 535 | XP_042326313.1 src substrate cortactin-like isoform X2 [Sceloporus undulatus] | diamond | 528 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Phrynosomatidae | Sceloporus | Sceloporus undulatus | |
| 30051022 | 30051022 | PRJNA700095_P_NODE_36231_length_286_cov_0.948357_g34967_i0 | PRJNA700095 | 36231 | 286 | 0.948357 | 2.71230102 | Tinamus guttatus | 94827 | Chordata | Chordata | 97.4 | 3.42e-21 | NR | XP_010212325.1 | 94827 | g34967 | i0 | 58.5 | 0.986013986013986 | 94 | 33 | 98.6 | 2 | 3 | 284 | 284 | 371 | XP_010212325.1 PREDICTED: uncharacterized protein LOC104567219, partial [Tinamus guttatus] | diamond | 282 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Tinamiformes | Tinamidae | Tinamus | Tinamus guttatus | |
| 31441543 | 31441543 | PRJNA700095_P_NODE_33496_length_295_cov_1.040541_g32232_i0 | PRJNA700095 | 33496 | 295 | 1.040541 | 3.06959595 | Gavialis gangeticus | 94835 | Chordata | Chordata | 58.9 | 1.38e-7 | NR | XP_019373327.1 | 94835 | g32232 | i0 | 34 | 3.82372881355932 | 94 | 38 | 95.6 | 2 | 1 | 282 | 33 | 102 | XP_019373327.1 PREDICTED: E3 ubiquitin-protein ligase TRIM23 isoform X2 [Gavialis gangeticus] | diamond | 1128 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Gavialidae | Gavialis | Gavialis gangeticus | ||
| 31769017 | 31769017 | PRJNA700095_P_NODE_20957_length_384_cov_1.717042_g19693_i0 | PRJNA700095 | 20957 | 384 | 1.717042 | 6.59344128 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.35e-27 | NR | XP_070742255.1 | 55135 | g19693 | i0 | 57.3 | 12.625 | 96 | 41 | 75 | 0 | 94 | 381 | 460 | 555 | XP_070742255.1 ubiquitin-like modifier-activating enzyme 6 [Pristiophorus japonicus] | diamond | 4848 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Pristiophoridae | Pristiophorus | Pristiophorus japonicus | ||
| 31821021 | 31821021 | PRJNA700095_P_NODE_48177_length_257_cov_1.657609_g46913_i0 | PRJNA700095 | 48177 | 257 | 1.657609 | 4.26005513 | Mycteria americana | 33587 | Chordata | Chordata | 43.9 | 0.00831 | NR | KAK4820545.1 | 33587 | g46913 | i0 | 36.8 | 0.665369649805447 | 57 | 34 | 64.2 | 1 | 226 | 62 | 86 | 142 | KAK4820545.1 hypothetical protein QYF61_000695 [Mycteria americana] | diamond | 171 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 31990460 | 31990460 | PRJNA700095_P_NODE_41798_length_271_cov_1.858586_g40534_i0 | PRJNA700095 | 41798 | 271 | 1.858586 | 5.03676806 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 2.12e-7 | NR | XP_030620105.1 | 9749 | g40534 | i0 | 66.7 | 1.39483394833948 | 42 | 14 | 46.5 | 0 | 1 | 126 | 47 | 88 | XP_030620105.1 LINE-1 type transposase domain-containing protein 1, partial [Delphinapterus leucas] | diamond | 378 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Delphinapterus | Delphinapterus leucas |
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);;