contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA453111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2992027 | 2992027 | PRJNA453111_P_NODE_10723_length_249_cov_0.875000_g10631_i0 | PRJNA453111 | 10723 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Chordata | Chordata | 151 | 3.06e-40 | NR | XP_067987547.1 | 7769 | g10631 | i0 | 83.1 | 67 | 83 | 14 | 100 | 0 | 1 | 249 | 2686 | 2768 | XP_067987547.1 cytoplasmic dynein 1 heavy chain 1 [Myxine glutinosa] | diamond | 16683 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 2992072 | 2992072 | PRJNA453111_P_NODE_3243_length_452_cov_1.606860_g3151_i0 | PRJNA453111 | 3243 | 452 | 1.60686 | 7.2630072 | Metazoa | 33208 | Chordata | Chordata | 179 | 4.59e-50 | NR | XP_067963046.1 | 7769 | g3151 | i0 | 57.8 | 167.661504424779 | 147 | 62 | 97.6 | 0 | 442 | 2 | 336 | 482 | XP_067963046.1 RNA polymerase-associated protein LEO1 [Myxine glutinosa] | diamond | 75783 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 12571792 | 12571792 | PRJNA453111_P_NODE_9990_length_251_cov_0.865169_g9898_i0 | PRJNA453111 | 9990 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Chordata | Chordata | 122 | 6.819999999999999e-32 | NR | KYO24442.1 | 8496 | g9898 | i0 | 69.5 | 22.5298804780876 | 82 | 25 | 98 | 0 | 4 | 249 | 129 | 210 | KYO24442.1 hydroxyacyl-coenzyme A dehydrogenase, mitochondrial [Alligator mississippiensis] | diamond | 5655 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator mississippiensis | ||
| 27265833 | 27265833 | PRJNA453111_P_NODE_12363_length_243_cov_1.358824_g12271_i0 | PRJNA453111 | 12363 | 243 | 1.358824 | 3.30194232 | Ochotona princeps | 9978 | Chordata | Chordata | 45.8 | 0.00292 | NR | XP_058536338.1 | 9978 | g12271 | i0 | 42.9 | 1.95061728395062 | 42 | 24 | 51.9 | 0 | 46 | 171 | 136 | 177 | XP_058536338.1 brain-specific serine protease 4 [Ochotona princeps] | diamond | 474 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 27297367 | 27297367 | PRJNA453111_P_NODE_8243_length_282_cov_1.000000_g8151_i0 | PRJNA453111 | 8243 | 282 | 1 | 2.82 | Chelonoidis abingdonii | 106734 | Chordata | Chordata | 48.9 | 1.88e-4 | NR | XP_032634775.1 | 106734 | g8151 | i0 | 44.8 | 1.18085106382979 | 58 | 30 | 60.6 | 2 | 252 | 82 | 59 | 115 | XP_032634775.1 pre-rRNA-processing protein TSR2 homolog [Chelonoidis abingdonii] | diamond | 333 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Testudinidae | Chelonoidis | Chelonoidis abingdonii | ||
| 27408650 | 27408650 | PRJNA453111_P_NODE_7423_length_297_cov_1.330357_g7331_i0 | PRJNA453111 | 7423 | 297 | 1.330357 | 3.95116029 | Psittaciformes | 9223 | Chordata | Chordata | 45.1 | 0.00233 | NR | XP_005142059.1 | 13146 | g7331 | i0 | 35.3 | 6.87878787878788 | 85 | 52 | 82.8 | 1 | 253 | 8 | 7 | 91 | XP_005142059.1 tubulin-specific chaperone A [Melopsittacus undulatus] | diamond | 2043 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittaculidae | Melopsittacus | Melopsittacus undulatus | |
| 28939423 | 28939423 | PRJNA453111_P_NODE_6828_length_310_cov_1.371308_g6736_i0 | PRJNA453111 | 6828 | 310 | 1.371308 | 4.2510548 | Myotis myotis | 51298 | Chordata | Chordata | 42.4 | 0.0378 | NR | XP_036201646.1 | 51298 | g6736 | i0 | 37.9 | 0.561290322580645 | 58 | 34 | 54.2 | 1 | 239 | 72 | 8 | 65 | XP_036201646.1 microtubule-associated proteins 1A/1B light chain 3B isoform X2 [Myotis myotis] | diamond | 174 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 29349845 | 29349845 | PRJNA453111_P_NODE_2749_length_494_cov_1.638955_g2657_i0 | PRJNA453111 | 2749 | 494 | 1.638955 | 8.0964377 | Staurois parvus | 386267 | Chordata | Chordata | 58.5 | 1.2e-7 | NR | CAI9533415.1 | 386267 | g2657 | i0 | 40 | 2.05263157894737 | 110 | 47 | 55.3 | 4 | 392 | 120 | 1 | 110 | CAI9533415.1 unnamed protein product [Staurois parvus] | diamond | 1014 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29823154 | 29823154 | PRJNA453111_P_NODE_6331_length_322_cov_0.927711_g6239_i0 | PRJNA453111 | 6331 | 322 | 0.927711 | 2.98722942 | Naja naja | 35670 | Chordata | Chordata | 116 | 1.4500000000000002e-27 | NR | KAG8129326.1 | 35670 | g6239 | i0 | 72.4 | 14.4782608695652 | 76 | 21 | 70.8 | 0 | 93 | 320 | 21 | 96 | KAG8129326.1 hypothetical protein E2320_016025 [Naja naja] | diamond | 4662 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 30202232 | 30202232 | PRJNA453111_P_NODE_10652_length_249_cov_0.875000_g10560_i0 | PRJNA453111 | 10652 | 249 | 0.875 | 2.17875 | Eleutherodactylus coqui | 57060 | Chordata | Chordata | 43.9 | 0.0163 | NR | KAG9488115.1 | 57060 | g10560 | i0 | 52.8 | 0.433734939759036 | 36 | 17 | 43.4 | 0 | 58 | 165 | 354 | 389 | KAG9488115.1 hypothetical protein GDO78_007745 [Eleutherodactylus coqui] | diamond | 108 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 30408599 | 30408599 | PRJNA453111_P_NODE_2753_length_494_cov_1.097387_g2661_i0 | PRJNA453111 | 2753 | 494 | 1.097387 | 5.42109178 | Psittaciformes | 9223 | Chordata | Chordata | 46.6 | 0.0208 | NR | NWS44501.1 | 141839 | g2661 | i0 | 32.3 | 1.80364372469636 | 65 | 44 | 39.5 | 0 | 54 | 248 | 1086 | 1150 | NWS44501.1 EDC4 protein [Probosciger aterrimus] | diamond | 891 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Cacatuidae | Probosciger | Probosciger aterrimus | |
| 30455592 | 30455592 | PRJNA453111_P_NODE_2193_length_554_cov_15.280665_g2101_i0 | PRJNA453111 | 2193 | 554 | 15.280665 | 84.6548841 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 130 | 7.189999999999998e-35 | NR | XP_019626026.1 | 7741 | g2101 | i0 | 45.5 | 1.52166064981949 | 132 | 71 | 71.5 | 1 | 482 | 87 | 18 | 148 | XP_019626026.1 PREDICTED: epididymal secretory protein E1-like [Branchiostoma belcheri] | diamond | 843 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31356438 | 31356438 | PRJNA453111_P_NODE_6736_length_312_cov_2.255230_g6644_i0 | PRJNA453111 | 6736 | 312 | 2.25523 | 7.0363176 | Branchiostoma | 7737 | Chordata | Chordata | 82.8 | 7.47e-16 | NR | XP_035689700.1 | 7739 | g6644 | i0 | 40 | 4.02884615384615 | 110 | 44 | 99 | 3 | 2 | 310 | 1804 | 1898 | XP_035689700.1 uncharacterized protein LOC118424993 [Branchiostoma floridae] | diamond | 1257 | 83.2 | 0.995192307692308 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31529995 | 31529995 | PRJNA453111_P_NODE_3696_length_422_cov_1.292264_g3604_i0 | PRJNA453111 | 3696 | 422 | 1.292264 | 5.45335408 | Hemicordylus capensis | 884348 | Chordata | Chordata | 57.4 | 2.05e-6 | NR | XP_053121534.1 | 884348 | g3604 | i0 | 28.4 | 5.01184834123223 | 141 | 97 | 97.4 | 2 | 412 | 2 | 495 | 635 | XP_053121534.1 angiotensin-converting enzyme isoform X2 [Hemicordylus capensis] | diamond | 2115 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Cordylidae | Hemicordylus | Hemicordylus capensis | |
| 32337218 | 32337218 | PRJNA453111_P_NODE_2399_length_530_cov_1.507659_g2307_i0 | PRJNA453111 | 2399 | 530 | 1.507659 | 7.9905927 | Aves | 8782 | Chordata | Chordata | 187 | 1.9999999999999998e-54 | NR | NP_001353263.2 | 9031 | g2307 | i0 | 59.3 | 4.34150943396226 | 162 | 53 | 84.3 | 1 | 83 | 529 | 24 | 185 | NP_001353263.2 selenide, water dikinase 3 [Gallus gallus] | diamond | 2301 | 188 | 0.99468085106383 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 32479156 | 32479156 | PRJNA453111_P_NODE_4639_length_375_cov_1.496689_g4547_i0 | PRJNA453111 | 4639 | 375 | 1.496689 | 5.61258375 | Nestor notabilis | 176057 | Chordata | Chordata | 48.1 | 2.32e-4 | NR | XP_010019090.1 | 176057 | g4547 | i0 | 50 | 0.704 | 48 | 23 | 38.4 | 1 | 157 | 14 | 14 | 60 | XP_010019090.1 PREDICTED: heterogeneous nuclear ribonucleoprotein L-like, partial [Nestor notabilis] | diamond | 264 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittacidae | Nestor | Nestor notabilis |
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);;