contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17304424 | 17304424 | PRJNA751877_P_NODE_2174_length_568_cov_2.424242_g2053_i0 | PRJNA751877 | 2174 | 568 | 2.424242 | 13.76969456 | Opisthokonta | 33154 | Chordata | Chordata | 81.6 | 2.23e-16 | NR | CAG5105596.1 | 34765 | g2053 | i0 | 69.1 | 3.21654929577465 | 110 | 34 | 58.1 | 0 | 21 | 350 | 1 | 110 | CAG5105596.1 Oidioi.mRNA.OKI2018_I69.chr1.g2273.t1.cds [Oikopleura dioica] | diamond | 1827 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 27115766 | 27115766 | PRJNA751877_P_NODE_7902_length_375_cov_1.019868_g7780_i0 | PRJNA751877 | 7902 | 375 | 1.019868 | 3.824505 | Phaenicophaeus curvirostris | 33595 | Chordata | Chordata | 176 | 1.37e-51 | NR | XP_069737843.1 | 33595 | g7780 | i0 | 66.7 | 27.52 | 123 | 41 | 98.4 | 0 | 373 | 5 | 128 | 250 | XP_069737843.1 cytochrome c1, heme protein, mitochondrial-like [Phaenicophaeus curvirostris] | diamond | 10320 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Cuculiformes | Cuculidae | Phaenicophaeus | Phaenicophaeus curvirostris | |
| 27463727 | 27463727 | PRJNA751877_P_NODE_25523_length_247_cov_0.885057_g25401_i0 | PRJNA751877 | 25523 | 247 | 0.885057 | 2.18609079 | Peromyscus leucopus | 10041 | Chordata | Chordata | 47.4 | 7.69e-4 | NR | XP_037056799.1 | 10041 | g25401 | i0 | 60 | 1.82186234817814 | 50 | 20 | 60.7 | 0 | 246 | 97 | 164 | 213 | XP_037056799.1 LOW QUALITY PROTEIN: 40S ribosomal protein S6-like [Peromyscus leucopus] | diamond | 450 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Peromyscus | Peromyscus leucopus | |
| 28000565 | 28000565 | PRJNA751877_P_NODE_25105_length_248_cov_0.880000_g24983_i0 | PRJNA751877 | 25105 | 248 | 0.88 | 2.1824 | Sciurus carolinensis | 30640 | Chordata | Chordata | 49.7 | 7.87e-5 | NR | MBZ3870293.1 | 30640 | g24983 | i0 | 50.9 | 1.39112903225806 | 57 | 26 | 66.5 | 1 | 8 | 172 | 96 | 152 | MBZ3870293.1 60S acidic ribosomal protein P2 [Sciurus carolinensis] | diamond | 345 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 28947832 | 28947832 | PRJNA751877_P_NODE_16988_length_284_cov_1.379147_g16866_i0 | PRJNA751877 | 16988 | 284 | 1.379147 | 3.91677748 | Ranitomeya imitator | 111125 | Chordata | Chordata | 76.3 | 1.01e-13 | NR | CAJ0964531.1 | 111125 | g16866 | i0 | 50 | 3.08450704225352 | 68 | 32 | 71.8 | 1 | 3 | 206 | 759 | 824 | CAJ0964531.1 unnamed protein product [Ranitomeya imitator] | diamond | 876 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29799970 | 29799970 | PRJNA751877_P_NODE_24731_length_248_cov_0.880000_g24609_i0 | PRJNA751877 | 24731 | 248 | 0.88 | 2.1824 | Candoia aspera | 51853 | Chordata | Chordata | 48.5 | 3.63e-4 | NR | XP_063147205.1 | 51853 | g24609 | i0 | 50 | 1.23387096774194 | 36 | 18 | 43.5 | 0 | 114 | 7 | 284 | 319 | XP_063147205.1 uncharacterized protein LOC134488789 [Candoia aspera] | diamond | 306 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Boidae | Candoia | Candoia aspera | |
| 29841624 | 29841624 | PRJNA751877_P_NODE_6751_length_394_cov_2.398754_g6629_i0 | PRJNA751877 | 6751 | 394 | 2.398754 | 9.45109076 | Metazoa | 33208 | Chordata | Chordata | 56.6 | 2.32e-6 | NR | XP_021482117.1 | 10047 | g6629 | i0 | 35.7 | 1.43908629441624 | 98 | 59 | 74.6 | 2 | 23 | 316 | 110 | 203 | XP_021482117.1 cathepsin 8-like [Meriones unguiculatus] | diamond | 567 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus | |
| 30337585 | 30337585 | PRJNA751877_P_NODE_19552_length_268_cov_1.287179_g19430_i0 | PRJNA751877 | 19552 | 268 | 1.287179 | 3.44963972 | Polypterus senegalus | 55291 | Chordata | Chordata | 55.5 | 1.56e-6 | NR | KAG2468153.1 | 55291 | g19430 | i0 | 71.4 | 1.72388059701493 | 35 | 10 | 39.2 | 0 | 164 | 268 | 239 | 273 | KAG2468153.1 TC1A transposase, partial [Polypterus senegalus] | diamond | 462 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31538311 | 31538311 | PRJNA751877_P_NODE_29616_length_242_cov_0.869822_g29494_i0 | PRJNA751877 | 29616 | 242 | 0.869822 | 2.10496924 | Xenopus tropicalis | 8364 | Chordata | Chordata | 52 | 1.46e-5 | NR | NP_001005817.1 | 8364 | g29494 | i0 | 41 | 0.966942148760331 | 78 | 44 | 94.2 | 1 | 2 | 229 | 18 | 95 | NP_001005817.1 oxidoreductase HTATIP2 [Xenopus tropicalis] | diamond | 234 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32139228 | 32139228 | PRJNA751877_P_NODE_17478_length_281_cov_1.447115_g17356_i0 | PRJNA751877 | 17478 | 281 | 1.447115 | 4.06639315 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 53.9 | 6.94e-6 | NR | XP_028670689.1 | 27687 | g17356 | i0 | 35.2 | 0.939501779359431 | 88 | 57 | 94 | 0 | 272 | 9 | 719 | 806 | XP_028670689.1 major vault protein [Erpetoichthys calabaricus] | diamond | 264 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32465726 | 32465726 | PRJNA751877_P_NODE_6259_length_404_cov_1.628399_g6137_i0 | PRJNA751877 | 6259 | 404 | 1.628399 | 6.57873196 | Branchiostoma | 7737 | Chordata | Chordata | 85.5 | 1.25e-16 | NR | XP_035689996.1 | 7739 | g6137 | i0 | 66.2 | 1.4480198019802 | 65 | 21 | 47.5 | 1 | 399 | 208 | 296 | 360 | XP_035689996.1 conditioned medium factor receptor 1-like [Branchiostoma floridae] | diamond | 585 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32613549 | 32613549 | PRJNA751877_P_NODE_25220_length_247_cov_1.666667_g25098_i0 | PRJNA751877 | 25220 | 247 | 1.666667 | 4.11666749 | Trichechus manatus latirostris | 127582 | Chordata | Chordata | 43.1 | 0.0302 | NR | XP_023587948.1 | 127582 | g25098 | i0 | 32.9 | 0.995951417004049 | 82 | 54 | 98.4 | 1 | 247 | 5 | 1445 | 1526 | XP_023587948.1 intermembrane lipid transfer protein VPS13D isoform X4 [Trichechus manatus latirostris] | diamond | 246 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Sirenia | Trichechidae | Trichechus | Trichechus manatus | |
| 32833926 | 32833926 | PRJNA751877_P_NODE_24200_length_249_cov_0.875000_g24078_i0 | PRJNA751877 | 24200 | 249 | 0.875 | 2.17875 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 46.2 | 0.00239 | NR | XP_066266064.1 | 7740 | g24078 | i0 | 65.5 | 0.349397590361446 | 29 | 10 | 34.9 | 0 | 3 | 89 | 11 | 39 | XP_066266064.1 protein phosphatase 1 regulatory subunit 12A-like isoform X6 [Branchiostoma lanceolatum] | diamond | 87 | 46.2 | 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);;