contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26643092 | 26643092 | PRJNA846486_P_NODE_88361_length_164_cov_0.904348_g88265_i0 | PRJNA846486 | 88361 | 164 | 0.904348 | 1.48313072 | Malaclemys terrapin pileata | 2991368 | Chordata | Chordata | 52.8 | 3.2e-6 | NR | XP_053886307.1 | 2991368 | g88265 | i0 | 46 | 0.914634146341463 | 50 | 27 | 91.5 | 0 | 14 | 163 | 107 | 156 | XP_053886307.1 uncharacterized protein LOC128838280 [Malaclemys terrapin pileata] | diamond | 150 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Malaclemys | Malaclemys terrapin | ||
| 26936537 | 26936537 | PRJNA846486_P_NODE_73802_length_171_cov_1.204918_g73706_i0 | PRJNA846486 | 73802 | 171 | 1.204918 | 2.06040978 | Metazoa | 33208 | Chordata | Chordata | 104 | 1.68e-24 | NR | XP_044151372.1 | 30331 | g73706 | i0 | 92.9 | 14.7017543859649 | 56 | 4 | 98.2 | 0 | 2 | 169 | 338 | 393 | XP_044151372.1 protein ZBED8-like [Bufo gargarizans] | diamond | 2514 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo gargarizans | |
| 27023122 | 27023122 | PRJNA846486_P_NODE_42202_length_211_cov_1.333333_g42106_i0 | PRJNA846486 | 42202 | 211 | 1.333333 | 2.81333263 | Chrysochloris asiatica | 185453 | Chordata | Chordata | 47.4 | 5.8e-4 | NR | XP_006871840.1 | 185453 | g42106 | i0 | 42.6 | 1.4218009478673 | 54 | 28 | 76.8 | 1 | 11 | 172 | 55 | 105 | XP_006871840.1 PREDICTED: MORN repeat-containing protein 1 [Chrysochloris asiatica] | diamond | 300 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chrysochloridae | Chrysochloris | Chrysochloris asiatica | ||
| 27054857 | 27054857 | PRJNA846486_P_NODE_35922_length_225_cov_1.085227_g35826_i0 | PRJNA846486 | 35922 | 225 | 1.085227 | 2.44176075 | Callorhinchus milii | 7868 | Chordata | Chordata | 150 | 1.18e-40 | NR | XP_042202422.1 | 7868 | g35826 | i0 | 97.3 | 5.92 | 74 | 2 | 98.7 | 0 | 3 | 224 | 515 | 588 | XP_042202422.1 uncharacterized protein LOC121852521 [Callorhinchus milii] | diamond | 1332 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 28097029 | 28097029 | PRJNA846486_P_NODE_94165_length_162_cov_0.920354_g94069_i0 | PRJNA846486 | 94165 | 162 | 0.920354 | 1.49097348 | Crocuta crocuta | 9678 | Chordata | Chordata | 40.8 | 0.0255 | NR | KAF0878112.1 | 9678 | g94069 | i0 | 44.1 | 0.62962962962963 | 34 | 19 | 63 | 0 | 22 | 123 | 72 | 105 | KAF0878112.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 102 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 28949782 | 28949782 | PRJNA846486_P_NODE_77128_length_169_cov_0.866667_g77032_i0 | PRJNA846486 | 77128 | 169 | 0.866667 | 1.46466723 | Rana temporaria | 8407 | Chordata | Chordata | 74.3 | 1e-13 | NR | XP_040217006.1 | 8407 | g77032 | i0 | 71.4 | 16.1005917159763 | 49 | 14 | 87 | 0 | 148 | 2 | 3 | 51 | XP_040217006.1 general transcription factor II-I repeat domain-containing protein 2B-like [Rana temporaria] | diamond | 2721 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 29612250 | 29612250 | PRJNA846486_P_NODE_11230_length_370_cov_2.950156_g11135_i0 | PRJNA846486 | 11230 | 370 | 2.950156 | 10.9155772 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 130 | 5.6e-34 | NR | XP_051791274.1 | 27687 | g11135 | i0 | 76.7 | 6.63243243243243 | 90 | 20 | 72.2 | 1 | 33 | 299 | 115 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2454 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 30054600 | 30054600 | PRJNA846486_P_NODE_89351_length_164_cov_0.878261_g89255_i0 | PRJNA846486 | 89351 | 164 | 0.878261 | 1.44034804 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.9 | 0.00462 | NR | XP_039600437.1 | 55291 | g89255 | i0 | 70.4 | 0.49390243902439 | 27 | 8 | 49.4 | 0 | 141 | 61 | 20 | 46 | XP_039600437.1 protein FAM3B-like isoform X2 [Polypterus senegalus] | diamond | 81 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30094607 | 30094607 | PRJNA846486_P_NODE_30032_length_241_cov_1.625000_g29936_i0 | PRJNA846486 | 30032 | 241 | 1.625 | 3.91625 | Metazoa | 33208 | Chordata | Chordata | 85.1 | 2.7e-17 | NR | XP_035679889.1 | 7739 | g29936 | i0 | 52.5 | 3.95850622406639 | 80 | 36 | 97.1 | 1 | 8 | 241 | 254 | 333 | XP_035679889.1 cysteine proteinase 1-like [Branchiostoma floridae] | diamond | 954 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30189490 | 30189490 | PRJNA846486_P_NODE_83572_length_166_cov_0.888889_g83476_i0 | PRJNA846486 | 83572 | 166 | 0.888889 | 1.47555574 | Chordata | 7711 | Chordata | Chordata | 62.8 | 1.12e-9 | NR | XP_006007181.1 | 7897 | g83476 | i0 | 100 | 144 | 24 | 0 | 43.4 | 0 | 166 | 95 | 293 | 316 | XP_006007181.1 protein-lysine 6-oxidase [Latimeria chalumnae] | diamond | 23904 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 30979606 | 30979606 | PRJNA846486_P_NODE_82234_length_167_cov_0.864407_g82138_i0 | PRJNA846486 | 82234 | 167 | 0.864407 | 1.44355969 | Chordata | 7711 | Chordata | Chordata | 58.2 | 4.78e-8 | NR | MEE6512861.1 | 8439 | g82138 | i0 | 100 | 11.6407185628743 | 27 | 0 | 48.5 | 0 | 167 | 87 | 160 | 186 | MEE6512861.1 hypothetical protein [Ascaphus truei] | diamond | 1944 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 31137104 | 31137104 | PRJNA846486_P_NODE_56975_length_189_cov_0.871429_g56879_i0 | PRJNA846486 | 56975 | 189 | 0.871429 | 1.64700081 | Chordata | 7711 | Chordata | Chordata | 58.5 | 4.73e-8 | NR | KAE8579759.1 | 8364 | g56879 | i0 | 59.1 | 34.2222222222222 | 44 | 18 | 69.8 | 0 | 53 | 184 | 65 | 108 | KAE8579759.1 hypothetical protein XENTR_v10024172 [Xenopus tropicalis] | diamond | 6468 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32086295 | 32086295 | PRJNA846486_P_NODE_34338_length_229_cov_1.094444_g34242_i0 | PRJNA846486 | 34338 | 229 | 1.094444 | 2.50627676 | Bufo | 8383 | Chordata | Chordata | 146 | 1.8799999999999993e-40 | NR | XP_040283232.1 | 8384 | g34242 | i0 | 98.7 | 11.7903930131004 | 75 | 1 | 98.3 | 0 | 227 | 3 | 136 | 210 | XP_040283232.1 protein ZBED8-like [Bufo bufo] | diamond | 2700 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 32244827 | 32244827 | PRJNA846486_P_NODE_77158_length_169_cov_0.866667_g77062_i0 | PRJNA846486 | 77158 | 169 | 0.866667 | 1.46466723 | Chordata | 7711 | Chordata | Chordata | 59.3 | 1.99e-8 | NR | XP_038647155.1 | 7830 | g77062 | i0 | 100 | 111.355029585799 | 29 | 0 | 51.5 | 0 | 169 | 83 | 472 | 500 | XP_038647155.1 protein furry homolog-like isoform X15 [Scyliorhinus canicula] | diamond | 18819 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 32521151 | 32521151 | PRJNA846486_P_NODE_51059_length_196_cov_1.972789_g50963_i0 | PRJNA846486 | 51059 | 196 | 1.972789 | 3.86666644 | Ascaphus truei | 8439 | Chordata | Chordata | 47 | 6.61e-4 | NR | MEE6482045.1 | 8439 | g50963 | i0 | 39.3 | 0.933673469387755 | 61 | 21 | 93.4 | 1 | 183 | 1 | 805 | 849 | MEE6482045.1 hypothetical protein [Ascaphus truei] | diamond | 183 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 32615564 | 32615564 | PRJNA846486_P_NODE_94060_length_162_cov_0.920354_g93964_i0 | PRJNA846486 | 94060 | 162 | 0.920354 | 1.49097348 | Staurois parvus | 386267 | Chordata | Chordata | 70.5 | 5.65e-13 | NR | CAI9569939.1 | 386267 | g93964 | i0 | 68.3 | 4.48148148148148 | 41 | 9 | 68.5 | 1 | 51 | 161 | 175 | 215 | CAI9569939.1 unnamed protein product, partial [Staurois parvus] | diamond | 726 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32646665 | 32646665 | PRJNA846486_P_NODE_9240_length_406_cov_0.739496_g9145_i0 | PRJNA846486 | 9240 | 406 | 0.739496 | 3.00235376 | Myxine glutinosa | 7769 | Chordata | Chordata | 60.8 | 9.65e-8 | NR | XP_067964918.1 | 7769 | g9145 | i0 | 63.3 | 0.443349753694581 | 60 | 17 | 40.6 | 3 | 77 | 241 | 354 | 413 | XP_067964918.1 WD repeat-containing protein 18 isoform X1 [Myxine glutinosa] | diamond | 180 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 32741639 | 32741639 | PRJNA846486_P_NODE_54040_length_192_cov_1.692308_g53944_i0 | PRJNA846486 | 54040 | 192 | 1.692308 | 3.24923136 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 69.3 | 7.86e-12 | NR | CAH1269567.1 | 7740 | g53944 | i0 | 50.8 | 1.90625 | 61 | 30 | 95.3 | 0 | 184 | 2 | 431 | 491 | CAH1269567.1 CTSF [Branchiostoma lanceolatum] | diamond | 366 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum |
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);;