contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA401346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2964902 | 2964902 | PRJNA401346_P_NODE_183_length_1029_cov_1.977273_g173_i0 | PRJNA401346 | 183 | 1029 | 1.977273 | 20.34613917 | Romerolagus diazi | 48089 | Chordata | Chordata | 486 | 2.0099999999999998e-170 | NR | AIM44674.1 | 48089 | g173 | i0 | 76.4 | 6.40816326530612 | 314 | 66 | 91.5 | 2 | 14 | 955 | 17 | 322 | AIM44674.1 immunoglobulin gamma heavy chain constant region, partial [Romerolagus diazi] | diamond | 6594 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Romerolagus | Romerolagus diazi | |
| 15716968 | 15716968 | PRJNA401346_P_NODE_513_length_642_cov_1.265060_g493_i0 | PRJNA401346 | 513 | 642 | 1.26506 | 8.1216852 | Metazoa | 33208 | Chordata | Chordata | 298 | 6.85e-98 | NR | XP_039263546.1 | 7725 | g493 | i0 | 66.5 | 2.87383177570093 | 209 | 68 | 96.7 | 1 | 629 | 9 | 130 | 338 | XP_039263546.1 cathepsin B-like [Styela clava] | diamond | 1845 | 299 | 0.996655518394649 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 19540140 | 19540140 | PRJNA401346_P_NODE_836_length_508_cov_1.505593_g815_i0 | PRJNA401346 | 836 | 508 | 1.505593 | 7.64841244 | Lepus europaeus | 9983 | Chordata | Chordata | 137 | 6.69e-34 | NR | XP_062067949.1 | 9983 | g815 | i0 | 55.1 | 1.03937007874016 | 176 | 69 | 99.8 | 3 | 507 | 1 | 1689 | 1861 | XP_062067949.1 cardiomyopathy-associated protein 5 [Lepus europaeus] | diamond | 528 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Lepus | Lepus europaeus | |
| 26726864 | 26726864 | PRJNA401346_P_NODE_7781_length_204_cov_0.895105_g7760_i0 | PRJNA401346 | 7781 | 204 | 0.895105 | 1.8260142 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 42.4 | 0.0305 | NR | XP_069928339.1 | 9986 | g7760 | i0 | 76 | 0.367647058823529 | 25 | 6 | 36.8 | 0 | 202 | 128 | 645 | 669 | XP_069928339.1 solute carrier family 12 member 8 isoform X2 [Oryctolagus cuniculus] | diamond | 75 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 27345207 | 27345207 | PRJNA401346_P_NODE_8803_length_201_cov_0.914286_g8782_i0 | PRJNA401346 | 8803 | 201 | 0.914286 | 1.83771486 | Metazoa | 33208 | Chordata | Chordata | 100 | 3.36e-23 | NR | XP_045709291.1 | 9423 | g8782 | i0 | 67.2 | 103.537313432836 | 67 | 22 | 100 | 0 | 1 | 201 | 54 | 120 | XP_045709291.1 calreticulin-3 [Phyllostomus hastatus] | diamond | 20811 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus hastatus | |
| 27534528 | 27534528 | PRJNA401346_P_NODE_7143_length_206_cov_0.882759_g7122_i0 | PRJNA401346 | 7143 | 206 | 0.882759 | 1.81848354 | Chordata | 7711 | Chordata | Chordata | 54.7 | 1.4e-6 | NR | XP_044291388.1 | 61221 | g7122 | i0 | 44.1 | 10.4708737864078 | 68 | 38 | 99 | 0 | 205 | 2 | 675 | 742 | XP_044291388.1 relA-associated inhibitor [Varanus komodoensis] | diamond | 2157 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 27565921 | 27565921 | PRJNA401346_P_NODE_7424_length_205_cov_0.888889_g7403_i0 | PRJNA401346 | 7424 | 205 | 0.888889 | 1.82222245 | Mammalia | 40674 | Chordata | Chordata | 65.1 | 3.05e-10 | NR | XP_051683780.2 | 9986 | g7403 | i0 | 100 | 1.81463414634146 | 31 | 0 | 45.4 | 0 | 112 | 204 | 1 | 31 | XP_051683780.2 rho-associated protein kinase 2 isoform X1 [Oryctolagus cuniculus] | diamond | 372 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 27660938 | 27660938 | PRJNA401346_P_NODE_5084_length_236_cov_1.937143_g5063_i0 | PRJNA401346 | 5084 | 236 | 1.937143 | 4.57165748 | Opisthokonta | 33154 | Chordata | Chordata | 77.4 | 2.91e-15 | NR | CBY41553.1 | 34765 | g5063 | i0 | 67.9 | 2.02118644067797 | 53 | 17 | 67.4 | 0 | 235 | 77 | 163 | 215 | CBY41553.1 unnamed protein product [Oikopleura dioica] | diamond | 477 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 28749183 | 28749183 | PRJNA401346_P_NODE_7407_length_205_cov_1.298611_g7386_i0 | PRJNA401346 | 7407 | 205 | 1.298611 | 2.66215255 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 43.9 | 0.00892 | NR | XP_069914521.1 | 9986 | g7386 | i0 | 47.9 | 0.702439024390244 | 48 | 23 | 70.2 | 2 | 145 | 2 | 430 | 475 | XP_069914521.1 cyclin-dependent kinase 14 isoform X3 [Oryctolagus cuniculus] | diamond | 144 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 28843719 | 28843719 | PRJNA401346_P_NODE_8208_length_203_cov_0.901408_g8187_i0 | PRJNA401346 | 8208 | 203 | 0.901408 | 1.82985824 | Phyllostomus discolor | 89673 | Chordata | Chordata | 54.3 | 2.79e-7 | NR | KAF6120004.1 | 89673 | g8187 | i0 | 43.1 | 0.960591133004926 | 65 | 36 | 94.6 | 1 | 201 | 10 | 1 | 65 | KAF6120004.1 hypothetical protein HJG60_010341 [Phyllostomus discolor] | diamond | 195 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 29380649 | 29380649 | PRJNA401346_P_NODE_3669_length_273_cov_1.509434_g3648_i0 | PRJNA401346 | 3669 | 273 | 1.509434 | 4.12075482 | Oikopleura dioica | 34765 | Chordata | Chordata | 97.4 | 1.5699999999999994e-23 | NR | CAG5105686.1 | 34765 | g3648 | i0 | 45 | 1.0989010989011 | 100 | 45 | 98.9 | 1 | 2 | 271 | 33 | 132 | CAG5105686.1 Oidioi.mRNA.OKI2018_I69.chr1.g2360.t1.cds [Oikopleura dioica] | diamond | 300 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 29822478 | 29822478 | PRJNA401346_P_NODE_6311_length_209_cov_0.864865_g6290_i0 | PRJNA401346 | 6311 | 209 | 0.864865 | 1.80756785 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 43.9 | 0.00823 | NR | XP_069908675.1 | 9986 | g6290 | i0 | 50 | 1.27751196172249 | 30 | 15 | 43.1 | 0 | 3 | 92 | 187 | 216 | XP_069908675.1 ras association domain-containing protein 3 isoform X2 [Oryctolagus cuniculus] | diamond | 267 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 31592602 | 31592602 | PRJNA401346_P_NODE_8576_length_202_cov_0.907801_g8555_i0 | PRJNA401346 | 8576 | 202 | 0.907801 | 1.83375802 | Bubalus bubalis | 89462 | Chordata | Chordata | 119 | 3.31e-29 | NR | XP_045021824.1 | 89462 | g8555 | i0 | 100 | 2.98514851485149 | 67 | 0 | 99.5 | 0 | 2 | 202 | 250 | 316 | XP_045021824.1 ski oncogene [Bubalus bubalis] | diamond | 603 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bubalus | Bubalus bubalis | |
| 32478495 | 32478495 | PRJNA401346_P_NODE_7319_length_206_cov_0.882759_g7298_i0 | PRJNA401346 | 7319 | 206 | 0.882759 | 1.81848354 | Choloepus didactylus | 27675 | Chordata | Chordata | 57 | 2.17e-7 | NR | XP_037701581.1 | 27675 | g7298 | i0 | 65.2 | 4.00485436893204 | 46 | 16 | 67 | 0 | 143 | 6 | 534 | 579 | XP_037701581.1 nascent polypeptide-associated complex subunit alpha, muscle-specific form-like [Choloepus didactylus] | diamond | 825 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus |
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);;