contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1393860 | 1393860 | PRJEB50332_P_NODE_342_length_875_cov_3.900491_g292_i0 | PRJEB50332 | 342 | 875 | 3.900491 | 34.12929625 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 267 | 1.0599999999999998e-85 | NR | AAZ38987.1 | 8668 | g292 | i0 | 58.3 | 46.896 | 235 | 85 | 79.2 | 4 | 738 | 46 | 10 | 235 | AAZ38987.1 40S ribosomal protein S2, partial [Oxyuranus scutellatus] | diamond | 41034 | 269 | 0.992565055762082 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Oxyuranus | Oxyuranus scutellatus | |
| 14147782 | 14147782 | PRJEB50332_P_NODE_2352_length_368_cov_1.752443_g2271_i0 | PRJEB50332 | 2352 | 368 | 1.752443 | 6.44899024 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 177 | 3.74e-51 | NR | Q9GR88.1 | 7723 | g2271 | i0 | 68.9 | 126.1875 | 122 | 38 | 99.5 | 0 | 2 | 367 | 109 | 230 | Q9GR88.1 RecName: Full=Eukaryotic peptide chain release factor subunit 1; Short=Eukaryotic release factor 1; Short=eRF1 [Polyandrocarpa misakiensis] | diamond | 46437 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Polyandrocarpa | Polyandrocarpa misakiensis | |
| 14147839 | 14147839 | PRJEB50332_P_NODE_712_length_641_cov_2.168966_g635_i0 | PRJEB50332 | 712 | 641 | 2.168966 | 13.90307206 | Chordata | 7711 | Chordata | Chordata | 288 | 3.34e-95 | NR | XP_012422504.1 | 9708 | g635 | i0 | 70.4 | 14.7051482059282 | 196 | 58 | 91.7 | 0 | 640 | 53 | 71 | 266 | XP_012422504.1 PREDICTED: guanine nucleotide-binding protein subunit beta-2-like 1 isoform X2 [Odobenus rosmarus divergens] | diamond | 9426 | 288 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Odobenidae | Odobenus | Odobenus rosmarus | |
| 21796190 | 21796190 | PRJEB50332_P_NODE_438_length_799_cov_2.888889_g375_i0 | PRJEB50332 | 438 | 799 | 2.888889 | 23.08222311 | Mammalia | 40674 | Chordata | Chordata | 317 | 5.46e-98 | NR | KAF5920767.1 | 77932 | g375 | i0 | 59.8 | 30.4918648310388 | 254 | 97 | 94.6 | 2 | 3 | 758 | 666 | 916 | KAF5920767.1 hypothetical protein HPG69_010301 [Diceros bicornis minor] | diamond | 24363 | 320 | 0.990625 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Rhinocerotidae | Diceros | Diceros bicornis | |
| 25217384 | 25217384 | PRJEB50332_P_NODE_3280_length_321_cov_0.946154_g3198_i0 | PRJEB50332 | 3280 | 321 | 0.946154 | 3.03715434 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 119 | 1.27e-29 | NR | XP_028340109.1 | 9755 | g3198 | i0 | 72.1 | 20.5981308411215 | 86 | 21 | 80.4 | 2 | 63 | 320 | 216 | 298 | XP_028340109.1 ATP-dependent RNA helicase DDX39A isoform X5 [Physeter macrocephalus] | diamond | 6612 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 27090111 | 27090111 | PRJEB50332_P_NODE_6302_length_249_cov_1.553191_g6220_i0 | PRJEB50332 | 6302 | 249 | 1.553191 | 3.86744559 | Chordata | 7711 | Chordata | Chordata | 49.7 | 1.46e-4 | NR | XP_044296782.1 | 61221 | g6220 | i0 | 53.4 | 2.6144578313253 | 58 | 25 | 69.9 | 2 | 15 | 188 | 8 | 63 | XP_044296782.1 glutamate-rich protein 3 isoform X1 [Varanus komodoensis] | diamond | 651 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 27349849 | 27349849 | PRJEB50332_P_NODE_15323_length_206_cov_0.896552_g15241_i0 | PRJEB50332 | 15323 | 206 | 0.896552 | 1.84689712 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 50.8 | 3.26e-5 | NR | CAH1272632.1 | 7740 | g15241 | i0 | 42.4 | 4.35436893203883 | 59 | 33 | 84.5 | 1 | 174 | 1 | 1250 | 1308 | CAH1272632.1 TNR [Branchiostoma lanceolatum] | diamond | 897 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 27444669 | 27444669 | PRJEB50332_P_NODE_2343_length_369_cov_1.496753_g2262_i0 | PRJEB50332 | 2343 | 369 | 1.496753 | 5.52301857 | Xenopus tropicalis | 8364 | Chordata | Chordata | 51.6 | 8.48e-6 | NR | NP_001291715.2 | 8364 | g2262 | i0 | 40.8 | 1.69918699186992 | 71 | 40 | 56.1 | 2 | 322 | 116 | 13 | 83 | NP_001291715.2 selenoprotein W1 [Xenopus tropicalis] | diamond | 627 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 28107292 | 28107292 | PRJEB50332_P_NODE_14625_length_207_cov_1.623288_g14543_i0 | PRJEB50332 | 14625 | 207 | 1.623288 | 3.36020616 | Hemicordylus capensis | 884348 | Chordata | Chordata | 45.4 | 0.00249 | NR | XP_053157935.1 | 884348 | g14543 | i0 | 42.9 | 1.21739130434783 | 42 | 24 | 60.9 | 0 | 130 | 5 | 21 | 62 | XP_053157935.1 procathepsin L-like [Hemicordylus capensis] | diamond | 252 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Cordylidae | Hemicordylus | Hemicordylus capensis | |
| 28416593 | 28416593 | PRJEB50332_P_NODE_11646_length_215_cov_2.110390_g11564_i0 | PRJEB50332 | 11646 | 215 | 2.11039 | 4.5373385 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 1.22e-16 | NR | XP_059806222.1 | 79690 | g11564 | i0 | 52.2 | 23.1488372093023 | 69 | 33 | 96.3 | 0 | 213 | 7 | 25 | 93 | XP_059806222.1 ras-related protein Rab-21-like isoform X8 [Hypanus sabinus] | diamond | 4977 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 28985070 | 28985070 | PRJEB50332_P_NODE_17888_length_202_cov_0.921986_g17806_i0 | PRJEB50332 | 17888 | 202 | 0.921986 | 1.86241172 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 1.3e-4 | NR | XP_014424576.1 | 13735 | g17806 | i0 | 42.6 | 2.88118811881188 | 68 | 33 | 93.6 | 2 | 200 | 12 | 103 | 169 | XP_014424576.1 ras-related protein Rab-2B [Pelodiscus sinensis] | diamond | 582 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Trionychidae | Pelodiscus | Pelodiscus sinensis | ||
| 29401959 | 29401959 | PRJEB50332_P_NODE_7549_length_238_cov_1.813559_g7467_i0 | PRJEB50332 | 7549 | 238 | 1.813559 | 4.31627042 | Polypterus senegalus | 55291 | Chordata | Chordata | 60.5 | 1.95e-8 | NR | KAG2469288.1 | 55291 | g7467 | i0 | 72.2 | 28.5882352941176 | 36 | 10 | 45.4 | 0 | 130 | 237 | 441 | 476 | KAG2469288.1 KAT5 acetyltransferase, partial [Polypterus senegalus] | diamond | 6804 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30280001 | 30280001 | PRJEB50332_P_NODE_5652_length_260_cov_1.804020_g5570_i0 | PRJEB50332 | 5652 | 260 | 1.80402 | 4.690452 | Aves | 8782 | Chordata | Chordata | 92 | 1.44e-19 | NR | NWX73917.1 | 28689 | g5570 | i0 | 53.4 | 19.2807692307692 | 88 | 39 | 99.2 | 1 | 1 | 258 | 293 | 380 | NWX73917.1 TRXR2 reductase [Alca torda] | diamond | 5013 | 92.4 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Alcidae | Alca | Alca torda | |
| 31423946 | 31423946 | PRJEB50332_P_NODE_13016_length_210_cov_1.483221_g12934_i0 | PRJEB50332 | 13016 | 210 | 1.483221 | 3.1147641 | Sceloporus undulatus | 8520 | Chordata | Chordata | 47.4 | 2.9e-4 | NR | XP_042322432.1 | 8520 | g12934 | i0 | 35.4 | 2.78571428571429 | 65 | 40 | 90 | 1 | 12 | 200 | 62 | 126 | XP_042322432.1 caltractin-like [Sceloporus undulatus] | diamond | 585 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Phrynosomatidae | Sceloporus | Sceloporus undulatus | |
| 32783137 | 32783137 | PRJEB50332_P_NODE_10840_length_220_cov_1.119497_g10758_i0 | PRJEB50332 | 10840 | 220 | 1.119497 | 2.4628934 | Bufotes viridis | 30338 | Chordata | Chordata | 43.9 | 0.0104 | NR | CAK8609802.1 | 30338 | g10758 | i0 | 63.3 | 0.940909090909091 | 30 | 11 | 40.9 | 0 | 126 | 215 | 1 | 30 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 207 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis |
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);;