contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA853203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26643345 | 26643345 | PRJNA853203_P_NODE_12921_length_282_cov_1.205742_g12772_i0 | PRJNA853203 | 12921 | 282 | 1.205742 | 3.40019244 | Pezoporus flaviventris | 889875 | Chordata | Chordata | 57.8 | 1.63e-8 | NR | XP_061306873.1 | 889875 | g12772 | i0 | 92 | 18.2659574468085 | 25 | 2 | 26.6 | 0 | 132 | 58 | 27 | 51 | XP_061306873.1 dnaJ homolog subfamily C member 17-like [Pezoporus flaviventris] | diamond | 5151 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittacidae | Pezoporus | Pezoporus flaviventris | |
| 26896997 | 26896997 | PRJNA853203_P_NODE_38661_length_247_cov_0.862069_g38512_i0 | PRJNA853203 | 38661 | 247 | 0.862069 | 2.12931043 | Molossus molossus | 27622 | Chordata | Chordata | 42 | 0.041 | NR | KAF6452817.1 | 27622 | g38512 | i0 | 35.5 | 0.923076923076923 | 76 | 48 | 92.3 | 1 | 5 | 232 | 79 | 153 | KAF6452817.1 hypothetical protein HJG59_008164 [Molossus molossus] | diamond | 228 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Molossidae | Molossus | Molossus molossus | |
| 27181282 | 27181282 | PRJNA853203_P_NODE_30362_length_251_cov_0.876404_g30213_i0 | PRJNA853203 | 30362 | 251 | 0.876404 | 2.19977404 | Monodon monoceros | 40151 | Chordata | Chordata | 43.1 | 0.0235 | NR | TKC40313.1 | 40151 | g30213 | i0 | 40 | 0.836653386454183 | 70 | 32 | 72.9 | 2 | 249 | 67 | 75 | 143 | TKC40313.1 hypothetical protein EI555_003953, partial [Monodon monoceros] | diamond | 210 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 28286540 | 28286540 | PRJNA853203_P_NODE_41046_length_245_cov_1.348837_g40897_i0 | PRJNA853203 | 41046 | 245 | 1.348837 | 3.30465065 | Myxine glutinosa | 7769 | Chordata | Chordata | 67.4 | 7.95e-11 | NR | XP_067965260.1 | 7769 | g40897 | i0 | 78.9 | 0.46530612244898 | 38 | 8 | 46.5 | 0 | 1 | 114 | 254 | 291 | XP_067965260.1 protein FAM83B-like [Myxine glutinosa] | diamond | 114 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28791756 | 28791756 | PRJNA853203_P_NODE_16407_length_274_cov_1.378109_g16258_i0 | PRJNA853203 | 16407 | 274 | 1.378109 | 3.77601866 | Myxine glutinosa | 7769 | Chordata | Chordata | 73.9 | 5.98e-13 | NR | XP_067970771.1 | 7769 | g16258 | i0 | 72.5 | 2.79197080291971 | 51 | 14 | 55.8 | 0 | 156 | 4 | 473 | 523 | XP_067970771.1 voltage-dependent L-type calcium channel subunit alpha-1D-like [Myxine glutinosa] | diamond | 765 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 29991895 | 29991895 | PRJNA853203_P_NODE_34611_length_249_cov_0.886364_g34462_i0 | PRJNA853203 | 34611 | 249 | 0.886364 | 2.20704636 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 62.4 | 4.81e-9 | NR | CAD7679477.1 | 34880 | g34462 | i0 | 100 | 0.542168674698795 | 45 | 0 | 54.2 | 0 | 113 | 247 | 108 | 152 | CAD7679477.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 135 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 30157784 | 30157784 | PRJNA853203_P_NODE_48472_length_240_cov_2.419162_g48323_i0 | PRJNA853203 | 48472 | 240 | 2.419162 | 5.8059888 | Chordata | 7711 | Chordata | Chordata | 64.7 | 6.47e-10 | NR | XP_039183841.1 | 88082 | g48323 | i0 | 93.9 | 8.275 | 33 | 2 | 41.3 | 0 | 101 | 3 | 115 | 147 | XP_039183841.1 enhancer of polycomb homolog 2 isoform X1 [Crotalus tigris] | diamond | 1986 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus tigris | |
| 30466058 | 30466058 | PRJNA853203_P_NODE_35553_length_248_cov_0.891429_g35404_i0 | PRJNA853203 | 35553 | 248 | 0.891429 | 2.21074392 | Ranitomeya imitator | 111125 | Chordata | Chordata | 43.1 | 0.0269 | NR | CAJ0943918.1 | 111125 | g35404 | i0 | 47.6 | 0.508064516129032 | 42 | 19 | 47.2 | 1 | 104 | 220 | 9 | 50 | CAJ0943918.1 unnamed protein product, partial [Ranitomeya imitator] | diamond | 126 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 30505623 | 30505623 | PRJNA853203_P_NODE_39933_length_246_cov_0.901734_g39784_i0 | PRJNA853203 | 39933 | 246 | 0.901734 | 2.21826564 | Chordata | 7711 | Chordata | Chordata | 103 | 1.1499999999999999e-23 | NR | XP_064418695.1 | 7897 | g39784 | i0 | 81.5 | 66.3414634146341 | 65 | 10 | 79.3 | 1 | 49 | 243 | 523 | 585 | XP_064418695.1 hexokinase-1 isoform X2 [Latimeria chalumnae] | diamond | 16320 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 30560307 | 30560307 | PRJNA853203_P_NODE_32653_length_250_cov_0.881356_g32504_i0 | PRJNA853203 | 32653 | 250 | 0.881356 | 2.20339 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 43.5 | 0.0208 | NR | KAJ7309587.1 | 171643 | g32504 | i0 | 40.8 | 0.852 | 71 | 37 | 85.2 | 2 | 32 | 244 | 12 | 77 | KAJ7309587.1 hypothetical protein JRQ81_007639 [Phrynocephalus forsythii] | diamond | 213 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 30631787 | 30631787 | PRJNA853203_P_NODE_34593_length_249_cov_0.886364_g34444_i0 | PRJNA853203 | 34593 | 249 | 0.886364 | 2.20704636 | Passeriformes | 9126 | Chordata | Chordata | 71.6 | 2.56e-12 | NR | XP_041569966.1 | 59729 | g34444 | i0 | 56.9 | 1.28915662650602 | 58 | 25 | 69.9 | 0 | 11 | 184 | 84 | 141 | XP_041569966.1 diacylglycerol O-acyltransferase 1-like [Taeniopygia guttata] | diamond | 321 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Taeniopygia | Taeniopygia guttata | |
| 31128936 | 31128936 | PRJNA853203_P_NODE_39315_length_246_cov_0.901734_g39166_i0 | PRJNA853203 | 39315 | 246 | 0.901734 | 2.21826564 | Smutsia gigantea | 1559511 | Chordata | Chordata | 43.9 | 0.0151 | NR | KAK2508851.1 | 1559511 | g39166 | i0 | 37.1 | 1.63414634146341 | 89 | 39 | 95.1 | 5 | 245 | 12 | 175 | 257 | KAK2508851.1 hypothetical protein MC885_011793, partial [Smutsia gigantea] | diamond | 402 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Smutsia | Smutsia gigantea | |
| 31327109 | 31327109 | PRJNA853203_P_NODE_31395_length_250_cov_1.762712_g31246_i0 | PRJNA853203 | 31395 | 250 | 1.762712 | 4.40678 | Artiodactyla | 91561 | Chordata | Chordata | 49.7 | 3.3e-5 | NR | KAJ1061657.1 | 9925 | g31246 | i0 | 92 | 4.032 | 25 | 2 | 30 | 0 | 104 | 30 | 2 | 26 | KAJ1061657.1 hypothetical protein K5549_002692 [Capra hircus] | diamond | 1008 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 31508908 | 31508908 | PRJNA853203_P_NODE_30436_length_251_cov_0.876404_g30287_i0 | PRJNA853203 | 30436 | 251 | 0.876404 | 2.19977404 | Myxine glutinosa | 7769 | Chordata | Chordata | 63.2 | 2.59e-9 | NR | XP_067957591.1 | 7769 | g30287 | i0 | 66.7 | 0.573705179282869 | 48 | 15 | 56.2 | 1 | 143 | 3 | 496 | 543 | XP_067957591.1 kinesin-like protein KIF9 [Myxine glutinosa] | diamond | 144 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 32268182 | 32268182 | PRJNA853203_P_NODE_41818_length_245_cov_0.906977_g41669_i0 | PRJNA853203 | 41818 | 245 | 0.906977 | 2.22209365 | Crocuta crocuta | 9678 | Chordata | Chordata | 52.8 | 5.81e-7 | NR | KAF0883172.1 | 9678 | g41669 | i0 | 56.9 | 2.51020408163265 | 51 | 13 | 61.2 | 3 | 153 | 4 | 19 | 61 | KAF0883172.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 615 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 32371302 | 32371302 | PRJNA853203_P_NODE_27919_length_252_cov_1.743017_g27770_i0 | PRJNA853203 | 27919 | 252 | 1.743017 | 4.39240284 | Chordata | 7711 | Chordata | Chordata | 85.9 | 2.72e-17 | NR | KYO23644.1 | 8496 | g27770 | i0 | 100 | 38.4761904761905 | 42 | 0 | 50 | 0 | 127 | 2 | 821 | 862 | KYO23644.1 exportin-1 [Alligator mississippiensis] | diamond | 9696 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator mississippiensis | ||
| 32426259 | 32426259 | PRJNA853203_P_NODE_11879_length_284_cov_1.616114_g11730_i0 | PRJNA853203 | 11879 | 284 | 1.616114 | 4.58976376 | Thamnophis sirtalis | 35019 | Chordata | Chordata | 58.5 | 1.76e-7 | NR | XP_013909607.1 | 35019 | g11730 | i0 | 83.3 | 0.380281690140845 | 36 | 6 | 38 | 0 | 282 | 175 | 1521 | 1556 | XP_013909607.1 PREDICTED: probable E3 ubiquitin-protein ligase HECTD4 [Thamnophis sirtalis] | diamond | 108 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Colubridae | Thamnophis | Thamnophis sirtalis |
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);;