contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13168971 | 13168971 | PRJNA407368_S_NODE_9471_length_162_cov_3.300752_g9369_i0 | PRJNA407368 | 9471 | 162 | 3.300752 | 5.34721824 | Metazoa | 33208 | Chordata | Chordata | 88.6 | 5.89e-21 | NR | XP_002128932.1 | 7719 | g9369 | i0 | 75.5 | 9.81481481481481 | 53 | 13 | 98.1 | 0 | 3 | 161 | 58 | 110 | XP_002128932.1 60S ribosomal protein L31 [Ciona intestinalis] | diamond | 1590 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 20816776 | 20816776 | PRJNA407368_S_NODE_6137_length_217_cov_2.526596_g6035_i0 | PRJNA407368 | 6137 | 217 | 2.526596 | 5.48271332 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 98.2 | 1.3e-22 | NR | CAB3998061.1 | 317549 | g6035 | i0 | 64.8 | 1.963133640553 | 71 | 25 | 98.2 | 0 | 215 | 3 | 49 | 119 | CAB3998061.1 60S acidic ribosomal P0-like [Paramuricea clavata] | diamond | 426 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27233517 | 27233517 | PRJNA407368_S_NODE_5323_length_238_cov_2.358852_g5221_i0 | PRJNA407368 | 5323 | 238 | 2.358852 | 5.61406776 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 67 | 1.02e-10 | NR | XP_033628590.1 | 7604 | g5221 | i0 | 47.3 | 1.53781512605042 | 55 | 29 | 69.3 | 0 | 181 | 17 | 527 | 581 | XP_033628590.1 papilin-like [Asterias rubens] | diamond | 366 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27423352 | 27423352 | PRJNA407368_S_NODE_4603_length_264_cov_4.361702_g4501_i0 | PRJNA407368 | 4603 | 264 | 4.361702 | 11.51489328 | Acanthoscelides obtectus | 200917 | Arthropoda | Arthropoda | 62 | 7.78e-9 | NR | CAH2011626.1 | 200917 | g4501 | i0 | 40.8 | 0.863636363636364 | 76 | 45 | 86.4 | 0 | 262 | 35 | 562 | 637 | CAH2011626.1 unnamed protein product, partial [Acanthoscelides obtectus] | diamond | 228 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Acanthoscelides | Acanthoscelides obtectus | |
| 27739198 | 27739198 | PRJNA407368_S_NODE_9264_length_165_cov_1.691176_g9162_i0 | PRJNA407368 | 9264 | 165 | 1.691176 | 2.7904404 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 94.7 | 3.52e-22 | NR | AEC33277.1 | 6687 | g9162 | i0 | 92.6 | 0.981818181818182 | 54 | 4 | 98.2 | 0 | 164 | 3 | 27 | 80 | AEC33277.1 14-3-3 protein, partial [Penaeus monodon] | diamond | 162 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 28149422 | 28149422 | PRJNA407368_S_NODE_6265_length_214_cov_2.664865_g6163_i0 | PRJNA407368 | 6265 | 214 | 2.664865 | 5.7028111 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 72 | 1.2e-12 | NR | KAK3604987.1 | 2493646 | g6163 | i0 | 51.5 | 4.5981308411215 | 68 | 32 | 95.3 | 1 | 9 | 212 | 102 | 168 | KAK3604987.1 hypothetical protein CHS0354_000652 [Potamilus streckersoni] | diamond | 984 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 28717746 | 28717746 | PRJNA407368_S_NODE_1647_length_489_cov_5.517391_g1552_i0 | PRJNA407368 | 1647 | 489 | 5.517391 | 26.98004199 | Aphis craccivora | 307492 | Arthropoda | Arthropoda | 125 | 1.4e-33 | NR | KAF0766158.1 | 307492 | g1552 | i0 | 86.3 | 0.447852760736196 | 73 | 8 | 43.6 | 1 | 155 | 367 | 51 | 123 | KAF0766158.1 Uncharacterized protein FWK35_00018507 [Aphis craccivora] | diamond | 219 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Aphis | Aphis craccivora | |
| 30644004 | 30644004 | PRJNA407368_S_NODE_10253_length_154_cov_1.176000_g10151_i0 | PRJNA407368 | 10253 | 154 | 1.176 | 1.81104 | Halocaridina rubra | 373956 | Arthropoda | Arthropoda | 82 | 8.79e-19 | NR | KAK7047499.1 | 373956 | g10151 | i0 | 68.6 | 2.98051948051948 | 51 | 16 | 99.4 | 0 | 2 | 154 | 19 | 69 | KAK7047499.1 60S ribosomal protein L37 [Halocaridina rubra] | diamond | 459 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Atyidae | Halocaridina | Halocaridina rubra | |
| 32573453 | 32573453 | PRJNA407368_S_NODE_6639_length_205_cov_8.545455_g6537_i0 | PRJNA407368 | 6639 | 205 | 8.545455 | 17.51818275 | Petrolisthes manimaculis | 1843537 | Arthropoda | Arthropoda | 40.8 | 0.0445 | NR | KAK4307008.1 | 1843537 | g6537 | i0 | 54.5 | 0.482926829268293 | 33 | 15 | 48.3 | 0 | 146 | 48 | 38 | 70 | KAK4307008.1 hypothetical protein Pmani_021200 [Petrolisthes manimaculis] | diamond | 99 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes manimaculis | |
| 32762110 | 32762110 | PRJNA407368_S_NODE_960_length_651_cov_6.289389_g886_i0 | PRJNA407368 | 960 | 651 | 6.289389 | 40.94392239 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 117 | 1.18e-30 | NR | MFH4985130.1 | 75299 | g886 | i0 | 92.6 | 0.248847926267281 | 54 | 4 | 24.9 | 0 | 2 | 163 | 14 | 67 | MFH4985130.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 162 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 32856499 | 32856499 | PRJNA407368_S_NODE_9900_length_157_cov_2.914062_g9798_i0 | PRJNA407368 | 9900 | 157 | 2.914062 | 4.57507734 | Tetranychus urticae | 32264 | Arthropoda | Arthropoda | 88.2 | 1.08e-18 | NR | XP_015794906.1 | 32264 | g9798 | i0 | 83.7 | 0.936305732484076 | 49 | 8 | 93.6 | 0 | 152 | 6 | 1231 | 1279 | XP_015794906.1 mediator of RNA polymerase II transcription subunit 14 [Tetranychus urticae] | diamond | 147 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae |
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);;