contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28012702 | 28012702 | PRJEB39269_P_NODE_65325_length_171_cov_2.250000_g64920_i0 | PRJEB39269 | 65325 | 171 | 2.25 | 3.8475 | Staurois parvus | 386267 | Chordata | Chordata | 51.6 | 1.4e-6 | NR | CAI9618505.1 | 386267 | g64920 | i0 | 43.9 | 1 | 57 | 31 | 98.2 | 1 | 171 | 4 | 38 | 94 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 171 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28738735 | 28738735 | PRJEB39269_P_NODE_64907_length_172_cov_1.120301_g64502_i0 | PRJEB39269 | 64907 | 172 | 1.120301 | 1.92691772 | Staurois parvus | 386267 | Chordata | Chordata | 62 | 1.16e-10 | NR | CAI9618505.1 | 386267 | g64502 | i0 | 53.5 | 1.5 | 43 | 20 | 75 | 0 | 1 | 129 | 9 | 51 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 258 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28770234 | 28770234 | PRJEB39269_P_NODE_58367_length_180_cov_2.531915_g57962_i0 | PRJEB39269 | 58367 | 180 | 2.531915 | 4.557447 | Polypterus senegalus | 55291 | Chordata | Chordata | 49.3 | 6.43e-5 | NR | XP_039600642.1 | 55291 | g57962 | i0 | 64.7 | 1.16666666666667 | 34 | 12 | 56.7 | 0 | 178 | 77 | 199 | 232 | XP_039600642.1 E3 SUMO-protein ligase ZBED1-like [Polypterus senegalus] | diamond | 210 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29243963 | 29243963 | PRJEB39269_P_NODE_80149_length_159_cov_0.941667_g79744_i0 | PRJEB39269 | 80149 | 159 | 0.941667 | 1.49725053 | Pseudophryne corroboree | 495146 | Chordata | Chordata | 61.6 | 2.54e-9 | NR | XP_063810519.1 | 495146 | g79744 | i0 | 56 | 0.943396226415094 | 50 | 22 | 94.3 | 0 | 9 | 158 | 208 | 257 | XP_063810519.1 toll-like receptor 7 [Pseudophryne corroboree] | diamond | 150 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Myobatrachidae | Pseudophryne | Pseudophryne corroboree | |
| 29426582 | 29426582 | PRJEB39269_P_NODE_90429_length_151_cov_1.098214_g90024_i0 | PRJEB39269 | 90429 | 151 | 1.098214 | 1.65830314 | root | 1 | Root_unresolved | Root_unresolved | 110 | 1.07e-26 | NR | XP_030109804.2 | 10090 | g90024 | i0 | 100 | 10.9271523178808 | 50 | 0 | 99.3 | 0 | 1 | 150 | 90 | 139 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 1650 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29938678 | 29938678 | PRJEB39269_P_NODE_45011_length_204_cov_2.842424_g44606_i0 | PRJEB39269 | 45011 | 204 | 2.842424 | 5.79854496 | Adineta environmental sample | 1193592 | Rotifera | other_Eukaryota | 64.7 | 8.91e-12 | NR | XBW52376.1 | 1193592 | g44606 | i0 | 64.3 | 0.823529411764706 | 56 | 20 | 82.4 | 0 | 204 | 37 | 25 | 80 | XBW52376.1 ice-binding family protein, partial [Adineta environmental sample] | diamond | 168 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta environmental sample | |
| 30191207 | 30191207 | PRJEB39269_P_NODE_71292_length_167_cov_0.898438_g70887_i0 | PRJEB39269 | 71292 | 167 | 0.898438 | 1.50039146 | Engystomops pustulosus | 76066 | Chordata | Chordata | 59.7 | 6.53e-10 | NR | KAG8573553.1 | 76066 | g70887 | i0 | 65.5 | 0.988023952095808 | 55 | 19 | 98.8 | 0 | 2 | 166 | 1 | 55 | KAG8573553.1 hypothetical protein GDO81_012454 [Engystomops pustulosus] | diamond | 165 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30601954 | 30601954 | PRJEB39269_P_NODE_79473_length_159_cov_1.708333_g79068_i0 | PRJEB39269 | 79473 | 159 | 1.708333 | 2.71624947 | Halotydeus destructor | 2874060 | Arthropoda | Arthropoda | 42.4 | 0.0161 | NR | KAI1303014.1 | 2874060 | g79068 | i0 | 38.1 | 2.24528301886792 | 42 | 23 | 73.6 | 1 | 155 | 39 | 174 | 215 | KAI1303014.1 hypothetical protein HDE_02276 [Halotydeus destructor] | diamond | 357 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Penthaleidae | Halotydeus | Halotydeus destructor | |
| 30854785 | 30854785 | PRJEB39269_P_NODE_59834_length_178_cov_2.266187_g59429_i0 | PRJEB39269 | 59834 | 178 | 2.266187 | 4.03381286 | Suricata suricatta | 37032 | Chordata | Chordata | 98.6 | 2.66e-22 | NR | XP_029793673.1 | 37032 | g59429 | i0 | 98 | 27.7921348314607 | 50 | 1 | 84.3 | 0 | 178 | 29 | 438 | 487 | XP_029793673.1 transmembrane protein 87B isoform X3 [Suricata suricatta] | diamond | 4947 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Herpestidae | Suricata | Suricata suricatta | |
| 31076120 | 31076120 | PRJEB39269_P_NODE_85335_length_154_cov_4.156522_g84930_i0 | PRJEB39269 | 85335 | 154 | 4.156522 | 6.40104388 | Portunus trituberculatus | 210409 | Arthropoda | Arthropoda | 44.7 | 0.00233 | NR | XP_045114004.1 | 210409 | g84930 | i0 | 63.9 | 1.28571428571429 | 36 | 10 | 64.3 | 1 | 100 | 2 | 252 | 287 | XP_045114004.1 neurofilament medium polypeptide-like [Portunus trituberculatus] | diamond | 198 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Portunidae | Portunus | Portunus trituberculatus | |
| 31455495 | 31455495 | PRJEB39269_P_NODE_14776_length_365_cov_2.346626_g14371_i0 | PRJEB39269 | 14776 | 365 | 2.346626 | 8.5651849 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0266 | NR | KAG2471189.1 | 55291 | g14371 | i0 | 57.1 | 0.287671232876712 | 35 | 15 | 28.8 | 0 | 208 | 312 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31859881 | 31859881 | PRJEB39269_P_NODE_75997_length_162_cov_1.146341_g75592_i0 | PRJEB39269 | 75997 | 162 | 1.146341 | 1.85707242 | Vespertilionidae | 9431 | Chordata | Chordata | 68.9 | 6.45e-12 | NR | XP_054581941.1 | 29078 | g75592 | i0 | 94.3 | 1.94444444444444 | 35 | 2 | 64.8 | 0 | 57 | 161 | 84 | 118 | XP_054581941.1 cytosolic 5'-nucleotidase 3A isoform X1 [Eptesicus fuscus] | diamond | 315 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Eptesicus | Eptesicus fuscus | |
| 32081436 | 32081436 | PRJEB39269_P_NODE_77838_length_160_cov_1.355372_g77433_i0 | PRJEB39269 | 77838 | 160 | 1.355372 | 2.1685952 | Mammalia | 40674 | Chordata | Chordata | 51.6 | 9.13e-6 | NR | KAG5195681.1 | 9940 | g77433 | i0 | 93.3 | 1.6875 | 30 | 2 | 56.3 | 0 | 2 | 91 | 1184 | 1213 | KAG5195681.1 hypothetical protein JEQ12_011976 [Ovis aries] | diamond | 270 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 32846055 | 32846055 | PRJEB39269_P_NODE_64640_length_172_cov_1.541353_g64235_i0 | PRJEB39269 | 64640 | 172 | 1.541353 | 2.65112716 | Amblyomma americanum | 6943 | Arthropoda | Arthropoda | 46.2 | 8.67e-4 | NR | KAK8780335.1 | 6943 | g64235 | i0 | 67.9 | 5.40697674418605 | 28 | 9 | 48.8 | 0 | 89 | 172 | 6 | 33 | KAK8780335.1 hypothetical protein V5799_018325 [Amblyomma americanum] | diamond | 930 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Amblyomma | Amblyomma americanum |
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);;