contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA339266" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24021636 | 24021636 | PRJNA339266_S_NODE_6859_length_197_cov_19.256250_g6848_i0 | PRJNA339266 | 6859 | 197 | 19.25625 | 37.9348125 | Plestiodon egregius | 463521 | Chordata | Chordata | 76.6 | 4.24e-15 | NR | NP_008780.1 | 463521 | g6848 | i0 | 58.2 | 7.53807106598985 | 55 | 23 | 83.8 | 0 | 1 | 165 | 167 | 221 | NP_008780.1 cytochrome c oxidase subunit II [Plestiodon egregius] | diamond | 1485 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Plestiodon | Plestiodon egregius | |
| 26821671 | 26821671 | PRJNA339266_S_NODE_13161_length_167_cov_2.446154_g13150_i0 | PRJNA339266 | 13161 | 167 | 2.446154 | 4.08507718 | Vombatus ursinus | 29139 | Chordata | Chordata | 43.9 | 0.00118 | NR | XP_027698346.1 | 29139 | g13150 | i0 | 45.7 | 0.62874251497006 | 35 | 19 | 62.9 | 0 | 165 | 61 | 63 | 97 | XP_027698346.1 60S ribosomal protein L37-like [Vombatus ursinus] | diamond | 105 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Vombatidae | Vombatus | Vombatus ursinus | |
| 27611891 | 27611891 | PRJNA339266_S_NODE_12584_length_169_cov_2.515152_g12573_i0 | PRJNA339266 | 12584 | 169 | 2.515152 | 4.25060688 | Gracilinanus agilis | 191870 | Chordata | Chordata | 47 | 2.87e-5 | NR | XP_044518926.1 | 191870 | g12573 | i0 | 71.9 | 1.70414201183432 | 32 | 9 | 56.8 | 0 | 158 | 63 | 23 | 54 | XP_044518926.1 LOW QUALITY PROTEIN: 40S ribosomal protein S29-like [Gracilinanus agilis] | diamond | 288 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Didelphimorphia | Didelphidae | Gracilinanus | Gracilinanus agilis | |
| 27611898 | 27611898 | PRJNA339266_S_NODE_5804_length_206_cov_2.804734_g5793_i0 | PRJNA339266 | 5804 | 206 | 2.804734 | 5.77775204 | Latimeria chalumnae | 7897 | Chordata | Chordata | 49.7 | 8.13e-5 | NR | XP_064423149.1 | 7897 | g5793 | i0 | 56.5 | 2.24271844660194 | 46 | 10 | 52.4 | 1 | 192 | 85 | 445 | 490 | XP_064423149.1 zinc finger BED domain-containing protein 5-like [Latimeria chalumnae] | diamond | 462 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 27706910 | 27706910 | PRJNA339266_S_NODE_9184_length_183_cov_5.000000_g9173_i0 | PRJNA339266 | 9184 | 183 | 5 | 9.15 | Myxine glutinosa | 7769 | Chordata | Chordata | 54.3 | 1.41e-6 | NR | XP_067977694.1 | 7769 | g9173 | i0 | 62.8 | 0.704918032786885 | 43 | 13 | 65.6 | 1 | 64 | 183 | 31 | 73 | XP_067977694.1 general transcription factor II-I repeat domain-containing protein 2-like [Myxine glutinosa] | diamond | 129 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 27818669 | 27818669 | PRJNA339266_S_NODE_19544_length_151_cov_1.350877_g19533_i0 | PRJNA339266 | 19544 | 151 | 1.350877 | 2.03982427 | Chordata | 7711 | Chordata | Chordata | 58.9 | 1.98e-8 | NR | XP_038637445.1 | 7830 | g19533 | i0 | 100 | 105.476821192053 | 26 | 0 | 51.7 | 0 | 3 | 80 | 773 | 798 | XP_038637445.1 RNA-binding protein 25b isoform X1 [Scyliorhinus canicula] | diamond | 15927 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 28228662 | 28228662 | PRJNA339266_S_NODE_12726_length_168_cov_9.374046_g12715_i0 | PRJNA339266 | 12726 | 168 | 9.374046 | 15.74839728 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 6.75e-8 | NR | XP_025967716.1 | 8790 | g12715 | i0 | 52.2 | 11.9464285714286 | 46 | 22 | 82.1 | 0 | 168 | 31 | 126 | 171 | XP_025967716.1 ADP-ribose glycohydrolase OARD1 isoform X2 [Dromaius novaehollandiae] | diamond | 2007 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Casuariiformes | Dromaiidae | Dromaius | Dromaius novaehollandiae | |
| 28418592 | 28418592 | PRJNA339266_S_NODE_13066_length_167_cov_4.407692_g13055_i0 | PRJNA339266 | 13066 | 167 | 4.407692 | 7.36084564 | Mammalia | 40674 | Chordata | Chordata | 50.4 | 7.35e-6 | NR | XP_035294859.1 | 10029 | g13055 | i0 | 55 | 2.1377245508982 | 40 | 18 | 71.9 | 0 | 3 | 122 | 89 | 128 | XP_035294859.1 LOW QUALITY PROTEIN: 60S ribosomal protein L23-like [Cricetulus griseus] | diamond | 357 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 28495982 | 28495982 | PRJNA339266_S_NODE_6467_length_201_cov_1.902439_g6456_i0 | PRJNA339266 | 6467 | 201 | 1.902439 | 3.82390239 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 66.6 | 4.1e-11 | NR | KAI8484927.1 | 7741 | g6456 | i0 | 67.4 | 5.49253731343284 | 46 | 15 | 68.7 | 0 | 21 | 158 | 193 | 238 | KAI8484927.1 hypothetical protein Bbelb_373340 [Branchiostoma belcheri] | diamond | 1104 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 28923433 | 28923433 | PRJNA339266_S_NODE_15188_length_161_cov_1.935484_g15177_i0 | PRJNA339266 | 15188 | 161 | 1.935484 | 3.11612924 | Opisthokonta | 33154 | Chordata | Chordata | 87 | 1.63e-18 | NR | MEE6484150.1 | 8439 | g15177 | i0 | 79.2 | 2.96273291925466 | 53 | 11 | 98.8 | 0 | 161 | 3 | 312 | 364 | MEE6484150.1 hypothetical protein [Ascaphus truei] | diamond | 477 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 29001415 | 29001415 | PRJNA339266_S_NODE_5768_length_206_cov_5.662722_g5757_i0 | PRJNA339266 | 5768 | 206 | 5.662722 | 11.66520732 | Callorhinchus milii | 7868 | Chordata | Chordata | 48.5 | 9.56e-5 | NR | XP_007898372.1 | 7868 | g5757 | i0 | 45.1 | 2.22815533980583 | 51 | 28 | 74.3 | 0 | 199 | 47 | 115 | 165 | XP_007898372.1 60S ribosomal protein L12 [Callorhinchus milii] | diamond | 459 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 29285025 | 29285025 | PRJNA339266_S_NODE_15829_length_159_cov_3.147541_g15818_i0 | PRJNA339266 | 15829 | 159 | 3.147541 | 5.00459019 | Lontra canadensis | 76717 | Chordata | Chordata | 63.2 | 1.18e-10 | NR | XP_032727192.1 | 76717 | g15818 | i0 | 56 | 4.71698113207547 | 50 | 22 | 94.3 | 0 | 152 | 3 | 102 | 151 | XP_032727192.1 60S ribosomal protein L8-like [Lontra canadensis] | diamond | 750 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Lontra | Lontra canadensis | |
| 29807524 | 29807524 | PRJNA339266_S_NODE_7911_length_190_cov_3.980392_g7900_i0 | PRJNA339266 | 7911 | 190 | 3.980392 | 7.5627448 | Cladistia | 1338366 | Chordata | Chordata | 75.9 | 4.17e-15 | NR | EMP39705.1 | 8469 | g7900 | i0 | 58.6 | 30.2210526315789 | 58 | 24 | 91.6 | 0 | 1 | 174 | 137 | 194 | EMP39705.1 40S ribosomal protein S7, partial [Chelonia mydas] | diamond | 5742 | 76.6 | 0.990861618798956 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Chelonia | Chelonia mydas | ||
| 29979897 | 29979897 | PRJNA339266_S_NODE_4891_length_215_cov_33.207865_g4880_i0 | PRJNA339266 | 4891 | 215 | 33.207865 | 71.39690975 | Rattus rattus | 10117 | Chordata | Chordata | 42.4 | 0.00577 | NR | XP_032745889.1 | 10117 | g4880 | i0 | 82.1 | 5.45581395348837 | 28 | 5 | 39.1 | 0 | 1 | 84 | 50 | 77 | XP_032745889.1 LOW QUALITY PROTEIN: thymosin beta-4 [Rattus rattus] | diamond | 1173 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus rattus | |
| 30502700 | 30502700 | PRJNA339266_P_NODE_6793_length_168_cov_3.137405_g6763_i0 | PRJNA339266 | 6793 | 168 | 3.1374050000000002 | 5.2708404 | root | 1 | Root_unresolved | Root_unresolved | 119 | 1e-29 | NR | XP_030110853.2 | 10090 | g6763 | i0 | 100 | 16.9821428571429 | 56 | 0 | 100 | 0 | 168 | 1 | 156 | 211 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 2853 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 30945132 | 30945132 | PRJNA339266_S_NODE_16214_length_158_cov_3.314050_g16203_i0 | PRJNA339266 | 16214 | 158 | 3.31405 | 5.236199 | Chordata | 7711 | Chordata | Chordata | 53.1 | 1.42e-6 | NR | AFK11613.1 | 7868 | g16203 | i0 | 61.5 | 34.0632911392405 | 39 | 15 | 74.1 | 0 | 157 | 41 | 147 | 185 | AFK11613.1 60S ribosomal protein L10a-like protein [Callorhinchus milii] | diamond | 5382 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 31229180 | 31229180 | PRJNA339266_S_NODE_4975_length_215_cov_1.544944_g4964_i0 | PRJNA339266 | 4975 | 215 | 1.544944 | 3.3216296 | root | 1 | Root_unresolved | Root_unresolved | 143 | 9.12e-38 | NR | XP_030109804.2 | 10090 | g4964 | i0 | 98.6 | 10.8976744186047 | 71 | 1 | 99.1 | 0 | 3 | 215 | 66 | 136 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 2343 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31560243 | 31560243 | PRJNA339266_S_NODE_17076_length_156_cov_2.563025_g17065_i0 | PRJNA339266 | 17076 | 156 | 2.563025 | 3.998319 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 55.1 | 4.94e-7 | NR | XP_068110944.1 | 752182 | g17065 | i0 | 54 | 1.86538461538462 | 50 | 22 | 94.2 | 1 | 6 | 152 | 7 | 56 | XP_068110944.1 olfactory receptor 10A7-like [Hyperolius riggenbachi] | diamond | 291 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 32002939 | 32002939 | PRJNA339266_S_NODE_7038_length_196_cov_3.314465_g7027_i0 | PRJNA339266 | 7038 | 196 | 3.314465 | 6.4963514 | Calidris pugnax | 198806 | Chordata | Chordata | 42.4 | 0.0223 | NR | XP_014796320.1 | 198806 | g7027 | i0 | 73.9 | 0.352040816326531 | 23 | 6 | 35.2 | 0 | 191 | 123 | 99 | 121 | XP_014796320.1 PREDICTED: U1 small nuclear ribonucleoprotein C-like isoform X1 [Calidris pugnax] | diamond | 69 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Scolopacidae | Calidris | Calidris pugnax | |
| 32666797 | 32666797 | PRJNA339266_S_NODE_17700_length_155_cov_1.118644_g17689_i0 | PRJNA339266 | 17700 | 155 | 1.118644 | 1.7338982 | Mycteria americana | 33587 | Chordata | Chordata | 54.7 | 6.78e-7 | NR | KAK4818546.1 | 33587 | g17689 | i0 | 51.2 | 11.6516129032258 | 43 | 20 | 83.2 | 1 | 3 | 131 | 688 | 729 | KAK4818546.1 hypothetical protein QYF61_014489 [Mycteria americana] | diamond | 1806 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 32729908 | 32729908 | PRJNA339266_S_NODE_15720_length_159_cov_6.983607_g15709_i0 | PRJNA339266 | 15720 | 159 | 6.983607 | 11.10393513 | Pygoscelis antarcticus | 79643 | Chordata | Chordata | 44.3 | 0.00313 | NR | YP_008083523.1 | 79643 | g15709 | i0 | 67.6 | 6.33962264150943 | 37 | 12 | 69.8 | 0 | 10 | 120 | 195 | 231 | YP_008083523.1 ATP synthase F0 subunit 6 [Pygoscelis antarcticus] | diamond | 1008 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Pygoscelis | Pygoscelis antarcticus |
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);;