contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1120586" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1028305 | 1028305 | PRJNA1120586_P_NODE_11741_length_360_cov_2.189003_g11550_i0 | PRJNA1120586 | 11741 | 360 | 2.189003 | 7.8804108 | Eukaryota | 2759 | Plants | Plants | 665 | 0 | NTclustered | gi|194703753|gb|BT040956.1| | 4577 | g11550 | i0 | 100 | 85.7583333333333 | 360 | 0 | 100 | 0 | 1 | 360 | 1147 | 788 | Zea mays full-length cDNA clone ZM_BFc0156E02 mRNA, complete cds | blastn | 30873 | 665 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 2303811 | 2303811 | PRJNA1120586_P_NODE_53582_length_222_cov_2.562092_g53391_i0 | PRJNA1120586 | 53582 | 222 | 2.562092 | 5.68784424 | Eukaryota | 2759 | Plants | Plants | 409 | 1.0100000000000001e-109 | NTclustered | gi|8547146|gb|AF154646.1| | 4097 | g53391 | i0 | 100 | 2.98648648648649 | 221 | 0 | 99 | 0 | 1 | 221 | 959 | 1179 | Nicotiana tabacum clone PR30 mRNA sequence | blastn | 663 | 409 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana tabacum | |
| 2303836 | 2303836 | PRJNA1120586_P_NODE_7182_length_434_cov_3.438356_g6991_i0 | PRJNA1120586 | 7182 | 434 | 3.438356 | 14.92246504 | Eukaryota | 2759 | Plants | Plants | 719 | 0 | NTclustered | gi|194703753|gb|BT040956.1| | 4577 | g6991 | i0 | 100 | 89.5622119815668 | 389 | 0 | 90 | 0 | 46 | 434 | 334 | 722 | Zea mays full-length cDNA clone ZM_BFc0156E02 mRNA, complete cds | blastn | 38870 | 719 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 3578984 | 3578984 | PRJNA1120586_P_NODE_28683_length_264_cov_3.502564_g28492_i0 | PRJNA1120586 | 28683 | 264 | 3.502564 | 9.24676896 | Vicia | 3904 | Plants | Plants | 488 | 1.5499999999999999e-133 | NTclustered | gi|1878849250|gb|MT796586.1| | 3909 | g28492 | i0 | 100 | 100.003787878788 | 264 | 0 | 100 | 0 | 1 | 264 | 1214 | 1477 | Vicia sativa subsp. nigra isolate DM378 small subunit ribosomal RNA gene, 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 | 26401 | 488 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia sativa | |
| 5379412 | 5379412 | PRJNA1120586_P_NODE_44705_length_231_cov_1.777778_g44514_i0 | PRJNA1120586 | 44705 | 231 | 1.777778 | 4.10666718 | Hordeum vulgare | 4513 | Plants | Plants | 99 | 2.61e-16 | NTclustered | gi|2133614081|ref|XR_006610545.1| | 112509 | g44514 | i0 | 85 | 31.0909090909091 | 100 | 12 | 43 | 2 | 131 | 229 | 1781 | 1878 | PREDICTED: Hordeum vulgare subsp. vulgare 28S ribosomal RNA (LOC123400256), rRNA | blastn | 7182 | 99 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 7929259 | 7929259 | PRJNA1120586_P_NODE_50027_length_228_cov_0.905660_g49836_i0 | PRJNA1120586 | 50027 | 228 | 0.90566 | 2.0649048 | Oryza sativa | 4530 | Plants | Plants | 383 | 6.35e-102 | NTclustered | gi|32973086|dbj|AK063068.1| | 39947 | g49836 | i0 | 96.93 | 5.06140350877193 | 228 | 7 | 100 | 0 | 1 | 228 | 633 | 406 | Oryza sativa Japonica Group cDNA clone:001-110-G10, full insert sequence | blastn | 1154 | 383 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 10479577 | 10479577 | PRJNA1120586_P_NODE_26689_length_271_cov_1.425743_g26498_i0 | PRJNA1120586 | 26689 | 271 | 1.425743 | 3.86376353 | Oryza sativa | 4530 | Plants | Plants | 490 | 4.44e-134 | NTclustered | gi|32994234|dbj|AK109025.1| | 39947 | g26498 | i0 | 99.262 | 1 | 271 | 2 | 100 | 0 | 1 | 271 | 282 | 552 | Oryza sativa Japonica Group cDNA clone:002-154-B05, full insert sequence | blastn | 271 | 490 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 10479583 | 10479583 | PRJNA1120586_P_NODE_2689_length_644_cov_4.252174_g2506_i0 | PRJNA1120586 | 2689 | 644 | 4.252174 | 27.38400056 | Vicia sativa | 3908 | Plants | Plants | 1168 | 0 | NTclustered | gi|1878849250|gb|MT796586.1| | 3909 | g2506 | i0 | 99.379 | 100 | 644 | 4 | 100 | 0 | 1 | 644 | 5124 | 4481 | Vicia sativa subsp. nigra isolate DM378 small subunit ribosomal RNA gene, 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 | 64400 | 1168 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia sativa | |
| 11754930 | 11754930 | PRJNA1120586_P_NODE_51270_length_227_cov_0.911392_g51079_i0 | PRJNA1120586 | 51270 | 227 | 0.911392 | 2.06885984 | Cephalomitrion aterrimum | 1527703 | Plants | Plants | 119 | 1.97e-22 | NTclustered | gi|671724742|gb|KF851759.1| | 1527703 | g51079 | i0 | 91.765 | 37.5286343612335 | 85 | 7 | 37 | 0 | 15 | 99 | 321 | 237 | Cephalomitrion aterrimum isolate L1226 26S large subunit ribosomal RNA gene, partial sequence | blastn | 8519 | 119 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Jungermanniopsida | Jungermanniales | Cephaloziellaceae | Cephalomitrion | Cephalomitrion aterrimum | |
| 13029600 | 13029600 | PRJNA1120586_P_NODE_21051_length_294_cov_1.280000_g20860_i0 | PRJNA1120586 | 21051 | 294 | 1.28 | 3.7632 | Hordeum vulgare | 4513 | Plants | Plants | 532 | 7.989999999999998e-147 | NTclustered | gi|326497356|dbj|AK371065.1| | 112509 | g20860 | i0 | 99.32 | 1 | 294 | 2 | 100 | 0 | 1 | 294 | 21 | 314 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123O06 | blastn | 294 | 532 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 14305012 | 14305012 | PRJNA1120586_P_NODE_38512_length_238_cov_1.023669_g38321_i0 | PRJNA1120586 | 38512 | 238 | 1.023669 | 2.43633222 | Sorghum bicolor | 4558 | Plants | Plants | 58.4 | 4.59e-4 | NTclustered | gi|33321007|gb|AF488412.1| | 4558 | g38321 | i0 | 94.737 | 0.159663865546218 | 38 | 1 | 16 | 1 | 171 | 207 | 111881 | 111844 | Sorghum bicolor BAC 131L1, complete sequence | blastn | 38 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Sorghum | Sorghum bicolor | |
| 15578705 | 15578705 | PRJNA1120586_P_NODE_22613_length_287_cov_1.197248_g22422_i0 | PRJNA1120586 | 22613 | 287 | 1.197248 | 3.43610176 | Vicia sativa | 3908 | Plants | Plants | 525 | 1.2999999999999995e-144 | NTclustered | gi|2753188135|emb|OZ078051.1| | 3908 | g22422 | i0 | 100 | 99.8850174216028 | 284 | 0 | 99 | 0 | 1 | 284 | 87141 | 87424 | Vicia sativa genome assembly, organelle: plastid:chloroplast | blastn | 28667 | 525 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia sativa | |
| 15579276 | 15579276 | PRJNA1120586_P_NODE_52913_length_226_cov_0.917197_g52722_i0 | PRJNA1120586 | 52913 | 226 | 0.917197 | 2.07286522 | Sorghum bicolor | 4558 | Plants | Plants | 357 | 3.81e-94 | NTclustered | gi|1205936758|ref|XM_002463060.2| | 4558 | g52722 | i0 | 95.133 | 38.4867256637168 | 226 | 11 | 100 | 0 | 1 | 226 | 1511 | 1286 | PREDICTED: Sorghum bicolor arabinosyltransferase RRA3 (LOC8078975), mRNA | blastn | 8698 | 357 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Sorghum | Sorghum bicolor | |
| 17605990 | 17605990 | PRJNA1120586_P_NODE_14914_length_330_cov_2.758621_g14723_i0 | PRJNA1120586 | 14914 | 330 | 2.758621 | 9.1034493 | Eukaryota | 2759 | Plants | Plants | 610 | 4.09e-170 | NTclustered | gi|194703603|gb|BT040881.1| | 4577 | g14723 | i0 | 100 | 99.9606060606061 | 330 | 0 | 100 | 0 | 1 | 330 | 203 | 532 | Zea mays full-length cDNA clone ZM_BFc0144J03 mRNA, complete cds | blastn | 32987 | 610 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 17606049 | 17606049 | PRJNA1120586_P_NODE_27054_length_270_cov_1.293532_g26863_i0 | PRJNA1120586 | 27054 | 270 | 1.293532 | 3.4925364 | Eukaryota | 2759 | Plants | Plants | 499 | 7.349999999999998e-137 | NTclustered | gi|194707657|gb|BT042908.1| | 4577 | g26863 | i0 | 100 | 53.9222222222222 | 270 | 0 | 100 | 0 | 1 | 270 | 1460 | 1729 | Zea mays full-length cDNA clone ZM_BFc0062L18 mRNA, complete cds | blastn | 14559 | 499 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 20154890 | 20154890 | PRJNA1120586_P_NODE_8976_length_398_cov_3.176292_g8785_i0 | PRJNA1120586 | 8976 | 398 | 3.176292 | 12.64164216 | Eukaryota | 2759 | Plants | Plants | 736 | 0 | NTclustered | gi|194707657|gb|BT042908.1| | 4577 | g8785 | i0 | 100 | 98.8542713567839 | 398 | 0 | 100 | 0 | 1 | 398 | 311 | 708 | Zea mays full-length cDNA clone ZM_BFc0062L18 mRNA, complete cds | blastn | 39344 | 736 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 21430337 | 21430337 | PRJNA1120586_P_NODE_28237_length_266_cov_1.426396_g28046_i0 | PRJNA1120586 | 28237 | 266 | 1.426396 | 3.79421336 | Juglandaceae | 16714 | Plants | Plants | 486 | 5.629999999999999e-133 | NTclustered | gi|2082500535|ref|XR_006239152.1| | 32201 | g28046 | i0 | 99.624 | 100 | 266 | 1 | 100 | 0 | 1 | 266 | 375 | 110 | PREDICTED: Carya illinoinensis 18S ribosomal RNA (LOC122298097), rRNA | blastn | 26600 | 486 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Juglandaceae | Carya | Carya illinoinensis | |
| 21953138 | 21953138 | PRJNA1120586_P_NODE_48678_length_229_cov_0.900000_g48487_i0 | PRJNA1120586 | 48678 | 229 | 0.9 | 2.061 | Zea mays | 4577 | Plants | Plants | 403 | 4.899999999999998e-108 | NTclustered | gi|55741096|gb|AY664419.1| | 4577 | g48487 | i0 | 99.107 | 232.56768558952 | 224 | 2 | 98 | 0 | 1 | 224 | 309357 | 309580 | Zea mays cultivar Mo17 locus 9009, complete sequence | blastn | 53258 | 403 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 22705362 | 22705362 | PRJNA1120586_P_NODE_45858_length_231_cov_0.888889_g45667_i0 | PRJNA1120586 | 45858 | 231 | 0.888889 | 2.05333359 | Caprifoliaceae | 4200 | Plants | Plants | 416 | 6.349999999999998e-112 | NTclustered | gi|2258688133|ref|NC_064333.1| | 134526 | g45667 | i0 | 99.134 | 7.06060606060606 | 231 | 2 | 100 | 0 | 1 | 231 | 276652 | 276422 | Triosteum pinnatifidum mitochondrion, complete genome | blastn | 1631 | 416 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Dipsacales | Caprifoliaceae | Triosteum | Triosteum pinnatifidum | |
| 23228325 | 23228325 | PRJNA1120586_P_NODE_31879_length_255_cov_1.548387_g31688_i0 | PRJNA1120586 | 31879 | 255 | 1.548387 | 3.94838685 | Impatiens glandulifera | 253017 | Plants | Plants | 235 | 2.1399999999999997e-57 | NTclustered | gi|2217250433|ref|XM_047452740.1| | 253017 | g31688 | i0 | 84.146 | 111.945098039216 | 246 | 36 | 96 | 3 | 3 | 247 | 345 | 102 | PREDICTED: Impatiens glandulifera ubiquitin-40S ribosomal protein S27a-like (LOC124912179), mRNA | blastn | 28546 | 235 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Balsaminaceae | Impatiens | Impatiens glandulifera | |
| 23980607 | 23980607 | PRJNA1120586_P_NODE_18219_length_309_cov_1.404167_g18028_i0 | PRJNA1120586 | 18219 | 309 | 1.404167 | 4.33887603 | Magnoliopsida | 3398 | Plants | Plants | 571 | 1.7899999999999995e-158 | NTclustered | gi|1381390543|ref|NC_037463.1| | 2711 | g18028 | i0 | 100 | 108.171521035599 | 309 | 0 | 100 | 0 | 1 | 309 | 38577 | 38885 | Citrus sinensis mitochondrion, complete genome | blastn | 33425 | 571 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 24502291 | 24502291 | PRJNA1120586_P_NODE_49740_length_228_cov_0.905660_g49549_i0 | PRJNA1120586 | 49740 | 228 | 0.90566 | 2.0649048 | Oryza sativa | 4530 | Plants | Plants | 394 | 2.93e-105 | NTclustered | gi|37989458|dbj|AK119835.1| | 39947 | g49549 | i0 | 97.807 | 1 | 228 | 5 | 100 | 0 | 1 | 228 | 1823 | 1596 | Oryza sativa Japonica Group cDNA clone:002-178-A12, full insert sequence | blastn | 228 | 394 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 25254676 | 25254676 | PRJNA1120586_P_NODE_22700_length_286_cov_2.138249_g22509_i0 | PRJNA1120586 | 22700 | 286 | 2.138249 | 6.11539214 | Eukaryota | 2759 | Plants | Plants | 518 | 2.17e-142 | NTclustered | gi|1702291457|gb|MN174867.1| | 82485 | g22509 | i0 | 99.301 | 107.045454545455 | 286 | 2 | 100 | 0 | 1 | 286 | 4013 | 4298 | 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 | 30615 | 523 | 0.990439770554493 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Liliales | Melanthiaceae | Trillium | Trillium govanianum |
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);;