contig_metadata
20 rows where bioproject = "PRJNA608894" and tax_phylum = "Rhodophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 585812 | 585812 | PRJNA608894_P_NODE_58641_length_242_cov_1.579882_g58142_i0 | PRJNA608894 | 58641 | 242 | 1.579882 | 3.82331444 | Pyropia yezoensis | 2788 | Rhodophyta | other_Eukaryota | 115 | 8.78e-28 | NR | AIT70095.1 | 2788 | g58142 | i0 | 62.5 | 0.991735537190083 | 80 | 30 | 99.2 | 0 | 241 | 2 | 152 | 231 | AIT70095.1 phosphoenolpyruvate carboxykinase [Pyropia yezoensis] | diamond | 240 | 115 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 7524851 | 7524851 | PRJNA608894_P_NODE_20446_length_448_cov_25.349333_g19950_i0 | PRJNA608894 | 20446 | 448 | 25.349333 | 113.56501184 | Galdieria yellowstonensis | 3028027 | Rhodophyta | other_Eukaryota | 109 | 1.17e-27 | NR | KAK4526463.1 | 3028027 | g19950 | i0 | 52.8 | 0.823660714285714 | 123 | 54 | 81 | 4 | 426 | 64 | 4 | 124 | KAK4526463.1 hypothetical protein GAYE_SCF24G4379 [Galdieria yellowstonensis] | diamond | 369 | 109 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Galdieriales | Galdieriaceae | Galdieria | Galdieria yellowstonensis | |||
| 8238719 | 8238719 | PRJNA608894_P_NODE_46987_length_259_cov_1.655914_g46488_i0 | PRJNA608894 | 46987 | 259 | 1.655914 | 4.28881726 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 1.24e-32 | NR | AAL05459.1 | 31436 | g46488 | i0 | 73.3 | 11.8725868725869 | 86 | 23 | 99.6 | 0 | 258 | 1 | 245 | 330 | AAL05459.1 enolase 1, partial [Mastocarpus papillatus] | diamond | 3075 | 127 | 0.992125984251969 | Eukaryota | Mastocarpus papillatus complex | Rhodophyta | Florideophyceae | Gigartinales | Phyllophoraceae | Mastocarpus | Mastocarpus papillatus | ||
| 13339659 | 13339659 | PRJNA608894_P_NODE_43171_length_272_cov_1.251256_g42672_i0 | PRJNA608894 | 43171 | 272 | 1.251256 | 3.40341632 | Pyropia vietnamensis | 683352 | Rhodophyta | other_Eukaryota | 122 | 1.6499999999999995e-31 | NR | GAB0489483.1 | 683352 | g42672 | i0 | 64.4 | 1.89705882352941 | 90 | 32 | 99.3 | 0 | 272 | 3 | 190 | 279 | GAB0489483.1 hypothetical protein MMPV_000702 [Pyropia vietnamensis] | diamond | 516 | 122 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia vietnamensis | |||
| 22262565 | 22262565 | PRJNA608894_P_NODE_36178_length_299_cov_2.044248_g35679_i0 | PRJNA608894 | 36178 | 299 | 2.044248 | 6.11230152 | Porphyridium purpureum | 35688 | Rhodophyta | other_Eukaryota | 127 | 6.71e-34 | NR | KAA8497731.1 | 35688 | g35679 | i0 | 70.1 | 0.77257525083612 | 77 | 23 | 77.3 | 0 | 297 | 67 | 179 | 255 | KAA8497731.1 Phosphomannomutase [Porphyridium purpureum] | diamond | 231 | 127 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Porphyridiales | Porphyridiaceae | Porphyridium | Porphyridium purpureum | |||
| 26921941 | 26921941 | PRJNA608894_P_NODE_48642_length_254_cov_1.701657_g48143_i0 | PRJNA608894 | 48642 | 254 | 1.701657 | 4.32220878 | Porphyridium purpureum | 35688 | Rhodophyta | other_Eukaryota | 50.8 | 5.77e-5 | NR | KAA8490618.1 | 35688 | g48143 | i0 | 41.5 | 2.32677165354331 | 65 | 38 | 76.8 | 0 | 5 | 199 | 32 | 96 | KAA8490618.1 Siroheme synthase 1 [Porphyridium purpureum] | diamond | 591 | 50.8 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Porphyridiales | Porphyridiaceae | Porphyridium | Porphyridium purpureum | |||
| 27029984 | 27029984 | PRJNA608894_P_NODE_53982_length_247_cov_0.885057_g53483_i0 | PRJNA608894 | 53982 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 125 | 7.459999999999999e-32 | NR | KAK1863367.1 | 2788 | g53483 | i0 | 85.7 | 6.87449392712551 | 70 | 10 | 85 | 0 | 243 | 34 | 310 | 379 | KAK1863367.1 hypothetical protein I4F81_005925 [Pyropia yezoensis] | diamond | 1698 | 126 | 0.992063492063492 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 27111600 | 27111600 | PRJNA608894_P_NODE_21642_length_428_cov_2.411268_g21146_i0 | PRJNA608894 | 21642 | 428 | 2.411268 | 10.32022704 | Pyropia yezoensis | 2788 | Rhodophyta | other_Eukaryota | 195 | 5.44e-57 | NR | AIT70051.1 | 2788 | g21146 | i0 | 67.1 | 1.9696261682243 | 140 | 46 | 98.1 | 0 | 425 | 6 | 121 | 260 | AIT70051.1 pyruvate kinase [Pyropia yezoensis] | diamond | 843 | 195 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 27409528 | 27409528 | PRJNA608894_P_NODE_48923_length_253_cov_2.161111_g48424_i0 | PRJNA608894 | 48923 | 253 | 2.161111 | 5.46761083 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 5.04e-4 | NR | OSX76546.1 | 2786 | g48424 | i0 | 42.6 | 3.54545454545455 | 61 | 30 | 66.4 | 2 | 13 | 180 | 45 | 105 | OSX76546.1 hypothetical protein BU14_0185s0008 [Porphyra umbilicalis] | diamond | 897 | 46.2 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Porphyra | Porphyra umbilicalis | |||
| 28072322 | 28072322 | PRJNA608894_P_NODE_62085_length_223_cov_4.206667_g61586_i0 | PRJNA608894 | 62085 | 223 | 4.206667 | 9.38086741 | Galdieria | 83373 | Rhodophyta | other_Eukaryota | 115 | 3.87e-28 | NR | GJQ10802.1 | 83374 | g61586 | i0 | 78.1 | 3.92825112107623 | 73 | 16 | 98.2 | 0 | 3 | 221 | 253 | 325 | GJQ10802.1 hypothetical protein GpartN1_g2593.t1 [Galdieria partita] | diamond | 876 | 115 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Galdieriales | Galdieriaceae | Galdieria | Galdieria partita | |||
| 28122371 | 28122371 | PRJNA608894_P_NODE_27085_length_360_cov_2.668990_g26586_i0 | PRJNA608894 | 27085 | 360 | 2.66899 | 9.608364 | Gracilariopsis chorda | 448386 | Rhodophyta | other_Eukaryota | 69.3 | 6.74e-11 | NR | PXF48173.1 | 448386 | g26586 | i0 | 61.4 | 0.475 | 57 | 19 | 45 | 1 | 115 | 276 | 458 | 514 | PXF48173.1 Cell division cycle protein 20-like [Gracilariopsis chorda] | diamond | 171 | 69.3 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilariopsis | Gracilariopsis chorda | |||
| 28356434 | 28356434 | PRJNA608894_P_NODE_31386_length_325_cov_1.833333_g30887_i0 | PRJNA608894 | 31386 | 325 | 1.833333 | 5.95833225 | Fungi | 4751 | Rhodophyta | other_Eukaryota | 147 | 9.999999999999999e-43 | NR | XP_005707661.1 | 130081 | g30887 | i0 | 67.3 | 19.4215384615385 | 101 | 33 | 93.2 | 0 | 6 | 308 | 4 | 104 | XP_005707661.1 40S ribosomal protein S18 [Galdieria sulphuraria] | diamond | 6312 | 148 | 0.993243243243243 | Eukaryota | Rhodophyta | Bangiophyceae | Galdieriales | Galdieriaceae | Galdieria | Galdieria sulphuraria | |||
| 28672420 | 28672420 | PRJNA608894_P_NODE_18707_length_480_cov_2.412776_g18211_i0 | PRJNA608894 | 18707 | 480 | 2.412776 | 11.5813248 | Viridiplantae | 33090 | Rhodophyta | other_Eukaryota | 134 | 9.92e-35 | NR | AIT76580.1 | 2788 | g18211 | i0 | 53.7 | 3.84375 | 123 | 57 | 76.9 | 0 | 111 | 479 | 132 | 254 | AIT76580.1 malate dehydrogenase [Pyropia yezoensis] | diamond | 1845 | 135 | 0.992592592592593 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 29069775 | 29069775 | PRJNA608894_P_NODE_13568_length_620_cov_1.585009_g13090_i0 | PRJNA608894 | 13568 | 620 | 1.585009 | 9.8270558 | Rhodosorus marinus | 101924 | Rhodophyta | other_Eukaryota | 110 | 5.47e-27 | NR | KAJ8901525.1 | 101924 | g13090 | i0 | 58.5 | 0.396774193548387 | 82 | 34 | 39.7 | 0 | 102 | 347 | 2 | 83 | KAJ8901525.1 hypothetical protein NDN08_007369 [Rhodosorus marinus] | diamond | 246 | 110 | 1 | Eukaryota | Rhodophyta | Stylonematophyceae | Stylonematales | Stylonemataceae | Rhodosorus | Rhodosorus marinus | |||
| 29164563 | 29164563 | PRJNA608894_P_NODE_52649_length_248_cov_1.668571_g52150_i0 | PRJNA608894 | 52649 | 248 | 1.668571 | 4.13805608 | Pyropia yezoensis | 2788 | Rhodophyta | other_Eukaryota | 115 | 9.53e-28 | NR | AIT70095.1 | 2788 | g52150 | i0 | 65.9 | 0.991935483870968 | 82 | 28 | 99.2 | 0 | 248 | 3 | 134 | 215 | AIT70095.1 phosphoenolpyruvate carboxykinase [Pyropia yezoensis] | diamond | 246 | 115 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 29196050 | 29196050 | PRJNA608894_P_NODE_42849_length_273_cov_1.410000_g42350_i0 | PRJNA608894 | 42849 | 273 | 1.41 | 3.8493 | Chondrus crispus | 2769 | Rhodophyta | other_Eukaryota | 82 | 1.65e-16 | NR | XP_005711466.1 | 2769 | g42350 | i0 | 42.9 | 0.923076923076923 | 84 | 48 | 92.3 | 0 | 253 | 2 | 70 | 153 | XP_005711466.1 unnamed protein product [Chondrus crispus] | diamond | 252 | 82 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Gigartinaceae | Chondrus | Chondrus crispus | |||
| 29637565 | 29637565 | PRJNA608894_P_NODE_38810_length_287_cov_2.158879_g38311_i0 | PRJNA608894 | 38810 | 287 | 2.158879 | 6.19598273 | Pyropia yezoensis | 2788 | Rhodophyta | other_Eukaryota | 116 | 4.669999999999999e-28 | NR | AIT70051.1 | 2788 | g38311 | i0 | 59.8 | 0.961672473867596 | 92 | 37 | 96.2 | 0 | 10 | 285 | 402 | 493 | AIT70051.1 pyruvate kinase [Pyropia yezoensis] | diamond | 276 | 116 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 30933268 | 30933268 | PRJNA608894_P_NODE_48454_length_255_cov_1.252747_g47955_i0 | PRJNA608894 | 48454 | 255 | 1.252747 | 3.19450485 | Pyropia yezoensis | 2788 | Rhodophyta | other_Eukaryota | 110 | 5.51e-26 | NR | AIT70051.1 | 2788 | g47955 | i0 | 62.4 | 1 | 85 | 32 | 100 | 0 | 255 | 1 | 402 | 486 | AIT70051.1 pyruvate kinase [Pyropia yezoensis] | diamond | 255 | 110 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia yezoensis | |||
| 31312397 | 31312397 | PRJNA608894_P_NODE_35595_length_302_cov_2.689956_g35096_i0 | PRJNA608894 | 35595 | 302 | 2.689956 | 8.12366712 | Rhodosorus marinus | 101924 | Rhodophyta | other_Eukaryota | 93.2 | 2.0600000000000001e-22 | NR | KAJ8905469.1 | 101924 | g35096 | i0 | 50.6 | 2.43377483443709 | 79 | 39 | 78.5 | 0 | 30 | 266 | 9 | 87 | KAJ8905469.1 hypothetical protein NDN08_001976 [Rhodosorus marinus] | diamond | 735 | 93.2 | 1 | Eukaryota | Rhodophyta | Stylonematophyceae | Stylonematales | Stylonemataceae | Rhodosorus | Rhodosorus marinus | |||
| 31470768 | 31470768 | PRJNA608894_P_NODE_43676_length_270_cov_1.563452_g43177_i0 | PRJNA608894 | 43676 | 270 | 1.563452 | 4.2213204 | Gracilaria domingensis | 172961 | Rhodophyta | other_Eukaryota | 52.8 | 1.56e-5 | NR | KAI0563915.1 | 172961 | g43177 | i0 | 33.3 | 1 | 90 | 57 | 97.8 | 2 | 7 | 270 | 83 | 171 | KAI0563915.1 glycine dehydrogenase (decarboxylating) [Gracilaria domingensis] | diamond | 270 | 52.8 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gracilariales | Gracilariaceae | Gracilaria | Gracilaria domingensis |
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);;