contig_metadata
26 rows where bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4956324 | 4956324 | PRJNA557436_S_NODE_6864_length_165_cov_1.984615_g6816_i0 | PRJNA557436 | 6864 | 165 | 1.984615 | 3.27461475 | Poaceae | 4479 | Plants | Plants | 296 | 5.77e-76 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g6816 | i0 | 100 | 182.30303030303 | 160 | 0 | 97 | 0 | 1 | 160 | 96491 | 96332 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 30080 | 296 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 5639546 | 5639546 | PRJNA557436_S_NODE_5985_length_173_cov_1.528986_g5937_i0 | PRJNA557436 | 5985 | 173 | 1.528986 | 2.64514578 | Cucumis sativus | 3659 | Plants | Plants | 222 | 1.05e-53 | NTclustered | gi|211940051|gb|FJ377880.1| | 3659 | g5937 | i0 | 93.377 | 4.25433526011561 | 151 | 9 | 87 | 1 | 23 | 173 | 163 | 14 | Cucumis sativus clone CsCent1-E centromere specific repeat 1-E genomic sequence | blastn | 736 | 222 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis sativus | |
| 6231928 | 6231928 | PRJNA557436_S_NODE_1525_length_298_cov_5.266160_g1477_i0 | PRJNA557436 | 1525 | 298 | 5.26616 | 15.6931568 | Eukaryota | 2759 | Plants | Plants | 529 | 1.0499999999999996e-145 | NTclustered | gi|1878849207|gb|MT796543.1| | 3512 | g1477 | i0 | 100 | 95.9731543624161 | 286 | 0 | 96 | 0 | 1 | 286 | 1667 | 1952 | Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 | 28600 | 529 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 6231931 | 6231931 | PRJNA557436_S_NODE_2725_length_231_cov_3.607143_g2677_i0 | PRJNA557436 | 2725 | 231 | 3.607143 | 8.33250033 | Magnoliopsida | 3398 | Plants | Plants | 427 | 2.9399999999999998e-115 | NTclustered | gi|1878849229|gb|MT796565.1| | 3505 | g2677 | i0 | 100 | 100 | 231 | 0 | 100 | 0 | 1 | 231 | 325 | 95 | Betula pendula isolate DM301 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 | 23100 | 427 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Betula | Betula pendula | |
| 6231935 | 6231935 | PRJNA557436_S_NODE_4365_length_193_cov_2.481013_g4317_i0 | PRJNA557436 | 4365 | 193 | 2.481013 | 4.78835509 | Poaceae | 4479 | Plants | Plants | 243 | 9.2e-60 | NTclustered | gi|440550761|gb|KC290897.1| | 4565 | g4317 | i0 | 90.374 | 36.279792746114 | 187 | 15 | 96 | 3 | 8 | 193 | 389 | 205 | Triticum aestivum clone pTa-505 FISH-positive repetitive sequence | blastn | 7002 | 244 | 0.995901639344262 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 6913644 | 6913644 | PRJNA557436_S_NODE_5986_length_173_cov_1.521739_g5938_i0 | PRJNA557436 | 5986 | 173 | 1.521739 | 2.63260847 | Secale cereale | 4550 | Plants | Plants | 298 | 1.69e-76 | NTclustered | gi|21198|emb|X64102.1| | 4550 | g5938 | i0 | 98.235 | 40.5028901734104 | 170 | 3 | 98 | 0 | 4 | 173 | 2990 | 2821 | S.cereale DNA for dispersed repeat sequence (R173-3) | blastn | 7007 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 7506313 | 7506313 | PRJNA557436_S_NODE_1546_length_296_cov_4.279693_g1498_i0 | PRJNA557436 | 1546 | 296 | 4.279693 | 12.66789128 | Magnoliopsida | 3398 | Plants | Plants | 525 | 1.35e-144 | NTclustered | gi|2504382689|gb|ON479685.1| | 2708 | g1498 | i0 | 98.649 | 100.182432432432 | 296 | 4 | 100 | 0 | 1 | 296 | 5241 | 4946 | Citrus x limon 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence | blastn | 29654 | 525 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus x limon | |
| 11331394 | 11331394 | PRJNA557436_S_NODE_3889_length_201_cov_5.421687_g3841_i0 | PRJNA557436 | 3889 | 201 | 5.421687 | 10.89759087 | Citrus | 2706 | Plants | Plants | 357 | 3.31e-94 | NTclustered | gi|2396003254|ref|XR_008051491.1| | 2711 | g3841 | i0 | 98.522 | 100.691542288557 | 203 | 1 | 100 | 2 | 1 | 201 | 2416 | 2618 | PREDICTED: Citrus sinensis 28S ribosomal RNA (LOC127899613), rRNA | blastn | 20239 | 357 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 12014650 | 12014650 | PRJNA557436_S_NODE_5250_length_181_cov_1.924658_g5202_i0 | PRJNA557436 | 5250 | 181 | 1.924658 | 3.48363098 | Quercus robur | 38942 | Plants | Plants | 329 | 6.340000000000001e-86 | NTclustered | gi|2293049806|ref|XR_007645197.1| | 38942 | g5202 | i0 | 99.448 | 100 | 181 | 1 | 100 | 0 | 1 | 181 | 3135 | 3315 | PREDICTED: Quercus robur 28S ribosomal RNA (LOC126693076), rRNA | blastn | 18100 | 329 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus robur | |
| 12014654 | 12014654 | PRJNA557436_S_NODE_550_length_476_cov_1.684807_g502_i0 | PRJNA557436 | 550 | 476 | 1.684807 | 8.01968132 | Secale cereale | 4550 | Plants | Plants | 784 | 0 | NTclustered | gi|995952672|gb|KT724944.1| | 4550 | g502 | i0 | 97.768 | 7.65126050420168 | 448 | 10 | 100 | 0 | 1 | 448 | 6778 | 6331 | Secale cereale clone BAC 122F3 retrotransposon, complete sequence; and satellite pSc250 sequence | blastn | 3642 | 784 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 12607241 | 12607241 | PRJNA557436_S_NODE_7390_length_161_cov_5.793651_g7342_i0 | PRJNA557436 | 7390 | 161 | 5.793651 | 9.32777811 | Schizanthus | 24674 | Plants | Plants | 298 | 1.56e-76 | NTclustered | gi|7595536|gb|AF207016.1| | 33122 | g7342 | i0 | 100 | 98.1739130434783 | 161 | 0 | 100 | 0 | 1 | 161 | 1601 | 1441 | Schizanthus pinnatus 18S ribosomal RNA gene, complete sequence | blastn | 15806 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Schizanthus | Schizanthus pinnatus | |
| 16431011 | 16431011 | PRJNA557436_S_NODE_4473_length_191_cov_7.826923_g4425_i0 | PRJNA557436 | 4473 | 191 | 7.826923 | 14.94942293 | Magnoliopsida | 3398 | Plants | Plants | 353 | 4.02e-93 | NTclustered | gi|30527332|gb|AY095469.1| | 3422 | g4425 | i0 | 100 | 100 | 191 | 0 | 100 | 0 | 1 | 191 | 2613 | 2803 | Tasmannia insipida 26S ribosomal RNA gene, partial sequence | blastn | 19100 | 353 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Canellales | Winteraceae | Tasmannia | Tasmannia insipida | |
| 17113449 | 17113449 | PRJNA557436_S_NODE_4154_length_197_cov_1.586420_g4106_i0 | PRJNA557436 | 4154 | 197 | 1.58642 | 3.1252474 | Secale cereale | 4550 | Plants | Plants | 313 | 7.09e-81 | NTclustered | gi|565500410|gb|KF835426.1| | 4550 | g4106 | i0 | 97.297 | 1237.34517766497 | 185 | 3 | 93 | 2 | 15 | 197 | 50082 | 50266 | Secale cereale clone BAC956-D7, complete sequence | blastn | 243757 | 313 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 17706220 | 17706220 | PRJNA557436_S_NODE_7334_length_162_cov_1.385827_g7286_i0 | PRJNA557436 | 7334 | 162 | 1.385827 | 2.24503974 | Acer | 4022 | Plants | Plants | 300 | 4.36e-77 | NTclustered | gi|2468785498|gb|OP221110.1| | 47963 | g7286 | i0 | 100 | 1077.35185185185 | 162 | 0 | 100 | 0 | 1 | 162 | 5276 | 5437 | Acer pictum subsp. mono isolate Q150 external transcribed spacer small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 174531 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer pictum | |
| 18387583 | 18387583 | PRJNA557436_S_NODE_2535_length_239_cov_1.294118_g2487_i0 | PRJNA557436 | 2535 | 239 | 1.294118 | 3.09294202 | Secale cereale | 4550 | Plants | Plants | 425 | 1.1e-114 | NTclustered | gi|565500410|gb|KF835426.1| | 4550 | g2487 | i0 | 98.745 | 62.7824267782427 | 239 | 3 | 100 | 0 | 1 | 239 | 39744 | 39506 | Secale cereale clone BAC956-D7, complete sequence | blastn | 15005 | 425 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 18387607 | 18387607 | PRJNA557436_S_NODE_735_length_415_cov_10.139474_g687_i0 | PRJNA557436 | 735 | 415 | 10.139474 | 42.0788171 | Secale cereale | 4550 | Plants | Plants | 721 | 0 | NTclustered | gi|994810|emb|Z54189.1| | 4550 | g687 | i0 | 98.072 | 103.084337349398 | 415 | 7 | 100 | 1 | 1 | 415 | 481 | 68 | Secale cereale DNA for satellite sequence (pSc200 family), subtelomeric | blastn | 42780 | 721 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 18979637 | 18979637 | PRJNA557436_S_NODE_2835_length_227_cov_3.156250_g2787_i0 | PRJNA557436 | 2835 | 227 | 3.15625 | 7.1646875 | Magnoliopsida | 3398 | Plants | Plants | 409 | 1.04e-109 | NTclustered | gi|2504382689|gb|ON479685.1| | 2708 | g2787 | i0 | 99.119 | 99.8810572687225 | 227 | 2 | 100 | 0 | 1 | 227 | 3710 | 3936 | Citrus x limon 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence | blastn | 22673 | 409 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus x limon | |
| 19661999 | 19661999 | PRJNA557436_S_NODE_3196_length_217_cov_5.302198_g3148_i0 | PRJNA557436 | 3196 | 217 | 5.302198 | 11.50576966 | Cucumis melo | 3656 | Plants | Plants | 383 | 5.98e-102 | NTclustered | gi|212961222|gb|FJ410944.1| | 3656 | g3148 | i0 | 98.611 | 9.51612903225806 | 216 | 3 | 100 | 0 | 2 | 217 | 295 | 80 | Cucumis melo satellite Csst1-Cm sequence | blastn | 2065 | 383 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 20254779 | 20254779 | PRJNA557436_S_NODE_396_length_551_cov_2.748062_g354_i0 | PRJNA557436 | 396 | 551 | 2.748062 | 15.14182162 | Oryza | 4527 | Plants | Plants | 63.9 | 2.51e-5 | NTclustered | gi|2348123842|ref|XM_052286747.1| | 4538 | g354 | i0 | 90 | 2.92014519056261 | 50 | 3 | 9 | 2 | 2 | 49 | 2687 | 2638 | PREDICTED: Oryza glaberrima glutamate receptor 2.9-like (LOC127762302), mRNA | blastn | 1609 | 63.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza glaberrima | |
| 22212760 | 22212760 | PRJNA557436_S_NODE_5758_length_175_cov_1.700000_g5710_i0 | PRJNA557436 | 5758 | 175 | 1.7 | 2.975 | Secale cereale | 4550 | Plants | Plants | 307 | 2.8500000000000004e-79 | NTclustered | gi|21198|emb|X64102.1| | 4550 | g5710 | i0 | 98.286 | 41.6628571428571 | 175 | 3 | 100 | 0 | 1 | 175 | 3848 | 3674 | S.cereale DNA for dispersed repeat sequence (R173-3) | blastn | 7291 | 307 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 24080194 | 24080194 | PRJNA557436_S_NODE_8259_length_156_cov_1.479339_g8211_i0 | PRJNA557436 | 8259 | 156 | 1.479339 | 2.30776884 | Triticum | 4564 | Plants | Plants | 248 | 1.5299999999999998e-61 | NTclustered | gi|110341789|gb|DQ537335.1| | 4565 | g8211 | i0 | 95.513 | 669.782051282051 | 156 | 6 | 100 | 1 | 1 | 156 | 183522 | 183368 | Triticum aestivum clones BAC 1031P08; BAC 754K10; BAC 1344C16, complete sequence | blastn | 104486 | 248 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 25354529 | 25354529 | PRJNA557436_S_NODE_3840_length_203_cov_1.047619_g3792_i0 | PRJNA557436 | 3840 | 203 | 1.047619 | 2.12666657 | Poaceae | 4479 | Plants | Plants | 305 | 1.23e-78 | NTclustered | gi|565500410|gb|KF835426.1| | 4550 | g3792 | i0 | 97.74 | 422.669950738916 | 177 | 4 | 100 | 0 | 1 | 177 | 138199 | 138375 | Secale cereale clone BAC956-D7, complete sequence | blastn | 85802 | 305 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Secale | Secale cereale | |
| 26762260 | 26762260 | PRJNA557436_S_NODE_6321_length_170_cov_1.237037_g6273_i0 | PRJNA557436 | 6321 | 170 | 1.237037 | 2.1029629 | Acer saccharum | 4024 | Plants | Plants | 66.2 | 6.89e-11 | NR | KAK1548203.1 | 4024 | g6273 | i0 | 48.2 | 2.82352941176471 | 56 | 29 | 98.8 | 0 | 170 | 3 | 142 | 197 | KAK1548203.1 hypothetical protein Q3G72_018492 [Acer saccharum] | diamond | 480 | 66.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 27805548 | 27805548 | PRJNA557436_S_NODE_4144_length_197_cov_1.790123_g4096_i0 | PRJNA557436 | 4144 | 197 | 1.790123 | 3.52654231 | Acer saccharum | 4024 | Plants | Plants | 107 | 2.39e-25 | NR | KAK1548911.1 | 4024 | g4096 | i0 | 72.3 | 0.989847715736041 | 65 | 18 | 99 | 0 | 3 | 197 | 193 | 257 | KAK1548911.1 hypothetical protein Q3G72_019842 [Acer saccharum] | diamond | 195 | 107 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 29289251 | 29289251 | PRJNA557436_S_NODE_2349_length_247_cov_2.547170_g2301_i0 | PRJNA557436 | 2349 | 247 | 2.54717 | 6.2915099 | Sphagnum balticum | 128184 | Plants | Plants | 128 | 8.4e-34 | NR | CAM5998727.1 | 128184 | g2301 | i0 | 70 | 2.8663967611336 | 80 | 24 | 97.2 | 0 | 242 | 3 | 236 | 315 | CAM5998727.1 unnamed protein product [Sphagnum balticum] | diamond | 708 | 128 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 29618800 | 29618800 | PRJNA557436_S_NODE_5910_length_174_cov_1.143885_g5862_i0 | PRJNA557436 | 5910 | 174 | 1.143885 | 1.9903599 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 6.56e-10 | NR | KAF3334543.1 | 544730 | g5862 | i0 | 52.9 | 2.62068965517241 | 51 | 24 | 87.9 | 0 | 2 | 154 | 273 | 323 | KAF3334543.1 methyl-CpG-binding domain protein 4 [Carex littledalei] | diamond | 456 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Carex | Carex littledalei |
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);;