contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6246773 | 6246773 | PRJNA603943_P_NODE_32045_length_321_cov_1.173387_g31853_i0 | PRJNA603943 | 32045 | 321 | 1.173387 | 3.76657227 | Ochotona | 9977 | Chordata | Chordata | 144 | 2.2999999999999998e-38 | NR | XP_058513196.1 | 9978 | g31853 | i0 | 70.8 | 30.6822429906542 | 106 | 31 | 99.1 | 0 | 3 | 320 | 287 | 392 | XP_058513196.1 3-ketoacyl-CoA thiolase, peroxisomal isoform X2 [Ochotona princeps] | diamond | 9849 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 23530520 | 23530520 | PRJNA603943_P_NODE_66999_length_243_cov_0.905882_g66807_i0 | PRJNA603943 | 66999 | 243 | 0.905882 | 2.20129326 | Opisthokonta | 33154 | Chordata | Chordata | 118 | 7.5e-29 | NR | CAB3237154.1 | 59560 | g66807 | i0 | 68.8 | 8.69135802469136 | 77 | 24 | 95.1 | 0 | 6 | 236 | 407 | 483 | CAB3237154.1 ATP-dependent RNA helicase dbp2 [Phallusia mammillata] | diamond | 2112 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 26840353 | 26840353 | PRJNA603943_P_NODE_38681_length_296_cov_1.381166_g38489_i0 | PRJNA603943 | 38681 | 296 | 1.381166 | 4.08825136 | Opisthokonta | 33154 | Chordata | Chordata | 161 | 2e-45 | NR | XP_053551836.1 | 8345 | g38489 | i0 | 79.6 | 23.8074324324324 | 98 | 20 | 99.3 | 0 | 295 | 2 | 89 | 186 | XP_053551836.1 cysteine desulfurase [Bombina bombina] | diamond | 7047 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 27396214 | 27396214 | PRJNA603943_P_NODE_24063_length_357_cov_1.591549_g23871_i0 | PRJNA603943 | 24063 | 357 | 1.591549 | 5.68182993 | Chloroceryle aenea | 176938 | Chordata | Chordata | 45.1 | 0.0203 | NR | NXI48764.1 | 176938 | g23871 | i0 | 37 | 0.613445378151261 | 73 | 42 | 58.8 | 2 | 50 | 259 | 433 | 504 | NXI48764.1 GP149 protein [Chloroceryle aenea] | diamond | 219 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Coraciiformes | Cerylidae | Chloroceryle | Chloroceryle aenea | |
| 27712204 | 27712204 | PRJNA603943_P_NODE_37364_length_301_cov_1.013158_g37172_i0 | PRJNA603943 | 37364 | 301 | 1.013158 | 3.04960558 | Branchiostoma floridae | 7739 | Chordata | Chordata | 56.6 | 8.77e-7 | NR | XP_035687788.1 | 7739 | g37172 | i0 | 48.9 | 0.46843853820598 | 47 | 23 | 46.8 | 1 | 289 | 149 | 84 | 129 | XP_035687788.1 multiple epidermal growth factor-like domains protein 6 [Branchiostoma floridae] | diamond | 141 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 27743652 | 27743652 | PRJNA603943_P_NODE_65004_length_244_cov_0.900585_g64812_i0 | PRJNA603943 | 65004 | 244 | 0.900585 | 2.1974274 | Pogona vitticeps | 103695 | Chordata | Chordata | 44.7 | 0.00487 | NR | XP_020665876.1 | 103695 | g64812 | i0 | 45.8 | 0.590163934426229 | 48 | 24 | 56.6 | 2 | 1 | 138 | 63 | 110 | XP_020665876.1 probable RNA-binding protein EIF1AD [Pogona vitticeps] | diamond | 144 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Pogona | Pogona vitticeps | |
| 27996062 | 27996062 | PRJNA603943_P_NODE_55705_length_250_cov_0.870056_g55513_i0 | PRJNA603943 | 55705 | 250 | 0.870056 | 2.17514 | Engystomops pustulosus | 76066 | Chordata | Chordata | 76.6 | 4.84e-14 | NR | KAG8571490.1 | 76066 | g55513 | i0 | 57 | 3.792 | 79 | 34 | 94.8 | 0 | 14 | 250 | 1011 | 1089 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 948 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28009376 | 28009376 | PRJNA603943_P_NODE_53585_length_251_cov_0.865169_g53393_i0 | PRJNA603943 | 53585 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Chordata | Chordata | 46.6 | 0.00174 | NR | NP_001414275.1 | 10090 | g53393 | i0 | 31.8 | 5.05577689243028 | 85 | 50 | 94.4 | 2 | 2 | 238 | 208 | 290 | NP_001414275.1 pleckstrin homology domain-containing family A member 2 isoform 1 [Mus musculus] | diamond | 1269 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28974856 | 28974856 | PRJNA603943_P_NODE_13748_length_443_cov_1.964865_g13556_i0 | PRJNA603943 | 13748 | 443 | 1.964865 | 8.70435195 | Hypanus sabinus | 79690 | Chordata | Chordata | 57.4 | 2.31e-6 | NR | XP_059816063.1 | 79690 | g13556 | i0 | 36.4 | 1.41534988713318 | 107 | 59 | 68.4 | 3 | 41 | 343 | 170 | 273 | XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus] | diamond | 627 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 30396372 | 30396372 | PRJNA603943_P_NODE_54593_length_250_cov_0.870056_g54401_i0 | PRJNA603943 | 54593 | 250 | 0.870056 | 2.17514 | Chiloscyllium punctatum | 137246 | Chordata | Chordata | 91.7 | 4.46e-22 | NR | GCC48393.1 | 137246 | g54401 | i0 | 65.6 | 1.272 | 64 | 22 | 76.8 | 0 | 59 | 250 | 1 | 64 | GCC48393.1 hypothetical protein [Chiloscyllium punctatum] | diamond | 318 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium punctatum | |
| 30775234 | 30775234 | PRJNA603943_P_NODE_29094_length_333_cov_1.092308_g28902_i0 | PRJNA603943 | 29094 | 333 | 1.092308 | 3.63738564 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 164 | 5.059999999999999e-46 | NR | CAK8676928.1 | 159417 | g28902 | i0 | 67 | 1.96396396396396 | 109 | 36 | 98.2 | 0 | 329 | 3 | 160 | 268 | CAK8676928.1 unnamed protein product [Clavelina lepadiformis] | diamond | 654 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31818306 | 31818306 | PRJNA603943_P_NODE_46637_length_270_cov_1.532995_g46445_i0 | PRJNA603943 | 46637 | 270 | 1.532995 | 4.1390865 | Mesoplodon densirostris | 48708 | Chordata | Chordata | 43.9 | 0.0185 | NR | XP_059948101.1 | 48708 | g46445 | i0 | 39.1 | 0.511111111111111 | 46 | 28 | 51.1 | 0 | 250 | 113 | 116 | 161 | XP_059948101.1 LOW QUALITY PROTEIN: olfactory receptor 10H3-like [Mesoplodon densirostris] | diamond | 138 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Ziphiidae | Mesoplodon | Mesoplodon densirostris | |
| 32261652 | 32261652 | PRJNA603943_P_NODE_46298_length_271_cov_1.555556_g46106_i0 | PRJNA603943 | 46298 | 271 | 1.555556 | 4.21555676 | Engystomops pustulosus | 76066 | Chordata | Chordata | 61.6 | 1.22e-8 | NR | KAG8571490.1 | 76066 | g46106 | i0 | 48.2 | 6.58671586715867 | 85 | 44 | 94.1 | 0 | 255 | 1 | 1009 | 1093 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 1785 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32861041 | 32861041 | PRJNA603943_P_NODE_26080_length_347_cov_0.912409_g25888_i0 | PRJNA603943 | 26080 | 347 | 0.912409 | 3.16605923 | Styela clava | 7725 | Chordata | Chordata | 62.8 | 7.78e-9 | NR | XP_039263126.1 | 7725 | g25888 | i0 | 34 | 0.838616714697406 | 97 | 60 | 82.1 | 3 | 290 | 6 | 93 | 187 | XP_039263126.1 uncharacterized protein LOC120339116 isoform X2 [Styela clava] | diamond | 291 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava |
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);;