contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4233951 | 4233951 | PRJNA385396_P_NODE_16144_length_248_cov_0.880000_g16052_i0 | PRJNA385396 | 16144 | 248 | 0.88 | 2.1824 | Klebsormidium nitens | 105231 | Plants | Plants | 99 | 6.54e-22 | NR | GAQ83598.1 | 105231 | g16052 | i0 | 63.2 | 4.34274193548387 | 76 | 27 | 91.9 | 1 | 246 | 19 | 406 | 480 | GAQ83598.1 DEAD-box RNA helicase family protein [Klebsormidium nitens] | diamond | 1077 | 99 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium nitens | ||
| 4234152 | 4234152 | PRJNA385396_P_NODE_3904_length_397_cov_1.188272_g3812_i0 | PRJNA385396 | 3904 | 397 | 1.188272 | 4.71743984 | Arabidopsis thaliana | 3702 | Plants | Plants | 67 | 6.76e-10 | NR | NP_196927.4 | 3702 | g3812 | i0 | 38.5 | 1.57178841309824 | 104 | 56 | 75.6 | 3 | 28 | 327 | 304 | 403 | NP_196927.4 ankyrin [Arabidopsis thaliana] | diamond | 624 | 67 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 15709481 | 15709481 | PRJNA385396_P_NODE_11873_length_264_cov_2.821990_g11781_i0 | PRJNA385396 | 11873 | 264 | 2.82199 | 7.4500536 | Eukaryota | 2759 | Plants | Plants | 126 | 7.18e-35 | NR | XP_024398553.1 | 3218 | g11781 | i0 | 64.4 | 13.7954545454545 | 87 | 31 | 98.9 | 0 | 3 | 263 | 25 | 111 | XP_024398553.1 nucleoside diphosphate kinase 4, chloroplastic-like isoform X2 [Physcomitrium patens] | diamond | 3642 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 22083196 | 22083196 | PRJNA385396_P_NODE_12398_length_259_cov_1.602151_g12306_i0 | PRJNA385396 | 12398 | 259 | 1.602151 | 4.14957109 | Mikania micrantha | 192012 | Plants | Plants | 95.5 | 1.27e-20 | NR | KAD5802506.1 | 192012 | g12306 | i0 | 58.3 | 1.94594594594595 | 84 | 34 | 96.1 | 1 | 255 | 7 | 4 | 87 | KAD5802506.1 hypothetical protein E3N88_13866 [Mikania micrantha] | diamond | 504 | 95.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Mikania | Mikania micrantha | |
| 24028298 | 24028298 | PRJNA385396_P_NODE_5859_length_345_cov_0.988971_g5767_i0 | PRJNA385396 | 5859 | 345 | 0.988971 | 3.41194995 | Drosera rotundifolia | 173423 | Plants | Plants | 157 | 9.78e-47 | NR | GAB2232939.1 | 173423 | g5767 | i0 | 69.6 | 44.7739130434783 | 112 | 34 | 97.4 | 0 | 338 | 3 | 9 | 120 | GAB2232939.1 hypothetical protein Drorol1_Dr00012008 [Drosera rotundifolia] | diamond | 15447 | 157 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Droseraceae | Drosera | Drosera rotundifolia | |
| 26600094 | 26600094 | PRJNA385396_P_NODE_6701_length_329_cov_2.851562_g6609_i0 | PRJNA385396 | 6701 | 329 | 2.851562 | 9.38163898 | Nymphaea colorata | 210225 | Plants | Plants | 136 | 1.08e-38 | NR | VVW86319.1 | 210225 | g6609 | i0 | 60.2 | 3.93920972644377 | 108 | 43 | 98.5 | 0 | 328 | 5 | 4 | 111 | VVW86319.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 1296 | 136 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 26680463 | 26680463 | PRJNA385396_P_NODE_16481_length_247_cov_0.885057_g16389_i0 | PRJNA385396 | 16481 | 247 | 0.885057 | 2.18609079 | Magnoliopsida | 3398 | Plants | Plants | 80.9 | 1.43e-15 | NR | KAJ8639270.1 | 3435 | g16389 | i0 | 55.7 | 27.582995951417 | 70 | 31 | 85 | 0 | 6 | 215 | 226 | 295 | KAJ8639270.1 hypothetical protein MRB53_015964 [Persea americana] | diamond | 6813 | 80.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Persea | Persea americana | |
| 26917037 | 26917037 | PRJNA385396_P_NODE_6482_length_333_cov_3.507692_g6390_i0 | PRJNA385396 | 6482 | 333 | 3.507692 | 11.68061436 | Rosa chinensis | 74649 | Plants | Plants | 79.3 | 5.93e-16 | NR | XP_024163700.1 | 74649 | g6390 | i0 | 55.6 | 0.648648648648649 | 72 | 25 | 63.1 | 3 | 6 | 215 | 94 | 160 | XP_024163700.1 pathogenesis-related protein 1A [Rosa chinensis] | diamond | 216 | 79.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Rosa | Rosa chinensis | |
| 27123350 | 27123350 | PRJNA385396_P_NODE_2102_length_516_cov_1.652370_g2010_i0 | PRJNA385396 | 2102 | 516 | 1.65237 | 8.5262292 | Eukaryota | 2759 | Plants | Plants | 100 | 1.9099999999999998e-23 | NR | KAK7257792.1 | 3830 | g2010 | i0 | 54.3 | 20.0116279069767 | 105 | 48 | 61 | 0 | 67 | 381 | 27 | 131 | KAK7257792.1 hypothetical protein RIF29_32024 [Crotalaria pallida] | diamond | 10326 | 101 | 0.99009900990099 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Crotalaria | Crotalaria pallida | |
| 28022909 | 28022909 | PRJNA385396_P_NODE_10965_length_274_cov_1.343284_g10873_i0 | PRJNA385396 | 10965 | 274 | 1.343284 | 3.68059816 | Zea mays | 4577 | Plants | Plants | 117 | 2.5299999999999993e-31 | NR | ACG27456.1 | 4577 | g10873 | i0 | 66.3 | 0.908759124087591 | 83 | 28 | 90.9 | 0 | 254 | 6 | 5 | 87 | ACG27456.1 60 ribosomal protein L14 [Zea mays] | diamond | 249 | 117 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 28513235 | 28513235 | PRJNA385396_P_NODE_2867_length_449_cov_2.018617_g2775_i0 | PRJNA385396 | 2867 | 449 | 2.018617 | 9.06359033 | Streptophyta | 35493 | Plants | Plants | 144 | 3.4199999999999993e-40 | NR | GAQ86255.1 | 105231 | g2775 | i0 | 55.6 | 39.2338530066815 | 142 | 59 | 94.9 | 3 | 4 | 429 | 1 | 138 | GAQ86255.1 40S ribosomal protein S8 [Klebsormidium nitens] | diamond | 17616 | 144 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium nitens | ||
| 28780391 | 28780391 | PRJNA385396_P_NODE_19947_length_243_cov_0.905882_g19855_i0 | PRJNA385396 | 19947 | 243 | 0.905882 | 2.20129326 | Acer negundo | 4023 | Plants | Plants | 94.4 | 2.5e-21 | NR | KAI9157559.1 | 4023 | g19855 | i0 | 60.8 | 0.975308641975309 | 79 | 29 | 95.1 | 1 | 233 | 3 | 52 | 130 | KAI9157559.1 hypothetical protein LWI28_024396 [Acer negundo] | diamond | 237 | 94.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer negundo | |
| 29081654 | 29081654 | PRJNA385396_P_NODE_5048_length_363_cov_1.058621_g4956_i0 | PRJNA385396 | 5048 | 363 | 1.058621 | 3.84279423 | Magnoliopsida | 3398 | Plants | Plants | 170 | 4.1e-50 | NR | TVU42949.1 | 38414 | g4956 | i0 | 70.6 | 92.4462809917355 | 119 | 35 | 98.3 | 0 | 5 | 361 | 132 | 250 | TVU42949.1 hypothetical protein EJB05_09375, partial [Eragrostis curvula] | diamond | 33558 | 171 | 0.994152046783626 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eragrostis | Eragrostis curvula | |
| 29176484 | 29176484 | PRJNA385396_P_NODE_6149_length_339_cov_1.684211_g6057_i0 | PRJNA385396 | 6149 | 339 | 1.684211 | 5.70947529 | Eukaryota | 2759 | Plants | Plants | 99 | 2.4399999999999999e-23 | NR | KDO83483.1 | 2711 | g6057 | i0 | 53 | 27.2212389380531 | 117 | 50 | 99.1 | 2 | 4 | 339 | 19 | 135 | KDO83483.1 hypothetical protein CISIN_1g026785mg [Citrus sinensis] | diamond | 9228 | 99.4 | 0.995975855130785 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 29870939 | 29870939 | PRJNA385396_P_NODE_9071_length_295_cov_3.112613_g8979_i0 | PRJNA385396 | 9071 | 295 | 3.112613 | 9.18220835 | Eukaryota | 2759 | Plants | Plants | 123 | 3.2999999999999997e-32 | NR | GER34224.1 | 4170 | g8979 | i0 | 71.4 | 47.0949152542373 | 84 | 23 | 85.4 | 1 | 31 | 282 | 127 | 209 | GER34224.1 60S ribosomal protein L6, partial [Striga asiatica] | diamond | 13893 | 124 | 0.991935483870968 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Striga | Striga asiatica | |
| 30707053 | 30707053 | PRJNA385396_P_NODE_11694_length_266_cov_1.595855_g11602_i0 | PRJNA385396 | 11694 | 266 | 1.595855 | 4.2449743 | Vigna angularis | 3914 | Plants | Plants | 50.8 | 5.62e-5 | NR | XP_017420281.1 | 3914 | g11602 | i0 | 52.6 | 0.428571428571429 | 38 | 17 | 41.7 | 1 | 261 | 151 | 28 | 65 | XP_017420281.1 uncharacterized protein LOC108330301 [Vigna angularis] | diamond | 114 | 50.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna angularis | |
| 31356176 | 31356176 | PRJNA385396_P_NODE_11696_length_266_cov_1.595855_g11604_i0 | PRJNA385396 | 11696 | 266 | 1.595855 | 4.2449743 | Magnoliopsida | 3398 | Plants | Plants | 111 | 1.4500000000000002e-26 | NR | ACJ85622.1 | 3880 | g11604 | i0 | 58.1 | 23.2781954887218 | 86 | 36 | 97 | 0 | 9 | 266 | 238 | 323 | ACJ85622.1 unknown, partial [Medicago truncatula] | diamond | 6192 | 112 | 0.991071428571429 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Medicago | Medicago truncatula | |
| 31560788 | 31560788 | PRJNA385396_P_NODE_18396_length_245_cov_0.895349_g18304_i0 | PRJNA385396 | 18396 | 245 | 0.895349 | 2.19360505 | Morus notabilis | 981085 | Plants | Plants | 72 | 1.84e-12 | NR | XP_010089424.1 | 981085 | g18304 | i0 | 46.9 | 1.98367346938776 | 81 | 42 | 99.2 | 1 | 1 | 243 | 127 | 206 | XP_010089424.1 DEAD-box ATP-dependent RNA helicase 39 [Morus notabilis] | diamond | 486 | 72 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Morus | Morus notabilis | |
| 31703939 | 31703939 | PRJNA385396_P_NODE_18117_length_245_cov_0.895349_g18025_i0 | PRJNA385396 | 18117 | 245 | 0.895349 | 2.19360505 | Magnoliopsida | 3398 | Plants | Plants | 121 | 1.3099999999999998e-31 | NR | RLN00394.1 | 4540 | g18025 | i0 | 78.5 | 84.2326530612245 | 79 | 17 | 96.7 | 0 | 237 | 1 | 94 | 172 | RLN00394.1 40S ribosomal protein S9-2-like [Panicum miliaceum] | diamond | 20637 | 122 | 0.991803278688525 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Panicum | Panicum miliaceum | |
| 31718750 | 31718750 | PRJNA385396_P_NODE_15497_length_249_cov_0.875000_g15405_i0 | PRJNA385396 | 15497 | 249 | 0.875 | 2.17875 | Glycine max | 3847 | Plants | Plants | 72 | 8.87e-14 | NR | NP_001238097.1 | 3847 | g15405 | i0 | 46.3 | 1.59036144578313 | 80 | 41 | 94 | 1 | 247 | 14 | 58 | 137 | NP_001238097.1 uncharacterized protein LOC100305878 [Glycine max] | diamond | 396 | 72 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 31893744 | 31893744 | PRJNA385396_P_NODE_5977_length_342_cov_1.717472_g5885_i0 | PRJNA385396 | 5977 | 342 | 1.717472 | 5.87375424 | Eukaryota | 2759 | Plants | Plants | 95.5 | 2.32e-22 | NR | KAK7257792.1 | 3830 | g5885 | i0 | 59.3 | 12.9736842105263 | 86 | 35 | 75.4 | 0 | 78 | 335 | 27 | 112 | KAK7257792.1 hypothetical protein RIF29_32024 [Crotalaria pallida] | diamond | 4437 | 95.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Crotalaria | Crotalaria pallida | |
| 32887653 | 32887653 | PRJNA385396_P_NODE_17660_length_246_cov_0.890173_g17568_i0 | PRJNA385396 | 17660 | 246 | 0.890173 | 2.18982558 | Ananas comosus | 4615 | Plants | Plants | 60.5 | 1.99e-8 | NR | XP_020089244.1 | 4615 | g17568 | i0 | 38.9 | 2.19512195121951 | 90 | 41 | 98.8 | 2 | 244 | 2 | 93 | 177 | XP_020089244.1 fruit bromelain-like [Ananas comosus] | diamond | 540 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus |
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);;