contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9116570 | 9116570 | PRJNA1074407_P_NODE_148068_length_232_cov_3.597484_g144230_i0 | PRJNA1074407 | 148068 | 232 | 3.597484 | 8.34616288 | Opisthokonta | 33154 | Chordata | Chordata | 84 | 1.03e-16 | NR | XP_039273955.1 | 7725 | g144230 | i0 | 83.3 | 14.2370689655172 | 48 | 6 | 62.1 | 1 | 61 | 204 | 2030 | 2075 | XP_039273955.1 chromodomain-helicase-DNA-binding protein 7-like [Styela clava] | diamond | 3303 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 10391393 | 10391393 | PRJNA1074407_P_NODE_104449_length_333_cov_1.461538_g100611_i0 | PRJNA1074407 | 104449 | 333 | 1.461538 | 4.86692154 | Metazoa | 33208 | Chordata | Chordata | 169 | 1.12e-49 | NR | NP_001005443.1 | 8364 | g100611 | i0 | 93.8 | 80.7117117117117 | 80 | 5 | 72.1 | 0 | 331 | 92 | 230 | 309 | NP_001005443.1 serine/threonine-protein phosphatase 2A catalytic subunit beta isoform [Xenopus tropicalis] | diamond | 26877 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 20142717 | 20142717 | PRJNA1074407_P_NODE_128776_length_264_cov_1.544503_g124938_i0 | PRJNA1074407 | 128776 | 264 | 1.544503 | 4.07748792 | Pleurodeles waltl | 8319 | Chordata | Chordata | 179 | 2.52e-52 | NR | KAJ1195343.1 | 8319 | g124938 | i0 | 92 | 307.465909090909 | 87 | 7 | 98.9 | 0 | 263 | 3 | 213 | 299 | KAJ1195343.1 hypothetical protein NDU88_004624 [Pleurodeles waltl] | diamond | 81171 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 23141175 | 23141175 | PRJNA1074407_P_NODE_146679_length_240_cov_0.886228_g142841_i0 | PRJNA1074407 | 146679 | 240 | 0.886228 | 2.1269472 | Mammalia | 40674 | Chordata | Chordata | 110 | 3.92e-29 | NR | XP_055180690.1 | 34880 | g142841 | i0 | 67.1 | 4.4 | 79 | 26 | 98.8 | 0 | 2 | 238 | 7 | 85 | XP_055180690.1 small nuclear ribonucleoprotein E-like [Nyctereutes procyonoides] | diamond | 1056 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 26963840 | 26963840 | PRJNA1074407_P_NODE_113822_length_304_cov_1.316017_g109984_i0 | PRJNA1074407 | 113822 | 304 | 1.316017 | 4.00069168 | Metazoa | 33208 | Chordata | Chordata | 156 | 9.85e-46 | NR | XP_039265878.1 | 7725 | g109984 | i0 | 74.3 | 8.88157894736842 | 101 | 26 | 99.7 | 0 | 303 | 1 | 112 | 212 | XP_039265878.1 elongation factor 1-beta-like [Styela clava] | diamond | 2700 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 27541457 | 27541457 | PRJNA1074407_P_NODE_127644_length_267_cov_1.242268_g123806_i0 | PRJNA1074407 | 127644 | 267 | 1.242268 | 3.31685556 | Monodon monoceros | 40151 | Chordata | Chordata | 52.8 | 9.68e-6 | NR | TKC47096.1 | 40151 | g123806 | i0 | 88.5 | 0.831460674157303 | 26 | 3 | 29.2 | 0 | 118 | 195 | 133 | 158 | TKC47096.1 hypothetical protein EI555_012305 [Monodon monoceros] | diamond | 222 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 27627766 | 27627766 | PRJNA1074407_P_NODE_133904_length_252_cov_0.921788_g130066_i0 | PRJNA1074407 | 133904 | 252 | 0.921788 | 2.32290576 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 4.26e-4 | NR | CAK8628284.1 | 30338 | g130066 | i0 | 56.4 | 8.25 | 39 | 16 | 45.2 | 1 | 164 | 51 | 199 | 237 | CAK8628284.1 Chymotrypsin-like elastase family member 1 [Bufotes viridis] | diamond | 2079 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28867447 | 28867447 | PRJNA1074407_P_NODE_108688_length_320_cov_0.923077_g104850_i0 | PRJNA1074407 | 108688 | 320 | 0.923077 | 2.9538464 | Phallusia mammillata | 59560 | Chordata | Chordata | 43.5 | 0.0477 | NR | CAB3263392.1 | 59560 | g104850 | i0 | 33.3 | 0.534375 | 57 | 38 | 53.4 | 0 | 53 | 223 | 124 | 180 | CAB3263392.1 la-related protein 7-like [Phallusia mammillata] | diamond | 171 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 29593300 | 29593300 | PRJNA1074407_P_NODE_62070_length_551_cov_5.665272_g58247_i0 | PRJNA1074407 | 62070 | 551 | 5.665272 | 31.21564872 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 130 | 6.95e-35 | NR | XP_019626026.1 | 7741 | g58247 | i0 | 45.5 | 1.52994555353902 | 132 | 71 | 71.9 | 1 | 72 | 467 | 18 | 148 | XP_019626026.1 PREDICTED: epididymal secretory protein E1-like [Branchiostoma belcheri] | diamond | 843 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29711116 | 29711116 | PRJNA1074407_P_NODE_86350_length_403_cov_1.151515_g82514_i0 | PRJNA1074407 | 86350 | 403 | 1.151515 | 4.64060545 | Aves | 8782 | Chordata | Chordata | 57.4 | 1.78e-6 | NR | XP_042681938.1 | 9002 | g82514 | i0 | 31.9 | 7.08684863523573 | 119 | 71 | 81.1 | 2 | 328 | 2 | 1964 | 2082 | XP_042681938.1 nipped-B-like protein [Centrocercus urophasianus] | diamond | 2856 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Centrocercus | Centrocercus urophasianus | |
| 29719712 | 29719712 | PRJNA1074407_P_NODE_144810_length_241_cov_0.904762_g140972_i0 | PRJNA1074407 | 144810 | 241 | 0.904762 | 2.18047642 | Neotoma lepida | 56216 | Chordata | Chordata | 90.5 | 5.4e-19 | NR | OBS75475.1 | 56216 | g140972 | i0 | 56.3 | 1.92946058091286 | 80 | 34 | 98.3 | 1 | 3 | 239 | 233 | 312 | OBS75475.1 hypothetical protein A6R68_14002 [Neotoma lepida] | diamond | 465 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Neotoma | Neotoma lepida | |
| 29964212 | 29964212 | PRJNA1074407_P_NODE_129111_length_263_cov_2.000000_g125273_i0 | PRJNA1074407 | 129111 | 263 | 2 | 5.26 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.5 | 2.8e-8 | NR | CBY09016.1 | 34765 | g125273 | i0 | 83.9 | 16.9277566539924 | 31 | 5 | 35.4 | 0 | 182 | 90 | 783 | 813 | CBY09016.1 unnamed protein product [Oikopleura dioica] | diamond | 4452 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 30090363 | 30090363 | PRJNA1074407_P_NODE_98952_length_352_cov_1.311828_g95114_i0 | PRJNA1074407 | 98952 | 352 | 1.311828 | 4.61763456 | Metazoa | 33208 | Chordata | Chordata | 68.9 | 6.89e-11 | NR | NP_001072907.1 | 8364 | g95114 | i0 | 43.5 | 2.10511363636364 | 92 | 41 | 78.4 | 1 | 349 | 74 | 28 | 108 | NP_001072907.1 nucleosome assembly protein 1-like 4 [Xenopus tropicalis] | diamond | 741 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30825666 | 30825666 | PRJNA1074407_P_NODE_55194_length_619_cov_1.813187_g51402_i0 | PRJNA1074407 | 55194 | 619 | 1.813187 | 11.22362753 | Egretta garzetta | 188379 | Chordata | Chordata | 106 | 4.409999999999999e-23 | NR | XP_009633903.1 | 188379 | g51402 | i0 | 73.3 | 0.983844911147011 | 101 | 27 | 48.9 | 0 | 1 | 303 | 208 | 308 | XP_009633903.1 early growth response protein 1, partial [Egretta garzetta] | diamond | 609 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Pelecaniformes | Ardeidae | Egretta | Egretta garzetta | |
| 31164461 | 31164461 | PRJNA1074407_P_NODE_130095_length_261_cov_1.212766_g126257_i0 | PRJNA1074407 | 130095 | 261 | 1.212766 | 3.16531926 | Metazoa | 33208 | Chordata | Chordata | 85.1 | 6.28e-18 | NR | AAH29801.1 | 10090 | g126257 | i0 | 84.8 | 1.03448275862069 | 46 | 7 | 52.9 | 0 | 12 | 149 | 1 | 46 | AAH29801.1 Klhl20 protein, partial [Mus musculus] | diamond | 270 | 85.5 | 0.9953216374269 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31354572 | 31354572 | PRJNA1074407_P_NODE_109396_length_317_cov_2.073770_g105558_i0 | PRJNA1074407 | 109396 | 317 | 2.07377 | 6.5738509 | Chordata | 7711 | Chordata | Chordata | 106 | 2.6799999999999998e-24 | NR | XP_023378286.1 | 132908 | g105558 | i0 | 89.1 | 1.5615141955836 | 55 | 6 | 52.1 | 0 | 2 | 166 | 444 | 498 | XP_023378286.1 F-box/WD repeat-containing protein 1A isoform X9 [Pteropus vampyrus] | diamond | 495 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Pteropus | Pteropus vampyrus | |
| 31607539 | 31607539 | PRJNA1074407_P_NODE_103456_length_336_cov_1.733840_g99618_i0 | PRJNA1074407 | 103456 | 336 | 1.73384 | 5.8257024 | Metazoa | 33208 | Chordata | Chordata | 101 | 2.58e-25 | NR | XP_039609960.1 | 55291 | g99618 | i0 | 53.7 | 9.17857142857143 | 95 | 44 | 84.8 | 0 | 1 | 285 | 5 | 99 | XP_039609960.1 transmembrane protein 14C [Polypterus senegalus] | diamond | 3084 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31639030 | 31639030 | PRJNA1074407_P_NODE_142456_length_243_cov_0.894118_g138618_i0 | PRJNA1074407 | 142456 | 243 | 0.894118 | 2.17270674 | Chordata | 7711 | Chordata | Chordata | 95.5 | 7.050000000000001e-21 | NR | XP_026243699.1 | 9999 | g138618 | i0 | 49.4 | 8.97530864197531 | 81 | 41 | 100 | 0 | 1 | 243 | 283 | 363 | XP_026243699.1 WD40 repeat-containing protein SMU1 [Urocitellus parryii] | diamond | 2181 | 96.3 | 0.991692627206646 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Urocitellus | Urocitellus parryii |
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);;