contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934814 | 934814 | PRJNA951412_P_NODE_2821_length_287_cov_2.168224_g2736_i0 | PRJNA951412 | 2821 | 287 | 2.168224 | 6.22280288 | Metazoa | 33208 | Chordata | Chordata | 118 | 1.94e-29 | NR | XP_042324725.1 | 8520 | g2736 | i0 | 54.5 | 25.0975609756098 | 101 | 39 | 98.3 | 1 | 3 | 284 | 153 | 253 | XP_042324725.1 cathepsin B isoform X1 [Sceloporus undulatus] | diamond | 7203 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Phrynosomatidae | Sceloporus | Sceloporus undulatus | |
| 11138445 | 11138445 | PRJNA951412_P_NODE_2849_length_287_cov_1.084112_g2764_i0 | PRJNA951412 | 2849 | 287 | 1.084112 | 3.11140144 | Chordata | 7711 | Chordata | Chordata | 131 | 3.78e-33 | NR | XP_004602334.3 | 42254 | g2764 | i0 | 68.1 | 167.717770034843 | 94 | 30 | 98.3 | 0 | 4 | 285 | 460 | 553 | XP_004602334.3 ATP-dependent translocase ABCB1 isoform X1 [Sorex araneus] | diamond | 48135 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Sorex | Sorex araneus | |
| 13688476 | 13688476 | PRJNA951412_P_NODE_551_length_641_cov_4.605634_g467_i0 | PRJNA951412 | 551 | 641 | 4.605634 | 29.52211394 | Patagioenas fasciata monilis | 372326 | Chordata | Chordata | 186 | 2.2599999999999997e-56 | NR | OPJ73047.1 | 372326 | g467 | i0 | 68.6 | 13.0670826833073 | 121 | 38 | 56.6 | 0 | 124 | 486 | 38 | 158 | OPJ73047.1 40S ribosomal protein S12 [Patagioenas fasciata monilis] | diamond | 8376 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Patagioenas | Patagioenas fasciata | |
| 26803973 | 26803973 | PRJNA951412_P_NODE_1501_length_366_cov_2.450512_g1416_i0 | PRJNA951412 | 1501 | 366 | 2.450512 | 8.96887392 | Branchiostoma floridae | 7739 | Chordata | Chordata | 82 | 1.97e-15 | NR | XP_035671522.1 | 7739 | g1416 | i0 | 39.8 | 1.90163934426229 | 128 | 71 | 100 | 5 | 1 | 366 | 33 | 160 | XP_035671522.1 subtilisin-like serine protease Rho m 2.0101 [Branchiostoma floridae] | diamond | 696 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 27088925 | 27088925 | PRJNA951412_P_NODE_5122_length_249_cov_2.630682_g5037_i0 | PRJNA951412 | 5122 | 249 | 2.630682 | 6.55039818 | Myxine glutinosa | 7769 | Chordata | Chordata | 89 | 1.61e-18 | NR | XP_067977168.1 | 7769 | g5037 | i0 | 50 | 11.6144578313253 | 82 | 41 | 98.8 | 0 | 247 | 2 | 215 | 296 | XP_067977168.1 nucleoredoxin isoform X1 [Myxine glutinosa] | diamond | 2892 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28952219 | 28952219 | PRJNA951412_P_NODE_7388_length_243_cov_0.917647_g7303_i0 | PRJNA951412 | 7388 | 243 | 0.917647 | 2.22988221 | Oikopleura dioica | 34765 | Chordata | Chordata | 57.8 | 1.9e-7 | NR | CBY14923.1 | 34765 | g7303 | i0 | 59 | 0.962962962962963 | 39 | 16 | 48.1 | 0 | 9 | 125 | 433 | 471 | CBY14923.1 unnamed protein product [Oikopleura dioica] | diamond | 234 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 29621122 | 29621122 | PRJNA951412_P_NODE_2450_length_303_cov_2.017391_g2365_i0 | PRJNA951412 | 2450 | 303 | 2.017391 | 6.11269473 | Testudines | 8459 | Chordata | Chordata | 103 | 2.98e-23 | NR | CAM2110467.1 | 8467 | g2365 | i0 | 52 | 8.88118811881188 | 100 | 47 | 98 | 1 | 299 | 3 | 419 | 518 | CAM2110467.1 unnamed protein product [Caretta caretta] | diamond | 2691 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 30057060 | 30057060 | PRJNA951412_P_NODE_3531_length_265_cov_1.229167_g3446_i0 | PRJNA951412 | 3531 | 265 | 1.229167 | 3.25729255 | Xenopus laevis | 8355 | Chordata | Chordata | 76.3 | 7.67e-14 | NR | NP_001080042.1 | 8355 | g3446 | i0 | 44 | 4.72075471698113 | 84 | 46 | 95.1 | 1 | 12 | 263 | 156 | 238 | NP_001080042.1 transducin (beta)-like 3 L homeolog [Xenopus laevis] | diamond | 1251 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 30847088 | 30847088 | PRJNA951412_P_NODE_714_length_542_cov_2.547974_g629_i0 | PRJNA951412 | 714 | 542 | 2.547974 | 13.81001908 | Hypanus sabinus | 79690 | Chordata | Chordata | 72.8 | 2.61e-11 | NR | XP_059816063.1 | 79690 | g629 | i0 | 37.6 | 1.20664206642066 | 109 | 62 | 57.6 | 2 | 461 | 150 | 110 | 217 | XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus] | diamond | 654 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 31264456 | 31264456 | PRJNA951412_P_NODE_1955_length_331_cov_1.426357_g1870_i0 | PRJNA951412 | 1955 | 331 | 1.426357 | 4.72124167 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 3.8399999999999997e-42 | NR | KAI6077199.1 | 8832 | g1870 | i0 | 78.3 | 78.9425981873112 | 92 | 20 | 83.4 | 0 | 54 | 329 | 2 | 93 | KAI6077199.1 Protein transport protein Sec61 subunit alpha [Aix galericulata] | diamond | 26130 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Aix | Aix galericulata | |
| 31352847 | 31352847 | PRJNA951412_P_NODE_3056_length_280_cov_1.352657_g2971_i0 | PRJNA951412 | 3056 | 280 | 1.352657 | 3.7874396 | Staurois parvus | 386267 | Chordata | Chordata | 50.8 | 5.42e-5 | NR | CAI9536211.1 | 386267 | g2971 | i0 | 51.8 | 1.11428571428571 | 56 | 20 | 52.5 | 3 | 48 | 194 | 170 | 225 | CAI9536211.1 unnamed protein product [Staurois parvus] | diamond | 312 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus |
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);;