contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5386795 | 5386795 | PRJNA1132896_P_NODE_1105_length_494_cov_1.736342_g1014_i0 | PRJNA1132896 | 1105 | 494 | 1.736342 | 8.57752948 | Opisthokonta | 33154 | Chordata | Chordata | 220 | 8.57e-67 | NR | XP_027306665.2 | 8839 | g1014 | i0 | 67.1 | 72.0971659919028 | 164 | 53 | 99.6 | 1 | 493 | 2 | 292 | 454 | XP_027306665.2 60S ribosomal protein L3 [Anas platyrhynchos] | diamond | 35616 | 221 | 0.995475113122172 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas platyrhynchos | |
| 8684851 | 8684851 | PRJNA1132896_P_NODE_3587_length_299_cov_2.300885_g3496_i0 | PRJNA1132896 | 3587 | 299 | 2.300885 | 6.87964615 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 146 | 2.02e-40 | NR | NP_001085326.1 | 8355 | g3496 | i0 | 74 | 11.0167224080268 | 100 | 24 | 99.3 | 2 | 1 | 297 | 37 | 135 | NP_001085326.1 malate dehydrogenase 2 S homeolog [Xenopus laevis] | diamond | 3294 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 13037339 | 13037339 | PRJNA1132896_P_NODE_471_length_760_cov_1.588064_g386_i0 | PRJNA1132896 | 471 | 760 | 1.588064 | 12.0692864 | Metazoa | 33208 | Chordata | Chordata | 326 | 4.0799999999999978e-106 | NR | KAK9400253.1 | 8729 | g386 | i0 | 62.8 | 73.2039473684211 | 250 | 93 | 98.7 | 0 | 3 | 752 | 63 | 312 | KAK9400253.1 rab GDP dissociation inhibitor beta [Crotalus adamanteus] | diamond | 55635 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 14312545 | 14312545 | PRJNA1132896_P_NODE_3792_length_292_cov_2.045662_g3701_i0 | PRJNA1132896 | 3792 | 292 | 2.045662 | 5.97333304 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 141 | 2.88e-38 | NR | XP_032830315.1 | 7757 | g3701 | i0 | 76.8 | 20.958904109589 | 82 | 18 | 83.2 | 1 | 3 | 245 | 71 | 152 | XP_032830315.1 actin-related protein 2/3 complex subunit 1A-like [Petromyzon marinus] | diamond | 6120 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 15059458 | 15059458 | PRJNA1132896_P_NODE_2572_length_344_cov_1.416974_g2481_i0 | PRJNA1132896 | 2572 | 344 | 1.416974 | 4.87439056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 153 | 1.91e-44 | NR | XP_043940687.1 | 7888 | g2481 | i0 | 68.9 | 4.55232558139535 | 103 | 32 | 89.8 | 0 | 29 | 337 | 6 | 108 | XP_043940687.1 peroxiredoxin-2 [Protopterus annectens] | diamond | 1566 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 18135367 | 18135367 | PRJNA1132896_P_NODE_2455_length_350_cov_4.223827_g2364_i0 | PRJNA1132896 | 2455 | 350 | 4.223827 | 14.7833945 | Opisthokonta | 33154 | Chordata | Chordata | 215 | 1.6e-69 | NR | XP_019621907.1 | 7741 | g2364 | i0 | 87 | 38.3657142857143 | 115 | 15 | 98.6 | 0 | 347 | 3 | 1 | 115 | XP_019621907.1 PREDICTED: peptidyl-prolyl cis-trans isomerase-like [Branchiostoma belcheri] | diamond | 13428 | 217 | 0.990783410138249 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27196574 | 27196574 | PRJNA1132896_P_NODE_2182_length_368_cov_1.044068_g2091_i0 | PRJNA1132896 | 2182 | 368 | 1.044068 | 3.84217024 | Ranitomeya imitator | 111125 | Chordata | Chordata | 69.7 | 4.74e-11 | NR | CAJ0964204.1 | 111125 | g2091 | i0 | 73 | 0.91304347826087 | 37 | 10 | 30.2 | 0 | 233 | 123 | 15 | 51 | CAJ0964204.1 unnamed protein product [Ranitomeya imitator] | diamond | 336 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 27765500 | 27765500 | PRJNA1132896_P_NODE_3684_length_296_cov_1.726457_g3593_i0 | PRJNA1132896 | 3684 | 296 | 1.726457 | 5.11031272 | Pseudophryne corroboree | 495146 | Chordata | Chordata | 69.7 | 5e-12 | NR | XP_063814617.1 | 495146 | g3593 | i0 | 46.1 | 0.77027027027027 | 76 | 37 | 73 | 2 | 271 | 56 | 3 | 78 | XP_063814617.1 glutathione S-transferase P 1-like [Pseudophryne corroboree] | diamond | 228 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Myobatrachidae | Pseudophryne | Pseudophryne corroboree | |
| 28554828 | 28554828 | PRJNA1132896_P_NODE_5767_length_264_cov_1.000000_g5676_i0 | PRJNA1132896 | 5767 | 264 | 1 | 2.64 | Spea bombifrons | 233779 | Chordata | Chordata | 57 | 4.69e-7 | NR | XP_053318521.1 | 233779 | g5676 | i0 | 50.8 | 14.2727272727273 | 59 | 27 | 64.8 | 1 | 3 | 173 | 1397 | 1455 | XP_053318521.1 leucine-rich repeat serine/threonine-protein kinase 2 isoform X2 [Spea bombifrons] | diamond | 3768 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pelobatidae | Spea | Spea bombifrons | |
| 28733283 | 28733283 | PRJNA1132896_P_NODE_7307_length_250_cov_0.870056_g7216_i0 | PRJNA1132896 | 7307 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.5 | 2.26e-8 | NR | XP_015676811.1 | 103944 | g7216 | i0 | 43.3 | 2.328 | 67 | 38 | 80.4 | 0 | 41 | 241 | 8 | 74 | XP_015676811.1 importin-4, partial [Protobothrops mucrosquamatus] | diamond | 582 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Protobothrops | Protobothrops mucrosquamatus | |
| 29049044 | 29049044 | PRJNA1132896_P_NODE_5128_length_273_cov_1.375000_g5037_i0 | PRJNA1132896 | 5128 | 273 | 1.375 | 3.75375 | Aves | 8782 | Chordata | Chordata | 77 | 5.73e-15 | NR | KAI6078827.1 | 8832 | g5037 | i0 | 57.1 | 6.94505494505495 | 70 | 29 | 76.9 | 1 | 265 | 56 | 81 | 149 | KAI6078827.1 Calmodulin, striated muscle [Aix galericulata] | diamond | 1896 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Aix | Aix galericulata | |
| 29690973 | 29690973 | PRJNA1132896_P_NODE_10170_length_241_cov_0.916667_g10079_i0 | PRJNA1132896 | 10170 | 241 | 0.916667 | 2.20916747 | Pristis pectinata | 685728 | Chordata | Chordata | 56.6 | 4.42e-7 | NR | XP_051885610.1 | 685728 | g10079 | i0 | 41.7 | 1.85477178423237 | 72 | 42 | 89.6 | 0 | 21 | 236 | 312 | 383 | XP_051885610.1 rho GTPase-activating protein 1 [Pristis pectinata] | diamond | 447 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rhinopristiformes | Pristidae | Pristis | Pristis pectinata | |
| 29817456 | 29817456 | PRJNA1132896_P_NODE_6311_length_256_cov_1.677596_g6220_i0 | PRJNA1132896 | 6311 | 256 | 1.677596 | 4.29464576 | Styela clava | 7725 | Chordata | Chordata | 75.9 | 9.41e-14 | NR | XP_039248804.1 | 7725 | g6220 | i0 | 58.3 | 1.40625 | 60 | 24 | 69.1 | 1 | 78 | 254 | 363 | 422 | XP_039248804.1 hephaestin-like protein [Styela clava] | diamond | 360 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 30228229 | 30228229 | PRJNA1132896_P_NODE_10092_length_241_cov_1.375000_g10001_i0 | PRJNA1132896 | 10092 | 241 | 1.375 | 3.31375 | Pitangus sulphuratus | 371930 | Chordata | Chordata | 53.9 | 4.22e-6 | NR | KAJ7422224.1 | 371930 | g10001 | i0 | 44.1 | 0.734439834024896 | 59 | 31 | 73.4 | 1 | 193 | 17 | 56 | 112 | KAJ7422224.1 hypothetical protein BTVI_15104 [Pitangus sulphuratus] | diamond | 177 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Tyrannidae | Pitangus | Pitangus sulphuratus | |
| 30228233 | 30228233 | PRJNA1132896_P_NODE_5592_length_266_cov_1.595855_g5501_i0 | PRJNA1132896 | 5592 | 266 | 1.595855 | 4.2449743 | Lerista edwardsae | 470340 | Chordata | Chordata | 49.7 | 1.19e-4 | NR | KAJ6663434.1 | 470340 | g5501 | i0 | 37.3 | 1.91729323308271 | 67 | 40 | 73.3 | 1 | 46 | 240 | 141 | 207 | KAJ6663434.1 hypothetical protein lerEdw1_009513 [Lerista edwardsae] | diamond | 510 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Lerista | Lerista edwardsae | |
| 30849275 | 30849275 | PRJNA1132896_P_NODE_1774_length_402_cov_2.559271_g1683_i0 | PRJNA1132896 | 1774 | 402 | 2.559271 | 10.28826942 | Branchiostoma | 7737 | Chordata | Chordata | 161 | 3.69e-48 | NR | XP_035667477.1 | 7739 | g1683 | i0 | 68.7 | 60.8582089552239 | 115 | 36 | 85.8 | 0 | 402 | 58 | 4 | 118 | XP_035667477.1 40S ribosomal protein S17 [Branchiostoma floridae] | diamond | 24465 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31355099 | 31355099 | PRJNA1132896_P_NODE_4636_length_280_cov_1.454106_g4545_i0 | PRJNA1132896 | 4636 | 280 | 1.454106 | 4.0714968 | Aves | 8782 | Chordata | Chordata | 104 | 1.35e-23 | NR | KAI6066677.1 | 8832 | g4545 | i0 | 50.5 | 51.8142857142857 | 93 | 46 | 99.6 | 0 | 279 | 1 | 1255 | 1347 | KAI6066677.1 RNA helicase [Aix galericulata] | diamond | 14508 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Aix | Aix galericulata | |
| 31587488 | 31587488 | PRJNA1132896_P_NODE_9836_length_242_cov_0.911243_g9745_i0 | PRJNA1132896 | 9836 | 242 | 0.911243 | 2.20520806 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 62 | 6.03e-9 | NR | KAI8478031.1 | 7741 | g9745 | i0 | 50 | 2.55371900826446 | 68 | 30 | 84.3 | 2 | 37 | 240 | 66 | 129 | KAI8478031.1 Histone acetyltransferase kat7 [Branchiostoma belcheri] | diamond | 618 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31618934 | 31618934 | PRJNA1132896_P_NODE_9316_length_244_cov_0.900585_g9225_i0 | PRJNA1132896 | 9316 | 244 | 0.900585 | 2.1974274 | Ranitomeya imitator | 111125 | Chordata | Chordata | 42.4 | 0.0466 | NR | CAJ0956274.1 | 111125 | g9225 | i0 | 48.5 | 0.897540983606557 | 33 | 17 | 40.6 | 0 | 101 | 3 | 1 | 33 | CAJ0956274.1 unnamed protein product [Ranitomeya imitator] | diamond | 219 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 31745361 | 31745361 | PRJNA1132896_P_NODE_4817_length_277_cov_3.343137_g4726_i0 | PRJNA1132896 | 4817 | 277 | 3.343137 | 9.26048949 | Oikopleura dioica | 34765 | Chordata | Chordata | 75.9 | 5.12e-15 | NR | CAG5109510.1 | 34765 | g4726 | i0 | 57.1 | 4.05054151624549 | 63 | 27 | 68.2 | 0 | 195 | 7 | 13 | 75 | CAG5109510.1 Oidioi.mRNA.OKI2018_I69.chr2.g4037.t1.cds [Oikopleura dioica] | diamond | 1122 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 32283610 | 32283610 | PRJNA1132896_P_NODE_7699_length_248_cov_1.720000_g7608_i0 | PRJNA1132896 | 7699 | 248 | 1.72 | 4.2656 | Petromyzon marinus | 7757 | Chordata | Chordata | 98.6 | 8.63e-22 | NR | XP_032806199.1 | 7757 | g7608 | i0 | 54.9 | 5.6008064516129 | 82 | 36 | 98 | 1 | 245 | 3 | 242 | 323 | XP_032806199.1 WD repeat-containing protein 1-A-like [Petromyzon marinus] | diamond | 1389 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 32430663 | 32430663 | PRJNA1132896_P_NODE_1779_length_402_cov_1.592705_g1688_i0 | PRJNA1132896 | 1779 | 402 | 1.592705 | 6.4026741 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 2.4e-24 | NR | OCT92450.1 | 8355 | g1688 | i0 | 57.9 | 17.5970149253731 | 76 | 32 | 56.7 | 0 | 262 | 35 | 71 | 146 | OCT92450.1 hypothetical protein XELAEV_18015505mg [Xenopus laevis] | diamond | 7074 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 32662340 | 32662340 | PRJNA1132896_P_NODE_7840_length_248_cov_0.880000_g7749_i0 | PRJNA1132896 | 7840 | 248 | 0.88 | 2.1824 | Xenopus laevis | 8355 | Chordata | Chordata | 44.7 | 0.0083 | NR | XP_041433230.1 | 8355 | g7749 | i0 | 38.9 | 1.75403225806452 | 72 | 44 | 87.1 | 0 | 24 | 239 | 21 | 92 | XP_041433230.1 uncharacterized protein LOC121398283 [Xenopus laevis] | diamond | 435 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis |
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);;