contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA927284" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 901899 | 901899 | PRJNA927284_P_NODE_8241_length_169_cov_3.092857_g8034_i0 | PRJNA927284 | 8241 | 169 | 3.092857 | 5.22692833 | Antirrhinum majus | 4151 | Plants | Plants | 313 | 5.859999999999999e-81 | NTclustered | gi|41323870|gb|AY423077.1| | 4151 | g8034 | i0 | 100 | 100 | 169 | 0 | 100 | 0 | 1 | 169 | 954 | 1122 | Antirrhinum majus isolate DNA-CW4 26S ribosomal RNA gene, partial sequence | blastn | 16900 | 313 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Plantaginaceae | Antirrhinum | Antirrhinum majus | |
| 6005017 | 6005017 | PRJNA927284_P_NODE_2305_length_456_cov_3.646370_g2113_i0 | PRJNA927284 | 2305 | 456 | 3.64637 | 16.6274472 | Taxillus matsudae | 2805424 | Plants | Plants | 126 | 2.5699999999999997e-24 | NTclustered | gi|1970150767|gb|MW555625.1| | 2805424 | g2113 | i0 | 84.375 | 4.65350877192982 | 128 | 20 | 28 | 0 | 258 | 385 | 3022 | 2895 | Taxillus matsudae voucher Su138 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2122 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Loranthaceae | Taxillus | Taxillus matsudae | |
| 8554688 | 8554688 | PRJNA927284_P_NODE_2047_length_492_cov_4.302376_g1753_i1 | PRJNA927284 | 2047 | 492 | 4.302376 | 21.16768992 | Smilax moranensis | 1080332 | Plants | Plants | 52.8 | 0.048 | NTclustered | gi|2231659460|gb|OL693684.1| | 1080332 | g1753 | i1 | 100 | 0.0569105691056911 | 28 | 0 | 6 | 0 | 449 | 476 | 47757 | 47730 | Smilax moranensis chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Liliales | Smilacaceae | Smilax | Smilax moranensis | |
| 8905359 | 8905359 | PRJNA927284_P_NODE_4407_length_286_cov_4.766537_g4200_i0 | PRJNA927284 | 4407 | 286 | 4.766537 | 13.63229582 | Magnoliopsida | 3398 | Plants | Plants | 523 | 4.659999999999998e-144 | NTclustered | gi|6467913|gb|AF197583.1| | 108423 | g4200 | i0 | 99.65 | 100 | 286 | 1 | 100 | 0 | 1 | 286 | 386 | 101 | Sarcococca confusa 18S ribosomal RNA gene, partial sequence | blastn | 28600 | 523 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Buxales | Buxaceae | Sarcococca | Sarcococca confusa | |
| 10181228 | 10181228 | PRJNA927284_P_NODE_4868_length_264_cov_2.221277_g4661_i0 | PRJNA927284 | 4868 | 264 | 2.221277 | 5.86417128 | Magnoliopsida | 3398 | Plants | Plants | 158 | 4.97e-34 | NTclustered | gi|2123588875|ref|XR_006435870.1| | 4565 | g4661 | i0 | 86.713 | 48.5643939393939 | 143 | 17 | 54 | 2 | 66 | 208 | 422 | 282 | PREDICTED: Triticum aestivum 28S ribosomal RNA (LOC123074126), rRNA | blastn | 12821 | 158 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 10181237 | 10181237 | PRJNA927284_P_NODE_7988_length_174_cov_2.620690_g7781_i0 | PRJNA927284 | 7988 | 174 | 2.62069 | 4.5600006 | Interfilum | 519230 | Plants | Plants | 322 | 1.01e-83 | NTclustered | gi|2550522787|gb|OR168093.1| | 519232 | g7781 | i0 | 100 | 149.402298850575 | 174 | 0 | 100 | 0 | 1 | 174 | 93765 | 93938 | Interfilum sp. SAG 36.88 plastid, complete genome | blastn | 25996 | 322 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Interfilum | Interfilum sp. SAG 36.88 | ||
| 11105481 | 11105481 | PRJNA927284_P_NODE_9389_length_150_cov_1.033058_g9182_i0 | PRJNA927284 | 9389 | 150 | 1.033058 | 1.549587 | Oryza sativa | 4530 | Plants | Plants | 161 | 1.95e-35 | NTclustered | gi|116641411|emb|CT836953.1| | 39946 | g9182 | i0 | 87.075 | 1.36 | 147 | 13 | 96 | 5 | 6 | 149 | 609 | 752 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA114K09, full insert sequence | blastn | 204 | 161 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 14006602 | 14006602 | PRJNA927284_P_NODE_7711_length_179_cov_5.053333_g7504_i0 | PRJNA927284 | 7711 | 179 | 5.053333 | 9.04546607 | Streptophyta | 35493 | Plants | Plants | 331 | 1.74e-86 | NTclustered | gi|1241931191|ref|NC_035860.1| | 3281 | g7504 | i0 | 100 | 180 | 179 | 0 | 100 | 0 | 1 | 179 | 86772 | 86950 | Onoclea sensibilis chloroplast, complete genome | blastn | 32220 | 331 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Onocleaceae | Onoclea | Onoclea sensibilis | |
| 14929798 | 14929798 | PRJNA927284_P_NODE_6512_length_206_cov_1.807910_g6305_i0 | PRJNA927284 | 6512 | 206 | 1.80791 | 3.7242946 | Phaseolus vulgaris | 3885 | Plants | Plants | 302 | 1.62e-77 | NTclustered | gi|1142584|emb|Z48778.1| | 3885 | g6305 | i0 | 98.817 | 1.00485436893204 | 169 | 2 | 100 | 0 | 1 | 169 | 10 | 178 | P.vulgaris rDNA intergenic spacer subrepeat | blastn | 207 | 302 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Phaseolus | Phaseolus vulgaris | |
| 14929812 | 14929812 | PRJNA927284_P_NODE_8732_length_161_cov_2.068182_g8525_i0 | PRJNA927284 | 8732 | 161 | 2.068182 | 3.32977302 | Vigna angularis | 3914 | Plants | Plants | 99 | 1.69e-16 | NTclustered | gi|2418129916|ref|XM_052879013.1| | 3914 | g8525 | i0 | 77.987 | 88.8695652173913 | 159 | 33 | 99 | 2 | 1 | 159 | 778 | 934 | PREDICTED: Vigna angularis uncharacterized LOC128197374 (LOC128197374), mRNA | blastn | 14308 | 99 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna angularis | |
| 15280552 | 15280552 | PRJNA927284_P_NODE_7072_length_192_cov_3.717791_g6865_i0 | PRJNA927284 | 7072 | 192 | 3.717791 | 7.13815872 | Magnoliopsida | 3398 | Plants | Plants | 307 | 3.2e-79 | NTclustered | gi|2720893215|gb|PP719342.1| | 43235 | g6865 | i0 | 98.837 | 89.65625 | 172 | 2 | 90 | 0 | 1 | 172 | 1788 | 1617 | Englerina woodfordioides voucher PE CPG28675 Z.D. Chen et al. 28675 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 | 17214 | 309 | 0.993527508090615 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Loranthaceae | Englerina | Englerina woodfordioides | |
| 16204846 | 16204846 | PRJNA927284_P_NODE_5493_length_238_cov_2.502392_g5286_i0 | PRJNA927284 | 5493 | 238 | 2.502392 | 5.95569296 | Ribes rubrum | 175228 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|2918370030|emb|OZ237958.1| | 175228 | g5286 | i0 | 100 | 0.117647058823529 | 28 | 0 | 12 | 0 | 24 | 51 | 5080306 | 5080333 | Ribes rubrum genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Saxifragales | Grossulariaceae | Ribes | Ribes rubrum | |
| 16204865 | 16204865 | PRJNA927284_P_NODE_8213_length_170_cov_1.900709_g8006_i0 | PRJNA927284 | 8213 | 170 | 1.900709 | 3.2312053 | Glycine max | 3847 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|332144645|dbj|AP011812.1| | 3847 | g8006 | i0 | 96.875 | 0.376470588235294 | 32 | 0 | 18 | 1 | 50 | 80 | 27959 | 27990 | Glycine max DNA, BAC clone: MiB309A12, complete sequence | blastn | 64 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 16555056 | 16555056 | PRJNA927284_P_NODE_3533_length_339_cov_3.641935_g3328_i0 | PRJNA927284 | 3533 | 339 | 3.641935 | 12.34615965 | Streptophyta | 35493 | Plants | Plants | 592 | 1.5299999999999996e-164 | NTclustered | gi|2314712628|emb|OX344767.1| | 28468 | g3328 | i0 | 99.387 | 170.212389380531 | 326 | 2 | 96 | 0 | 1 | 326 | 92362 | 92687 | Rhytidiadelphus loreus genome assembly, organelle: plastid:chloroplast | blastn | 57702 | 597 | 0.991624790619765 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Hypnales | Hylocomiaceae | Rhytidiadelphus | Rhytidiadelphus loreus | |
| 16555061 | 16555061 | PRJNA927284_P_NODE_6893_length_196_cov_2.676647_g6686_i0 | PRJNA927284 | 6893 | 196 | 2.676647 | 5.24622812 | Eukaryota | 2759 | Plants | Plants | 363 | 6.899999999999998e-96 | NTclustered | gi|115430545|emb|CT837767.1| | 39946 | g6686 | i0 | 100 | 95.7602040816327 | 196 | 0 | 100 | 0 | 1 | 196 | 664 | 859 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA115O12, full insert sequence | blastn | 18769 | 363 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 17830064 | 17830064 | PRJNA927284_P_NODE_7714_length_179_cov_2.820000_g7507_i0 | PRJNA927284 | 7714 | 179 | 2.82 | 5.0478 | Orthotrichum | 52990 | Plants | Plants | 285 | 1.3699999999999998e-72 | NTclustered | gi|1419383928|gb|MH133388.1| | 122744 | g7507 | i0 | 99.363 | 89.2458100558659 | 157 | 1 | 88 | 0 | 1 | 157 | 157 | 1 | Orthotrichum pumilum isolate 26S_113 26S ribosomal RNA gene, partial sequence | blastn | 15975 | 287 | 0.993031358885017 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Orthotrichales | Orthotrichaceae | Orthotrichum | Orthotrichum pumilum | |
| 19104016 | 19104016 | PRJNA927284_P_NODE_3235_length_361_cov_13.385542_g3030_i0 | PRJNA927284 | 3235 | 361 | 13.385542 | 48.32180662 | Eukaryota | 2759 | Plants | Plants | 636 | 7.429999999999999e-178 | NTclustered | gi|1702291457|gb|MN174867.1| | 82485 | g3030 | i0 | 98.607 | 105.315789473684 | 359 | 5 | 99 | 0 | 3 | 361 | 4043 | 4401 | Trillium govanianum voucher CL1804 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 | 38019 | 636 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Liliales | Melanthiaceae | Trillium | Trillium govanianum | |
| 21654824 | 21654824 | PRJNA927284_P_NODE_8137_length_171_cov_3.028169_g7930_i0 | PRJNA927284 | 8137 | 171 | 3.028169 | 5.17816899 | Streptophyta | 35493 | Plants | Plants | 313 | 5.95e-81 | NTclustered | gi|486172263|gb|JX241569.1| | 3213 | g7930 | i0 | 100 | 184.859649122807 | 169 | 0 | 99 | 0 | 1 | 169 | 28 | 196 | Polytrichum commune large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 31611 | 316 | 0.990506329113924 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polytrichopsida | Polytrichales | Polytrichaceae | Polytrichum | Polytrichum commune | |
| 22579017 | 22579017 | PRJNA927284_P_NODE_6398_length_209_cov_2.933333_g6191_i0 | PRJNA927284 | 6398 | 209 | 2.933333 | 6.13066597 | Justicia demissa | 1685546 | Plants | Plants | 387 | 4.42e-103 | NTclustered | gi|2482680364|gb|OQ785890.1| | 1685546 | g6191 | i0 | 100 | 105.703349282297 | 209 | 0 | 100 | 0 | 1 | 209 | 5819 | 5611 | Justicia demissa small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 22092 | 387 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Acanthaceae | Justicia | Justicia demissa | |
| 22930336 | 22930336 | PRJNA927284_P_NODE_5598_length_234_cov_3.229268_g5391_i0 | PRJNA927284 | 5598 | 234 | 3.229268 | 7.55648712 | Orthotrichaceae | 52989 | Plants | Plants | 416 | 6.449999999999999e-112 | NTclustered | gi|817527089|ref|NC_026979.1| | 61564 | g5391 | i0 | 98.718 | 163.807692307692 | 234 | 3 | 100 | 0 | 1 | 234 | 86482 | 86715 | Nyholmiella obtusifolia chloroplast, complete genome | blastn | 38331 | 416 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Orthotrichales | Orthotrichaceae | Orthotrichum | Orthotrichum obtusifolium | |
| 23854131 | 23854131 | PRJNA927284_P_NODE_2919_length_387_cov_10.382682_g2717_i0 | PRJNA927284 | 2919 | 387 | 10.382682 | 40.18097934 | Oryza sativa | 4530 | Plants | Plants | 460 | 5.18e-125 | NTclustered | gi|116640607|emb|CT836548.1| | 39946 | g2717 | i0 | 88.144 | 503.894056847545 | 388 | 44 | 100 | 2 | 1 | 387 | 395 | 9 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA126A09, full insert sequence | blastn | 195007 | 460 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 24204108 | 24204108 | PRJNA927284_P_NODE_7599_length_181_cov_3.440789_g7392_i0 | PRJNA927284 | 7599 | 181 | 3.440789 | 6.22782809 | Solanaceae | 4070 | Plants | Plants | 329 | 6.340000000000001e-86 | NTclustered | gi|2839189188|ref|XR_011219215.1| | 4081 | g7392 | i0 | 99.448 | 100 | 181 | 1 | 100 | 0 | 1 | 181 | 632 | 812 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138346485), rRNA | blastn | 18100 | 329 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 25479155 | 25479155 | PRJNA927284_P_NODE_1160_length_699_cov_3.777612_g1020_i0 | PRJNA927284 | 1160 | 699 | 3.777612 | 26.40550788 | Orthotrichaceae | 52989 | Plants | Plants | 1219 | 0 | NTclustered | gi|817527089|ref|NC_026979.1| | 61564 | g1020 | i0 | 99.406 | 168.474964234621 | 673 | 3 | 96 | 1 | 1 | 672 | 91398 | 92070 | Nyholmiella obtusifolia chloroplast, complete genome | blastn | 117764 | 1225 | 0.995102040816327 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Orthotrichales | Orthotrichaceae | Orthotrichum | Orthotrichum obtusifolium | |
| 25479159 | 25479159 | PRJNA927284_P_NODE_3340_length_353_cov_7.879630_g3135_i0 | PRJNA927284 | 3340 | 353 | 7.87963 | 27.8150939 | Eukaryota | 2759 | Plants | Plants | 610 | 4.39e-170 | NTclustered | gi|2839186375|ref|XR_011216401.1| | 4081 | g3135 | i0 | 98.006 | 100.118980169972 | 351 | 7 | 99 | 0 | 3 | 353 | 1013 | 663 | PREDICTED: Solanum lycopersicum 18S ribosomal RNA (LOC138343606), rRNA | blastn | 35342 | 616 | 0.99025974025974 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum |
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);;