contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA931595" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27182779 | 27182779 | PRJNA931595_P_NODE_8122_length_289_cov_1.236111_g8013_i0 | PRJNA931595 | 8122 | 289 | 1.236111 | 3.57236079 | Bufotes viridis | 30338 | Chordata | Chordata | 45.4 | 0.00712 | NR | CAK8609802.1 | 30338 | g8013 | i0 | 62.5 | 0.332179930795848 | 32 | 12 | 33.2 | 0 | 190 | 285 | 1 | 32 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 96 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28572406 | 28572406 | PRJNA931595_P_NODE_10487_length_268_cov_1.528205_g10378_i0 | PRJNA931595 | 10487 | 268 | 1.528205 | 4.0955894 | Phyllostomus discolor | 89673 | Chordata | Chordata | 53.5 | 8.22e-6 | NR | XP_035889096.1 | 89673 | g10378 | i0 | 45.8 | 3.30223880597015 | 59 | 32 | 66 | 0 | 268 | 92 | 315 | 373 | XP_035889096.1 NACHT, LRR and PYD domains-containing protein 1-like [Phyllostomus discolor] | diamond | 885 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 28895121 | 28895121 | PRJNA931595_P_NODE_12688_length_250_cov_0.870056_g12579_i0 | PRJNA931595 | 12688 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Chordata | Chordata | 64.3 | 9.27e-11 | NR | XP_061413560.1 | 7753 | g12579 | i0 | 100 | 258.204 | 34 | 0 | 40.8 | 0 | 250 | 149 | 107 | 140 | XP_061413560.1 ATP synthase F(0) complex subunit C3, mitochondrial-like [Lethenteron reissneri] | diamond | 64551 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lethenteron | Lethenteron reissneri | |
| 28919597 | 28919597 | PRJNA931595_P_NODE_10208_length_270_cov_2.279188_g10099_i0 | PRJNA931595 | 10208 | 270 | 2.279188 | 6.1538076 | Sus scrofa | 9823 | Chordata | Chordata | 179 | 6.559999999999999e-52 | NR | XP_020938199.1 | 9823 | g10099 | i0 | 100 | 2.96666666666667 | 89 | 0 | 98.9 | 0 | 269 | 3 | 196 | 284 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 801 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 29211156 | 29211156 | PRJNA931595_P_NODE_7749_length_292_cov_3.890411_g7640_i0 | PRJNA931595 | 7749 | 292 | 3.890411 | 11.36000012 | root | 1 | Root_unresolved | Root_unresolved | 199 | 2.57e-62 | NR | BAA10935.1 | 7801 | g7640 | i0 | 97.9 | 125.568493150685 | 97 | 2 | 99.7 | 0 | 2 | 292 | 74 | 170 | BAA10935.1 nurse shark LMPX, partial [Ginglymostoma cirratum] | diamond | 36666 | 200 | 0.995 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Ginglymostomatidae | Ginglymostoma | Ginglymostoma cirratum | |
| 30214382 | 30214382 | PRJNA931595_P_NODE_9272_length_279_cov_1.310680_g9163_i0 | PRJNA931595 | 9272 | 279 | 1.31068 | 3.6567972 | Engystomops pustulosus | 76066 | Chordata | Chordata | 44.3 | 0.0167 | NR | KAG8571490.1 | 76066 | g9163 | i0 | 54.8 | 7.75268817204301 | 42 | 17 | 43 | 2 | 155 | 274 | 987 | 1028 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 2163 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30537536 | 30537536 | PRJNA931595_P_NODE_12813_length_249_cov_1.971591_g12704_i0 | PRJNA931595 | 12813 | 249 | 1.971591 | 4.90926159 | Metazoa | 33208 | Chordata | Chordata | 147 | 1.74e-42 | NR | AZL49427.1 | 9031 | g12704 | i0 | 95.1 | 1412.50602409639 | 82 | 4 | 98.8 | 0 | 3 | 248 | 121 | 202 | AZL49427.1 cytochrome c oxidase subunit I, partial [Gallus gallus] | diamond | 351714 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 30593567 | 30593567 | PRJNA931595_P_NODE_12853_length_249_cov_1.607955_g12744_i0 | PRJNA931595 | 12853 | 249 | 1.607955 | 4.00380795 | Engystomops pustulosus | 76066 | Chordata | Chordata | 44.3 | 0.00117 | NR | KAG8584541.1 | 76066 | g12744 | i0 | 66.7 | 0.36144578313253 | 30 | 10 | 36.1 | 0 | 159 | 248 | 8 | 37 | KAG8584541.1 hypothetical protein GDO81_004655 [Engystomops pustulosus] | diamond | 90 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31004455 | 31004455 | PRJNA931595_P_NODE_13914_length_246_cov_0.890173_g13805_i0 | PRJNA931595 | 13914 | 246 | 0.890173 | 2.18982558 | Pyxicephalus adspersus | 30357 | Chordata | Chordata | 141 | 1.0499999999999998e-37 | NR | DBA16504.1 | 30357 | g13805 | i0 | 98.5 | 17.6463414634146 | 65 | 1 | 79.3 | 0 | 3 | 197 | 417 | 481 | DBA16504.1 TPA: hypothetical protein GDO54_003891 [Pyxicephalus adspersus] | diamond | 4341 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pyxicephalidae | Pyxicephalus | Pyxicephalus adspersus | |
| 31383885 | 31383885 | PRJNA931595_P_NODE_6056_length_324_cov_1.151394_g5947_i0 | PRJNA931595 | 6056 | 324 | 1.151394 | 3.73051656 | Polypterus senegalus | 55291 | Chordata | Chordata | 47 | 5.74e-4 | NR | XP_039590836.1 | 55291 | g5947 | i0 | 100 | 10.2037037037037 | 19 | 0 | 17.6 | 0 | 59 | 3 | 30 | 48 | XP_039590836.1 pancreatic progenitor cell differentiation and proliferation factor-like [Polypterus senegalus] | diamond | 3306 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31422420 | 31422420 | PRJNA931595_P_NODE_10736_length_266_cov_1.176166_g10627_i0 | PRJNA931595 | 10736 | 266 | 1.176166 | 3.12860156 | Chordata | 7711 | Chordata | Chordata | 129 | 5.349999999999999e-37 | NR | CAM4613088.1 | 8472 | g10627 | i0 | 100 | 29.4586466165414 | 62 | 0 | 69.9 | 0 | 81 | 266 | 1 | 62 | CAM4613088.1 unnamed protein product [Lepidochelys kempii] | diamond | 7836 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii | ||
| 31636726 | 31636726 | PRJNA931595_P_NODE_13416_length_247_cov_2.454023_g13307_i0 | PRJNA931595 | 13416 | 247 | 2.454023 | 6.06143681 | Engystomops pustulosus | 76066 | Chordata | Chordata | 57 | 3.8e-7 | NR | KAG8571490.1 | 76066 | g13307 | i0 | 51.6 | 3.01214574898785 | 62 | 30 | 75.3 | 0 | 2 | 187 | 1014 | 1075 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 744 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31801802 | 31801802 | PRJNA931595_P_NODE_8437_length_286_cov_1.446009_g8328_i0 | PRJNA931595 | 8437 | 286 | 1.446009 | 4.13558574 | Chondrichthyes | 7777 | Chordata | Chordata | 147 | 3.12e-41 | NR | XP_059848313.1 | 79690 | g8328 | i0 | 100 | 25.6888111888112 | 70 | 0 | 73.4 | 0 | 1 | 210 | 240 | 309 | XP_059848313.1 eukaryotic translation initiation factor 3 subunit G isoform X1 [Hypanus sabinus] | diamond | 7347 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 32844738 | 32844738 | PRJNA931595_P_NODE_12400_length_251_cov_0.865169_g12291_i0 | PRJNA931595 | 12400 | 251 | 0.865169 | 2.17157419 | Chordata | 7711 | Chordata | Chordata | 64.3 | 1.04e-9 | NR | XP_038665106.1 | 7830 | g12291 | i0 | 97.1 | 189.9203187251 | 35 | 1 | 41.8 | 0 | 3 | 107 | 938 | 972 | XP_038665106.1 disks large-associated protein 1 isoform X5 [Scyliorhinus canicula] | diamond | 47670 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula |
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);;