contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA797475" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12260903 | 12260903 | PRJNA797475_P_NODE_23430_length_249_cov_0.875000_g23331_i0 | PRJNA797475 | 23430 | 249 | 0.875 | 2.17875 | Chordata | 7711 | Chordata | Chordata | 97.8 | 1.7400000000000003e-21 | NR | KAG8141766.1 | 35670 | g23331 | i0 | 57.5 | 86.8915662650602 | 80 | 28 | 96.4 | 1 | 249 | 10 | 235 | 308 | KAG8141766.1 hypothetical protein E2320_006450 [Naja naja] | diamond | 21636 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 16084001 | 16084001 | PRJNA797475_P_NODE_25933_length_246_cov_0.890173_g25834_i0 | PRJNA797475 | 25933 | 246 | 0.890173 | 2.18982558 | Cricetulus griseus | 10029 | Chordata | Chordata | 108 | 7.2e-29 | NR | ERE68096.1 | 10029 | g25834 | i0 | 78.5 | 0.792682926829268 | 65 | 14 | 79.3 | 0 | 203 | 9 | 1 | 65 | ERE68096.1 hypothetical protein H671_7g18186 [Cricetulus griseus] | diamond | 195 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 22458439 | 22458439 | PRJNA797475_P_NODE_12698_length_300_cov_1.356828_g12599_i0 | PRJNA797475 | 12698 | 300 | 1.356828 | 4.070484 | Scyliorhinus torazame | 75743 | Chordata | Chordata | 139 | 3.5300000000000004e-36 | NR | GCB73862.1 | 75743 | g12599 | i0 | 71.9 | 68.13 | 89 | 25 | 89 | 0 | 33 | 299 | 393 | 481 | GCB73862.1 hypothetical protein [Scyliorhinus torazame] | diamond | 20439 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus torazame | |
| 23734329 | 23734329 | PRJNA797475_P_NODE_4639_length_464_cov_1.163683_g4541_i0 | PRJNA797475 | 4639 | 464 | 1.163683 | 5.39948912 | Metazoa | 33208 | Chordata | Chordata | 222 | 3.18e-69 | NR | XP_039263546.1 | 7725 | g4541 | i0 | 66.7 | 16.0668103448276 | 156 | 50 | 99.6 | 1 | 463 | 2 | 169 | 324 | XP_039263546.1 cathepsin B-like [Styela clava] | diamond | 7455 | 223 | 0.995515695067265 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 27180072 | 27180072 | PRJNA797475_P_NODE_12862_length_298_cov_2.324444_g12763_i0 | PRJNA797475 | 12862 | 298 | 2.324444 | 6.92684312 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 76.3 | 4.37e-16 | NR | XP_019633956.1 | 7741 | g12763 | i0 | 75 | 5.96979865771812 | 52 | 13 | 52.3 | 0 | 287 | 132 | 1 | 52 | XP_019633956.1 PREDICTED: 60S ribosomal protein L29-like [Branchiostoma belcheri] | diamond | 1779 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27401684 | 27401684 | PRJNA797475_P_NODE_9523_length_338_cov_1.694340_g9424_i0 | PRJNA797475 | 9523 | 338 | 1.69434 | 5.7268692 | Spea bombifrons | 233779 | Chordata | Chordata | 70.1 | 1.14e-11 | NR | XP_053322712.1 | 233779 | g9424 | i0 | 38.7 | 1.51775147928994 | 106 | 62 | 94.1 | 2 | 320 | 3 | 86 | 188 | XP_053322712.1 carbonic anhydrase 3-like [Spea bombifrons] | diamond | 513 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pelobatidae | Spea | Spea bombifrons | |
| 28475119 | 28475119 | PRJNA797475_P_NODE_24626_length_248_cov_0.874286_g24527_i0 | PRJNA797475 | 24626 | 248 | 0.874286 | 2.16822928 | Marmota monax | 9995 | Chordata | Chordata | 90.9 | 1.83e-19 | NR | KAF7462032.1 | 9995 | g24527 | i0 | 56.3 | 5.15322580645161 | 71 | 31 | 85.9 | 0 | 20 | 232 | 209 | 279 | KAF7462032.1 hypothetical protein GHT09_013259 [Marmota monax] | diamond | 1278 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 28831390 | 28831390 | PRJNA797475_P_NODE_24588_length_248_cov_0.880000_g24489_i0 | PRJNA797475 | 24588 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Chordata | Chordata | 97.4 | 4.76e-24 | NR | NXL98530.1 | 137541 | g24489 | i0 | 66.7 | 19.2822580645161 | 81 | 27 | 98 | 0 | 245 | 3 | 26 | 106 | NXL98530.1 EF1D factor [Tyrannus savana] | diamond | 4782 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Tyrannidae | Tyrannus | Tyrannus savana | |
| 29264228 | 29264228 | PRJNA797475_P_NODE_12349_length_304_cov_1.099567_g12250_i0 | PRJNA797475 | 12349 | 304 | 1.099567 | 3.34268368 | Myotis brandtii | 109478 | Chordata | Chordata | 66.6 | 4.71e-11 | NR | EPQ04490.1 | 109478 | g12250 | i0 | 60.8 | 0.503289473684211 | 51 | 20 | 50.3 | 0 | 138 | 290 | 88 | 138 | EPQ04490.1 DNA-directed RNA polymerases I, II, and III subunit RPABC2 [Myotis brandtii] | diamond | 153 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis brandtii | |
| 30347879 | 30347879 | PRJNA797475_P_NODE_7912_length_365_cov_1.482877_g7813_i0 | PRJNA797475 | 7912 | 365 | 1.482877 | 5.41250105 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.7 | 0.0331 | NR | CAB3267733.1 | 59560 | g7813 | i0 | 30.5 | 1.44657534246575 | 95 | 58 | 75.6 | 3 | 287 | 12 | 12 | 101 | CAB3267733.1 protein Asterix [Phallusia mammillata] | diamond | 528 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 30599992 | 30599992 | PRJNA797475_P_NODE_28453_length_243_cov_0.905882_g28354_i0 | PRJNA797475 | 28453 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Chordata | Chordata | 129 | 3.5699999999999995e-35 | NR | XP_019394314.1 | 8502 | g28354 | i0 | 78 | 80 | 82 | 15 | 100 | 2 | 243 | 1 | 59 | 138 | XP_019394314.1 PREDICTED: vacuolar protein sorting-associated protein 29 isoform X2 [Crocodylus porosus] | diamond | 19440 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Crocodylidae | Crocodylus | Crocodylus porosus | ||
| 30726421 | 30726421 | PRJNA797475_P_NODE_11394_length_314_cov_1.278008_g11295_i0 | PRJNA797475 | 11394 | 314 | 1.278008 | 4.01294512 | Opisthokonta | 33154 | Chordata | Chordata | 60.1 | 2.98e-9 | NR | XP_027242255.1 | 10029 | g11295 | i0 | 70.2 | 3.09554140127389 | 47 | 14 | 44.9 | 0 | 314 | 174 | 7 | 53 | XP_027242255.1 40S ribosomal protein S6-like isoform X1, partial [Cricetulus griseus] | diamond | 972 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30970297 | 30970297 | PRJNA797475_P_NODE_10114_length_330_cov_1.494163_g10015_i0 | PRJNA797475 | 10114 | 330 | 1.494163 | 4.9307379 | Xenopus tropicalis | 8364 | Chordata | Chordata | 51.6 | 6.02e-6 | NR | NP_001291715.2 | 8364 | g10015 | i0 | 40.8 | 1.9 | 71 | 40 | 62.7 | 2 | 46 | 252 | 13 | 83 | NP_001291715.2 selenoprotein W1 [Xenopus tropicalis] | diamond | 627 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 31539365 | 31539365 | PRJNA797475_P_NODE_19396_length_261_cov_1.393617_g19297_i0 | PRJNA797475 | 19396 | 261 | 1.393617 | 3.63734037 | Mus musculus | 10090 | Chordata | Chordata | 93.2 | 1.56e-20 | NR | BAB30146.1 | 10090 | g19297 | i0 | 73.1 | 1.19540229885057 | 52 | 14 | 59.8 | 0 | 3 | 158 | 24 | 75 | BAB30146.1 unnamed protein product [Mus musculus] | diamond | 312 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 32045482 | 32045482 | PRJNA797475_P_NODE_15278_length_282_cov_1.425837_g15179_i0 | PRJNA797475 | 15278 | 282 | 1.425837 | 4.02086034 | Zootoca vivipara | 8524 | Chordata | Chordata | 79.7 | 1.4e-15 | NR | XP_034973091.1 | 8524 | g15179 | i0 | 43.5 | 0.904255319148936 | 85 | 47 | 89.4 | 1 | 16 | 267 | 175 | 259 | XP_034973091.1 C-signal [Zootoca vivipara] | diamond | 255 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Zootoca | Zootoca vivipara | |
| 32203624 | 32203624 | PRJNA797475_P_NODE_25578_length_246_cov_1.670520_g25479_i0 | PRJNA797475 | 25578 | 246 | 1.67052 | 4.1094792 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 72.8 | 1.02e-12 | NR | XP_019641984.1 | 7741 | g25479 | i0 | 44.6 | 0.902439024390244 | 74 | 41 | 90.2 | 0 | 222 | 1 | 35 | 108 | XP_019641984.1 PREDICTED: tripeptidyl-peptidase 1-like [Branchiostoma belcheri] | diamond | 222 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32497644 | 32497644 | PRJNA797475_P_NODE_12759_length_299_cov_2.668142_g12660_i0 | PRJNA797475 | 12759 | 299 | 2.668142 | 7.97774458 | Metazoa | 33208 | Chordata | Chordata | 95.9 | 3.2000000000000003e-22 | NR | XP_067969602.1 | 7769 | g12660 | i0 | 56.7 | 30.0602006688963 | 90 | 36 | 87.3 | 1 | 35 | 295 | 1 | 90 | XP_067969602.1 transmembrane emp24 domain-containing protein 2 isoform X2 [Myxine glutinosa] | diamond | 8988 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 32654915 | 32654915 | PRJNA797475_P_NODE_20400_length_255_cov_2.346154_g20301_i0 | PRJNA797475 | 20400 | 255 | 2.346154 | 5.9826927 | Opisthokonta | 33154 | Chordata | Chordata | 82 | 9.93e-18 | NR | XP_035667477.1 | 7739 | g20301 | i0 | 67.7 | 7.92941176470588 | 62 | 20 | 72.9 | 0 | 3 | 188 | 57 | 118 | XP_035667477.1 40S ribosomal protein S17 [Branchiostoma floridae] | diamond | 2022 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32835024 | 32835024 | PRJNA797475_P_NODE_30240_length_241_cov_0.916667_g30141_i0 | PRJNA797475 | 30240 | 241 | 0.916667 | 2.20916747 | Peromyscus leucopus | 10041 | Chordata | Chordata | 57.4 | 2.21e-7 | NR | XP_028747518.1 | 10041 | g30141 | i0 | 43.4 | 3.59751037344398 | 76 | 40 | 93.4 | 3 | 227 | 3 | 205 | 278 | XP_028747518.1 procathepsin L [Peromyscus leucopus] | diamond | 867 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Peromyscus | Peromyscus leucopus |
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);;