contig_metadata
18 rows where bioproject = "PRJNA1044115" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171657 | 171657 | PRJNA1044115_P_NODE_42241_length_240_cov_2.335329_g42057_i0 | PRJNA1044115 | 42241 | 240 | 2.335329 | 5.6047896 | Actinidia rufa | 165716 | Plants | Plants | 122 | 1.7199999999999998e-32 | NR | GFS46595.1 | 165716 | g42057 | i0 | 62 | 74.4875 | 121 | 4 | 98.8 | 2 | 3 | 239 | 38 | 158 | GFS46595.1 Mov34/MPN/PAD-1 family protein [Actinidia rufa] | diamond | 17877 | 122 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Actinidiaceae | Actinidia | Actinidia rufa | |
| 2722056 | 2722056 | PRJNA1044115_P_NODE_39703_length_245_cov_0.906977_g39519_i0 | PRJNA1044115 | 39703 | 245 | 0.906977 | 2.22209365 | Picea glauca | 3330 | Plants | Plants | 154 | 5.89e-33 | NTclustered | gi|270136242|gb|BT103194.1| | 3330 | g39519 | i0 | 78.788 | 47.2816326530612 | 231 | 47 | 94 | 2 | 5 | 234 | 487 | 716 | Picea glauca clone GQ0208_C23 mRNA sequence | blastn | 11584 | 154 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea glauca | |
| 7824339 | 7824339 | PRJNA1044115_P_NODE_5447_length_677_cov_5.692053_g5278_i0 | PRJNA1044115 | 5447 | 677 | 5.692053 | 38.53519881 | Oryza sativa | 4530 | Plants | Plants | 582 | 1.94e-161 | NTclustered | gi|32994371|dbj|AK109162.1| | 39947 | g5278 | i0 | 82.292 | 100.088626292467 | 672 | 119 | 99 | 0 | 1 | 672 | 369 | 1040 | Oryza sativa Japonica Group cDNA clone:002-155-G09, full insert sequence | blastn | 67760 | 582 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 8661973 | 8661973 | PRJNA1044115_P_NODE_27027_length_281_cov_1.903846_g26843_i0 | PRJNA1044115 | 27027 | 281 | 1.903846 | 5.34980726 | Eukaryota | 2759 | Plants | Plants | 187 | 6.809999999999998e-43 | NTclustered | gi|1173821329|ref|XM_011090943.2| | 4182 | g26843 | i0 | 80.408 | 27.0498220640569 | 245 | 48 | 87 | 0 | 3 | 247 | 898 | 1142 | PREDICTED: Sesamum indicum cell division cycle protein 48 homolog (LOC105170266), mRNA | blastn | 7601 | 187 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Pedaliaceae | Sesamum | Sesamum indicum | |
| 12925222 | 12925222 | PRJNA1044115_P_NODE_34071_length_253_cov_0.866667_g33887_i0 | PRJNA1044115 | 34071 | 253 | 0.866667 | 2.19266751 | Allium cepa | 4679 | Plants | Plants | 390 | 4.28e-104 | NTclustered | gi|1524345309|gb|MH017542.1| | 4679 | g33887 | i0 | 94.466 | 5.69169960474308 | 253 | 14 | 100 | 0 | 1 | 253 | 236 | 488 | Allium cepa clone ac198993 acepCL7Contig93 repeat region | blastn | 1440 | 390 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Amaryllidaceae | Allium | Allium cepa | |
| 14200078 | 14200078 | PRJNA1044115_P_NODE_2872_length_954_cov_11.375709_g2740_i0 | PRJNA1044115 | 2872 | 954 | 11.375709 | 108.52426386 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 423 | 6.65e-147 | NR | BAJ95666.1 | 112509 | g2740 | i0 | 91 | 0.767295597484277 | 244 | 22 | 76.7 | 0 | 822 | 91 | 3 | 246 | BAJ95666.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 732 | 423 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 15036520 | 15036520 | PRJNA1044115_P_NODE_30792_length_265_cov_1.468750_g30608_i0 | PRJNA1044115 | 30792 | 265 | 1.46875 | 3.8921875 | Musa | 4640 | Plants | Plants | 490 | 4.3299999999999986e-134 | NTclustered | gi|2046372313|dbj|LC609770.1| | 4641 | g30608 | i0 | 100 | 101 | 265 | 0 | 100 | 0 | 1 | 265 | 43398 | 43134 | Musa acuminata cv. Morado chloroplast DNA, complete genome | blastn | 26765 | 490 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Musa | Musa acuminata | |
| 16311217 | 16311217 | PRJNA1044115_P_NODE_31853_length_261_cov_0.920213_g31669_i0 | PRJNA1044115 | 31853 | 261 | 0.920213 | 2.40175593 | Magnoliopsida | 3398 | Plants | Plants | 455 | 1.55e-123 | NTclustered | gi|133900038|gb|EF135610.1| | 124827 | g31669 | i0 | 98.084 | 100 | 261 | 5 | 100 | 0 | 1 | 261 | 309 | 49 | Endospermum moluccanum 26S ribosomal RNA gene, partial sequence | blastn | 26100 | 455 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Euphorbiaceae | Endospermum | Endospermum moluccanum | |
| 16748459 | 16748459 | PRJNA1044115_P_NODE_32114_length_260_cov_1.064171_g31930_i0 | PRJNA1044115 | 32114 | 260 | 1.064171 | 2.7668446 | Brassica napus | 3708 | Plants | Plants | 60.2 | 1.42e-4 | NTclustered | gi|2258217032|ref|XM_048738471.1| | 3708 | g31930 | i0 | 88.462 | 4.42307692307692 | 52 | 2 | 19 | 3 | 118 | 167 | 1238 | 1287 | PREDICTED: Brassica napus myrosinase-binding protein 2-like (LOC106360475), transcript variant X2, mRNA | blastn | 1150 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 16748522 | 16748522 | PRJNA1044115_P_NODE_35914_length_250_cov_1.322034_g35730_i0 | PRJNA1044115 | 35914 | 250 | 1.322034 | 3.305085 | Pinus taeda | 3352 | Plants | Plants | 287 | 5.7e-73 | NTclustered | gi|297747432|gb|AC241314.1| | 3352 | g35730 | i0 | 88.703 | 28.316 | 239 | 22 | 94 | 3 | 11 | 246 | 129378 | 129614 | Pinus taeda clone PT_7Ba3152O20, complete sequence | blastn | 7079 | 287 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus taeda | |
| 19297342 | 19297342 | PRJNA1044115_P_NODE_34816_length_252_cov_0.871508_g34632_i0 | PRJNA1044115 | 34816 | 252 | 0.871508 | 2.19620016 | Benincasa hispida | 102211 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|1955874634|ref|XM_039039330.1| | 102211 | g34632 | i0 | 96.875 | 0.507936507936508 | 32 | 0 | 13 | 1 | 7 | 38 | 902 | 932 | PREDICTED: Benincasa hispida DNA-directed RNA polymerases II and IV subunit 5A-like (LOC120083535), transcript variant X3, mRNA | blastn | 128 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Benincasa | Benincasa hispida | |
| 19297527 | 19297527 | PRJNA1044115_P_NODE_9436_length_495_cov_4.457346_g9253_i0 | PRJNA1044115 | 9436 | 495 | 4.457346 | 22.0638627 | Calluna vulgaris | 13385 | Plants | Plants | 52.8 | 0.048 | NTclustered | gi|2917527253|emb|OZ224584.1| | 13385 | g9253 | i0 | 100 | 0.113131313131313 | 28 | 0 | 6 | 0 | 455 | 482 | 52156 | 52183 | Calluna vulgaris genome assembly, chromosome: 5 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 24397756 | 24397756 | PRJNA1044115_P_NODE_9220_length_502_cov_8.783217_g9037_i0 | PRJNA1044115 | 9220 | 502 | 8.783217 | 44.09174934 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 282 | 2.47e-95 | NR | BAK02811.1 | 112509 | g9037 | i0 | 94.6 | 0.884462151394422 | 148 | 8 | 88.4 | 0 | 1 | 444 | 4 | 151 | BAK02811.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 444 | 282 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 27161364 | 27161364 | PRJNA1044115_P_NODE_20722_length_320_cov_1.866397_g20538_i0 | PRJNA1044115 | 20722 | 320 | 1.866397 | 5.9724704 | Lycium barbarum | 112863 | Plants | Plants | 58.2 | 3.51e-7 | NR | XP_060183138.1 | 112863 | g20538 | i0 | 39.8 | 2.2875 | 83 | 48 | 75.9 | 1 | 47 | 289 | 306 | 388 | XP_060183138.1 DNA polymerase-like [Lycium barbarum] | diamond | 732 | 58.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Lycium | Lycium barbarum | |
| 27762053 | 27762053 | PRJNA1044115_P_NODE_41144_length_243_cov_0.917647_g40960_i0 | PRJNA1044115 | 41144 | 243 | 0.917647 | 2.22988221 | Ensete ventricosum | 4639 | Plants | Plants | 43.9 | 0.0021 | NR | RWW75103.1 | 4639 | g40960 | i0 | 56.7 | 0.37037037037037 | 30 | 13 | 37 | 0 | 119 | 30 | 40 | 69 | RWW75103.1 hypothetical protein BHE74_00016894 [Ensete ventricosum] | diamond | 90 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Ensete | Ensete ventricosum | |
| 28488087 | 28488087 | PRJNA1044115_P_NODE_28907_length_273_cov_1.200000_g28723_i0 | PRJNA1044115 | 28907 | 273 | 1.2 | 3.276 | Colocasia esculenta | 4460 | Plants | Plants | 43.1 | 0.0385 | NR | MQM03685.1 | 4460 | g28723 | i0 | 34.3 | 0.769230769230769 | 70 | 46 | 76.9 | 0 | 229 | 20 | 237 | 306 | MQM03685.1 hypothetical protein [Colocasia esculenta] | diamond | 210 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 29561368 | 29561368 | PRJNA1044115_P_NODE_41650_length_242_cov_0.923077_g41466_i0 | PRJNA1044115 | 41650 | 242 | 0.923077 | 2.23384634 | Brassica cretica | 69181 | Plants | Plants | 43.5 | 0.0192 | NR | KAF2602336.1 | 69181 | g41466 | i0 | 44.1 | 2.16942148760331 | 59 | 29 | 69.4 | 3 | 5 | 172 | 145 | 202 | KAF2602336.1 hypothetical protein F2Q70_00026563 [Brassica cretica] | diamond | 525 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica cretica | |
| 29940625 | 29940625 | PRJNA1044115_P_NODE_39071_length_246_cov_0.901734_g38887_i0 | PRJNA1044115 | 39071 | 246 | 0.901734 | 2.21826564 | Ipomoea trifida | 35884 | Plants | Plants | 40.8 | 0.0445 | NR | GLL29531.1 | 35884 | g38887 | i0 | 48.6 | 0.451219512195122 | 37 | 19 | 45.1 | 0 | 115 | 5 | 22 | 58 | GLL29531.1 hypothetical protein Itr_chr06CG12020 [Ipomoea trifida] | diamond | 111 | 40.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea trifida |
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);;