contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13966566 | 13966566 | PRJNA782551_P_NODE_9731_length_302_cov_1.200873_g9609_i0 | PRJNA782551 | 9731 | 302 | 1.200873 | 3.62663646 | Metazoa | 33208 | Chordata | Chordata | 159 | 7.07e-44 | NR | ETE73729.1 | 8665 | g9609 | i0 | 83.9 | 16.4205298013245 | 87 | 14 | 86.4 | 0 | 2 | 262 | 446 | 532 | ETE73729.1 Aspartyl-tRNA synthetase, cytoplasmic, partial [Ophiophagus hannah] | diamond | 4959 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Ophiophagus | Ophiophagus hannah | |
| 26619711 | 26619711 | PRJNA782551_P_NODE_15181_length_254_cov_1.701657_g15059_i0 | PRJNA782551 | 15181 | 254 | 1.701657 | 4.32220878 | Passeriformes | 9126 | Chordata | Chordata | 50.4 | 8.42e-5 | NR | XP_014745843.1 | 9172 | g15059 | i0 | 45.1 | 3.34251968503937 | 51 | 28 | 60.2 | 0 | 154 | 2 | 1080 | 1130 | XP_014745843.1 PREDICTED: intersectin-1 [Sturnus vulgaris] | diamond | 849 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sturnidae | Sturnus | Sturnus vulgaris | |
| 27211431 | 27211431 | PRJNA782551_P_NODE_12962_length_271_cov_1.555556_g12840_i0 | PRJNA782551 | 12962 | 271 | 1.555556 | 4.21555676 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 59.7 | 2.75e-9 | NR | KAI4568487.1 | 2918886 | g12840 | i0 | 90.9 | 0.365313653136531 | 33 | 3 | 36.5 | 0 | 99 | 1 | 58 | 90 | KAI4568487.1 hypothetical protein MJT46_008285 [Ovis ammon polii x Ovis aries] | diamond | 99 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 27433088 | 27433088 | PRJNA782551_P_NODE_24883_length_241_cov_0.916667_g24761_i0 | PRJNA782551 | 24883 | 241 | 0.916667 | 2.20916747 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 68.2 | 3.12e-12 | NR | KAF6441176.1 | 9407 | g24761 | i0 | 49.3 | 1.85477178423237 | 71 | 34 | 88.4 | 1 | 214 | 2 | 40 | 108 | KAF6441176.1 hypothetical protein HJG63_012326 [Rousettus aegyptiacus] | diamond | 447 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 27505499 | 27505499 | PRJNA782551_P_NODE_21763_length_244_cov_0.900585_g21641_i0 | PRJNA782551 | 21763 | 244 | 0.900585 | 2.1974274 | Chordata | 7711 | Chordata | Chordata | 108 | 2.61e-25 | NR | XP_050749097.1 | 33616 | g21641 | i0 | 65.4 | 6.97131147540984 | 81 | 28 | 99.6 | 0 | 2 | 244 | 596 | 676 | XP_050749097.1 heat shock protein HSP 90-beta isoform X2 [Gymnogyps californianus] | diamond | 1701 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Cathartidae | Gymnogyps | Gymnogyps californianus | |
| 27780305 | 27780305 | PRJNA782551_P_NODE_24084_length_242_cov_0.911243_g23962_i0 | PRJNA782551 | 24084 | 242 | 0.911243 | 2.20520806 | Mycteria americana | 33587 | Chordata | Chordata | 43.9 | 0.0134 | NR | KAK4830265.1 | 33587 | g23962 | i0 | 46 | 0.78099173553719 | 63 | 31 | 74.4 | 1 | 215 | 36 | 219 | 281 | KAK4830265.1 hypothetical protein QYF61_009358 [Mycteria americana] | diamond | 189 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 27843135 | 27843135 | PRJNA782551_P_NODE_20524_length_246_cov_0.890173_g20402_i0 | PRJNA782551 | 20524 | 246 | 0.890173 | 2.18982558 | Grus japonensis | 30415 | Chordata | Chordata | 60.8 | 1.15e-8 | NR | GAB0186367.1 | 30415 | g20402 | i0 | 51.6 | 1.57317073170732 | 64 | 16 | 59.8 | 1 | 33 | 179 | 219 | 282 | GAB0186367.1 mitochondrial enolase superfamily member 1 [Grus japonensis] | diamond | 387 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 29358935 | 29358935 | PRJNA782551_P_NODE_14269_length_261_cov_1.414894_g14147_i0 | PRJNA782551 | 14269 | 261 | 1.414894 | 3.69287334 | Muntiacus reevesi | 9886 | Chordata | Chordata | 46.2 | 0.00273 | NR | KAB0353587.1 | 9886 | g14147 | i0 | 66.7 | 0.413793103448276 | 36 | 12 | 41.4 | 0 | 109 | 216 | 356 | 391 | KAB0353587.1 hypothetical protein FD755_023713, partial [Muntiacus reevesi] | diamond | 108 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 29421811 | 29421811 | PRJNA782551_P_NODE_23789_length_242_cov_0.911243_g23667_i0 | PRJNA782551 | 23789 | 242 | 0.911243 | 2.20520806 | Manis javanica | 9974 | Chordata | Chordata | 69.7 | 3.53e-12 | NR | KAI5940395.1 | 9974 | g23667 | i0 | 61.8 | 0.84297520661157 | 68 | 21 | 79.3 | 3 | 1 | 192 | 161 | 227 | KAI5940395.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 204 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 29484873 | 29484873 | PRJNA782551_P_NODE_24070_length_242_cov_0.911243_g23948_i0 | PRJNA782551 | 24070 | 242 | 0.911243 | 2.20520806 | Muntiacus reevesi | 9886 | Chordata | Chordata | 54.3 | 3.02e-6 | NR | KAB0339383.1 | 9886 | g23948 | i0 | 41.3 | 3.14876033057851 | 92 | 39 | 96.7 | 3 | 3 | 236 | 403 | 493 | KAB0339383.1 hypothetical protein FD755_024967 [Muntiacus reevesi] | diamond | 762 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 29769221 | 29769221 | PRJNA782551_P_NODE_22151_length_244_cov_0.900585_g22029_i0 | PRJNA782551 | 22151 | 244 | 0.900585 | 2.1974274 | Muntiacus reevesi | 9886 | Chordata | Chordata | 48.9 | 2.53e-4 | NR | KAB0372535.1 | 9886 | g22029 | i0 | 88.5 | 0.319672131147541 | 26 | 3 | 32 | 0 | 244 | 167 | 34 | 59 | KAB0372535.1 hypothetical protein FD755_016327, partial [Muntiacus reevesi] | diamond | 78 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 30148173 | 30148173 | PRJNA782551_P_NODE_14452_length_260_cov_1.085561_g14330_i0 | PRJNA782551 | 14452 | 260 | 1.085561 | 2.8224586 | Bos javanicus | 9906 | Chordata | Chordata | 53.5 | 5.49e-6 | NR | XP_061237218.1 | 9906 | g14330 | i0 | 54.9 | 1.17692307692308 | 51 | 17 | 51.9 | 1 | 105 | 239 | 199 | 249 | XP_061237218.1 uncharacterized protein LOC133227011 isoform X1 [Bos javanicus] | diamond | 306 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 30338411 | 30338411 | PRJNA782551_P_NODE_19952_length_246_cov_0.890173_g19830_i0 | PRJNA782551 | 19952 | 246 | 0.890173 | 2.18982558 | Ovis aries | 9940 | Chordata | Chordata | 42.4 | 0.0486 | NR | XP_042094387.1 | 9940 | g19830 | i0 | 45.9 | 0.902439024390244 | 74 | 25 | 75.6 | 3 | 200 | 15 | 4 | 74 | XP_042094387.1 methylated-DNA--protein-cysteine methyltransferase isoform X1 [Ovis aries] | diamond | 222 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 30852778 | 30852778 | PRJNA782551_P_NODE_23334_length_242_cov_1.698225_g23212_i0 | PRJNA782551 | 23334 | 242 | 1.698225 | 4.1097045 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.8099999999999999e-28 | NR | XP_039272032.1 | 7725 | g23212 | i0 | 69.6 | 19.5867768595041 | 79 | 24 | 97.9 | 0 | 2 | 238 | 325 | 403 | XP_039272032.1 ruvB-like 2 [Styela clava] | diamond | 4740 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 31285795 | 31285795 | PRJNA782551_P_NODE_24015_length_242_cov_0.911243_g23893_i0 | PRJNA782551 | 24015 | 242 | 0.911243 | 2.20520806 | Bos mutus | 72004 | Chordata | Chordata | 105 | 2.24e-24 | NR | MXQ94399.1 | 72004 | g23893 | i0 | 90.6 | 0.65702479338843 | 53 | 5 | 65.7 | 0 | 2 | 160 | 773 | 825 | MXQ94399.1 hypothetical protein [Bos mutus] | diamond | 159 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 31760325 | 31760325 | PRJNA782551_P_NODE_16757_length_250_cov_0.870056_g16635_i0 | PRJNA782551 | 16757 | 250 | 0.870056 | 2.17514 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 52.8 | 2.89e-6 | NR | KAF6422800.1 | 9407 | g16635 | i0 | 41.5 | 0.984 | 82 | 36 | 85.2 | 3 | 225 | 13 | 55 | 135 | KAF6422800.1 hypothetical protein HJG63_008601 [Rousettus aegyptiacus] | diamond | 246 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 32465935 | 32465935 | PRJNA782551_P_NODE_17719_length_249_cov_0.875000_g17597_i0 | PRJNA782551 | 17719 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Chordata | Chordata | 130 | 7.56e-33 | NR | PIO29837.1 | 8400 | g17597 | i0 | 75.3 | 101.55421686747 | 81 | 20 | 97.6 | 0 | 3 | 245 | 631 | 711 | PIO29837.1 hypothetical protein AB205_0009430, partial [Aquarana catesbeiana] | diamond | 25287 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 32708782 | 32708782 | PRJNA782551_P_NODE_19560_length_247_cov_0.885057_g19438_i0 | PRJNA782551 | 19560 | 247 | 0.885057 | 2.18609079 | Ambystoma mexicanum | 8296 | Chordata | Chordata | 104 | 5.96e-25 | NR | XP_069463286.1 | 8296 | g19438 | i0 | 63.4 | 0.995951417004049 | 82 | 29 | 98.4 | 1 | 3 | 245 | 150 | 231 | XP_069463286.1 deaminated glutathione amidase isoform X2 [Ambystoma mexicanum] | diamond | 246 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum |
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);;