contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA758770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27369493 | 27369493 | PRJNA758770_S_NODE_29163_length_246_cov_0.901734_g29037_i0 | PRJNA758770 | 29163 | 246 | 0.901734 | 2.21826564 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 42.7 | 0.0327 | NR | CAF3660305.1 | 433720 | g29037 | i0 | 40.4 | 0.573170731707317 | 47 | 28 | 57.3 | 0 | 45 | 185 | 83 | 129 | CAF3660305.1 unnamed protein product [Adineta steineri] | diamond | 141 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27905659 | 27905659 | PRJNA758770_S_NODE_27865_length_248_cov_0.891429_g27739_i0 | PRJNA758770 | 27865 | 248 | 0.891429 | 2.21074392 | Panulirus ornatus | 150431 | Arthropoda | Arthropoda | 89 | 4.88e-19 | NR | XP_071542476.1 | 150431 | g27739 | i0 | 54.9 | 0.858870967741935 | 71 | 31 | 85.9 | 1 | 220 | 8 | 89 | 158 | XP_071542476.1 uncharacterized protein [Panulirus ornatus] | diamond | 213 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Palinuridae | Panulirus | Panulirus ornatus | |
| 28032359 | 28032359 | PRJNA758770_S_NODE_27945_length_248_cov_0.891429_g27819_i0 | PRJNA758770 | 27945 | 248 | 0.891429 | 2.21074392 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 108 | 1.46e-25 | NR | KAL3115786.1 | 157864 | g27819 | i0 | 56.1 | 0.991935483870968 | 82 | 36 | 99.2 | 0 | 246 | 1 | 42 | 123 | KAL3115786.1 hypothetical protein niasHT_007791 [Heterodera trifolii] | diamond | 246 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28862728 | 28862728 | PRJNA758770_S_NODE_29848_length_245_cov_0.906977_g29722_i0 | PRJNA758770 | 29848 | 245 | 0.906977 | 2.22209365 | Carnivora | 33554 | Chordata | Chordata | 58.5 | 1.03e-7 | NR | XP_008706472.1 | 29073 | g29722 | i0 | 65.8 | 1.82448979591837 | 38 | 13 | 46.5 | 0 | 190 | 77 | 69 | 106 | XP_008706472.1 protein mono-ADP-ribosyltransferase PARP15 [Ursus maritimus] | diamond | 447 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ursus | Ursus maritimus | |
| 28894311 | 28894311 | PRJNA758770_S_NODE_21788_length_260_cov_2.497326_g21662_i0 | PRJNA758770 | 21788 | 260 | 2.497326 | 6.4930476 | Chordata | 7711 | Chordata | Chordata | 178 | 4.46e-56 | NR | KAF6475981.1 | 9407 | g21662 | i0 | 98.8 | 20.8384615384615 | 86 | 1 | 99.2 | 0 | 259 | 2 | 4 | 89 | KAF6475981.1 ribosomal protein L15 [Rousettus aegyptiacus] | diamond | 5418 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 29147404 | 29147404 | PRJNA758770_S_NODE_2369_length_667_cov_3.528620_g2250_i0 | PRJNA758770 | 2369 | 667 | 3.52862 | 23.5358954 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 3.87e-4 | NR | GBN61280.1 | 182803 | g2250 | i0 | 50.9 | 2.19490254872564 | 53 | 26 | 23.8 | 0 | 123 | 281 | 1136 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 1464 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 30369520 | 30369520 | PRJNA758770_S_NODE_29192_length_246_cov_0.901734_g29066_i0 | PRJNA758770 | 29192 | 246 | 0.901734 | 2.21826564 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 153 | 4.95e-42 | NR | CAD2167908.1 | 390850 | g29066 | i0 | 100 | 1.95121951219512 | 80 | 0 | 97.6 | 0 | 241 | 2 | 27 | 106 | CAD2167908.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 480 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30716484 | 30716484 | PRJNA758770_S_NODE_31194_length_244_cov_0.912281_g31068_i0 | PRJNA758770 | 31194 | 244 | 0.912281 | 2.22596564 | Chiloscyllium punctatum | 137246 | Chordata | Chordata | 42.7 | 0.0364 | NR | GCC41064.1 | 137246 | g31068 | i0 | 39.7 | 0.836065573770492 | 68 | 33 | 83.6 | 1 | 32 | 235 | 72 | 131 | GCC41064.1 hypothetical protein [Chiloscyllium punctatum] | diamond | 204 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium punctatum | |
| 31032837 | 31032837 | PRJNA758770_S_NODE_21955_length_259_cov_3.241935_g21829_i0 | PRJNA758770 | 21955 | 259 | 3.241935 | 8.39661165 | Capitella teleta | 283909 | Annelida | Annelida | 68.6 | 3.36e-12 | NR | ELU01707.1 | 283909 | g21829 | i0 | 100 | 6.31274131274131 | 37 | 0 | 42.9 | 0 | 3 | 113 | 123 | 159 | ELU01707.1 hypothetical protein CAPTEDRAFT_19190 [Capitella teleta] | diamond | 1635 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31095659 | 31095659 | PRJNA758770_S_NODE_26635_length_249_cov_0.886364_g26509_i0 | PRJNA758770 | 26635 | 249 | 0.886364 | 2.20704636 | Camelus dromedarius | 9838 | Chordata | Chordata | 52 | 2.26e-5 | NR | KAB1260743.1 | 9838 | g26509 | i0 | 62.7 | 0.614457831325301 | 51 | 19 | 61.4 | 0 | 211 | 59 | 329 | 379 | KAB1260743.1 Spermatogenesis-associated protein 31E1 [Camelus dromedarius] | diamond | 153 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus dromedarius | |
| 31507042 | 31507042 | PRJNA758770_S_NODE_25876_length_250_cov_0.881356_g25750_i0 | PRJNA758770 | 25876 | 250 | 0.881356 | 2.20339 | Ladona fulva | 123851 | Arthropoda | Arthropoda | 101 | 4.65e-26 | NR | KAG8227828.1 | 123851 | g25750 | i0 | 72.1 | 0.732 | 61 | 17 | 73.2 | 0 | 6 | 188 | 10 | 70 | KAG8227828.1 hypothetical protein J437_LFUL008472 [Ladona fulva] | diamond | 183 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Odonata | Libellulidae | Ladona | Ladona fulva | |
| 32370887 | 32370887 | PRJNA758770_S_NODE_33359_length_227_cov_6.032468_g33233_i0 | PRJNA758770 | 33359 | 227 | 6.032468 | 13.69370236 | Chordata | 7711 | Chordata | Chordata | 156 | 1.39e-47 | NR | KAF6475981.1 | 9407 | g33233 | i0 | 100 | 26.7621145374449 | 75 | 0 | 99.1 | 0 | 1 | 225 | 13 | 87 | KAF6475981.1 ribosomal protein L15 [Rousettus aegyptiacus] | diamond | 6075 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 32424291 | 32424291 | PRJNA758770_S_NODE_23539_length_253_cov_0.866667_g23413_i0 | PRJNA758770 | 23539 | 253 | 0.866667 | 2.19266751 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 98.2 | 8.960000000000001e-22 | NR | CAD2182996.1 | 390850 | g23413 | i0 | 84.3 | 0.8300395256917 | 70 | 10 | 83 | 1 | 210 | 1 | 1 | 69 | CAD2182996.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 210 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32519464 | 32519464 | PRJNA758770_S_NODE_32579_length_242_cov_0.923077_g32453_i0 | PRJNA758770 | 32579 | 242 | 0.923077 | 2.23384634 | Oppia nitens | 1686743 | Arthropoda | Arthropoda | 67.8 | 1.11e-11 | NR | XP_054158602.1 | 1686743 | g32453 | i0 | 70.9 | 0.681818181818182 | 55 | 16 | 68.2 | 0 | 77 | 241 | 4 | 58 | XP_054158602.1 troponin I-like [Oppia nitens] | diamond | 165 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Oppia | Oppia nitens | |
| 32582574 | 32582574 | PRJNA758770_S_NODE_31659_length_243_cov_0.917647_g31533_i0 | PRJNA758770 | 31659 | 243 | 0.917647 | 2.22988221 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 142 | 2.769999999999999e-41 | NR | CAD2168916.1 | 390850 | g31533 | i0 | 85.7 | 1.93827160493827 | 77 | 11 | 95.1 | 0 | 12 | 242 | 11 | 87 | CAD2168916.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 471 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32906828 | 32906828 | PRJNA758770_S_NODE_33140_length_235_cov_2.302469_g33014_i0 | PRJNA758770 | 33140 | 235 | 2.302469 | 5.41080215 | root | 1 | Root_unresolved | Root_unresolved | 69.3 | 4.89e-13 | NR | NP_008530.1 | 7797 | g33014 | i0 | 100 | 666.829787234043 | 36 | 0 | 46 | 0 | 1 | 108 | 42 | 77 | NP_008530.1 NADH dehydrogenase subunit 3 [Squalus acanthias] | diamond | 156705 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Squaliformes | Squalidae | Squalus | Squalus acanthias |
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);;