contig_metadata
21 rows where bioproject = "PRJNA702290" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5787281 | 5787281 | PRJNA702290_P_NODE_1545_length_159_cov_15.200000_g1537_i0 | PRJNA702290 | 1545 | 159 | 15.2 | 24.168 | Ipomoea nil | 35883 | Plants | Plants | 128 | 2.13e-25 | NTclustered | gi|1109193309|ref|XM_019322592.1| | 35883 | g1537 | i0 | 82.249 | 68.3018867924528 | 169 | 11 | 95 | 5 | 3 | 153 | 168 | 335 | PREDICTED: Ipomoea nil 60S ribosomal protein L12-like (LOC109173353), mRNA | blastn | 10860 | 128 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea nil | |
| 5787295 | 5787295 | PRJNA702290_P_NODE_285_length_279_cov_198.587500_g277_i0 | PRJNA702290 | 285 | 279 | 198.5875 | 554.059125 | Bupleurum falcatum | 46367 | Plants | Plants | 496 | 9.88e-136 | NTclustered | gi|2571153582|gb|OR493979.1| | 46367 | g277 | i0 | 98.921 | 97.0143369175627 | 278 | 2 | 99 | 1 | 2 | 278 | 5416 | 5693 | Bupleurum falcatum voucher 2009100601 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 | 27067 | 496 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Bupleurum | Bupleurum falcatum | |
| 6288708 | 6288708 | PRJNA702290_P_NODE_865_length_191_cov_11.434211_g857_i0 | PRJNA702290 | 865 | 191 | 11.434211 | 21.83934301 | Glycine | 3846 | Plants | Plants | 73.1 | 1.26e-8 | NTclustered | gi|210143208|dbj|AK285990.1| | 3847 | g857 | i0 | 89.474 | 11.6020942408377 | 57 | 6 | 30 | 0 | 121 | 177 | 288 | 232 | Glycine max cDNA, clone: GMFL01-19-P06 | blastn | 2216 | 73.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 7562549 | 7562549 | PRJNA702290_P_NODE_426_length_217_cov_3.629213_g418_i0 | PRJNA702290 | 426 | 217 | 3.629213 | 7.87539221 | Magnoliopsida | 3398 | Plants | Plants | 379 | 7.739999999999998e-101 | NTclustered | gi|377819357|ref|NC_016753.1| | 4460 | g418 | i0 | 99.519 | 186.912442396313 | 208 | 1 | 96 | 0 | 4 | 211 | 111339 | 111132 | Colocasia esculenta chloroplast, complete genome | blastn | 40560 | 379 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 8336925 | 8336925 | PRJNA702290_P_NODE_1147_length_191_cov_4.467105_g1139_i0 | PRJNA702290 | 1147 | 191 | 4.467105 | 8.53217055 | Cornus florida | 4283 | Plants | Plants | 58.4 | 3.53e-4 | NTclustered | gi|2583722524|ref|XR_009470331.1| | 4283 | g1139 | i0 | 94.737 | 0.198952879581152 | 38 | 1 | 20 | 1 | 140 | 177 | 109 | 73 | PREDICTED: Cornus florida uncharacterized LOC132274092 (LOC132274092), ncRNA | blastn | 38 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Cornaceae | Cornus | Cornus florida | |
| 8837554 | 8837554 | PRJNA702290_P_NODE_47_length_515_cov_3.915966_g40_i0 | PRJNA702290 | 47 | 515 | 3.915966 | 20.1672249 | Araceae | 4454 | Plants | Plants | 918 | 0 | NTclustered | gi|161784171|ref|NC_010109.1| | 4472 | g40 | i0 | 98.835 | 197.003883495146 | 515 | 6 | 100 | 0 | 1 | 515 | 111109 | 110595 | Lemna minor chloroplast, complete genome | blastn | 101457 | 924 | 0.993506493506494 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Lemna | Lemna minor | |
| 10113262 | 10113262 | PRJNA702290_P_NODE_2048_length_152_cov_22.371681_g2040_i0 | PRJNA702290 | 2048 | 152 | 22.371681 | 34.00495512 | Magnoliopsida | 3398 | Plants | Plants | 267 | 4.08e-67 | NTclustered | gi|1952043583|gb|MN428574.1| | 4355 | g2040 | i0 | 99.32 | 96.7105263157895 | 147 | 1 | 97 | 0 | 6 | 152 | 2351 | 2497 | Darlingtonia californica isolate DCAL01 26S ribosomal RNA gene, partial sequence | blastn | 14700 | 267 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Sarraceniaceae | Darlingtonia | Darlingtonia californica | |
| 10887850 | 10887850 | PRJNA702290_P_NODE_1449_length_164_cov_1.224000_g1441_i0 | PRJNA702290 | 1449 | 164 | 1.224 | 2.00736 | Lemna minuta | 161101 | Plants | Plants | 300 | 4.43e-77 | NTclustered | gi|2859900956|emb|OZ204802.1| | 161101 | g1441 | i0 | 100 | 98.7560975609756 | 162 | 0 | 99 | 0 | 3 | 164 | 114665 | 114826 | Lemna minuta genome assembly, organelle: plastid:chloroplast | blastn | 16196 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Lemna | Lemna minuta | |
| 12664146 | 12664146 | PRJNA702290_P_NODE_270_length_285_cov_6.345528_g262_i0 | PRJNA702290 | 270 | 285 | 6.345528 | 18.0847548 | Magnoliopsida | 3398 | Plants | Plants | 505 | 1.6799999999999995e-138 | NTclustered | gi|161784171|ref|NC_010109.1| | 4472 | g262 | i0 | 99.286 | 192.575438596491 | 280 | 1 | 98 | 1 | 3 | 282 | 111176 | 111454 | Lemna minor chloroplast, complete genome | blastn | 54884 | 510 | 0.990196078431373 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Lemna | Lemna minor | |
| 13938581 | 13938581 | PRJNA702290_P_NODE_331_length_250_cov_3.872038_g323_i0 | PRJNA702290 | 331 | 250 | 3.872038 | 9.680095 | Magnoliopsida | 3398 | Plants | Plants | 442 | 1.1499999999999994e-119 | NTclustered | gi|156598340|gb|EU017008.1| | 4641 | g323 | i0 | 100 | 185.464 | 239 | 0 | 96 | 0 | 8 | 246 | 2286 | 2524 | Musa acuminata 23S ribosomal RNA (rrn23) gene, partial sequence; chloroplast | blastn | 46366 | 442 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Musa | Musa acuminata | |
| 15213208 | 15213208 | PRJNA702290_P_NODE_1232_length_191_cov_2.486842_g1224_i0 | PRJNA702290 | 1232 | 191 | 2.486842 | 4.74986822 | Eukaryota | 2759 | Plants | Plants | 141 | 3.41e-29 | NTclustered | gi|2029522069|ref|XR_005924068.1| | 3635 | g1224 | i0 | 98.734 | 701.732984293194 | 79 | 1 | 41 | 0 | 113 | 191 | 961 | 1039 | PREDICTED: Gossypium hirsutum 18S ribosomal RNA (LOC121226206), rRNA | blastn | 134031 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium hirsutum | |
| 15986371 | 15986371 | PRJNA702290_P_NODE_1753_length_157_cov_21.915254_g1745_i0 | PRJNA702290 | 1753 | 157 | 21.915254 | 34.40694878 | Oryza sativa | 4530 | Plants | Plants | 259 | 7.11e-65 | NTclustered | gi|37989591|dbj|AK119968.1| | 39947 | g1745 | i0 | 98.63 | 22 | 146 | 2 | 93 | 0 | 3 | 148 | 179 | 324 | Oryza sativa Japonica Group cDNA clone:002-184-D12, full insert sequence | blastn | 3454 | 259 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 16487602 | 16487602 | PRJNA702290_P_NODE_1693_length_158_cov_8.840336_g1685_i0 | PRJNA702290 | 1693 | 158 | 8.840336 | 13.96773088 | Lauraceae | 3433 | Plants | Plants | 263 | 5.54e-66 | NTclustered | gi|2249528587|gb|ON685408.1| | 119261 | g1685 | i0 | 98.039 | 102.778481012658 | 153 | 0 | 95 | 2 | 3 | 152 | 2338 | 2186 | Cinnamomum burmanni isolate BPTPS094 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 | 16239 | 263 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Cinnamomum | Cinnamomum burmanni | |
| 16487603 | 16487603 | PRJNA702290_P_NODE_1733_length_158_cov_1.252101_g1725_i0 | PRJNA702290 | 1733 | 158 | 1.252101 | 1.97831958 | Magnoliopsida | 3398 | Plants | Plants | 279 | 5.500000000000001e-71 | NTclustered | gi|1158586937|gb|KY084475.1| | 3483 | g1725 | i0 | 99.351 | 192.063291139241 | 154 | 1 | 97 | 0 | 4 | 157 | 104583 | 104430 | Cannabis sativa chloroplast, complete genome | blastn | 30346 | 281 | 0.99288256227758 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 19036399 | 19036399 | PRJNA702290_P_NODE_1135_length_191_cov_4.730263_g1127_i0 | PRJNA702290 | 1135 | 191 | 4.730263 | 9.03480233 | Pinopsida | 58019 | Plants | Plants | 143 | 9.479999999999999e-30 | NTclustered | gi|2571304680|ref|XR_009364031.1| | 3369 | g1127 | i0 | 98.75 | 80.8952879581152 | 80 | 1 | 81 | 0 | 1 | 80 | 352 | 273 | PREDICTED: Cryptomeria japonica 28S ribosomal RNA (LOC131865303), rRNA | blastn | 15451 | 143 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 19810693 | 19810693 | PRJNA702290_P_NODE_656_length_191_cov_18.026316_g648_i0 | PRJNA702290 | 656 | 191 | 18.026316 | 34.43026356 | Urtica morifolia | 1435590 | Plants | Plants | 141 | 3.41e-29 | NTclustered | gi|2254130385|gb|OM892805.1| | 1435590 | g648 | i0 | 98.734 | 42.9738219895288 | 79 | 1 | 41 | 0 | 112 | 190 | 4309 | 4231 | Urtica morifolia isolate U200 18S small subunit ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence | blastn | 8208 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Urticaceae | Urtica | Urtica morifolia | |
| 19810699 | 19810699 | PRJNA702290_P_NODE_956_length_191_cov_9.223684_g948_i0 | PRJNA702290 | 956 | 191 | 9.223684 | 17.61723644 | Solanum stenotomum | 172797 | Plants | Plants | 139 | 1.23e-28 | NTclustered | gi|2276444676|ref|XM_049541914.1| | 172797 | g948 | i0 | 100 | 8.49738219895288 | 75 | 0 | 81 | 0 | 6 | 80 | 1035 | 961 | PREDICTED: Solanum stenotomum CSC1-like protein RXW8 (LOC125861973), transcript variant X1, mRNA | blastn | 1623 | 139 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum stenotomum | |
| 21586883 | 21586883 | PRJNA702290_P_NODE_1117_length_191_cov_5.118421_g1109_i0 | PRJNA702290 | 1117 | 191 | 5.118421 | 9.77618411 | Magnoliopsida | 3398 | Plants | Plants | 145 | 2.63e-30 | NTclustered | gi|1516510546|emb|LR031570.1| | 3711 | g1109 | i0 | 100 | 99.6858638743455 | 78 | 0 | 41 | 0 | 113 | 190 | 4078572 | 4078649 | Brassica rapa genome, scaffold: A05 | blastn | 19040 | 145 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 21586908 | 21586908 | PRJNA702290_P_NODE_917_length_191_cov_10.243421_g909_i0 | PRJNA702290 | 917 | 191 | 10.243421 | 19.56493411 | Magnoliopsida | 3398 | Plants | Plants | 145 | 2.63e-30 | NTclustered | gi|1381390543|ref|NC_037463.1| | 2711 | g909 | i0 | 100 | 74.6020942408377 | 78 | 0 | 80 | 0 | 4 | 81 | 348949 | 349026 | Citrus sinensis mitochondrion, complete genome | blastn | 14249 | 145 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 24136375 | 24136375 | PRJNA702290_P_NODE_1019_length_191_cov_7.934211_g1011_i0 | PRJNA702290 | 1019 | 191 | 7.934211 | 15.15434301 | Ericaceae | 4345 | Plants | Plants | 137 | 4.41e-28 | NTclustered | gi|2739979358|emb|OZ071053.1| | 13385 | g1011 | i0 | 100 | 82.8062827225131 | 74 | 0 | 80 | 0 | 7 | 80 | 201724 | 201651 | Calluna vulgaris genome assembly, organelle: mitochondrion | blastn | 15816 | 137 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 25411165 | 25411165 | PRJNA702290_P_NODE_1300_length_189_cov_7.526667_g1292_i0 | PRJNA702290 | 1300 | 189 | 7.526667 | 14.22540063 | root | 1 | Root_unresolved | Root_unresolved | 335 | 1.4399999999999993e-87 | NTclustered | gi|161784171|ref|NC_010109.1| | 4472 | g1292 | i0 | 100 | 185.280423280423 | 181 | 0 | 96 | 0 | 4 | 184 | 107404 | 107224 | Lemna minor chloroplast, complete genome | blastn | 35018 | 335 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Lemna | Lemna minor |
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);;