contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJDB9741" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5113331 | 5113331 | PRJDB9741_P_NODE_31325_length_165_cov_1.396552_g31008_i0 | PRJDB9741 | 31325 | 165 | 1.396552 | 2.3043108 | Anura | 8342 | Chordata | Chordata | 99 | 1.3e-22 | NR | XP_069613570.1 | 111125 | g31008 | i0 | 85.5 | 4.96363636363636 | 55 | 8 | 100 | 0 | 165 | 1 | 185 | 239 | XP_069613570.1 beta-ureidopropionase [Ranitomeya imitator] | diamond | 819 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 20108417 | 20108417 | PRJDB9741_P_NODE_5256_length_276_cov_1.123348_g4940_i0 | PRJDB9741 | 5256 | 276 | 1.123348 | 3.10044048 | Metazoa | 33208 | Chordata | Chordata | 128 | 2.44e-34 | NR | XP_049994965.1 | 100897 | g4940 | i0 | 68.9 | 15.6521739130435 | 90 | 28 | 97.8 | 0 | 5 | 274 | 162 | 251 | XP_049994965.1 60S ribosomal protein L23a-like [Alexandromys fortis] | diamond | 4320 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Alexandromys | Alexandromys fortis | |
| 22962783 | 22962783 | PRJDB9741_P_NODE_2239_length_499_cov_3.713333_g1926_i0 | PRJDB9741 | 2239 | 499 | 3.713333 | 18.52953167 | Opisthokonta | 33154 | Chordata | Chordata | 81.6 | 1.21e-16 | NR | CAG5105596.1 | 34765 | g1926 | i0 | 69.1 | 3.66132264529058 | 110 | 34 | 66.1 | 0 | 460 | 131 | 1 | 110 | CAG5105596.1 Oidioi.mRNA.OKI2018_I69.chr1.g2273.t1.cds [Oikopleura dioica] | diamond | 1827 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 26741269 | 26741269 | PRJDB9741_P_NODE_2581_length_455_cov_2.000000_g2267_i0 | PRJDB9741 | 2581 | 455 | 2 | 9.1 | Chordata | 7711 | Chordata | Chordata | 192 | 1.11e-59 | NR | KAK9406484.1 | 8729 | g2267 | i0 | 67.1 | 75.2307692307692 | 146 | 44 | 94.3 | 2 | 430 | 2 | 38 | 182 | KAK9406484.1 hypothetical protein NXF25_005258 [Crotalus adamanteus] | diamond | 34230 | 193 | 0.994818652849741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 26868549 | 26868549 | PRJDB9741_P_NODE_15441_length_186_cov_1.248175_g15124_i0 | PRJDB9741 | 15441 | 186 | 1.248175 | 2.3216055 | Chordata | 7711 | Chordata | Chordata | 48.1 | 2.11e-4 | NR | NP_001407367.1 | 10090 | g15124 | i0 | 69 | 4.20967741935484 | 29 | 9 | 46.8 | 0 | 3 | 89 | 369 | 397 | NP_001407367.1 cysteine desulfurase isoform 2 [Mus musculus] | diamond | 783 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27784940 | 27784940 | PRJDB9741_P_NODE_8684_length_214_cov_2.551515_g8367_i0 | PRJDB9741 | 8684 | 214 | 2.551515 | 5.4602421 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.9 | 3.46e-16 | NR | NP_001085135.1 | 8355 | g8367 | i0 | 77.8 | 61.4439252336449 | 45 | 10 | 63.1 | 0 | 213 | 79 | 254 | 298 | NP_001085135.1 solute carrier family 25 (mitochondrial carrier, adenine nucleotide translocator), member 4 L homeolog [Xenopus laevis] | diamond | 13149 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 28864123 | 28864123 | PRJDB9741_P_NODE_24988_length_170_cov_1.685950_g24671_i0 | PRJDB9741 | 24988 | 170 | 1.68595 | 2.866115 | Suncus etruscus | 109475 | Chordata | Chordata | 50.8 | 3.8e-6 | NR | XP_049637858.1 | 109475 | g24671 | i0 | 60.6 | 0.582352941176471 | 33 | 13 | 58.2 | 0 | 169 | 71 | 88 | 120 | XP_049637858.1 60S ribosomal protein L22-like 1 [Suncus etruscus] | diamond | 99 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 28984810 | 28984810 | PRJDB9741_P_NODE_34448_length_164_cov_0.886957_g34131_i0 | PRJDB9741 | 34448 | 164 | 0.886957 | 1.45460948 | Branchiostoma | 7737 | Chordata | Chordata | 95.9 | 1.5e-21 | NR | CAH1231397.1 | 7740 | g34131 | i0 | 81.5 | 1.97560975609756 | 54 | 10 | 98.8 | 0 | 2 | 163 | 28 | 81 | CAH1231397.1 Hypp381 [Branchiostoma lanceolatum] | diamond | 324 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 29022446 | 29022446 | PRJDB9741_P_NODE_24708_length_170_cov_2.619835_g24391_i0 | PRJDB9741 | 24708 | 170 | 2.619835 | 4.4537195 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 67.8 | 2.02e-11 | NR | CAD7692971.1 | 34880 | g24391 | i0 | 67.3 | 0.970588235294118 | 55 | 18 | 97.1 | 0 | 165 | 1 | 28 | 82 | CAD7692971.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 165 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 29426382 | 29426382 | PRJDB9741_P_NODE_37049_length_162_cov_1.787611_g36732_i0 | PRJDB9741 | 37049 | 162 | 1.787611 | 2.89592982 | Metazoa | 33208 | Chordata | Chordata | 80.1 | 4.06e-16 | NR | XP_019633086.1 | 7741 | g36732 | i0 | 66 | 11.9259259259259 | 50 | 17 | 92.6 | 0 | 153 | 4 | 260 | 309 | XP_019633086.1 PREDICTED: deoxyribose-phosphate aldolase-like [Branchiostoma belcheri] | diamond | 1932 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29621485 | 29621485 | PRJDB9741_P_NODE_27530_length_167_cov_0.864407_g27213_i0 | PRJDB9741 | 27530 | 167 | 0.864407 | 1.44355969 | Staurois parvus | 386267 | Chordata | Chordata | 66.2 | 2.25e-12 | NR | CAI9547784.1 | 386267 | g27213 | i0 | 66.7 | 1.38323353293413 | 39 | 13 | 70.1 | 0 | 51 | 167 | 5 | 43 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 231 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30190423 | 30190423 | PRJDB9741_P_NODE_7732_length_226_cov_1.440678_g7415_i0 | PRJDB9741 | 7732 | 226 | 1.440678 | 3.25593228 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 44.3 | 0.00707 | NR | XP_066287101.1 | 7740 | g7415 | i0 | 32 | 1.35398230088496 | 75 | 41 | 99.6 | 2 | 225 | 1 | 43 | 107 | XP_066287101.1 large ribosomal subunit protein uL6-like [Branchiostoma lanceolatum] | diamond | 306 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 30695943 | 30695943 | PRJDB9741_P_NODE_30354_length_166_cov_0.871795_g30037_i0 | PRJDB9741 | 30354 | 166 | 0.871795 | 1.4471797 | Rhineura floridana | 261503 | Chordata | Chordata | 65.1 | 1.73e-10 | NR | XP_061493005.1 | 261503 | g30037 | i0 | 50.9 | 16.8975903614458 | 55 | 27 | 99.4 | 0 | 2 | 166 | 302 | 356 | XP_061493005.1 eukaryotic translation initiation factor 2A isoform X1 [Rhineura floridana] | diamond | 2805 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Rhineuridae | Rhineura | Rhineura floridana | |
| 30879580 | 30879580 | PRJDB9741_P_NODE_18974_length_180_cov_1.167939_g18657_i0 | PRJDB9741 | 18974 | 180 | 1.167939 | 2.1022902 | Metazoa | 33208 | Chordata | Chordata | 75.9 | 1.74e-15 | NR | XP_005994162.2 | 7897 | g18657 | i0 | 68.6 | 20.15 | 51 | 16 | 85 | 0 | 28 | 180 | 20 | 70 | XP_005994162.2 small ribosomal subunit protein eS17 [Latimeria chalumnae] | diamond | 3627 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 31201142 | 31201142 | PRJDB9741_P_NODE_7375_length_231_cov_1.379121_g7058_i0 | PRJDB9741 | 7375 | 231 | 1.379121 | 3.18576951 | Engystomops pustulosus | 76066 | Chordata | Chordata | 48.1 | 4.17e-4 | NR | KAG8571490.1 | 76066 | g7058 | i0 | 61.8 | 8.83116883116883 | 34 | 13 | 44.2 | 0 | 102 | 1 | 982 | 1015 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 2040 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31232994 | 31232994 | PRJDB9741_P_NODE_23035_length_173_cov_1.459677_g22718_i0 | PRJDB9741 | 23035 | 173 | 1.459677 | 2.52524121 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 57 | 1.36e-7 | NR | XP_019618294.1 | 7741 | g22718 | i0 | 46.4 | 0.971098265895954 | 56 | 30 | 97.1 | 0 | 1 | 168 | 1113 | 1168 | XP_019618294.1 PREDICTED: ATP-binding cassette sub-family A member 1-like [Branchiostoma belcheri] | diamond | 168 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31296372 | 31296372 | PRJDB9741_P_NODE_10735_length_201_cov_2.013158_g10418_i0 | PRJDB9741 | 10735 | 201 | 2.013158 | 4.04644758 | Branchiostoma floridae | 7739 | Chordata | Chordata | 42.4 | 0.0221 | NR | XP_035674994.1 | 7739 | g10418 | i0 | 62.5 | 1.65671641791045 | 24 | 9 | 35.8 | 0 | 12 | 83 | 167 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 333 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31417007 | 31417007 | PRJDB9741_P_NODE_40956_length_160_cov_2.279279_g40639_i0 | PRJDB9741 | 40956 | 160 | 2.279279 | 3.6468464 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 2.64e-6 | NR | OXB70831.1 | 9014 | g40639 | i0 | 44 | 1.8375 | 50 | 28 | 93.8 | 0 | 158 | 9 | 65 | 114 | OXB70831.1 hypothetical protein H355_002510 [Colinus virginianus] | diamond | 294 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Odontophoridae | Colinus | Colinus virginianus | |
| 31486441 | 31486441 | PRJDB9741_P_NODE_18196_length_181_cov_1.530303_g17879_i0 | PRJDB9741 | 18196 | 181 | 1.530303 | 2.76984843 | Erinaceus europaeus | 9365 | Chordata | Chordata | 72.8 | 2.08e-14 | NR | XP_060035059.1 | 9365 | g17879 | i0 | 69.6 | 0.76243093922651906 | 46 | 14 | 76.2 | 0 | 152 | 15 | 24 | 69 | XP_060035059.1 microsomal glutathione S-transferase 2 [Erinaceus europaeus] | diamond | 138 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Erinaceidae | Erinaceus | Erinaceus europaeus | |
| 31543595 | 31543595 | PRJDB9741_P_NODE_4936_length_287_cov_1.907563_g4620_i0 | PRJDB9741 | 4936 | 287 | 1.907563 | 5.47470581 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 64.3 | 7.56e-10 | NR | XP_019641702.1 | 7741 | g4620 | i0 | 42.2 | 4.74564459930314 | 90 | 52 | 94.1 | 0 | 276 | 7 | 12 | 101 | XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri] | diamond | 1362 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31581271 | 31581271 | PRJDB9741_P_NODE_42356_length_155_cov_2.207547_g42039_i0 | PRJDB9741 | 42356 | 155 | 2.207547 | 3.42169785 | Mus musculus | 10090 | Chordata | Chordata | 107 | 1.62e-25 | NR | NP_001165572.1 | 10090 | g42039 | i0 | 100 | 0.987096774193548 | 51 | 0 | 98.7 | 0 | 2 | 154 | 336 | 386 | NP_001165572.1 ribonuclease inhibitor isoform b [Mus musculus] | diamond | 153 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31764889 | 31764889 | PRJDB9741_P_NODE_33357_length_164_cov_1.382609_g33040_i0 | PRJDB9741 | 33357 | 164 | 1.382609 | 2.26747876 | Chordata | 7711 | Chordata | Chordata | 40 | 0.0323 | NR | XP_040261850.1 | 8384 | g33040 | i0 | 50 | 2.81707317073171 | 42 | 20 | 75 | 1 | 4 | 126 | 48 | 89 | XP_040261850.1 selenoprotein W [Bufo bufo] | diamond | 462 | 40 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo bufo | |
| 32524607 | 32524607 | PRJDB9741_P_NODE_34979_length_163_cov_1.789474_g34662_i0 | PRJDB9741 | 34979 | 163 | 1.789474 | 2.91684262 | Anura | 8342 | Chordata | Chordata | 50.1 | 3.31e-5 | NR | XP_018418790.1 | 125878 | g34662 | i0 | 48 | 2.76073619631902 | 50 | 26 | 92 | 0 | 1 | 150 | 368 | 417 | XP_018418790.1 PREDICTED: nucleolin isoform X4 [Nanorana parkeri] | diamond | 450 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dicroglossidae | Nanorana | Nanorana parkeri | |
| 32530460 | 32530460 | PRJDB9741_P_NODE_17639_length_182_cov_1.473684_g17322_i0 | PRJDB9741 | 17639 | 182 | 1.473684 | 2.68210488 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 91.7 | 9.68e-20 | NR | KAI8508850.1 | 7741 | g17322 | i0 | 67.2 | 7.5 | 58 | 19 | 95.6 | 0 | 3 | 176 | 692 | 749 | KAI8508850.1 hypothetical protein Bbelb_139490 [Branchiostoma belcheri] | diamond | 1365 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32587622 | 32587622 | PRJDB9741_P_NODE_35599_length_163_cov_0.894737_g35282_i0 | PRJDB9741 | 35599 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 4.36e-5 | NR | XP_028561992.1 | 64176 | g35282 | i0 | 48 | 5.52147239263804 | 50 | 26 | 92 | 0 | 158 | 9 | 45 | 94 | XP_028561992.1 protein unc-45 homolog A isoform X1 [Podarcis muralis] | diamond | 900 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis muralis | |
| 32902184 | 32902184 | PRJDB9741_P_NODE_18580_length_180_cov_2.083969_g18263_i0 | PRJDB9741 | 18580 | 180 | 2.083969 | 3.7511442 | Opisthokonta | 33154 | Chordata | Chordata | 108 | 1.74e-28 | NR | CBY33775.1 | 34765 | g18263 | i0 | 81.4 | 3.86666666666667 | 59 | 11 | 98.3 | 0 | 178 | 2 | 55 | 113 | CBY33775.1 unnamed protein product [Oikopleura dioica] | diamond | 696 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica |
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);;