contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA879067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21258088 | 21258088 | PRJNA879067_P_NODE_77017_length_352_cov_2.501792_g73531_i0 | PRJNA879067 | 77017 | 352 | 2.501792 | 8.80630784 | Mammalia | 40674 | Chordata | Chordata | 55.5 | 4.51e-7 | NR | XP_043843908.1 | 33562 | g73531 | i0 | 51.7 | 3.46875 | 58 | 26 | 49.4 | 1 | 48 | 221 | 24 | 79 | XP_043843908.1 40S ribosomal protein S25-like [Dromiciops gliroides] | diamond | 1221 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Microbiotheria | Microbiotheriidae | Dromiciops | Dromiciops gliroides | |
| 27560621 | 27560621 | PRJNA879067_P_NODE_109724_length_242_cov_2.692308_g106238_i0 | PRJNA879067 | 109724 | 242 | 2.692308 | 6.51538536 | Crocuta crocuta | 9678 | Chordata | Chordata | 48.1 | 1.49e-4 | NR | KAF0870898.1 | 9678 | g106238 | i0 | 43.1 | 0.71900826446281 | 58 | 31 | 70.7 | 2 | 42 | 212 | 50 | 106 | KAF0870898.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 174 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 27719115 | 27719115 | PRJNA879067_P_NODE_82984_length_326_cov_3.723320_g79498_i0 | PRJNA879067 | 82984 | 326 | 3.72332 | 12.1380232 | Staurois parvus | 386267 | Chordata | Chordata | 108 | 1.94e-28 | NR | CAI9604451.1 | 386267 | g79498 | i0 | 66.7 | 1.62883435582822 | 81 | 27 | 74.5 | 0 | 298 | 56 | 1 | 81 | CAI9604451.1 unnamed protein product, partial [Staurois parvus] | diamond | 531 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27750471 | 27750471 | PRJNA879067_P_NODE_103864_length_250_cov_0.870056_g100378_i0 | PRJNA879067 | 103864 | 250 | 0.870056 | 2.17514 | Marmota monax | 9995 | Chordata | Chordata | 72.4 | 1.13e-12 | NR | KAF7462032.1 | 9995 | g100378 | i0 | 43.7 | 1.704 | 71 | 40 | 85.2 | 0 | 22 | 234 | 209 | 279 | KAF7462032.1 hypothetical protein GHT09_013259 [Marmota monax] | diamond | 426 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 27750483 | 27750483 | PRJNA879067_P_NODE_39924_length_623_cov_20.549091_g36479_i0 | PRJNA879067 | 39924 | 623 | 20.549091 | 128.02083693 | Dasypus novemcinctus | 9361 | Chordata | Chordata | 46.6 | 0.0422 | NR | XP_058141964.1 | 9361 | g36479 | i0 | 63.2 | 0.36597110754414103 | 38 | 14 | 18.3 | 0 | 167 | 280 | 435 | 472 | XP_058141964.1 merlin-like isoform X2 [Dasypus novemcinctus] | diamond | 228 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Cingulata | Dasypodidae | Dasypus | Dasypus novemcinctus | |
| 27876491 | 27876491 | PRJNA879067_P_NODE_110045_length_242_cov_0.911243_g106559_i0 | PRJNA879067 | 110045 | 242 | 0.911243 | 2.20520806 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 60.5 | 1.97e-8 | NR | XP_055511116.1 | 7782 | g106559 | i0 | 50 | 12.1611570247934 | 60 | 30 | 74.4 | 0 | 194 | 15 | 246 | 305 | XP_055511116.1 uncharacterized protein LOC129709027 [Leucoraja erinaceus] | diamond | 2943 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 28231595 | 28231595 | PRJNA879067_P_NODE_105626_length_248_cov_0.880000_g102140_i0 | PRJNA879067 | 105626 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Chordata | Chordata | 49.7 | 1.41e-4 | NR | XP_067971183.1 | 7769 | g102140 | i0 | 38.3 | 3.66532258064516 | 60 | 31 | 72.6 | 1 | 246 | 67 | 407 | 460 | XP_067971183.1 uncharacterized protein [Myxine glutinosa] | diamond | 909 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28508082 | 28508082 | PRJNA879067_P_NODE_65047_length_416_cov_6.408163_g61562_i0 | PRJNA879067 | 65047 | 416 | 6.408163 | 26.65795808 | Engystomops pustulosus | 76066 | Chordata | Chordata | 46.6 | 9.96e-4 | NR | KAG8536220.1 | 76066 | g61562 | i0 | 67.9 | 0.605769230769231 | 28 | 9 | 20.2 | 0 | 320 | 403 | 43 | 70 | KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] | diamond | 252 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 29139750 | 29139750 | PRJNA879067_P_NODE_105589_length_248_cov_0.880000_g102103_i0 | PRJNA879067 | 105589 | 248 | 0.88 | 2.1824 | Muntiacus reevesi | 9886 | Chordata | Chordata | 44.7 | 0.00259 | NR | KAB0379141.1 | 9886 | g102103 | i0 | 80 | 0.362903225806452 | 30 | 2 | 35.1 | 2 | 88 | 174 | 93 | 119 | KAB0379141.1 hypothetical protein FD755_010719, partial [Muntiacus reevesi] | diamond | 90 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 29265604 | 29265604 | PRJNA879067_P_NODE_26109_length_843_cov_4.500000_g22896_i0 | PRJNA879067 | 26109 | 843 | 4.5 | 37.935 | Charadrius vociferus | 50402 | Chordata | Chordata | 111 | 2.38e-23 | NR | XP_009883999.1 | 50402 | g22896 | i0 | 60.6 | 0.352313167259786 | 99 | 39 | 35.2 | 0 | 786 | 490 | 242 | 340 | XP_009883999.1 PREDICTED: uncharacterized protein LOC104287046, partial [Charadrius vociferus] | diamond | 297 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Charadriidae | Charadrius | Charadrius vociferus | |
| 30149832 | 30149832 | PRJNA879067_P_NODE_11772_length_1421_cov_3.280415_g9472_i0 | PRJNA879067 | 11772 | 1421 | 3.280415 | 46.61469715 | Mobula hypostoma | 723540 | Chordata | Chordata | 56.6 | 2.17e-4 | NR | XP_062911967.1 | 723540 | g9472 | i0 | 28.6 | 0.570021111893033 | 147 | 89 | 29.8 | 4 | 995 | 1417 | 323 | 459 | XP_062911967.1 ribosomal protein S6 kinase alpha-5-like isoform X3 [Mobula hypostoma] | diamond | 810 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Myliobatidae | Mobula | Mobula hypostoma | |
| 30221158 | 30221158 | PRJNA879067_P_NODE_79632_length_341_cov_1.048507_g76146_i0 | PRJNA879067 | 79632 | 341 | 1.048507 | 3.57540887 | Metazoa | 33208 | Chordata | Chordata | 67.8 | 8.71e-11 | NR | XP_038452574.1 | 9615 | g76146 | i0 | 45.1 | 5.48973607038123 | 71 | 39 | 62.5 | 0 | 311 | 99 | 181 | 251 | XP_038452574.1 LOW QUALITY PROTEIN: 40S ribosomal protein S3a-like isoform X4 [Canis lupus familiaris] | diamond | 1872 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 30411182 | 30411182 | PRJNA879067_P_NODE_102793_length_251_cov_3.174157_g99307_i0 | PRJNA879067 | 102793 | 251 | 3.174157 | 7.96713407 | Mammalia | 40674 | Chordata | Chordata | 57.8 | 2.04e-7 | NR | XP_060046634.1 | 9365 | g99307 | i0 | 50.7 | 4.48207171314741 | 75 | 37 | 89.6 | 0 | 244 | 20 | 173 | 247 | XP_060046634.1 potassium voltage-gated channel subfamily S member 1 [Erinaceus europaeus] | diamond | 1125 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Erinaceidae | Erinaceus | Erinaceus europaeus | |
| 30474193 | 30474193 | PRJNA879067_P_NODE_65593_length_413_cov_2.529412_g62108_i0 | PRJNA879067 | 65593 | 413 | 2.529412 | 10.44647156 | Carnivora | 33554 | Chordata | Chordata | 58.5 | 4.4e-7 | NR | KAF0875183.1 | 9678 | g62108 | i0 | 83.9 | 0.450363196125908 | 31 | 5 | 22.5 | 0 | 321 | 413 | 185 | 215 | KAF0875183.1 NDKB kinase, partial [Crocuta crocuta] | diamond | 186 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 31043117 | 31043117 | PRJNA879067_P_NODE_112015_length_226_cov_3.117647_g108529_i0 | PRJNA879067 | 112015 | 226 | 3.117647 | 7.04588222 | Opisthokonta | 33154 | Chordata | Chordata | 47.8 | 4.79e-4 | NR | XP_045441905.1 | 59472 | g108529 | i0 | 33.9 | 4.64601769911504 | 59 | 39 | 78.3 | 0 | 184 | 8 | 168 | 226 | XP_045441905.1 LOW QUALITY PROTEIN: cyclin-Y-like protein 1 [Pipistrellus kuhlii] | diamond | 1050 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Pipistrellus | Pipistrellus kuhlii | |
| 31074439 | 31074439 | PRJNA879067_P_NODE_72615_length_374_cov_2.000000_g69130_i0 | PRJNA879067 | 72615 | 374 | 2 | 7.48 | Anura | 8342 | Chordata | Chordata | 55.5 | 5.6e-6 | NR | CAK8621194.1 | 30338 | g69130 | i0 | 26.5 | 1.92513368983957 | 113 | 77 | 85.8 | 2 | 332 | 12 | 343 | 455 | CAK8621194.1 LINE-1 retrotransposable element ORF2 protein [Bufotes viridis] | diamond | 720 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31097769 | 31097769 | PRJNA879067_P_NODE_110415_length_242_cov_0.911243_g106929_i0 | PRJNA879067 | 110415 | 242 | 0.911243 | 2.20520806 | Polypterus senegalus | 55291 | Chordata | Chordata | 81.3 | 1.02e-15 | NR | KAG2463522.1 | 55291 | g106929 | i0 | 55 | 21.8181818181818 | 80 | 36 | 99.2 | 0 | 241 | 2 | 563 | 642 | KAG2463522.1 IFT56 protein, partial [Polypterus senegalus] | diamond | 5280 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31192320 | 31192320 | PRJNA879067_P_NODE_103975_length_250_cov_0.870056_g100489_i0 | PRJNA879067 | 103975 | 250 | 0.870056 | 2.17514 | Mus musculus | 10090 | Chordata | Chordata | 57.8 | 1.69e-8 | NR | EDL01021.1 | 10090 | g100489 | i0 | 46.7 | 0.72 | 60 | 32 | 72 | 0 | 212 | 33 | 52 | 111 | EDL01021.1 mCG1026770 [Mus musculus] | diamond | 180 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31192327 | 31192327 | PRJNA879067_P_NODE_31575_length_738_cov_4.039098_g28231_i0 | PRJNA879067 | 31575 | 738 | 4.039098 | 29.80854324 | Marmota monax | 9995 | Chordata | Chordata | 60.1 | 3.41e-7 | NR | VTJ83332.1 | 9995 | g28231 | i0 | 75.7 | 0.963414634146341 | 37 | 9 | 15 | 0 | 112 | 2 | 37 | 73 | VTJ83332.1 Hypothetical predicted protein [Marmota monax] | diamond | 711 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 31485612 | 31485612 | PRJNA879067_P_NODE_41576_length_605_cov_3.682331_g38124_i0 | PRJNA879067 | 41576 | 605 | 3.682331 | 22.27810255 | Metazoa | 33208 | Chordata | Chordata | 55.5 | 4.34e-5 | NR | XP_032084909.1 | 35005 | g38124 | i0 | 25.8 | 2.83140495867769 | 186 | 118 | 86.3 | 6 | 590 | 69 | 88 | 265 | XP_032084909.1 ubiquitin-protein ligase E3B [Thamnophis elegans] | diamond | 1713 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Colubridae | Thamnophis | Thamnophis elegans | |
| 32331912 | 32331912 | PRJNA879067_P_NODE_54879_length_486_cov_2.523002_g51394_i0 | PRJNA879067 | 54879 | 486 | 2.523002 | 12.26178972 | Petromyzon marinus | 7757 | Chordata | Chordata | 73.9 | 1.61e-13 | NR | XP_032822869.1 | 7757 | g51394 | i0 | 53.2 | 1.45679012345679 | 47 | 22 | 29 | 0 | 11 | 151 | 79 | 125 | XP_032822869.1 brain protein I3-like isoform X1 [Petromyzon marinus] | diamond | 708 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 32616068 | 32616068 | PRJNA879067_P_NODE_40900_length_612_cov_24.185529_g37448_i0 | PRJNA879067 | 40900 | 612 | 24.185529 | 148.01543748 | Aptenodytes forsteri | 9233 | Chordata | Chordata | 83.2 | 4.57e-15 | NR | XP_019327576.1 | 9233 | g37448 | i0 | 51 | 0.5 | 102 | 34 | 42.2 | 3 | 175 | 432 | 4 | 105 | XP_019327576.1 PREDICTED: LOW QUALITY PROTEIN: cancer-associated gene 1 protein [Aptenodytes forsteri] | diamond | 306 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Aptenodytes | Aptenodytes forsteri |
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);;