contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3784159 | 3784159 | PRJNA849172_P_NODE_18003_length_488_cov_22.392771_g17644_i0 | PRJNA849172 | 18003 | 488 | 22.392771 | 109.27672248 | Mammalia | 40674 | Chordata | Chordata | 106 | 1.6600000000000002e-26 | NR | XP_036624378.1 | 9337 | g17644 | i0 | 59.7 | 4.78893442622951 | 77 | 31 | 47.3 | 0 | 377 | 147 | 32 | 108 | XP_036624378.1 cytochrome c oxidase subunit 6A1, mitochondrial [Trichosurus vulpecula] | diamond | 2337 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Phalangeridae | Trichosurus | Trichosurus vulpecula | |
| 9762124 | 9762124 | PRJNA849172_P_NODE_101028_length_245_cov_11.500000_g100668_i0 | PRJNA849172 | 101028 | 245 | 11.5 | 28.175 | root | 1 | Root_unresolved | Root_unresolved | 99.8 | 6.6e-24 | NR | XP_035660024.1 | 7739 | g100668 | i0 | 67.2 | 3.26938775510204 | 67 | 22 | 82 | 0 | 1 | 201 | 144 | 210 | XP_035660024.1 60S ribosomal protein L11 isoform X1 [Branchiostoma floridae] | diamond | 801 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 19084516 | 19084516 | PRJNA849172_P_NODE_81135_length_258_cov_8.854054_g80775_i0 | PRJNA849172 | 81135 | 258 | 8.854054 | 22.84345932 | root | 1 | Root_unresolved | Root_unresolved | 122 | 4.89e-31 | NR | CAB3219666.1 | 59560 | g80775 | i0 | 77 | 8.53488372093023 | 74 | 17 | 86 | 0 | 3 | 224 | 323 | 396 | CAB3219666.1 3-ketoacyl-CoA thiolase, mitochondrial-like [Phallusia mammillata] | diamond | 2202 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 26928282 | 26928282 | PRJNA849172_P_NODE_18882_length_476_cov_12.059553_g18523_i0 | PRJNA849172 | 18882 | 476 | 12.059553 | 57.40347228 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 99 | 2.98e-22 | NR | CAH1266045.1 | 7740 | g18523 | i0 | 34.7 | 1.8781512605042 | 147 | 90 | 92 | 4 | 466 | 29 | 81 | 222 | CAH1266045.1 GM2A [Branchiostoma lanceolatum] | diamond | 894 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 26999721 | 26999721 | PRJNA849172_P_NODE_34762_length_348_cov_41.621818_g34403_i0 | PRJNA849172 | 34762 | 348 | 41.621818 | 144.84392664 | Metazoa | 33208 | Chordata | Chordata | 107 | 2.23e-26 | NR | XP_040592635.1 | 10036 | g34403 | i0 | 57.4 | 7.47413793103448 | 94 | 38 | 81 | 1 | 346 | 65 | 92 | 183 | XP_040592635.1 ras-related protein Rab-2B isoform X2 [Mesocricetus auratus] | diamond | 2601 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 27474035 | 27474035 | PRJNA849172_P_NODE_73483_length_266_cov_1.891192_g73123_i0 | PRJNA849172 | 73483 | 266 | 1.891192 | 5.03057072 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0414 | NR | CAL5923357.1 | 7748 | g73123 | i0 | 43.1 | 1.38721804511278 | 65 | 35 | 73.3 | 1 | 223 | 29 | 122 | 184 | CAL5923357.1 unnamed protein product [Lampetra fluviatilis] | diamond | 369 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 27663583 | 27663583 | PRJNA849172_P_NODE_44984_length_310_cov_33.333333_g44624_i0 | PRJNA849172 | 44984 | 310 | 33.333333 | 103.3333323 | Chordata | 7711 | Chordata | Chordata | 90.5 | 2.33e-21 | NR | XP_043942800.1 | 7888 | g44624 | i0 | 100 | 65.4677419354839 | 44 | 0 | 42.6 | 0 | 310 | 179 | 39 | 82 | XP_043942800.1 60S ribosomal protein L39-like [Protopterus annectens] | diamond | 20295 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 27695293 | 27695293 | PRJNA849172_P_NODE_57924_length_283_cov_15.690476_g57564_i0 | PRJNA849172 | 57924 | 283 | 15.690476 | 44.40404708 | Chordata | 7711 | Chordata | Chordata | 69.3 | 1.84e-12 | NR | XP_053239864.1 | 65483 | g57564 | i0 | 63.2 | 8.88339222614841 | 87 | 30 | 92.2 | 1 | 269 | 9 | 65 | 149 | XP_053239864.1 coiled-coil domain-containing protein 25 isoform X2 [Podarcis raffonei] | diamond | 2514 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis raffonei | |
| 27876094 | 27876094 | PRJNA849172_P_NODE_9445_length_702_cov_21.821940_g9097_i0 | PRJNA849172 | 9445 | 702 | 21.82194 | 153.1900188 | Engystomops pustulosus | 76066 | Chordata | Chordata | 180 | 1.7e-51 | NR | KAG8587977.1 | 76066 | g9097 | i0 | 49.5 | 8.36324786324786 | 196 | 75 | 82.9 | 5 | 700 | 119 | 98 | 271 | KAG8587977.1 hypothetical protein GDO81_005837 [Engystomops pustulosus] | diamond | 5871 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28034108 | 28034108 | PRJNA849172_P_NODE_143665_length_203_cov_6.984615_g143305_i0 | PRJNA849172 | 143665 | 203 | 6.984615 | 14.17876845 | Haliaeetus leucocephalus | 52644 | Chordata | Chordata | 42 | 0.0402 | NR | XP_010563483.1 | 52644 | g143305 | i0 | 46.3 | 0.605911330049261 | 41 | 22 | 60.6 | 0 | 130 | 8 | 67 | 107 | XP_010563483.1 PREDICTED: coenzyme Q-binding protein COQ10 homolog A, mitochondrial [Haliaeetus leucocephalus] | diamond | 123 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Accipitridae | Haliaeetus | Haliaeetus leucocephalus | |
| 28476011 | 28476011 | PRJNA849172_P_NODE_116026_length_235_cov_3.759259_g115666_i0 | PRJNA849172 | 116026 | 235 | 3.759259 | 8.83425865 | Dendropsophus ebraccatus | 150705 | Chordata | Chordata | 102 | 4.189999999999999e-23 | NR | XP_069811917.1 | 150705 | g115666 | i0 | 63.5 | 2.83404255319149 | 74 | 27 | 94.5 | 0 | 12 | 233 | 221 | 294 | XP_069811917.1 general transcription factor II-I repeat domain-containing protein 2-like [Dendropsophus ebraccatus] | diamond | 666 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Dendropsophus | Dendropsophus ebraccatus | |
| 28570691 | 28570691 | PRJNA849172_P_NODE_86267_length_254_cov_2.585635_g85907_i0 | PRJNA849172 | 86267 | 254 | 2.585635 | 6.5675129 | Ursus arctos | 9644 | Chordata | Chordata | 44.3 | 0.0119 | NR | XP_057162024.1 | 9644 | g85907 | i0 | 37.5 | 1.03937007874016 | 88 | 41 | 93.3 | 3 | 15 | 251 | 272 | 354 | XP_057162024.1 uncharacterized protein LOC113266848 [Ursus arctos] | diamond | 264 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ursus | Ursus arctos | |
| 29170762 | 29170762 | PRJNA849172_P_NODE_146649_length_200_cov_5.763780_g146289_i0 | PRJNA849172 | 146649 | 200 | 5.76378 | 11.52756 | Dipodomys ordii | 10020 | Chordata | Chordata | 42.7 | 0.0217 | NR | XP_012881624.1 | 10020 | g146289 | i0 | 45.5 | 0.945 | 33 | 18 | 49.5 | 0 | 173 | 75 | 469 | 501 | XP_012881624.1 PREDICTED: serine/threonine-protein kinase Nek1 isoform X1 [Dipodomys ordii] | diamond | 189 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Heteromyidae | Dipodomys | Dipodomys ordii | |
| 29265123 | 29265123 | PRJNA849172_P_NODE_108109_length_242_cov_1.846154_g107749_i0 | PRJNA849172 | 108109 | 242 | 1.846154 | 4.46769268 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 122 | 3.0999999999999996e-32 | NR | CAH1240681.1 | 7740 | g107749 | i0 | 76.4 | 0.892561983471074 | 72 | 17 | 89.3 | 0 | 216 | 1 | 18 | 89 | CAH1240681.1 MTOR [Branchiostoma lanceolatum] | diamond | 216 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 30916431 | 30916431 | PRJNA849172_P_NODE_140774_length_206_cov_15.127820_g140414_i0 | PRJNA849172 | 140774 | 206 | 15.12782 | 31.1633092 | Opisthokonta | 33154 | Chordata | Chordata | 75.5 | 2.22e-14 | NR | XP_002125322.1 | 7719 | g140414 | i0 | 59.4 | 6.94660194174757 | 64 | 20 | 84.5 | 1 | 204 | 31 | 187 | 250 | XP_002125322.1 40S ribosomal protein S3a [Ciona intestinalis] | diamond | 1431 | 75.9 | 0.994729907773386 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 31010985 | 31010985 | PRJNA849172_P_NODE_33934_length_352_cov_15.810036_g33575_i0 | PRJNA849172 | 33934 | 352 | 15.810036 | 55.65132672 | Metazoa | 33208 | Chordata | Chordata | 105 | 6.29e-25 | NR | XP_009860378.1 | 7719 | g33575 | i0 | 61 | 4.06534090909091 | 82 | 31 | 69 | 1 | 82 | 324 | 175 | 256 | XP_009860378.1 40S ribosomal protein S4-like isoform X2 [Ciona intestinalis] | diamond | 1431 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 31856426 | 31856426 | PRJNA849172_P_NODE_48457_length_300_cov_18.784141_g48097_i0 | PRJNA849172 | 48457 | 300 | 18.784141 | 56.352423 | Rhinatrema bivittatum | 194408 | Chordata | Chordata | 148 | 6.859999999999998e-42 | NR | XP_029447335.1 | 194408 | g48097 | i0 | 74.7 | 2.73 | 91 | 23 | 91 | 0 | 300 | 28 | 177 | 267 | XP_029447335.1 60S ribosomal protein L7 [Rhinatrema bivittatum] | diamond | 819 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 32267932 | 32267932 | PRJNA849172_P_NODE_107118_length_242_cov_5.715976_g106758_i0 | PRJNA849172 | 107118 | 242 | 5.715976 | 13.83266192 | Heptranchias perlo | 212740 | Chordata | Chordata | 87.4 | 6.86e-18 | NR | XP_067839112.1 | 212740 | g106758 | i0 | 63.2 | 2.52892561983471 | 68 | 24 | 83.1 | 1 | 237 | 37 | 670 | 737 | XP_067839112.1 peroxisomal multifunctional enzyme type 2 [Heptranchias perlo] | diamond | 612 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 32678344 | 32678344 | PRJNA849172_P_NODE_54000_length_289_cov_1.925926_g53640_i0 | PRJNA849172 | 54000 | 289 | 1.925926 | 5.56592614 | Chelonia mydas | 8469 | Chordata | Chordata | 62.4 | 7.73e-9 | NR | EMP29380.1 | 8469 | g53640 | i0 | 74.4 | 2.08650519031142 | 39 | 10 | 40.5 | 0 | 75 | 191 | 395 | 433 | EMP29380.1 Signal transducer and activator of transcription 6 [Chelonia mydas] | diamond | 603 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Chelonia | Chelonia mydas |
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);;