contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 121903 | 121903 | PRJEB55250_P_NODE_7161_length_283_cov_1.228571_g7037_i0 | PRJEB55250 | 7161 | 283 | 1.228571 | 3.47685593 | root | 1 | Root_unresolved | Root_unresolved | 147 | 2.4e-40 | NR | XP_039260094.1 | 7725 | g7037 | i0 | 77.4 | 14.7879858657244 | 93 | 21 | 98.6 | 0 | 281 | 3 | 160 | 252 | XP_039260094.1 glutaryl-CoA dehydrogenase, mitochondrial-like isoform X1 [Styela clava] | diamond | 4185 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 6499883 | 6499883 | PRJEB55250_P_NODE_11706_length_251_cov_0.865169_g11582_i0 | PRJEB55250 | 11706 | 251 | 0.865169 | 2.17157419 | Rotaria | 231623 | Rotifera | other_Eukaryota | 140 | 1.82e-36 | NR | CAF4293048.1 | 392030 | g11582 | i0 | 74.7 | 18.8247011952191 | 83 | 21 | 99.2 | 0 | 250 | 2 | 600 | 682 | CAF4293048.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 4725 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 9920122 | 9920122 | PRJEB55250_P_NODE_6888_length_285_cov_1.433962_g6764_i0 | PRJEB55250 | 6888 | 285 | 1.433962 | 4.0867917 | Trichinella | 6333 | Nematoda | Nematoda | 102 | 7.39e-23 | NR | KRZ62808.1 | 6335 | g6764 | i0 | 54.1 | 8 | 85 | 39 | 89.5 | 0 | 1 | 255 | 438 | 522 | KRZ62808.1 Regulator of chromosome condensation, partial [Trichinella nativa] | diamond | 2280 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa | |
| 10324833 | 10324833 | PRJEB55250_P_NODE_3149_length_376_cov_1.118812_g3025_i0 | PRJEB55250 | 3149 | 376 | 1.118812 | 4.20673312 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 166 | 7.34e-49 | NR | RWS10781.1 | 1965070 | g3025 | i0 | 66.9 | 1.98670212765957 | 124 | 41 | 98.9 | 0 | 4 | 375 | 38 | 161 | RWS10781.1 ribosomal protein-like protein, partial [Dinothrombium tinctorium] | diamond | 747 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombidiidae | Dinothrombium | Dinothrombium tinctorium | |
| 19247418 | 19247418 | PRJEB55250_P_NODE_5756_length_299_cov_1.362832_g5632_i0 | PRJEB55250 | 5756 | 299 | 1.362832 | 4.07486768 | Rhabditidae | 6243 | Nematoda | Nematoda | 152 | 3.15e-44 | NR | ACI49216.1 | 860376 | g5632 | i0 | 69.7 | 6.95317725752508 | 99 | 30 | 99.3 | 0 | 297 | 1 | 113 | 211 | ACI49216.1 hypothetical protein Csp3_JD05.001 [Caenorhabditis angaria] | diamond | 2079 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 26970166 | 26970166 | PRJEB55250_P_NODE_13162_length_248_cov_0.880000_g13038_i0 | PRJEB55250 | 13162 | 248 | 0.88 | 2.1824 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 121 | 5.959999999999999e-31 | NR | CAF1910845.1 | 392030 | g13038 | i0 | 93.5 | 1.5 | 62 | 4 | 75 | 0 | 248 | 63 | 293 | 354 | CAF1910845.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 372 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27532371 | 27532371 | PRJEB55250_P_NODE_13603_length_247_cov_0.885057_g13479_i0 | PRJEB55250 | 13603 | 247 | 0.885057 | 2.18609079 | Insecta | 50557 | Arthropoda | Arthropoda | 69.3 | 1.11e-11 | NR | KAL4717768.1 | 72366 | g13479 | i0 | 48.6 | 9.68016194331984 | 72 | 37 | 87.4 | 0 | 26 | 241 | 20 | 91 | KAL4717768.1 hypothetical protein ACJJTC_000917 [Scirpophaga incertulas] | diamond | 2391 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Scirpophaga | Scirpophaga incertulas | |
| 27539228 | 27539228 | PRJEB55250_P_NODE_7304_length_282_cov_1.148325_g7180_i0 | PRJEB55250 | 7304 | 282 | 1.148325 | 3.2382765 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 43.9 | 0.00608 | NR | CAF1209424.1 | 433720 | g7180 | i0 | 50 | 0.595744680851064 | 56 | 21 | 54.3 | 2 | 280 | 128 | 17 | 70 | CAF1209424.1 unnamed protein product [Adineta steineri] | diamond | 168 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27728953 | 27728953 | PRJEB55250_P_NODE_11684_length_251_cov_0.865169_g11560_i0 | PRJEB55250 | 11684 | 251 | 0.865169 | 2.17157419 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 45.4 | 0.00452 | NR | XP_049849277.1 | 7010 | g11560 | i0 | 47.8 | 0.549800796812749 | 46 | 22 | 52.6 | 1 | 136 | 5 | 30 | 75 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 138 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 28044290 | 28044290 | PRJEB55250_P_NODE_12165_length_250_cov_0.870056_g12041_i0 | PRJEB55250 | 12165 | 250 | 0.870056 | 2.17514 | Carabus blaptoides fortunei | 49296 | Arthropoda | Arthropoda | 97.4 | 2.3700000000000003e-21 | NR | GLV38013.1 | 49296 | g12041 | i0 | 63 | 0.972 | 81 | 30 | 97.2 | 0 | 244 | 2 | 647 | 727 | GLV38013.1 uncharacterized protein CBL_07811 [Carabus blaptoides fortunei] | diamond | 243 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Carabidae | Carabus | Carabus blaptoides | |
| 28233471 | 28233471 | PRJEB55250_P_NODE_10966_length_254_cov_1.701657_g10842_i0 | PRJEB55250 | 10966 | 254 | 1.701657 | 4.32220878 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 44.3 | 0.0118 | NR | XP_067941500.1 | 2589382 | g10842 | i0 | 35.7 | 0.826771653543307 | 70 | 42 | 81.5 | 2 | 33 | 239 | 271 | 338 | XP_067941500.1 elongation factor 1-gamma-like [Watersipora subatra] | diamond | 210 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28233474 | 28233474 | PRJEB55250_P_NODE_13546_length_247_cov_0.885057_g13422_i0 | PRJEB55250 | 13546 | 247 | 0.885057 | 2.18609079 | Meladema coriacea | 107907 | Arthropoda | Arthropoda | 132 | 8.83e-38 | NR | CAJ17403.1 | 107907 | g13422 | i0 | 91.3 | 1.7004048582996 | 69 | 6 | 83.8 | 0 | 209 | 3 | 1 | 69 | CAJ17403.1 ribosomal protein L28e [Meladema coriacea] | diamond | 420 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Dytiscidae | Meladema | Meladema coriacea | |
| 28644373 | 28644373 | PRJEB55250_P_NODE_14647_length_245_cov_0.895349_g14523_i0 | PRJEB55250 | 14647 | 245 | 0.895349 | 2.19360505 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 56.6 | 4.92e-7 | NR | XP_049848239.1 | 7010 | g14523 | i0 | 31 | 0.869387755102041 | 71 | 49 | 86.9 | 0 | 1 | 213 | 482 | 552 | XP_049848239.1 uncharacterized protein LOC126313330 [Schistocerca gregaria] | diamond | 213 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 29401997 | 29401997 | PRJEB55250_P_NODE_8089_length_276_cov_0.960591_g7965_i0 | PRJEB55250 | 8089 | 276 | 0.960591 | 2.65123116 | Exocentrus adspersus | 1586481 | Arthropoda | Arthropoda | 91.7 | 2.6e-19 | NR | KAJ8924928.1 | 1586481 | g7965 | i0 | 49.4 | 2.83695652173913 | 89 | 45 | 96.7 | 0 | 275 | 9 | 331 | 419 | KAJ8924928.1 hypothetical protein NQ315_001091 [Exocentrus adspersus] | diamond | 783 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Cerambycidae | Exocentrus | Exocentrus adspersus | |
| 29521518 | 29521518 | PRJEB55250_P_NODE_1890_length_469_cov_5.848485_g1767_i0 | PRJEB55250 | 1890 | 469 | 5.848485 | 27.42939465 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 2.66e-30 | NR | CAJ0575662.1 | 96644 | g1767 | i0 | 46.8 | 2.41791044776119 | 126 | 62 | 77.4 | 2 | 438 | 76 | 1 | 126 | CAJ0575662.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 1134 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 29559730 | 29559730 | PRJEB55250_P_NODE_6290_length_290_cov_1.327189_g6166_i0 | PRJEB55250 | 6290 | 290 | 1.327189 | 3.8488481 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 43.5 | 0.00514 | NR | XP_015910180.1 | 114398 | g6166 | i0 | 37.7 | 0.631034482758621 | 61 | 36 | 63.1 | 1 | 2 | 184 | 16 | 74 | XP_015910180.1 cytochrome b-c1 complex subunit 8 [Parasteatoda tepidariorum] | diamond | 183 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 29963704 | 29963704 | PRJEB55250_P_NODE_6471_length_288_cov_1.879070_g6347_i0 | PRJEB55250 | 6471 | 288 | 1.87907 | 5.4117216 | Arachnida | 6854 | Arthropoda | Arthropoda | 131 | 5.48e-34 | NR | XP_015789961.1 | 32264 | g6347 | i0 | 62.8 | 7.16666666666667 | 94 | 35 | 97.9 | 0 | 7 | 288 | 30 | 123 | XP_015789961.1 probable medium-chain specific acyl-CoA dehydrogenase, mitochondrial isoform X2 [Tetranychus urticae] | diamond | 2064 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 30539080 | 30539080 | PRJEB55250_P_NODE_15593_length_243_cov_0.905882_g15469_i0 | PRJEB55250 | 15593 | 243 | 0.905882 | 2.20129326 | Drosophila bipectinata | 42026 | Arthropoda | Arthropoda | 43.5 | 0.0202 | NR | XP_017105683.2 | 42026 | g15469 | i0 | 33.3 | 1.40740740740741 | 57 | 38 | 70.4 | 0 | 48 | 218 | 226 | 282 | XP_017105683.2 rab3 GTPase-activating protein non-catalytic subunit [Drosophila bipectinata] | diamond | 342 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila bipectinata | |
| 30879839 | 30879839 | PRJEB55250_P_NODE_10074_length_261_cov_1.228723_g9950_i0 | PRJEB55250 | 10074 | 261 | 1.228723 | 3.20696703 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 151 | 2.16e-43 | NR | XP_002110080.1 | 10228 | g9950 | i0 | 82.6 | 66.2298850574713 | 86 | 15 | 98.9 | 0 | 2 | 259 | 121 | 206 | XP_002110080.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 17286 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30911639 | 30911639 | PRJEB55250_P_NODE_16894_length_235_cov_3.814815_g16770_i0 | PRJEB55250 | 16894 | 235 | 3.814815 | 8.96481525 | root | 1 | Root_unresolved | Root_unresolved | 159 | 1.7899999999999996e-43 | NR | XP_030109804.2 | 10090 | g16770 | i0 | 98.7 | 12.9446808510638 | 78 | 1 | 99.6 | 0 | 235 | 2 | 5 | 82 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 3042 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31234057 | 31234057 | PRJEB55250_P_NODE_16515_length_241_cov_0.916667_g16391_i0 | PRJEB55250 | 16515 | 241 | 0.916667 | 2.20916747 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 87 | 8.68e-18 | NR | XP_049849277.1 | 7010 | g16391 | i0 | 51.3 | 0.995850622406639 | 80 | 37 | 97.1 | 1 | 234 | 1 | 204 | 283 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 240 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 31765124 | 31765124 | PRJEB55250_P_NODE_12977_length_248_cov_0.880000_g12853_i0 | PRJEB55250 | 12977 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 82.8 | 3.2e-16 | NR | XP_013414480.1 | 7574 | g12853 | i0 | 51.4 | 7.66935483870968 | 70 | 33 | 84.7 | 1 | 5 | 214 | 193 | 261 | XP_013414480.1 carboxypeptidase D [Lingula anatina] | diamond | 1902 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31835024 | 31835024 | PRJEB55250_P_NODE_9517_length_265_cov_1.208333_g9393_i0 | PRJEB55250 | 9517 | 265 | 1.208333 | 3.20208245 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 65.9 | 3.31e-10 | NR | CAF4057732.1 | 2762511 | g9393 | i0 | 59.6 | 1.64150943396226 | 47 | 19 | 53.2 | 0 | 241 | 101 | 254 | 300 | CAF4057732.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 435 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31993365 | 31993365 | PRJEB55250_P_NODE_11138_length_253_cov_1.616667_g11014_i0 | PRJEB55250 | 11138 | 253 | 1.616667 | 4.09016751 | Staurois parvus | 386267 | Chordata | Chordata | 60.5 | 4.59e-10 | NR | CAI9620946.1 | 386267 | g11014 | i0 | 70.3 | 0.438735177865613 | 37 | 11 | 43.9 | 0 | 4 | 114 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32151619 | 32151619 | PRJEB55250_P_NODE_15638_length_243_cov_0.905882_g15514_i0 | PRJEB55250 | 15638 | 243 | 0.905882 | 2.20129326 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 57.4 | 2.48e-7 | NR | KAK2160138.1 | 53620 | g15514 | i0 | 46.1 | 1.92592592592593 | 76 | 26 | 88.9 | 2 | 232 | 17 | 388 | 452 | KAK2160138.1 hypothetical protein LSH36_139g02023 [Paralvinella palmiformis] | diamond | 468 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32341659 | 32341659 | PRJEB55250_P_NODE_8559_length_272_cov_1.396985_g8435_i0 | PRJEB55250 | 8559 | 272 | 1.396985 | 3.7997992 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 117 | 7.62e-32 | NR | XP_070194632.1 | 31220 | g8435 | i0 | 64.6 | 5.37132352941176 | 82 | 29 | 90.4 | 0 | 270 | 25 | 4 | 85 | XP_070194632.1 large ribosomal subunit protein eL37-like [Littorina saxatilis] | diamond | 1461 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32681896 | 32681896 | PRJEB55250_P_NODE_6000_length_294_cov_1.416290_g5876_i0 | PRJEB55250 | 6000 | 294 | 1.41629 | 4.1638926 | Metazoa | 33208 | Arthropoda | Arthropoda | 88.6 | 3.99e-19 | NR | RXG61010.1 | 13347 | g5876 | i0 | 54.3 | 3.30612244897959 | 81 | 37 | 82.7 | 0 | 244 | 2 | 144 | 224 | RXG61010.1 hypothetical protein Avbf_14182 [Armadillidium vulgare] | diamond | 972 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Armadillidiidae | Armadillidium | Armadillidium vulgare | |
| 32846254 | 32846254 | PRJEB55250_P_NODE_14700_length_245_cov_0.895349_g14576_i0 | PRJEB55250 | 14700 | 245 | 0.895349 | 2.19360505 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 85.5 | 3.17e-17 | NR | XP_049849277.1 | 7010 | g14576 | i0 | 52.5 | 0.979591836734694 | 80 | 30 | 96.7 | 2 | 238 | 2 | 62 | 134 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 240 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria |
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);;