contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA415636" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419108 | 419108 | PRJNA415636_S_NODE_3961_length_250_cov_1.256158_g3914_i0 | PRJNA415636 | 3961 | 250 | 1.256158 | 3.140395 | Oryza sativa | 4530 | Plants | Plants | 377 | 3.29e-100 | NTclustered | gi|347661380|gb|BT131733.1| | 39947 | g3914 | i0 | 93.976 | 0.996 | 249 | 15 | 99 | 0 | 1 | 249 | 275 | 523 | Oryza sativa clone RRlibD00354 mRNA sequence | blastn | 249 | 377 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 1693936 | 1693936 | PRJNA415636_S_NODE_2202_length_312_cov_6.000000_g2155_i0 | PRJNA415636 | 2202 | 312 | 6 | 18.72 | Calluna vulgaris | 13385 | Plants | Plants | 58.4 | 6.27e-4 | NTclustered | gi|2917555290|emb|OZ228607.1| | 13385 | g2155 | i0 | 94.595 | 1.06089743589744 | 37 | 2 | 12 | 0 | 32 | 68 | 61123213 | 61123249 | Calluna vulgaris genome assembly, chromosome: 4 | blastn | 331 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 8072406 | 8072406 | PRJNA415636_S_NODE_2467_length_299_cov_1.821429_g2420_i0 | PRJNA415636 | 2467 | 299 | 1.821429 | 5.44607271 | Oryza sativa | 4530 | Plants | Plants | 364 | 3.1399999999999986e-96 | NTclustered | gi|32994248|dbj|AK109039.1| | 39947 | g2420 | i0 | 90.842 | 0.91304347826087 | 273 | 23 | 91 | 2 | 2 | 273 | 562 | 833 | Oryza sativa Japonica Group cDNA clone:002-154-C12, full insert sequence | blastn | 273 | 364 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 10622993 | 10622993 | PRJNA415636_S_NODE_3909_length_251_cov_2.166667_g3862_i0 | PRJNA415636 | 3909 | 251 | 2.166667 | 5.43833417 | Eucalyptus grandis | 71139 | Plants | Plants | 195 | 3.57e-45 | NTclustered | gi|1973646297|ref|XM_039308465.1| | 71139 | g3862 | i0 | 88.344 | 24.2988047808765 | 163 | 17 | 65 | 2 | 17 | 178 | 306 | 145 | PREDICTED: Eucalyptus grandis 40S ribosomal protein S30 (LOC120291292), mRNA | blastn | 6099 | 195 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Myrtaceae | Eucalyptus | Eucalyptus grandis | |
| 11897954 | 11897954 | PRJNA415636_S_NODE_3490_length_262_cov_2.032558_g3443_i0 | PRJNA415636 | 3490 | 262 | 2.032558 | 5.32530196 | Corylus avellana | 13451 | Plants | Plants | 333 | 7.619999999999999e-87 | NTclustered | gi|2578518154|ref|XM_059595289.1| | 13451 | g3443 | i0 | 94.444 | 8.68702290076336 | 216 | 12 | 82 | 0 | 1 | 216 | 178 | 393 | PREDICTED: Corylus avellana uncharacterized LOC132182083 (LOC132182083), mRNA | blastn | 2276 | 333 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Corylus | Corylus avellana | |
| 14447997 | 14447997 | PRJNA415636_S_NODE_2252_length_309_cov_8.179389_g2205_i0 | PRJNA415636 | 2252 | 309 | 8.179389 | 25.27431201 | Calluna vulgaris | 13385 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917566876|emb|OZ228610.1| | 13385 | g2205 | i0 | 97.059 | 0.653721682847896 | 34 | 0 | 11 | 1 | 136 | 168 | 49713335 | 49713368 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 202 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 14448000 | 14448000 | PRJNA415636_S_NODE_3432_length_264_cov_1.935484_g3385_i0 | PRJNA415636 | 3432 | 264 | 1.935484 | 5.10967776 | Oryza sativa | 4530 | Plants | Plants | 340 | 4.5999999999999996e-89 | NTclustered | gi|32994134|dbj|AK108925.1| | 39947 | g3385 | i0 | 90.189 | 1.00378787878788 | 265 | 21 | 100 | 3 | 1 | 264 | 1044 | 784 | Oryza sativa Japonica Group cDNA clone:002-152-H12, full insert sequence | blastn | 265 | 340 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 14448002 | 14448002 | PRJNA415636_S_NODE_4072_length_247_cov_1.785000_g4025_i0 | PRJNA415636 | 4072 | 247 | 1.785 | 4.40895 | Oryza sativa | 4530 | Plants | Plants | 228 | 3.4599999999999984e-55 | NTclustered | gi|37989474|dbj|AK119851.1| | 39947 | g4025 | i0 | 92.216 | 0.821862348178138 | 167 | 4 | 78 | 8 | 1 | 158 | 2484 | 2650 | Oryza sativa Japonica Group cDNA clone:002-178-F09, full insert sequence | blastn | 203 | 228 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 15721777 | 15721777 | PRJNA415636_S_NODE_253_length_639_cov_4.206081_g223_i0 | PRJNA415636 | 253 | 639 | 4.206081 | 26.87685759 | Vitis vinifera | 29760 | Plants | Plants | 54.7 | 0.018 | NTclustered | gi|147811573|emb|AM450020.2| | 29760 | g223 | i0 | 100 | 0.100156494522692 | 29 | 0 | 5 | 0 | 18 | 46 | 13984 | 13956 | Vitis vinifera contig VV78X043765.9, whole genome shotgun sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 15721785 | 15721785 | PRJNA415636_S_NODE_6953_length_193_cov_11.226027_g6906_i0 | PRJNA415636 | 6953 | 193 | 11.226027 | 21.66623211 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.017 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g6906 | i0 | 100 | 0.145077720207254 | 28 | 0 | 15 | 0 | 166 | 193 | 59 | 32 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 20820831 | 20820831 | PRJNA415636_S_NODE_3717_length_256_cov_0.971292_g3670_i0 | PRJNA415636 | 3717 | 256 | 0.971292 | 2.48650752 | Phyllostachys edulis | 38705 | Plants | Plants | 468 | 1.95e-127 | NTclustered | gi|242382032|emb|FP097018.1| | 38705 | g3670 | i0 | 99.609 | 1 | 256 | 1 | 100 | 0 | 1 | 256 | 645 | 900 | Phyllostachys edulis cDNA clone: bphyem112p22, full insert sequence | blastn | 256 | 468 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis | |
| 23371223 | 23371223 | PRJNA415636_S_NODE_2639_length_292_cov_1.534694_g2592_i0 | PRJNA415636 | 2639 | 292 | 1.534694 | 4.48130648 | Vitis vinifera | 29760 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|147777539|emb|AM432656.2| | 29760 | g2592 | i0 | 96.774 | 0.106164383561644 | 31 | 1 | 11 | 0 | 77 | 107 | 616 | 586 | Vitis vinifera contig VV78X053000.2, whole genome shotgun sequence | blastn | 31 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 23371228 | 23371228 | PRJNA415636_S_NODE_6819_length_197_cov_2.040000_g6772_i0 | PRJNA415636 | 6819 | 197 | 2.04 | 4.0188 | Triticum aestivum | 4565 | Plants | Plants | 91.6 | 3.62e-14 | NTclustered | gi|2123604979|ref|XM_044565676.1| | 4565 | g6772 | i0 | 86.585 | 8.43654822335025 | 82 | 11 | 42 | 0 | 116 | 197 | 476 | 395 | PREDICTED: Triticum aestivum 60S ribosomal protein L18a-like (LOC123146086), mRNA | blastn | 1662 | 91.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 25309417 | 25309417 | PRJNA415636_S_NODE_1760_length_338_cov_1.261168_g1713_i0 | PRJNA415636 | 1760 | 338 | 1.261168 | 4.26274784 | Poaceae | 4479 | Plants | Plants | 619 | 6.969999999999999e-173 | NTclustered | gi|2307846209|gb|OM049555.1| | 4545 | g1713 | i0 | 99.704 | 100 | 338 | 1 | 100 | 0 | 1 | 338 | 503 | 166 | Poa pratensis voucher Po_p_1 chloroplast, complete genome | blastn | 33800 | 619 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Poa | Poa pratensis |
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);;