contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28862019 | 28862019 | PRJNA674048_P_NODE_29588_length_166_cov_0.888889_g29385_i0 | PRJNA674048 | 29588 | 166 | 0.888889 | 1.47555574 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.1 | 2.83e-6 | NR | XP_039606628.1 | 55291 | g29385 | i0 | 39 | 6.01807228915663 | 59 | 31 | 97.6 | 1 | 163 | 2 | 696 | 754 | XP_039606628.1 proprotein convertase subtilisin/kexin type 5b isoform X3 [Polypterus senegalus] | diamond | 999 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29209592 | 29209592 | PRJNA674048_P_NODE_21089_length_191_cov_3.119718_g20886_i0 | PRJNA674048 | 21089 | 191 | 3.119718 | 5.95866138 | Opisthokonta | 33154 | Chordata | Chordata | 55.5 | 9.76e-8 | NR | XP_019639315.1 | 7741 | g20886 | i0 | 48 | 3.89528795811518 | 50 | 26 | 78.5 | 0 | 181 | 32 | 81 | 130 | XP_019639315.1 PREDICTED: profilin-1A-like [Branchiostoma belcheri] | diamond | 744 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29765714 | 29765714 | PRJNA674048_P_NODE_20591_length_194_cov_1.434483_g20388_i0 | PRJNA674048 | 20591 | 194 | 1.434483 | 2.78289702 | Xenopus laevis | 8355 | Chordata | Chordata | 42 | 0.0379 | NR | XP_018096756.1 | 8355 | g20388 | i0 | 34.3 | 1.08247422680412 | 70 | 34 | 95.9 | 5 | 6 | 191 | 938 | 1003 | XP_018096756.1 SCO-spondin isoform X1 [Xenopus laevis] | diamond | 210 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 29797311 | 29797311 | PRJNA674048_P_NODE_26071_length_172_cov_1.121951_g25868_i0 | PRJNA674048 | 26071 | 172 | 1.121951 | 1.92975572 | Hymenochirus boettgeri | 247094 | Chordata | Chordata | 47.4 | 3.25e-4 | NR | KAG8441433.1 | 247094 | g25868 | i0 | 51.9 | 0.941860465116279 | 54 | 25 | 92.4 | 1 | 12 | 170 | 647 | 700 | KAG8441433.1 hypothetical protein GDO86_006974 [Hymenochirus boettgeri] | diamond | 162 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Hymenochirus | Hymenochirus boettgeri | |
| 30188360 | 30188360 | PRJNA674048_P_NODE_27352_length_169_cov_0.866667_g27149_i0 | PRJNA674048 | 27352 | 169 | 0.866667 | 1.46466723 | Metazoa | 33208 | Chordata | Chordata | 65.1 | 1.74e-10 | NR | XP_039251051.1 | 7725 | g27149 | i0 | 63.4 | 3.26627218934911 | 41 | 15 | 72.8 | 0 | 167 | 45 | 877 | 917 | XP_039251051.1 mucin-3A-like [Styela clava] | diamond | 552 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 30441378 | 30441378 | PRJNA674048_P_NODE_11173_length_278_cov_2.711790_g10970_i0 | PRJNA674048 | 11173 | 278 | 2.71179 | 7.5387762 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 103 | 2.73e-24 | NR | MEE6463730.1 | 8439 | g10970 | i0 | 72.6 | 80.341726618705 | 62 | 17 | 66.9 | 0 | 2 | 187 | 235 | 296 | MEE6463730.1 hypothetical protein [Ascaphus truei] | diamond | 22335 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 30757207 | 30757207 | PRJNA674048_P_NODE_16914_length_216_cov_2.035928_g16711_i0 | PRJNA674048 | 16914 | 216 | 2.035928 | 4.39760448 | Metazoa | 33208 | Chordata | Chordata | 94.7 | 1.28e-20 | NR | KAG2469906.1 | 55291 | g16711 | i0 | 78.3 | 24.9027777777778 | 69 | 15 | 95.8 | 0 | 9 | 215 | 839 | 907 | KAG2469906.1 GOGA1 protein, partial [Polypterus senegalus] | diamond | 5379 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31262760 | 31262760 | PRJNA674048_P_NODE_11395_length_275_cov_1.827434_g11192_i0 | PRJNA674048 | 11395 | 275 | 1.827434 | 5.0254435 | Chordata | 7711 | Chordata | Chordata | 45.8 | 0.00474 | NR | XP_053575473.1 | 8345 | g11192 | i0 | 69 | 1.0581818181818201 | 29 | 9 | 31.6 | 0 | 110 | 24 | 1255 | 1283 | XP_053575473.1 LOW QUALITY PROTEIN: hydrocephalus-inducing protein homolog [Bombina bombina] | diamond | 291 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 31978280 | 31978280 | PRJNA674048_P_NODE_23878_length_180_cov_1.465649_g23675_i0 | PRJNA674048 | 23878 | 180 | 1.465649 | 2.6381682 | Physeter macrocephalus | 9755 | Chordata | Chordata | 57 | 1.46e-7 | NR | XP_054944300.1 | 9755 | g23675 | i0 | 54.3 | 0.766666666666667 | 46 | 21 | 76.7 | 0 | 170 | 33 | 75 | 120 | XP_054944300.1 G-protein coupled receptor 176 isoform X1 [Physeter macrocephalus] | diamond | 138 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 32168429 | 32168429 | PRJNA674048_P_NODE_7618_length_355_cov_2.379085_g7415_i0 | PRJNA674048 | 7618 | 355 | 2.379085 | 8.44575175 | Hypanus sabinus | 79690 | Chordata | Chordata | 72 | 7.19e-12 | NR | XP_059816063.1 | 79690 | g7415 | i0 | 38.9 | 1.6056338028169 | 95 | 53 | 76.1 | 1 | 17 | 286 | 110 | 204 | XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus] | diamond | 570 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 32326806 | 32326806 | PRJNA674048_P_NODE_21959_length_188_cov_1.122302_g21756_i0 | PRJNA674048 | 21959 | 188 | 1.122302 | 2.10992776 | Ciona intestinalis | 7719 | Chordata | Chordata | 56.2 | 3.11e-7 | NR | XP_026690802.1 | 7719 | g21756 | i0 | 57.1 | 0.670212765957447 | 42 | 18 | 67 | 0 | 187 | 62 | 102 | 143 | XP_026690802.1 neurogenic locus notch homolog protein 1 [Ciona intestinalis] | diamond | 126 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 32358326 | 32358326 | PRJNA674048_P_NODE_28479_length_167_cov_0.881356_g28276_i0 | PRJNA674048 | 28479 | 167 | 0.881356 | 1.47186452 | Cyrtonyx montezumae | 9017 | Chordata | Chordata | 61.6 | 2.9e-9 | NR | XP_065587235.1 | 9017 | g28276 | i0 | 58 | 4.65269461077844 | 50 | 21 | 89.8 | 0 | 165 | 16 | 504 | 553 | XP_065587235.1 LOW QUALITY PROTEIN: probable ATP-dependent RNA helicase DHX34 [Cyrtonyx montezumae] | diamond | 777 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Odontophoridae | Cyrtonyx | Cyrtonyx montezumae | |
| 32799676 | 32799676 | PRJNA674048_P_NODE_13000_length_252_cov_2.093596_g12797_i0 | PRJNA674048 | 13000 | 252 | 2.093596 | 5.27586192 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 65.9 | 2.38e-10 | NR | XP_051791274.1 | 27687 | g12797 | i0 | 48.2 | 4.94047619047619 | 83 | 16 | 98.8 | 1 | 3 | 251 | 175 | 230 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 1245 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32906142 | 32906142 | PRJNA674048_P_NODE_28460_length_167_cov_0.881356_g28257_i0 | PRJNA674048 | 28460 | 167 | 0.881356 | 1.47186452 | Anura | 8342 | Chordata | Chordata | 83.6 | 5.41e-17 | NR | MEE6520153.1 | 8439 | g28257 | i0 | 65.5 | 11.8562874251497 | 55 | 19 | 98.8 | 0 | 167 | 3 | 902 | 956 | MEE6520153.1 hypothetical protein [Ascaphus truei] | diamond | 1980 | 84.3 | 0.991696322657177 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei |
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);;