contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 324523 | 324523 | PRJNA1198392_P_NODE_16401_length_250_cov_0.870056_g16260_i0 | PRJNA1198392 | 16401 | 250 | 0.870056 | 2.17514 | Salvia splendens | 180675 | Plants | Plants | 149 | 4.3099999999999986e-43 | NR | KAG6434738.1 | 180675 | g16260 | i0 | 86.7 | 27.864 | 83 | 11 | 99.6 | 0 | 2 | 250 | 39 | 121 | KAG6434738.1 hypothetical protein SASPL_106380 [Salvia splendens] | diamond | 6966 | 149 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lamiaceae | Salvia | Salvia splendens | |
| 4871827 | 4871827 | PRJNA1198392_P_NODE_12424_length_270_cov_1.563452_g12283_i0 | PRJNA1198392 | 12424 | 270 | 1.563452 | 4.2213204 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 144 | 1.0899999999999997e-42 | NR | KAL4446784.1 | 554058 | g12283 | i0 | 75.9 | 4.84444444444444 | 87 | 21 | 96.7 | 0 | 8 | 268 | 10 | 96 | KAL4446784.1 hypothetical protein ABPG77_008028 [Micractinium sp. CCAP 211/92] | diamond | 1308 | 144 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 9252458 | 9252458 | PRJNA1198392_P_NODE_15048_length_255_cov_1.692308_g14907_i0 | PRJNA1198392 | 15048 | 255 | 1.692308 | 4.3153854 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 58.2 | 1.65e-7 | NR | GMH40484.1 | 3041901 | g14907 | i0 | 66.7 | 9.2 | 45 | 14 | 51.8 | 1 | 7 | 138 | 248 | 292 | GMH40484.1 hypothetical protein BSKO_08388 [Bryopsis sp. KO-2023] | diamond | 2346 | 58.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 13078202 | 13078202 | PRJNA1198392_P_NODE_18731_length_246_cov_0.890173_g18590_i0 | PRJNA1198392 | 18731 | 246 | 0.890173 | 2.18982558 | Ceratopteris richardii | 49495 | Plants | Plants | 77.8 | 1.43e-14 | NR | KAH7415353.1 | 49495 | g18590 | i0 | 77.8 | 15.2560975609756 | 81 | 18 | 98.8 | 0 | 2 | 244 | 266 | 346 | KAH7415353.1 hypothetical protein KP509_14G039100 [Ceratopteris richardii] | diamond | 3753 | 77.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 28114663 | 28114663 | PRJNA1198392_P_NODE_16185_length_250_cov_1.740113_g16044_i0 | PRJNA1198392 | 16185 | 250 | 1.740113 | 4.3502825 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 60.8 | 1.71e-8 | NR | KAK9903904.1 | 248742 | g16044 | i0 | 44.3 | 0.948 | 79 | 39 | 90 | 3 | 231 | 7 | 24 | 101 | KAK9903904.1 hypothetical protein WJX75_000011 [Coccomyxa subellipsoidea] | diamond | 237 | 60.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 28177701 | 28177701 | PRJNA1198392_P_NODE_15166_length_254_cov_1.701657_g15025_i0 | PRJNA1198392 | 15166 | 254 | 1.701657 | 4.32220878 | Juncus effusus | 13579 | Plants | Plants | 75.1 | 1.19e-13 | NR | KAJ3681105.1 | 13579 | g15025 | i0 | 42.5 | 2.00787401574803 | 87 | 47 | 99.2 | 2 | 252 | 1 | 106 | 192 | KAJ3681105.1 hypothetical protein LUZ60_015594 [Juncus effusus] | diamond | 510 | 75.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 28228198 | 28228198 | PRJNA1198392_P_NODE_9246_length_286_cov_1.244131_g9105_i0 | PRJNA1198392 | 9246 | 286 | 1.244131 | 3.55821466 | Eukaryota | 2759 | Plants | Plants | 69.7 | 2.08e-11 | NR | KAJ9512917.1 | 44745 | g9105 | i0 | 47 | 4.40559440559441 | 83 | 41 | 85 | 2 | 257 | 15 | 245 | 326 | KAJ9512917.1 hypothetical protein QJQ45_029067 [Haematococcus lacustris] | diamond | 1260 | 69.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28588599 | 28588599 | PRJNA1198392_P_NODE_20367_length_243_cov_0.905882_g20226_i0 | PRJNA1198392 | 20367 | 243 | 0.905882 | 2.20129326 | Punica granatum | 22663 | Plants | Plants | 44.7 | 0.00713 | NR | PKI59010.1 | 22663 | g20226 | i0 | 35.3 | 0.839506172839506 | 68 | 40 | 79 | 1 | 224 | 33 | 182 | 249 | PKI59010.1 hypothetical protein CRG98_020578 [Punica granatum] | diamond | 204 | 44.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Lythraceae | Punica | Punica granatum | |
| 28651580 | 28651580 | PRJNA1198392_P_NODE_18707_length_246_cov_0.890173_g18566_i0 | PRJNA1198392 | 18707 | 246 | 0.890173 | 2.18982558 | Cardamine amara subsp. amara | 228776 | Plants | Plants | 73.9 | 3.65e-13 | NR | KAL1194816.1 | 228776 | g18566 | i0 | 51.3 | 9.41463414634146 | 76 | 32 | 86.6 | 1 | 221 | 9 | 334 | 409 | KAL1194816.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Cardamine amara subsp. amara] | diamond | 2316 | 73.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Cardamine | Cardamine amara | |
| 28714783 | 28714783 | PRJNA1198392_P_NODE_12547_length_269_cov_3.938776_g12406_i0 | PRJNA1198392 | 12547 | 269 | 3.938776 | 10.59530744 | Momordica charantia | 3673 | Plants | Plants | 73.6 | 7.36e-13 | NR | XP_022144587.1 | 3673 | g12406 | i0 | 48.7 | 0.869888475836431 | 78 | 34 | 87 | 2 | 253 | 20 | 671 | 742 | XP_022144587.1 serine/threonine-protein kinase CTR1-like isoform X2 [Momordica charantia] | diamond | 234 | 73.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Momordica | Momordica charantia | |
| 28733711 | 28733711 | PRJNA1198392_P_NODE_12267_length_271_cov_1.434343_g12126_i0 | PRJNA1198392 | 12267 | 271 | 1.434343 | 3.88706953 | Streptophyta | 35493 | Plants | Plants | 57 | 5.07e-7 | NR | KAJ7544256.1 | 34168 | g12126 | i0 | 65.9 | 9.74169741697417 | 44 | 15 | 48.7 | 0 | 145 | 14 | 653 | 696 | KAJ7544256.1 hypothetical protein O6H91_09G070900 [Diphasiastrum complanatum] | diamond | 2640 | 57 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Lycopodiales | Lycopodiaceae | Diphasiastrum | Diphasiastrum complanatum | |
| 29440619 | 29440619 | PRJNA1198392_P_NODE_11390_length_275_cov_2.193069_g11249_i0 | PRJNA1198392 | 11390 | 275 | 2.193069 | 6.03093975 | Monoraphidium neglectum | 145388 | Plants | Plants | 45.1 | 0.00269 | NR | XP_013906395.1 | 145388 | g11249 | i0 | 60.5 | 0.905454545454545 | 43 | 16 | 45.8 | 1 | 274 | 149 | 27 | 69 | XP_013906395.1 hypothetical protein MNEG_0583 [Monoraphidium neglectum] | diamond | 249 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 29617341 | 29617341 | PRJNA1198392_P_NODE_18590_length_246_cov_0.890173_g18449_i0 | PRJNA1198392 | 18590 | 246 | 0.890173 | 2.18982558 | Chlamydomonadales | 3042 | Plants | Plants | 48.9 | 2.59e-4 | NR | XP_042917195.1 | 3055 | g18449 | i0 | 56.8 | 7.1219512195122 | 44 | 17 | 51.2 | 1 | 228 | 103 | 393 | 436 | XP_042917195.1 uncharacterized protein CHLRE_13g563733v5 [Chlamydomonas reinhardtii] | diamond | 1752 | 48.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 30009519 | 30009519 | PRJNA1198392_P_NODE_7091_length_308_cov_0.982979_g6950_i0 | PRJNA1198392 | 7091 | 308 | 0.982979 | 3.02757532 | Oryza sativa | 4530 | Plants | Plants | 141 | 8.149999999999999e-40 | NR | KAB8089558.1 | 4530 | g6950 | i0 | 70.9 | 1.86038961038961 | 103 | 29 | 99.4 | 1 | 1 | 306 | 47 | 149 | KAB8089558.1 hypothetical protein EE612_014527, partial [Oryza sativa] | diamond | 573 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 30249672 | 30249672 | PRJNA1198392_P_NODE_10592_length_279_cov_2.160194_g10451_i0 | PRJNA1198392 | 10592 | 279 | 2.160194 | 6.02694126 | Chlorophyta | 3041 | Plants | Plants | 90.5 | 9.36e-19 | NR | KAK9807779.1 | 41462 | g10451 | i0 | 52.2 | 8.90322580645161 | 92 | 42 | 98.9 | 1 | 277 | 2 | 741 | 830 | KAK9807779.1 hypothetical protein WJX72_008954 [[Myrmecia] bisecta] | diamond | 2484 | 90.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30660151 | 30660151 | PRJNA1198392_P_NODE_5013_length_353_cov_3.103571_g4872_i0 | PRJNA1198392 | 5013 | 353 | 3.103571 | 10.95560563 | Viridiplantae | 33090 | Plants | Plants | 161 | 6.68e-48 | NR | XP_022839661.1 | 70448 | g4872 | i0 | 72.8 | 6.17847025495751 | 103 | 28 | 87.5 | 0 | 2 | 310 | 83 | 185 | XP_022839661.1 Ribosomal protein L18e, conserved site [Ostreococcus tauri] | diamond | 2181 | 161 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 30799085 | 30799085 | PRJNA1198392_P_NODE_11654_length_274_cov_1.532338_g11513_i0 | PRJNA1198392 | 11654 | 274 | 1.532338 | 4.19860612 | Salix suchowensis | 1278906 | Plants | Plants | 43.5 | 0.0275 | NR | KAJ6375252.1 | 1278906 | g11513 | i0 | 29.3 | 0.821167883211679 | 75 | 44 | 72.3 | 1 | 61 | 258 | 18 | 92 | KAJ6375252.1 hypothetical protein OIU77_000268 [Salix suchowensis] | diamond | 225 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix suchowensis | |
| 30944651 | 30944651 | PRJNA1198392_P_NODE_14534_length_258_cov_1.664865_g14393_i0 | PRJNA1198392 | 14534 | 258 | 1.664865 | 4.2953517 | Brassicaceae | 3700 | Plants | Plants | 74.3 | 3.35e-13 | NR | XP_006293755.1 | 81985 | g14393 | i0 | 56.9 | 6.7906976744186 | 65 | 26 | 75.6 | 1 | 20 | 214 | 421 | 483 | XP_006293755.1 ubiquitin carboxyl-terminal hydrolase 19 [Capsella rubella] | diamond | 1752 | 74.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Capsella | Capsella rubella | |
| 31368345 | 31368345 | PRJNA1198392_P_NODE_19676_length_244_cov_0.900585_g19535_i0 | PRJNA1198392 | 19676 | 244 | 0.900585 | 2.1974274 | Vitis vinifera | 29760 | Plants | Plants | 75.5 | 1.09e-13 | NR | CAN82845.1 | 29760 | g19535 | i0 | 45.7 | 2.98770491803279 | 81 | 44 | 99.6 | 0 | 244 | 2 | 29 | 109 | CAN82845.1 hypothetical protein VITISV_005762 [Vitis vinifera] | diamond | 729 | 75.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 31399920 | 31399920 | PRJNA1198392_P_NODE_18836_length_245_cov_2.656977_g18695_i0 | PRJNA1198392 | 18836 | 245 | 2.656977 | 6.50959365 | Capsicum chinense | 80379 | Plants | Plants | 44.3 | 0.00994 | NR | PHU30644.1 | 80379 | g18695 | i0 | 77.3 | 0.269387755102041 | 22 | 5 | 26.9 | 0 | 231 | 166 | 250 | 271 | PHU30644.1 hypothetical protein BC332_02737 [Capsicum chinense] | diamond | 66 | 44.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum chinense | |
| 32222270 | 32222270 | PRJNA1198392_P_NODE_8278_length_290_cov_1.419355_g8137_i0 | PRJNA1198392 | 8278 | 290 | 1.419355 | 4.1161295 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 48.9 | 3.88e-4 | NR | KAK3256699.1 | 36881 | g8137 | i0 | 32.6 | 1.83103448275862 | 86 | 45 | 75.5 | 1 | 44 | 262 | 189 | 274 | KAK3256699.1 hypothetical protein CYMTET_34178 [Cymbomonas tetramitiformis] | diamond | 531 | 48.9 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 32317478 | 32317478 | PRJNA1198392_P_NODE_14739_length_257_cov_1.673913_g14598_i0 | PRJNA1198392 | 14739 | 257 | 1.673913 | 4.30195641 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 78.6 | 3.65e-16 | NR | GAX83532.1 | 1157962 | g14598 | i0 | 50.8 | 0.712062256809339 | 61 | 30 | 71.2 | 0 | 3 | 185 | 92 | 152 | GAX83532.1 hypothetical protein CEUSTIGMA_g10957.t1 [Chlamydomonas eustigma] | diamond | 183 | 78.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;