contig_metadata
20 rows where bioproject = "PRJEB6055" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125527 | 125527 | PRJEB6055_S_NODE_1721_length_229_cov_1.134021_g1697_i0 | PRJEB6055 | 1721 | 229 | 1.134021 | 2.59690809 | Populus trichocarpa | 3694 | Plants | Plants | 217 | 6.85e-52 | NTclustered | gi|2396430170|ref|XM_006370104.3| | 3694 | g1697 | i0 | 87 | 1.75982532751092 | 200 | 16 | 83 | 7 | 1 | 190 | 479 | 678 | PREDICTED: Populus trichocarpa olee1-like protein (LOC18095502), mRNA | blastn | 403 | 217 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus trichocarpa | |
| 2675606 | 2675606 | PRJEB6055_S_NODE_1503_length_239_cov_6.274510_g1479_i0 | PRJEB6055 | 1503 | 239 | 6.27451 | 14.9960789 | Brachypodium distachyon | 15368 | Plants | Plants | 213 | 9.31e-51 | NTclustered | gi|554786685|dbj|AK424354.1| | 15368 | g1479 | i0 | 87.845 | 0.757322175732218 | 181 | 22 | 76 | 0 | 3 | 183 | 70 | 250 | Brachypodium distachyon mRNA, clone: PL016C01-A-001_I10 | blastn | 181 | 213 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Brachypodium | Brachypodium distachyon | |
| 7369753 | 7369753 | PRJEB6055_S_NODE_1746_length_228_cov_2.694301_g1722_i0 | PRJEB6055 | 1746 | 228 | 2.694301 | 6.14300628 | Salicaceae | 3688 | Plants | Plants | 422 | 1.34e-113 | NTclustered | gi|2511398409|emb|OX637692.1| | 3691 | g1722 | i0 | 100 | 108.982456140351 | 228 | 0 | 100 | 0 | 1 | 228 | 256387 | 256614 | Populus nigra genome assembly, organelle: mitochondrion | blastn | 24848 | 422 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus nigra | |
| 7369754 | 7369754 | PRJEB6055_S_NODE_2446_length_205_cov_2.352941_g2422_i0 | PRJEB6055 | 2446 | 205 | 2.352941 | 4.82352905 | root | 1 | Root_unresolved | Root_unresolved | 372 | 1.21e-98 | NTclustered | gi|1481899845|gb|MH971208.1| | 3175 | g2422 | i0 | 99.51 | 94.8634146341463 | 204 | 1 | 99 | 0 | 1 | 204 | 949 | 1152 | Klebsormidium flaccidum strain Us-1-2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19447 | 374 | 0.994652406417112 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium flaccidum | ||
| 10328598 | 10328598 | PRJEB6055_S_NODE_709_length_306_cov_8.708487_g685_i0 | PRJEB6055 | 709 | 306 | 8.708487 | 26.64797022 | Hordeum vulgare | 4513 | Plants | Plants | 372 | 1.93e-98 | NTclustered | gi|326488240|dbj|AK362585.1| | 112509 | g685 | i0 | 99.51 | 0.666666666666667 | 204 | 1 | 67 | 0 | 1 | 204 | 534 | 737 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2008H07 | blastn | 204 | 372 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 12471242 | 12471242 | PRJEB6055_S_NODE_1350_length_248_cov_5.342723_g1326_i0 | PRJEB6055 | 1350 | 248 | 5.342723 | 13.24995304 | Salix | 40685 | Plants | Plants | 442 | 1.1399999999999995e-119 | NTclustered | gi|1881064953|gb|MT808329.1| | 75704 | g1326 | i0 | 98.79 | 100 | 248 | 3 | 100 | 0 | 1 | 248 | 2586 | 2833 | Salix alba isolate DM300 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24800 | 442 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix alba | |
| 12471245 | 12471245 | PRJEB6055_S_NODE_590_length_321_cov_13006.860140_g566_i0 | PRJEB6055 | 590 | 321 | 13006.86014 | 41752.0210494 | Magnoliopsida | 3398 | Plants | Plants | 464 | 3.2599999999999995e-126 | NTclustered | gi|2569531918|ref|NC_081498.1| | 35974 | g566 | i0 | 99.222 | 104.660436137072 | 257 | 2 | 80 | 0 | 65 | 321 | 119322 | 119066 | Santalum album mitochondrion, complete genome | blastn | 33596 | 466 | 0.995708154506438 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Santalaceae | Santalum | Santalum album | |
| 13745715 | 13745715 | PRJEB6055_S_NODE_4071_length_173_cov_1.478261_g4047_i0 | PRJEB6055 | 4071 | 173 | 1.478261 | 2.55739153 | Corylus | 13450 | Plants | Plants | 224 | 2.91e-54 | NTclustered | gi|2578543229|ref|XM_059607332.1| | 13451 | g4047 | i0 | 91.071 | 5.28323699421965 | 168 | 12 | 95 | 1 | 9 | 173 | 353 | 186 | PREDICTED: Corylus avellana protein SRC1 (LOC132192114), mRNA | blastn | 914 | 224 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Corylus | Corylus avellana | |
| 16702230 | 16702230 | PRJEB6055_S_NODE_4274_length_170_cov_3.770370_g4250_i0 | PRJEB6055 | 4274 | 170 | 3.7703700000000002 | 6.409629 | Brachypodium distachyon | 15368 | Plants | Plants | 241 | 2.8300000000000007e-59 | NTclustered | gi|554786563|dbj|AK440311.1| | 15368 | g4250 | i0 | 92.982 | 1.00588235294118 | 171 | 3 | 98 | 5 | 1 | 167 | 821 | 986 | Brachypodium distachyon mRNA, clone: PL016C01-A-104_M01 | blastn | 171 | 241 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Brachypodium | Brachypodium distachyon | |
| 16702231 | 16702231 | PRJEB6055_S_NODE_4334_length_169_cov_4.902985_g4310_i0 | PRJEB6055 | 4334 | 169 | 4.902985 | 8.28604465 | Oryza sativa | 4530 | Plants | Plants | 172 | 1.04e-38 | NTclustered | gi|116641261|emb|CT836802.1| | 39946 | g4310 | i0 | 87.333 | 5.9585798816568 | 150 | 19 | 89 | 0 | 20 | 169 | 484 | 335 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCEA044G19, full insert sequence | blastn | 1007 | 172 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 17570109 | 17570109 | PRJEB6055_S_NODE_3914_length_175_cov_3.807143_g3890_i0 | PRJEB6055 | 3914 | 175 | 3.807143 | 6.66250025 | Magnoliopsida | 3398 | Plants | Plants | 261 | 2.25e-65 | NTclustered | gi|6689072|emb|AJ235979.1| | 3610 | g3890 | i0 | 99.306 | 82.2914285714286 | 144 | 1 | 82 | 0 | 1 | 144 | 903 | 760 | Rhamnus cathartica 18S rRNA gene | blastn | 14401 | 263 | 0.992395437262357 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rhamnaceae | Rhamnus | Rhamnus cathartica | |
| 17570110 | 17570110 | PRJEB6055_S_NODE_4994_length_160_cov_9.464000_g4970_i0 | PRJEB6055 | 4994 | 160 | 9.464 | 15.1424 | Poaceae | 4479 | Plants | Plants | 217 | 4.45e-52 | NTclustered | gi|511347561|ref|NC_021372.1| | 38686 | g4970 | i0 | 100 | 141.13125 | 117 | 0 | 73 | 0 | 29 | 145 | 100123 | 100239 | Pharus latifolius chloroplast, complete genome | blastn | 22581 | 217 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Pharus | Pharus latifolius | |
| 20118795 | 20118795 | PRJEB6055_S_NODE_4616_length_165_cov_3.384615_g4592_i0 | PRJEB6055 | 4616 | 165 | 3.384615 | 5.58461475 | Taxus | 25628 | Plants | Plants | 305 | 9.59e-79 | NTclustered | gi|1206255126|ref|NC_035066.1| | 25629 | g4592 | i0 | 100 | 99.4666666666667 | 165 | 0 | 100 | 0 | 1 | 165 | 101897 | 101733 | Taxus baccata chloroplast, complete genome | blastn | 16412 | 305 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus baccata | |
| 21394343 | 21394343 | PRJEB6055_S_NODE_1617_length_233_cov_2.308081_g1593_i0 | PRJEB6055 | 1617 | 233 | 2.308081 | 5.37782873 | Populus | 3689 | Plants | Plants | 431 | 2.2899999999999996e-116 | NTclustered | gi|1878849222|gb|MT796558.1| | 3690 | g1593 | i0 | 100 | 100 | 233 | 0 | 100 | 0 | 1 | 233 | 4199 | 4431 | Populus x canadensis isolate DM631 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23300 | 431 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus x canadensis | |
| 21394348 | 21394348 | PRJEB6055_S_NODE_3717_length_178_cov_6.223776_g3693_i0 | PRJEB6055 | 3717 | 178 | 6.223776 | 11.07832128 | Magnoliopsida | 3398 | Plants | Plants | 122 | 1.13e-23 | NTclustered | gi|2907550926|emb|OZ222503.1| | 3516 | g3693 | i0 | 100 | 64.9831460674157 | 66 | 0 | 53 | 0 | 83 | 148 | 82042 | 82107 | Alnus incana genome assembly, organelle: mitochondrion | blastn | 11567 | 122 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Alnus | Alnus incana | |
| 21802289 | 21802289 | PRJEB6055_S_NODE_3618_length_180_cov_1.951724_g3594_i0 | PRJEB6055 | 3618 | 180 | 1.951724 | 3.5131032 | Corylus avellana | 13451 | Plants | Plants | 165 | 1.88e-36 | NTclustered | gi|2578511177|ref|XM_059593011.1| | 13451 | g3594 | i0 | 92.5 | 0.666666666666667 | 120 | 2 | 63 | 2 | 1 | 114 | 706 | 824 | PREDICTED: Corylus avellana classical arabinogalactan protein 11-like (LOC132180260), mRNA | blastn | 120 | 165 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Corylus | Corylus avellana | |
| 28991914 | 28991914 | PRJEB6055_S_NODE_5748_length_152_cov_1.914530_g5724_i0 | PRJEB6055 | 5748 | 152 | 1.91453 | 2.9100856 | Carpinus fangiana | 176857 | Plants | Plants | 61.6 | 1.7e-10 | NR | KAE8124078.1 | 176857 | g5724 | i0 | 91.9 | 0.730263157894737 | 37 | 3 | 73 | 0 | 16 | 126 | 1 | 37 | KAE8124078.1 hypothetical protein FH972_018988 [Carpinus fangiana] | diamond | 111 | 61.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Carpinus | Carpinus fangiana | |
| 29363799 | 29363799 | PRJEB6055_S_NODE_649_length_314_cov_2.071685_g625_i0 | PRJEB6055 | 649 | 314 | 2.071685 | 6.5050909 | Eukaryota | 2759 | Plants | Plants | 53.1 | 4.45e-6 | NR | XP_055818756.1 | 45834 | g625 | i0 | 66.7 | 7.80573248407643 | 81 | 25 | 77.4 | 1 | 289 | 47 | 69 | 147 | XP_055818756.1 60S acidic ribosomal protein P2B-like [Solanum dulcamara] | diamond | 2451 | 53.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum dulcamara | |
| 29844076 | 29844076 | PRJEB6055_S_NODE_2911_length_193_cov_2.398734_g2887_i0 | PRJEB6055 | 2911 | 193 | 2.398734 | 4.62955662 | Sphenostylis stenocarpa | 92480 | Plants | Plants | 74.7 | 9.92e-14 | NR | CAJ1971540.1 | 92480 | g2887 | i0 | 65.5 | 4.29015544041451 | 55 | 19 | 85.5 | 0 | 193 | 29 | 400 | 454 | CAJ1971540.1 unnamed protein product [Sphenostylis stenocarpa] | diamond | 828 | 74.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Sphenostylis | Sphenostylis stenocarpa | |
| 29907408 | 29907408 | PRJEB6055_S_NODE_731_length_304_cov_3.758364_g707_i0 | PRJEB6055 | 731 | 304 | 3.758364 | 11.42542656 | Rhamnella rubrinervis | 2594499 | Plants | Plants | 49.7 | 2.64e-4 | NR | KAF3449793.1 | 2594499 | g707 | i0 | 41.4 | 0.690789473684211 | 70 | 28 | 69.1 | 3 | 94 | 303 | 301 | 357 | KAF3449793.1 hypothetical protein FNV43_RR05871 [Rhamnella rubrinervis] | diamond | 210 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rhamnaceae | Rhamnella | Rhamnella rubrinervis |
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);;