contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1103784" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212169 | 212169 | PRJNA1103784_P_NODE_4981_length_263_cov_1.589474_g4926_i0 | PRJNA1103784 | 4981 | 263 | 1.589474 | 4.18031662 | Oryza sativa | 4530 | Plants | Plants | 414 | 2.66e-111 | NTclustered | gi|32992879|dbj|AK107670.1| | 39947 | g4926 | i0 | 95.057 | 39.4030418250951 | 263 | 13 | 100 | 0 | 1 | 263 | 1374 | 1636 | Oryza sativa Japonica Group cDNA clone:002-131-H08, full insert sequence | blastn | 10363 | 414 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 1486779 | 1486779 | PRJNA1103784_P_NODE_1922_length_377_cov_1.736842_g1867_i0 | PRJNA1103784 | 1922 | 377 | 1.736842 | 6.54789434 | Andropogon virgatus | 2491225 | Plants | Plants | 695 | 0 | NTclustered | gi|1524087539|gb|MH181223.1| | 2491225 | g1867 | i0 | 100 | 194.48275862069 | 376 | 0 | 99 | 0 | 2 | 377 | 101146 | 100771 | Andropogon virgatus isolate TK477 chloroplast, complete genome | blastn | 73320 | 695 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Andropogon | Andropogon virgatus | |
| 1486829 | 1486829 | PRJNA1103784_P_NODE_4782_length_266_cov_5.393782_g4727_i0 | PRJNA1103784 | 4782 | 266 | 5.393782 | 14.34746012 | Cryptomeria japonica | 3369 | Plants | Plants | 492 | 1.2099999999999999e-134 | NTclustered | gi|2571330970|ref|XR_009371277.1| | 3369 | g4727 | i0 | 100 | 100 | 266 | 0 | 100 | 0 | 1 | 266 | 313 | 48 | PREDICTED: Cryptomeria japonica 18S ribosomal RNA (LOC131873292), rRNA | blastn | 26600 | 492 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 1486881 | 1486881 | PRJNA1103784_P_NODE_8022_length_233_cov_2.012500_g7967_i0 | PRJNA1103784 | 8022 | 233 | 2.0125 | 4.689125 | Oryza sativa | 4530 | Plants | Plants | 387 | 5.03e-103 | NTclustered | gi|32973086|dbj|AK063068.1| | 39947 | g7967 | i0 | 96.567 | 3.17167381974249 | 233 | 8 | 100 | 0 | 1 | 233 | 715 | 483 | Oryza sativa Japonica Group cDNA clone:001-110-G10, full insert sequence | blastn | 739 | 387 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 2295617 | 2295617 | PRJNA1103784_P_NODE_3142_length_309_cov_1.805085_g3087_i0 | PRJNA1103784 | 3142 | 309 | 1.805085 | 5.57771265 | Eukaryota | 2759 | Plants | Plants | 211 | 4.5e-50 | NTclustered | gi|326521829|dbj|AK369289.1| | 112509 | g3087 | i0 | 86.772 | 59.8155339805825 | 189 | 25 | 61 | 0 | 117 | 305 | 1195 | 1007 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2088F12 | blastn | 18483 | 213 | 0.990610328638498 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 2762903 | 2762903 | PRJNA1103784_P_NODE_7803_length_241_cov_0.916667_g7748_i0 | PRJNA1103784 | 7803 | 241 | 0.916667 | 2.20916747 | Cucumis melo | 3656 | Plants | Plants | 172 | 1.6e-38 | NTclustered | gi|733578317|emb|LN713264.1| | 3656 | g7748 | i0 | 82.927 | 1.70124481327801 | 205 | 22 | 84 | 6 | 39 | 240 | 5871736 | 5871542 | Cucumis melo genomic chromosome, chr_10 | blastn | 410 | 172 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 3570719 | 3570719 | PRJNA1103784_P_NODE_8163_length_218_cov_11.303448_g8108_i0 | PRJNA1103784 | 8163 | 218 | 11.303448 | 24.64151664 | Cupressaceae | 3367 | Plants | Plants | 401 | 1.6599999999999993e-107 | NTclustered | gi|2571330970|ref|XR_009371277.1| | 3369 | g8108 | i0 | 100 | 99.5412844036697 | 217 | 0 | 99 | 0 | 2 | 218 | 1648 | 1432 | PREDICTED: Cryptomeria japonica 18S ribosomal RNA (LOC131873292), rRNA | blastn | 21700 | 401 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 5315002 | 5315002 | PRJNA1103784_P_NODE_3765_length_288_cov_1.246512_g3710_i0 | PRJNA1103784 | 3765 | 288 | 1.246512 | 3.58995456 | Hordeum vulgare | 4513 | Plants | Plants | 477 | 3.71e-130 | NTclustered | gi|326524316|dbj|AK369340.1| | 112509 | g3710 | i0 | 96.528 | 93.8229166666667 | 288 | 10 | 100 | 0 | 1 | 288 | 1155 | 868 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2089H12 | blastn | 27021 | 477 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 6123236 | 6123236 | PRJNA1103784_P_NODE_5605_length_251_cov_1.410112_g5550_i0 | PRJNA1103784 | 5605 | 251 | 1.410112 | 3.53938112 | Lolium | 4520 | Plants | Plants | 459 | 1.1499999999999996e-124 | NTclustered | gi|2922430418|ref|XR_011750348.1| | 4522 | g5550 | i0 | 99.602 | 100.019920318725 | 251 | 1 | 100 | 0 | 1 | 251 | 27 | 277 | PREDICTED: Lolium perenne 28S ribosomal RNA (LOC139834652), rRNA | blastn | 25105 | 459 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 7397974 | 7397974 | PRJNA1103784_P_NODE_5446_length_254_cov_1.364641_g5391_i0 | PRJNA1103784 | 5446 | 254 | 1.364641 | 3.46618814 | Fabaceae | 3803 | Plants | Plants | 448 | 2.5199999999999996e-121 | NTclustered | gi|1714054218|gb|MN244679.1| | 126820 | g5391 | i0 | 98.425 | 99.2204724409449 | 254 | 4 | 100 | 0 | 1 | 254 | 4204 | 3951 | Senna occidentalis isolate B 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 | 25202 | 449 | 0.997772828507795 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Senna | Senna occidentalis | |
| 8673425 | 8673425 | PRJNA1103784_P_NODE_7927_length_238_cov_2.466667_g7872_i0 | PRJNA1103784 | 7927 | 238 | 2.466667 | 5.87066746 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 4.59e-4 | NTclustered | gi|2526028454|ref|XM_057560482.1| | 34305 | g7872 | i0 | 100 | 1.76050420168067 | 31 | 0 | 13 | 0 | 4 | 34 | 297 | 267 | PREDICTED: Lotus japonicus protein SRC1 (LOC130711042), mRNA | blastn | 419 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 9948338 | 9948338 | PRJNA1103784_P_NODE_2108_length_364_cov_8.443299_g2053_i0 | PRJNA1103784 | 2108 | 364 | 8.443299 | 30.73360836 | Cunninghamia | 25608 | Plants | Plants | 673 | 0 | NTclustered | gi|152060717|gb|EF673736.1| | 28977 | g2053 | i0 | 100 | 100 | 364 | 0 | 100 | 0 | 1 | 364 | 200 | 563 | Cunninghamia lanceolata 18S ribosomal RNA gene, partial sequence | blastn | 36400 | 673 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cunninghamia | Cunninghamia lanceolata | |
| 9948369 | 9948369 | PRJNA1103784_P_NODE_7028_length_244_cov_1.730994_g6973_i0 | PRJNA1103784 | 7028 | 244 | 1.730994 | 4.22362536 | Magnoliopsida | 3398 | Plants | Plants | 451 | 1.86e-122 | NTclustered | gi|1829764937|ref|NC_046700.1| | 4013 | g6973 | i0 | 100 | 197 | 244 | 0 | 100 | 0 | 1 | 244 | 108405 | 108162 | Toxicodendron vernicifluum cultivar Dahongpao chloroplast, complete genome | blastn | 48068 | 451 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Anacardiaceae | Toxicodendron | Toxicodendron vernicifluum | |
| 10415514 | 10415514 | PRJNA1103784_P_NODE_3229_length_306_cov_1.321888_g3174_i0 | PRJNA1103784 | 3229 | 306 | 1.321888 | 4.04497728 | Oryza sativa | 4530 | Plants | Plants | 405 | 1.9e-108 | NTclustered | gi|32972508|dbj|AK062490.1| | 39947 | g3174 | i0 | 92.832 | 0.911764705882353 | 279 | 20 | 91 | 0 | 25 | 303 | 52 | 330 | Oryza sativa Japonica Group cDNA clone:001-103-H06, full insert sequence | blastn | 279 | 405 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 10415566 | 10415566 | PRJNA1103784_P_NODE_5489_length_253_cov_1.711111_g5434_i0 | PRJNA1103784 | 5489 | 253 | 1.711111 | 4.32911083 | Beta vulgaris | 161934 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2518601700|ref|XM_048645242.2| | 3555 | g5434 | i0 | 100 | 0.458498023715415 | 29 | 0 | 11 | 0 | 10 | 38 | 1010 | 982 | PREDICTED: Beta vulgaris subsp. vulgaris hypothetical protein (LOC104892105), transcript variant X4, mRNA | blastn | 116 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Beta | Beta vulgaris | |
| 11690890 | 11690890 | PRJNA1103784_P_NODE_7950_length_237_cov_2.439024_g7895_i0 | PRJNA1103784 | 7950 | 237 | 2.439024 | 5.78048688 | Oryza sativa | 4530 | Plants | Plants | 294 | 3.2e-75 | NTclustered | gi|32993583|dbj|AK108374.1| | 39947 | g7895 | i0 | 92.647 | 8.47257383966245 | 204 | 15 | 86 | 0 | 31 | 234 | 838 | 635 | Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence | blastn | 2008 | 294 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 13773508 | 13773508 | PRJNA1103784_P_NODE_3311_length_303_cov_1.278261_g3256_i0 | PRJNA1103784 | 3311 | 303 | 1.278261 | 3.87313083 | Cupressaceae | 3367 | Plants | Plants | 560 | 3.79e-155 | NTclustered | gi|2059415815|gb|MW354310.1| | 3371 | g3256 | i0 | 100 | 99.8910891089109 | 303 | 0 | 100 | 0 | 1 | 303 | 18496 | 18798 | Metasequoia glyptostroboides 5S ribosomal RNA (rrn5) gene, complete sequence; mitochondrial | blastn | 30267 | 560 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Metasequoia | Metasequoia glyptostroboides | |
| 17597868 | 17597868 | PRJNA1103784_P_NODE_434_length_714_cov_4.513261_g381_i0 | PRJNA1103784 | 434 | 714 | 4.513261 | 32.22468354 | Eukaryota | 2759 | Plants | Plants | 1122 | 0 | NTclustered | gi|150172490|emb|CU406894.1| | 4529 | g381 | i0 | 95.098 | 4.98879551820728 | 714 | 31 | 99 | 3 | 1 | 712 | 732 | 21 | Oryza rufipogon (W1943) cDNA clone: ORW1943C111D01, full insert sequence | blastn | 3562 | 1127 | 0.995563442768412 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza rufipogon | |
| 18063818 | 18063818 | PRJNA1103784_P_NODE_3555_length_293_cov_1.740909_g3500_i0 | PRJNA1103784 | 3555 | 293 | 1.740909 | 5.10086337 | Oryza sativa | 4530 | Plants | Plants | 403 | 6.51e-108 | NTclustered | gi|32971027|dbj|AK061009.1| | 39947 | g3500 | i0 | 91.724 | 91.3959044368601 | 290 | 24 | 99 | 0 | 1 | 290 | 837 | 1126 | Oryza sativa Japonica Group cDNA clone:006-204-A10, full insert sequence | blastn | 26779 | 403 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 18063830 | 18063830 | PRJNA1103784_P_NODE_4395_length_274_cov_2.014925_g4340_i0 | PRJNA1103784 | 4395 | 274 | 2.014925 | 5.5208945 | Hordeum vulgare | 4513 | Plants | Plants | 431 | 2.769999999999999e-116 | NTclustered | gi|326524316|dbj|AK369340.1| | 112509 | g4340 | i0 | 96.198 | 86.2627737226277 | 263 | 10 | 96 | 0 | 1 | 263 | 301 | 39 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2089H12 | blastn | 23636 | 431 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 18871775 | 18871775 | PRJNA1103784_P_NODE_5175_length_259_cov_2.279570_g5120_i0 | PRJNA1103784 | 5175 | 259 | 2.27957 | 5.9040863 | Rosa | 3764 | Plants | Plants | 108 | 4.96e-19 | NTclustered | gi|2646229739|ref|XM_062139703.1| | 74645 | g5120 | i0 | 80.714 | 27.8571428571429 | 140 | 25 | 54 | 2 | 121 | 259 | 876 | 1014 | PREDICTED: Rosa rugosa heat shock protein 83 (LOC133713671), mRNA | blastn | 7215 | 108 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Rosa | Rosa rugosa | |
| 18871777 | 18871777 | PRJNA1103784_P_NODE_615_length_612_cov_2.549165_g561_i0 | PRJNA1103784 | 615 | 612 | 2.549165 | 15.6008898 | Poaceae | 4479 | Plants | Plants | 56.5 | 0.005 | NTclustered | gi|2649483048|ref|XM_062341975.1| | 29695 | g561 | i0 | 96.97 | 0.377450980392157 | 33 | 1 | 5 | 0 | 432 | 464 | 1512 | 1544 | PREDICTED: Phragmites australis la-related protein 6B-like (LOC133900745), transcript variant X2, mRNA | blastn | 231 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phragmites | Phragmites australis | |
| 21888918 | 21888918 | PRJNA1103784_P_NODE_3118_length_310_cov_1.839662_g3063_i0 | PRJNA1103784 | 3118 | 310 | 1.839662 | 5.7029522 | Oryza sativa | 4530 | Plants | Plants | 459 | 1.46e-124 | NTclustered | gi|32994295|dbj|AK109086.1| | 39947 | g3063 | i0 | 93.528 | 179.216129032258 | 309 | 18 | 99 | 2 | 1 | 308 | 1634 | 1941 | Oryza sativa Japonica Group cDNA clone:002-154-H10, full insert sequence | blastn | 55557 | 459 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 24438057 | 24438057 | PRJNA1103784_P_NODE_5880_length_250_cov_0.870056_g5825_i0 | PRJNA1103784 | 5880 | 250 | 0.870056 | 2.17514 | Cannabis sativa | 3483 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|2748541027|gb|CP158645.1| | 3483 | g5825 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 5 | 32 | 73695926 | 73695899 | Cannabis sativa cultivar ERBxHO40_23 chromosome 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa |
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);;