contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA672101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3192688 | 3192688 | PRJNA672101_S_NODE_16343_length_304_cov_1.246753_g16312_i0 | PRJNA672101 | 16343 | 304 | 1.246753 | 3.79012912 | Picea abies | 3329 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|2835530376|dbj|LC777199.1| | 3329 | g16312 | i0 | 100 | 0.1875 | 29 | 0 | 10 | 0 | 276 | 304 | 405 | 377 | Picea abies Pa-Kumamoto-2022 PaDdl mRNA for D-alanine-D-alanine ligase, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 3193025 | 3193025 | PRJNA672101_S_NODE_7343_length_374_cov_3.930233_g7312_i0 | PRJNA672101 | 7343 | 374 | 3.930233 | 14.69907142 | Oryza sativa | 4530 | Plants | Plants | 656 | 0 | NTclustered | gi|37989591|dbj|AK119968.1| | 39947 | g7312 | i0 | 99.176 | 7.3048128342246 | 364 | 3 | 97 | 0 | 1 | 364 | 347 | 710 | Oryza sativa Japonica Group cDNA clone:002-184-D12, full insert sequence | blastn | 2732 | 656 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 4470077 | 4470077 | PRJNA672101_S_NODE_9764_length_350_cov_3.465704_g9733_i0 | PRJNA672101 | 9764 | 350 | 3.465704 | 12.129964 | Hordeum vulgare | 4513 | Plants | Plants | 643 | 4.2899999999999986e-180 | NTclustered | gi|151420338|dbj|AK251690.1| | 112509 | g9733 | i0 | 100 | 2.27428571428571 | 348 | 0 | 99 | 0 | 3 | 350 | 1544 | 1197 | Hordeum vulgare subsp. vulgare cDNA clone: FLbaf127c16, mRNA sequence | blastn | 796 | 643 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 5745328 | 5745328 | PRJNA672101_S_NODE_18925_length_290_cov_9.253456_g18894_i0 | PRJNA672101 | 18925 | 290 | 9.253456 | 26.8350224 | Cannabis sativa | 3483 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|2748541476|gb|CP158647.1| | 3483 | g18894 | i0 | 100 | 0.096551724137931 | 28 | 0 | 10 | 0 | 175 | 202 | 69990875 | 69990848 | Cannabis sativa cultivar ERBxHO40_23 chromosome 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 7020621 | 7020621 | PRJNA672101_S_NODE_30606_length_246_cov_7.884393_g30575_i0 | PRJNA672101 | 30606 | 246 | 7.884393 | 19.39560678 | Picea abies | 3329 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g30575 | i0 | 96.97 | 0.247967479674797 | 33 | 1 | 13 | 0 | 214 | 246 | 61 | 29 | Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds | blastn | 61 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 7020622 | 7020622 | PRJNA672101_S_NODE_30626_length_246_cov_4.167630_g30595_i0 | PRJNA672101 | 30626 | 246 | 4.16763 | 10.2523698 | Conocephalum japonicum | 134427 | Plants | Plants | 84.2 | 7.88e-12 | NTclustered | gi|60543033|dbj|AB185035.1| | 134427 | g30595 | i0 | 100 | 4.86991869918699 | 45 | 0 | 18 | 0 | 1 | 45 | 428 | 472 | Conocephalum japonicum H3 gene for histone 3, complete cds, clone: CS15 | blastn | 1198 | 84.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Conocephalaceae | Conocephalum | Conocephalum japonicum | |
| 10094166 | 10094166 | PRJNA672101_S_NODE_27508_length_254_cov_4.392265_g27477_i0 | PRJNA672101 | 27508 | 254 | 4.392265 | 11.1563531 | Brassicaceae | 3700 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|2258322714|ref|XM_013851268.3| | 3708 | g27477 | i0 | 100 | 0.551181102362205 | 28 | 0 | 11 | 0 | 17 | 44 | 3694 | 3721 | PREDICTED: Brassica napus autophagy-related protein 11-like (LOC106410705), mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 10845792 | 10845792 | PRJNA672101_S_NODE_11089_length_339_cov_2.605263_g11058_i0 | PRJNA672101 | 11089 | 339 | 2.605263 | 8.83184157 | Quercus lobata | 97700 | Plants | Plants | 577 | 4.2699999999999996e-160 | NTclustered | gi|1757522763|ref|XM_031085268.1| | 97700 | g11058 | i0 | 97.345 | 35.1592920353982 | 339 | 9 | 100 | 0 | 1 | 339 | 93 | 431 | PREDICTED: Quercus lobata stress-induced protein KIN2-like (LOC115965948), mRNA | blastn | 11919 | 577 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus lobata | |
| 12644817 | 12644817 | PRJNA672101_S_NODE_20190_length_284_cov_4.601896_g20159_i0 | PRJNA672101 | 20190 | 284 | 4.601896 | 13.069384640000001 | Bryum | 37412 | Plants | Plants | 520 | 5.98e-143 | NTclustered | gi|109139846|gb|DQ641451.1| | 37413 | g20159 | i0 | 99.648 | 98.669014084507 | 284 | 1 | 100 | 0 | 1 | 284 | 296 | 13 | Bryum argenteum large subunit ribosomal RNA gene, partial sequence | blastn | 28022 | 520 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Bryales | Bryaceae | Bryum | Bryum argenteum | |
| 13395873 | 13395873 | PRJNA672101_S_NODE_16231_length_304_cov_4.541126_g16200_i0 | PRJNA672101 | 16231 | 304 | 4.541126 | 13.80502304 | Calluna vulgaris | 13385 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917566876|emb|OZ228610.1| | 13385 | g16200 | i0 | 97.059 | 0.664473684210526 | 34 | 0 | 11 | 1 | 138 | 170 | 49713368 | 49713335 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 202 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 13919478 | 13919478 | PRJNA672101_S_NODE_26291_length_259_cov_1.655914_g26260_i0 | PRJNA672101 | 26291 | 259 | 1.655914 | 4.28881726 | Actinidia | 3624 | Plants | Plants | 462 | 9.2e-126 | NTclustered | gi|2090193738|gb|OK036795.1| | 165200 | g26260 | i0 | 100 | 97.1312741312741 | 250 | 0 | 97 | 0 | 10 | 259 | 629 | 380 | Actinidia eriantha isolate WY-1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 25157 | 462 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Actinidiaceae | Actinidia | Actinidia eriantha | |
| 17220082 | 17220082 | PRJNA672101_S_NODE_33094_length_241_cov_6.315476_g33063_i0 | PRJNA672101 | 33094 | 241 | 6.315476 | 15.22029716 | Hordeum vulgare | 4513 | Plants | Plants | 363 | 8.819999999999997e-96 | NTclustered | gi|326496930|dbj|AK367289.1| | 112509 | g33063 | i0 | 94.468 | 47.0373443983403 | 235 | 13 | 98 | 0 | 1 | 235 | 881 | 1115 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2054B13 | blastn | 11336 | 363 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 19017227 | 19017227 | PRJNA672101_S_NODE_26575_length_258_cov_1.605405_g26544_i0 | PRJNA672101 | 26575 | 258 | 1.605405 | 4.1419449 | Eukaryota | 2759 | Plants | Plants | 477 | 3.2699999999999985e-130 | NTclustered | gi|194707657|gb|BT042908.1| | 4577 | g26544 | i0 | 100 | 32.5426356589147 | 258 | 0 | 100 | 0 | 1 | 258 | 1417 | 1674 | Zea mays full-length cDNA clone ZM_BFc0062L18 mRNA, complete cds | blastn | 8396 | 477 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 21044598 | 21044598 | PRJNA672101_S_NODE_4557_length_416_cov_5.851312_g4526_i0 | PRJNA672101 | 4557 | 416 | 5.851312 | 24.34145792 | Solanum lycopersicum | 4081 | Plants | Plants | 52.8 | 0.04 | NTclustered | gi|331640153|gb|AC244586.1| | 4081 | g4526 | i0 | 100 | 0.0673076923076923 | 28 | 0 | 7 | 0 | 112 | 139 | 9819 | 9846 | Solanum lycopersicum strain Heinz 1706 chromosome 10 clone hba-38l10 map 10, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 22319155 | 22319155 | PRJNA672101_S_NODE_18478_length_292_cov_5.557078_g18447_i0 | PRJNA672101 | 18478 | 292 | 5.557078 | 16.22666776 | Nelumbo nucifera | 4432 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|1102763362|ref|XM_019197723.1| | 4432 | g18447 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 33 | 60 | 759 | 786 | PREDICTED: Nelumbo nucifera transcription factor LAX PANICLE-like (LOC109114696), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Nelumbonaceae | Nelumbo | Nelumbo nucifera | |
| 22319412 | 22319412 | PRJNA672101_S_NODE_5198_length_404_cov_2.432024_g5167_i0 | PRJNA672101 | 5198 | 404 | 2.432024 | 9.82537696 | Nicotiana benthamiana | 4100 | Plants | Plants | 135 | 3.7400000000000006e-27 | NTclustered | gi|576528492|emb|HF675000.1| | 4100 | g5167 | i0 | 85.385 | 25.8613861386139 | 130 | 19 | 32 | 0 | 257 | 386 | 4192 | 4321 | Nicotiana benthamiana gfp gene for green fluorescent protein and pat gene for phosphinothricin acetyltransferase | blastn | 10448 | 135 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana benthamiana | |
| 22842976 | 22842976 | PRJNA672101_S_NODE_33098_length_241_cov_5.815476_g33067_i0 | PRJNA672101 | 33098 | 241 | 5.815476 | 14.01529716 | Oryza | 4527 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|9186821|gb|AC016780.6| | 4530 | g33067 | i0 | 100 | 0.464730290456432 | 28 | 0 | 12 | 0 | 28 | 55 | 84770 | 84797 | Genomic Sequence For Oryza sativa (japonica cultivar-group) cultivar Nipponbare Clone OSJNBa0061K21 From Chromosome 10, complete sequence | blastn | 112 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 23594581 | 23594581 | PRJNA672101_S_NODE_11199_length_338_cov_3.596226_g11168_i0 | PRJNA672101 | 11199 | 338 | 3.596226 | 12.15524388 | Gossypium hirsutum | 3635 | Plants | Plants | 54.7 | 0.009 | NTclustered | gi|2029703940|ref|XM_041100755.1| | 3635 | g11168 | i0 | 94.286 | 0.103550295857988 | 35 | 2 | 10 | 0 | 156 | 190 | 203 | 237 | PREDICTED: Gossypium hirsutum ABC transporter G family member 22 (LOC107891207), transcript variant X2, mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium hirsutum | |
| 23594834 | 23594834 | PRJNA672101_S_NODE_28299_length_251_cov_4.533708_g28268_i0 | PRJNA672101 | 28299 | 251 | 4.533708 | 11.37960708 | Triticum dicoccoides | 85692 | Plants | Plants | 106 | 1.72e-18 | NTclustered | gi|1931559860|ref|XM_037590031.1| | 85692 | g28268 | i0 | 93.056 | 37.1872509960159 | 72 | 5 | 29 | 0 | 173 | 244 | 619 | 548 | PREDICTED: Triticum dicoccoides polyubiquitin-like (LOC119315405), mRNA | blastn | 9334 | 106 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum dicoccoides | |
| 24117393 | 24117393 | PRJNA672101_S_NODE_12419_length_329_cov_3.277344_g12388_i0 | PRJNA672101 | 12419 | 329 | 3.277344 | 10.78246176 | Poaceae | 4479 | Plants | Plants | 584 | 2.469999999999999e-162 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g12388 | i0 | 100 | 190.936170212766 | 316 | 0 | 96 | 0 | 14 | 329 | 96780 | 96465 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 62818 | 584 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 24117398 | 24117398 | PRJNA672101_S_NODE_18099_length_294_cov_2.787330_g18068_i0 | PRJNA672101 | 18099 | 294 | 2.78733 | 8.1947502 | Aralia | 13340 | Plants | Plants | 544 | 3.69e-150 | NTclustered | gi|2865139569|gb|PQ516462.1| | 45209 | g18068 | i0 | 100 | 100.071428571429 | 294 | 0 | 100 | 0 | 1 | 294 | 2466 | 2173 | Aralia spinifolia isolate XZ30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 29421 | 544 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Araliaceae | Aralia | Aralia spinifolia | |
| 24117420 | 24117420 | PRJNA672101_S_NODE_32839_length_242_cov_1.094675_g32808_i0 | PRJNA672101 | 32839 | 242 | 1.094675 | 2.6491135 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2835530376|dbj|LC777199.1| | 3329 | g32808 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 215 | 242 | 404 | 377 | Picea abies Pa-Kumamoto-2022 PaDdl mRNA for D-alanine-D-alanine ligase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies |
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);;