contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB81171" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12892818 | 12892818 | PRJEB81171_P_NODE_1891_length_479_cov_1.362069_g1767_i0 | PRJEB81171 | 1891 | 479 | 1.362069 | 6.52431051 | Opisthokonta | 33154 | Chordata | Chordata | 217 | 7.85e-66 | NR | XP_027306665.2 | 8839 | g1767 | i0 | 67.7 | 56.5678496868476 | 158 | 50 | 99 | 1 | 479 | 6 | 290 | 446 | XP_027306665.2 60S ribosomal protein L3 [Anas platyrhynchos] | diamond | 27096 | 219 | 0.990867579908676 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas platyrhynchos | |
| 21816097 | 21816097 | PRJEB81171_P_NODE_3418_length_357_cov_1.809859_g3291_i0 | PRJEB81171 | 3418 | 357 | 1.809859 | 6.46119663 | Metazoa | 33208 | Chordata | Chordata | 160 | 7.21e-44 | NR | XP_046764483.1 | 9031 | g3291 | i0 | 65.5 | 22.4453781512605 | 119 | 40 | 99.2 | 1 | 356 | 3 | 85 | 203 | XP_046764483.1 protein transport protein Sec61 subunit alpha isoform X1 [Gallus gallus] | diamond | 8013 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 26717272 | 26717272 | PRJEB81171_P_NODE_1061_length_635_cov_1.229537_g940_i0 | PRJEB81171 | 1061 | 635 | 1.229537 | 7.80755995 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 47.8 | 0.0132 | NR | XP_055487001.1 | 7782 | g940 | i0 | 48.5 | 1.1007874015748 | 66 | 30 | 30.2 | 3 | 360 | 169 | 152 | 215 | XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus] | diamond | 699 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 27248222 | 27248222 | PRJEB81171_P_NODE_5763_length_282_cov_1.492823_g5636_i0 | PRJEB81171 | 5763 | 282 | 1.492823 | 4.20976086 | Muridae | 10066 | Chordata | Chordata | 66.6 | 2.49e-10 | NR | XP_060235202.1 | 10047 | g5636 | i0 | 49.3 | 10.1170212765957 | 69 | 35 | 73.4 | 0 | 73 | 279 | 935 | 1003 | XP_060235202.1 kinesin-like protein KIF17 isoform X7 [Meriones unguiculatus] | diamond | 2853 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus | |
| 27571369 | 27571369 | PRJEB81171_P_NODE_8004_length_251_cov_1.539326_g7877_i0 | PRJEB81171 | 8004 | 251 | 1.539326 | 3.86370826 | Pyxicephalus adspersus | 30357 | Chordata | Chordata | 57.8 | 2.06e-7 | NR | DBA17628.1 | 30357 | g7877 | i0 | 39.7 | 1.38645418326693 | 58 | 35 | 69.3 | 0 | 14 | 187 | 114 | 171 | DBA17628.1 TPA: hypothetical protein GDO54_003046 [Pyxicephalus adspersus] | diamond | 348 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pyxicephalidae | Pyxicephalus | Pyxicephalus adspersus | |
| 28921643 | 28921643 | PRJEB81171_P_NODE_9288_length_245_cov_0.906977_g9161_i0 | PRJEB81171 | 9288 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 119 | 3.39e-29 | NR | XP_059825434.1 | 79690 | g9161 | i0 | 63 | 21.8204081632653 | 81 | 30 | 99.2 | 0 | 243 | 1 | 150 | 230 | XP_059825434.1 serine/threonine-protein kinase RIO2 [Hypanus sabinus] | diamond | 5346 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 29118774 | 29118774 | PRJEB81171_P_NODE_7249_length_259_cov_1.258065_g7122_i0 | PRJEB81171 | 7249 | 259 | 1.258065 | 3.25838835 | Oikopleura dioica | 34765 | Chordata | Chordata | 45.4 | 0.00519 | NR | CAG5098649.1 | 34765 | g7122 | i0 | 41.1 | 1.28571428571429 | 56 | 27 | 64.9 | 1 | 179 | 12 | 532 | 581 | CAG5098649.1 Oidioi.mRNA.OKI2018_I69.XSR.g15857.t1.cds [Oikopleura dioica] | diamond | 333 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 29206173 | 29206173 | PRJEB81171_P_NODE_6009_length_279_cov_1.038835_g5882_i0 | PRJEB81171 | 6009 | 279 | 1.038835 | 2.89834965 | Opisthokonta | 33154 | Chordata | Chordata | 99.8 | 5.700000000000001e-22 | NR | XP_067959053.1 | 7769 | g5882 | i0 | 48.3 | 15.1290322580645 | 87 | 45 | 93.5 | 0 | 279 | 19 | 3468 | 3554 | XP_067959053.1 LOW QUALITY PROTEIN: cytoplasmic dynein 1 heavy chain 1-like [Myxine glutinosa] | diamond | 4221 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 30027099 | 30027099 | PRJEB81171_P_NODE_9831_length_243_cov_0.917647_g9704_i0 | PRJEB81171 | 9831 | 243 | 0.917647 | 2.22988221 | Metazoa | 33208 | Chordata | Chordata | 82.4 | 3.85e-16 | NR | XP_019616203.1 | 7741 | g9704 | i0 | 58.6 | 1.76543209876543 | 70 | 28 | 85.2 | 1 | 215 | 9 | 31 | 100 | XP_019616203.1 PREDICTED: cAMP-regulated D2 protein-like [Branchiostoma belcheri] | diamond | 429 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 30192150 | 30192150 | PRJEB81171_P_NODE_5212_length_292_cov_0.785388_g5085_i0 | PRJEB81171 | 5212 | 292 | 0.785388 | 2.29333296 | Engystomops pustulosus | 76066 | Chordata | Chordata | 61.6 | 1.6e-8 | NR | KAG8571490.1 | 76066 | g5085 | i0 | 55.6 | 2.21917808219178 | 72 | 32 | 74 | 0 | 62 | 277 | 1119 | 1190 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 648 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32563874 | 32563874 | PRJEB81171_P_NODE_5259_length_291_cov_1.091743_g5132_i0 | PRJEB81171 | 5259 | 291 | 1.091743 | 3.17697213 | Mauremys mutica | 74926 | Chordata | Chordata | 42.4 | 0.0427 | NR | KAH1178546.1 | 74926 | g5132 | i0 | 40.3 | 0.639175257731959 | 62 | 34 | 62.9 | 2 | 25 | 207 | 34 | 93 | KAH1178546.1 hypothetical protein KIL84_012248 [Mauremys mutica] | diamond | 186 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Geoemydidae | Mauremys | Mauremys mutica |
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);;