contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA664479" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1162226 | 1162226 | PRJNA664479_S_NODE_16341_length_164_cov_1.156522_g16265_i0 | PRJNA664479 | 16341 | 164 | 1.156522 | 1.89669608 | Setaria | 4554 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|1256417653|ref|XM_004960968.3| | 4555 | g16265 | i0 | 100 | 0.341463414634146 | 28 | 0 | 17 | 0 | 126 | 153 | 125 | 98 | PREDICTED: Setaria italica cytokinin riboside 5'-monophosphate phosphoribohydrolase LOG-like (LOC101766458), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Setaria | Setaria italica | |
| 1905265 | 1905265 | PRJNA664479_S_NODE_18922_length_161_cov_0.910714_g18846_i0 | PRJNA664479 | 18922 | 161 | 0.910714 | 1.46624954 | Solanum lycopersicum | 4081 | Plants | Plants | 298 | 1.56e-76 | NTclustered | gi|392841230|gb|AC246645.7| | 4081 | g18846 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 53246 | 53406 | Solanum lycopersicum strain Heinz 1706 chromosome 1 clone slm-49l1 map 1, complete sequence | blastn | 161 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 4457069 | 4457069 | PRJNA664479_S_NODE_12264_length_175_cov_4.230159_g12188_i0 | PRJNA664479 | 12264 | 175 | 4.230159 | 7.40277825 | Lupinus angustifolius | 3871 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|1117456837|ref|XR_002105945.1| | 3871 | g12188 | i0 | 96.774 | 0.885714285714286 | 31 | 1 | 18 | 0 | 138 | 168 | 1088 | 1118 | PREDICTED: Lupinus angustifolius acidic leucine-rich nuclear phosphoprotein 32-related protein-like (LOC109332806), transcript variant X4, misc_RNA | blastn | 155 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus angustifolius | |
| 4457075 | 4457075 | PRJNA664479_S_NODE_17144_length_163_cov_0.894737_g17068_i0 | PRJNA664479 | 17144 | 163 | 0.894737 | 1.45842131 | Fagopyrum esculentum | 3617 | Plants | Plants | 147 | 6.0599999999999996e-31 | NTclustered | gi|270272190|gb|GU130001.1| | 3617 | g17068 | i0 | 82.822 | 10.3312883435583 | 163 | 28 | 100 | 0 | 1 | 163 | 20 | 182 | Fagopyrum esculentum legumin-like protein mRNA, partial cds | blastn | 1684 | 147 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Polygonaceae | Fagopyrum | Fagopyrum esculentum | |
| 5732612 | 5732612 | PRJNA664479_S_NODE_14565_length_167_cov_0.864407_g14489_i0 | PRJNA664479 | 14565 | 167 | 0.864407 | 1.44355969 | Pinus taeda | 3352 | Plants | Plants | 215 | 1.69e-51 | NTclustered | gi|297747464|gb|AC241351.1| | 3352 | g14489 | i0 | 89.881 | 1.0059880239521 | 168 | 15 | 100 | 2 | 1 | 167 | 120331 | 120165 | Pinus taeda clone PT_7Ba4290D18, complete sequence | blastn | 168 | 215 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus taeda | |
| 7007783 | 7007783 | PRJNA664479_S_NODE_17926_length_162_cov_0.902655_g17850_i0 | PRJNA664479 | 17926 | 162 | 0.902655 | 1.4623011 | Triticum aestivum | 4565 | Plants | Plants | 267 | 4.419999999999999e-67 | NTclustered | gi|1282798539|gb|MG560142.1| | 4565 | g17850 | i0 | 96.296 | 5 | 162 | 6 | 100 | 0 | 1 | 162 | 631607 | 631768 | Triticum aestivum omega gliadin-D1, omega gliadin-D2, omega gliadin-D3, gamma gliadin-D1, delta gliadin-D1, gamma gliadin-D2, gamma gliadin-D3, gamma gliadin-D4, LMW-D1, LMW-D2, LMW-D3, LMW-D6, and LMW-D7 genes, complete cds | blastn | 810 | 267 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 7007786 | 7007786 | PRJNA664479_S_NODE_2606_length_307_cov_12.310078_g2530_i0 | PRJNA664479 | 2606 | 307 | 12.310078 | 37.79193946 | Calluna vulgaris | 13385 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917566876|emb|OZ228610.1| | 13385 | g2530 | i0 | 97.059 | 0.657980456026059 | 34 | 0 | 11 | 1 | 133 | 165 | 49713335 | 49713368 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 202 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 7007788 | 7007788 | PRJNA664479_S_NODE_3326_length_279_cov_2.586957_g3250_i0 | PRJNA664479 | 3326 | 279 | 2.586957 | 7.21761003 | Cephalomitrion aterrimum | 1527703 | Plants | Plants | 119 | 2.5000000000000002e-22 | NTclustered | gi|671724742|gb|KF851759.1| | 1527703 | g3250 | i0 | 91.765 | 44.2508960573477 | 85 | 7 | 43 | 0 | 129 | 213 | 237 | 321 | Cephalomitrion aterrimum isolate L1226 26S large subunit ribosomal RNA gene, partial sequence | blastn | 12346 | 119 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Jungermanniopsida | Jungermanniales | Cephaloziellaceae | Cephalomitrion | Cephalomitrion aterrimum | |
| 7007795 | 7007795 | PRJNA664479_S_NODE_9846_length_189_cov_1.092857_g9770_i0 | PRJNA664479 | 9846 | 189 | 1.092857 | 2.06549973 | Ipomoea nil | 35883 | Plants | Plants | 58.4 | 3.49e-4 | NTclustered | gi|1109197592|ref|XM_019294223.1| | 35883 | g9770 | i0 | 90.909 | 0.412698412698413 | 44 | 3 | 23 | 1 | 55 | 97 | 127 | 170 | PREDICTED: Ipomoea nil putative glycine-rich cell wall structural protein 1 (LOC109146556), mRNA | blastn | 78 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea nil | |
| 8282370 | 8282370 | PRJNA664479_S_NODE_13467_length_170_cov_1.264463_g13391_i0 | PRJNA664479 | 13467 | 170 | 1.264463 | 2.1495871 | Brassica oleracea | 3712 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|1516555473|emb|LR031873.1| | 3712 | g13391 | i0 | 100 | 0.164705882352941 | 28 | 0 | 16 | 0 | 73 | 100 | 33301957 | 33301984 | Brassica oleracea HDEM genome, scaffold: C4 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica oleracea | |
| 8282376 | 8282376 | PRJNA664479_S_NODE_17267_length_163_cov_0.894737_g17191_i0 | PRJNA664479 | 17267 | 163 | 0.894737 | 1.45842131 | Cucumis melo | 3656 | Plants | Plants | 86.1 | 1.34e-12 | NTclustered | gi|733591281|emb|LN681806.1| | 3656 | g17191 | i0 | 97.959 | 1.53374233128834 | 49 | 1 | 57 | 0 | 59 | 107 | 2883797 | 2883749 | Cucumis melo genomic scaffold, anchoredscaffold00025 | blastn | 250 | 86.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 8282377 | 8282377 | PRJNA664479_S_NODE_17527_length_163_cov_0.894737_g17451_i0 | PRJNA664479 | 17527 | 163 | 0.894737 | 1.45842131 | Ipomoea triloba | 35885 | Plants | Plants | 132 | 1.7e-26 | NTclustered | gi|1766814296|ref|XM_031255134.1| | 35885 | g17451 | i0 | 81.875 | 25.0245398773006 | 160 | 25 | 97 | 4 | 5 | 162 | 295 | 452 | PREDICTED: Ipomoea triloba 60S ribosomal protein L23-like (LOC116015121), mRNA | blastn | 4079 | 132 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea triloba | |
| 10833267 | 10833267 | PRJNA664479_S_NODE_11749_length_178_cov_1.581395_g11673_i0 | PRJNA664479 | 11749 | 178 | 1.581395 | 2.8148831 | Rutidosis leptorrhynchoides | 125765 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|2922576363|ref|XM_071879525.1| | 125765 | g11673 | i0 | 100 | 0.471910112359551 | 28 | 0 | 16 | 0 | 91 | 118 | 1327 | 1300 | PREDICTED: Rutidosis leptorrhynchoides uncharacterized protein (LOC139896878), transcript variant X1, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Rutidosis | Rutidosis leptorrhynchoides | |
| 10833269 | 10833269 | PRJNA664479_S_NODE_13029_length_172_cov_1.235772_g12953_i0 | PRJNA664479 | 13029 | 172 | 1.235772 | 2.12552784 | Cucumis sativus | 3659 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|1784882558|ref|XM_004143577.3| | 3659 | g12953 | i0 | 100 | 0.168604651162791 | 29 | 0 | 17 | 0 | 88 | 116 | 478 | 450 | PREDICTED: Cucumis sativus BAG family molecular chaperone regulator 2 (LOC101207502), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis sativus | |
| 12108492 | 12108492 | PRJNA664479_S_NODE_5250_length_233_cov_2.342391_g5174_i0 | PRJNA664479 | 5250 | 233 | 2.342391 | 5.45777103 | Ribes rubrum | 175228 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|2918370030|emb|OZ237958.1| | 175228 | g5174 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 184 | 211 | 66157878 | 66157851 | Ribes rubrum genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Saxifragales | Grossulariaceae | Ribes | Ribes rubrum | |
| 17207200 | 17207200 | PRJNA664479_S_NODE_1054_length_461_cov_2.868932_g978_i0 | PRJNA664479 | 1054 | 461 | 2.868932 | 13.22577652 | Oryza sativa | 4530 | Plants | Plants | 52.8 | 0.045 | NTclustered | gi|2668294540|dbj|AP027395.1| | 1771142 | g978 | i0 | 100 | 0.0607375271149675 | 28 | 0 | 6 | 0 | 63 | 90 | 21488206 | 21488179 | Oryza sativa indica subgroup Inn Ma Yebaw DNA, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 18481550 | 18481550 | PRJNA664479_S_NODE_10035_length_188_cov_0.863309_g9959_i0 | PRJNA664479 | 10035 | 188 | 0.863309 | 1.62302092 | Impatiens glandulifera | 253017 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|2217228804|ref|XM_047478146.1| | 253017 | g9959 | i0 | 94.286 | 0.186170212765957 | 35 | 1 | 18 | 1 | 139 | 172 | 362 | 328 | PREDICTED: Impatiens glandulifera LOB domain-containing protein 14-like (LOC124937816), mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Balsaminaceae | Impatiens | Impatiens glandulifera | |
| 18481560 | 18481560 | PRJNA664479_S_NODE_2155_length_336_cov_0.986063_g2079_i0 | PRJNA664479 | 2155 | 336 | 0.986063 | 3.31317168 | Typha angustifolia | 59011 | Plants | Plants | 604 | 1.9399999999999992e-168 | NTclustered | gi|61741968|gb|AY952385.1| | 59011 | g2079 | i0 | 99.107 | 100.002976190476 | 336 | 3 | 100 | 0 | 1 | 336 | 1118 | 783 | Typha angustifolia 18S ribosomal RNA gene, partial sequence | blastn | 33601 | 604 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Typhaceae | Typha | Typha angustifolia | |
| 18481562 | 18481562 | PRJNA664479_S_NODE_355_length_752_cov_2.384068_g298_i0 | PRJNA664479 | 355 | 752 | 2.384068 | 17.92819136 | Calluna vulgaris | 13385 | Plants | Plants | 54.7 | 0.021 | NTclustered | gi|2917531254|emb|OZ224585.1| | 13385 | g298 | i0 | 100 | 0.038563829787234 | 29 | 0 | 4 | 0 | 372 | 400 | 46849746 | 46849774 | Calluna vulgaris genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 21031697 | 21031697 | PRJNA664479_S_NODE_5897_length_224_cov_0.868571_g5821_i0 | PRJNA664479 | 5897 | 224 | 0.868571 | 1.94559904 | Calluna vulgaris | 13385 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2917535065|emb|OZ224586.1| | 13385 | g5821 | i0 | 100 | 0.129464285714286 | 29 | 0 | 13 | 0 | 91 | 119 | 44949631 | 44949603 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 21031698 | 21031698 | PRJNA664479_S_NODE_8697_length_197_cov_0.810811_g8621_i0 | PRJNA664479 | 8697 | 197 | 0.810811 | 1.59729767 | Aristolochia californica | 171875 | Plants | Plants | 104 | 4.64e-18 | NTclustered | gi|2811324983|ref|XM_068793660.1| | 171875 | g8621 | i0 | 82.759 | 0.588832487309645 | 116 | 20 | 59 | 0 | 2 | 117 | 1411 | 1296 | PREDICTED: Aristolochia californica polyubiquitin (LOC137947850), mRNA | blastn | 116 | 104 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Piperales | Aristolochiaceae | Aristolochia | Aristolochia californica | |
| 22306454 | 22306454 | PRJNA664479_S_NODE_12378_length_175_cov_1.214286_g12302_i0 | PRJNA664479 | 12378 | 175 | 1.214286 | 2.1250005 | Phyllostachys edulis | 38705 | Plants | Plants | 324 | 2.83e-84 | NTclustered | gi|242388190|emb|FP094850.1| | 38705 | g12302 | i0 | 100 | 1 | 175 | 0 | 100 | 0 | 1 | 175 | 1013 | 839 | Phyllostachys edulis cDNA clone: bphyem103d09, full insert sequence | blastn | 175 | 324 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis | |
| 22306456 | 22306456 | PRJNA664479_S_NODE_14458_length_167_cov_0.864407_g14382_i0 | PRJNA664479 | 14458 | 167 | 0.864407 | 1.44355969 | Benincasa hispida | 102211 | Plants | Plants | 89.8 | 1.07e-13 | NTclustered | gi|1955864069|ref|XM_039034032.1| | 102211 | g14382 | i0 | 90 | 0.419161676646707 | 70 | 6 | 42 | 1 | 84 | 153 | 1512 | 1444 | PREDICTED: Benincasa hispida uncharacterized LOC120079705 (LOC120079705), mRNA | blastn | 70 | 89.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Benincasa | Benincasa hispida | |
| 24114210 | 24114210 | PRJNA664479_S_NODE_17039_length_163_cov_1.350877_g16963_i0 | PRJNA664479 | 17039 | 163 | 1.350877 | 2.20192951 | Eukaryota | 2759 | Plants | Plants | 71.3 | 3.75e-8 | NTclustered | gi|2649115748|ref|XM_062315601.1| | 3517 | g16963 | i0 | 93.617 | 7.24539877300614 | 47 | 3 | 29 | 0 | 116 | 162 | 768 | 814 | PREDICTED: Alnus glutinosa ADP,ATP carrier protein, mitochondrial (LOC133877335), mRNA | blastn | 1181 | 71.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Alnus | Alnus glutinosa | |
| 24855411 | 24855411 | PRJNA664479_S_NODE_7280_length_208_cov_1.264151_g7204_i0 | PRJNA664479 | 7280 | 208 | 1.264151 | 2.62943408 | Spinacia oleracea | 3562 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|2514611079|ref|XM_056839726.1| | 3562 | g7204 | i0 | 96.97 | 0.158653846153846 | 33 | 0 | 15 | 1 | 95 | 126 | 835 | 803 | PREDICTED: Spinacia oleracea uncharacterized LOC130470126 (LOC130470126), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea |
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);;