contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA734313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 716696 | 716696 | PRJNA734313_S_NODE_18501_length_217_cov_2.700000_g18388_i0 | PRJNA734313 | 18501 | 217 | 2.7 | 5.859 | Anacolia laevisphaera | 188169 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|548954658|emb|HF536620.1| | 188169 | g18388 | i0 | 100 | 3.2258064516129 | 30 | 0 | 14 | 0 | 75 | 104 | 686 | 657 | Anacolia laevisphaera chloroplast trnS-trnF region, isolate Murcia-994 | blastn | 700 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Bartramiales | Bartramiaceae | Anacolia | Anacolia laevisphaera | |
| 716711 | 716711 | PRJNA734313_S_NODE_3661_length_436_cov_10.195373_g3553_i0 | PRJNA734313 | 3661 | 436 | 10.195373 | 44.45182628 | Malus domestica | 3750 | Plants | Plants | 58.4 | 0.001 | NTclustered | gi|2810943376|gb|CP168774.1| | 3750 | g3553 | i0 | 97.059 | 0.0779816513761468 | 34 | 1 | 8 | 0 | 386 | 419 | 7388809 | 7388776 | Malus domestica cultivar Golden Delicious chromosome 10 | blastn | 34 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 1196720 | 1196720 | PRJNA734313_S_NODE_10361_length_291_cov_3.581967_g10248_i0 | PRJNA734313 | 10361 | 291 | 3.581967 | 10.42352397 | Brassica | 3705 | Plants | Plants | 60.2 | 1.61e-4 | NTclustered | gi|2258341992|ref|XM_013833021.3| | 3708 | g10248 | i0 | 100 | 4.553264604811 | 32 | 0 | 11 | 0 | 86 | 117 | 557 | 588 | PREDICTED: Brassica napus phosphopantothenoylcysteine decarboxylase subunit VHS3 (LOC106392219), mRNA | blastn | 1325 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 2472116 | 2472116 | PRJNA734313_S_NODE_20562_length_206_cov_0.962264_g20449_i0 | PRJNA734313 | 20562 | 206 | 0.962264 | 1.98226384 | Eukaryota | 2759 | Plants | Plants | 58.4 | 3.87e-4 | NTclustered | gi|2258318110|ref|XM_013822454.3| | 3708 | g20449 | i0 | 97.059 | 2.20873786407767 | 34 | 1 | 17 | 0 | 132 | 165 | 1099 | 1132 | PREDICTED: Brassica napus nucleosome assembly protein 1;2 (LOC106382434), transcript variant X2, mRNA | blastn | 455 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 4545187 | 4545187 | PRJNA734313_S_NODE_17004_length_227_cov_1.505556_g16891_i0 | PRJNA734313 | 17004 | 227 | 1.505556 | 3.41761212 | Picea abies | 3329 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2835530376|dbj|LC777199.1| | 3329 | g16891 | i0 | 96.97 | 0.268722466960352 | 33 | 1 | 15 | 0 | 1 | 33 | 377 | 409 | Picea abies Pa-Kumamoto-2022 PaDdl mRNA for D-alanine-D-alanine ligase, complete cds | blastn | 61 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 5820288 | 5820288 | PRJNA734313_S_NODE_19845_length_209_cov_8.561728_g19732_i0 | PRJNA734313 | 19845 | 209 | 8.561728 | 17.89401152 | Zingiber officinale | 94328 | Plants | Plants | 60.2 | 1.1e-4 | NTclustered | gi|2070000340|ref|XR_006114785.1| | 94328 | g19732 | i0 | 100 | 0.425837320574163 | 32 | 0 | 15 | 0 | 1 | 32 | 174 | 205 | PREDICTED: Zingiber officinale uncharacterized LOC121991958 (LOC121991958), ncRNA | blastn | 89 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Zingiberaceae | Zingiber | Zingiber officinale | |
| 6300819 | 6300819 | PRJNA734313_S_NODE_14085_length_251_cov_1.210784_g13972_i0 | PRJNA734313 | 14085 | 251 | 1.210784 | 3.03906784 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g13972 | i0 | 100 | 0.350597609561753 | 28 | 0 | 11 | 0 | 1 | 28 | 6 | 33 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 88 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 7095388 | 7095388 | PRJNA734313_S_NODE_26786_length_179_cov_1.159091_g26673_i0 | PRJNA734313 | 26786 | 179 | 1.159091 | 2.07477289 | Dendrobium officinale | 142615 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|855403370|gb|KP009862.1| | 142615 | g26673 | i0 | 100 | 0.810055865921788 | 30 | 0 | 17 | 0 | 150 | 179 | 79 | 50 | Dendrobium catenatum somatic embryogenesis receptor kinase protein (SERK) mRNA, complete cds | blastn | 145 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Dendrobium | Dendrobium officinale | |
| 7574679 | 7574679 | PRJNA734313_S_NODE_1926_length_531_cov_6.960744_g1821_i0 | PRJNA734313 | 1926 | 531 | 6.960744 | 36.96155064 | Eukaryota | 2759 | Plants | Plants | 54.7 | 0.014 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g1821 | i0 | 100 | 0.188323917137476 | 29 | 0 | 5 | 0 | 503 | 531 | 34 | 6 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 100 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 9645183 | 9645183 | PRJNA734313_S_NODE_24668_length_187_cov_1.457143_g24555_i0 | PRJNA734313 | 24668 | 187 | 1.457143 | 2.72485741 | Eragrostis tef | 110835 | Plants | Plants | 228 | 2.4799999999999995e-55 | NTclustered | gi|2710185566|gb|CP137595.1| | 110835 | g24555 | i0 | 90.23 | 0.93048128342246 | 174 | 17 | 93 | 0 | 14 | 187 | 22658282 | 22658109 | Eragrostis tef cultivar Dabbi chromosome 7B | blastn | 174 | 228 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eragrostis | Eragrostis tef | |
| 11400467 | 11400467 | PRJNA734313_S_NODE_21069_length_203_cov_1.602564_g20956_i0 | PRJNA734313 | 21069 | 203 | 1.602564 | 3.25320492 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.018 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g20956 | i0 | 100 | 0.413793103448276 | 28 | 0 | 14 | 0 | 176 | 203 | 33 | 6 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 11400468 | 11400468 | PRJNA734313_S_NODE_21329_length_202_cov_1.012903_g21216_i0 | PRJNA734313 | 21329 | 202 | 1.012903 | 2.04606406 | Eukaryota | 2759 | Plants | Plants | 363 | 7.149999999999999e-96 | NTclustered | gi|2249528557|gb|ON685378.1| | 29818 | g21216 | i0 | 99.01 | 100 | 202 | 2 | 100 | 0 | 1 | 202 | 2401 | 2200 | Plantago major isolate BPTPS058 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 | 20200 | 363 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Plantaginaceae | Plantago | Plantago major | |
| 14745628 | 14745628 | PRJNA734313_S_NODE_15792_length_236_cov_9.285714_g15679_i0 | PRJNA734313 | 15792 | 236 | 9.285714 | 21.91428504 | Cannabis sativa | 3483 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2748511602|gb|CP158658.1| | 3483 | g15679 | i0 | 100 | 0.241525423728814 | 29 | 0 | 12 | 0 | 133 | 161 | 3771578 | 3771606 | Cannabis sativa cultivar ERBxHO40_23 chromosome 7 | blastn | 57 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 15225325 | 15225325 | PRJNA734313_S_NODE_16572_length_230_cov_2.830601_g16459_i0 | PRJNA734313 | 16572 | 230 | 2.830601 | 6.5103823 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.021 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g16459 | i0 | 100 | 0.243478260869565 | 28 | 0 | 12 | 0 | 203 | 230 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 16499779 | 16499779 | PRJNA734313_S_NODE_5333_length_385_cov_4.298817_g5221_i0 | PRJNA734313 | 5333 | 385 | 4.298817 | 16.55044545 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.037 | NTclustered | gi|2835530366|dbj|LC777195.1| | 3329 | g5221 | i0 | 100 | 0.290909090909091 | 28 | 0 | 7 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds | blastn | 112 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 17294743 | 17294743 | PRJNA734313_S_NODE_15774_length_237_cov_1.078947_g15661_i0 | PRJNA734313 | 15774 | 237 | 1.078947 | 2.55710439 | Lilium hybrid cultivar | 156531 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|1789804197|gb|MF101406.2| | 156531 | g15661 | i0 | 100 | 0.476793248945148 | 29 | 0 | 12 | 0 | 1 | 29 | 30 | 58 | Lilium hybrid cultivar soluble starch synthase (SSS) mRNA, complete cds | blastn | 113 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Liliales | Liliaceae | Lilium | Lilium hybrid cultivar | |
| 17294755 | 17294755 | PRJNA734313_S_NODE_24554_length_187_cov_8.414286_g24441_i0 | PRJNA734313 | 24554 | 187 | 8.414286 | 15.73471482 | Cunninghamia lanceolata | 28977 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|1826605616|gb|MK585475.1| | 28977 | g24441 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 3 | 30 | 1 | 28 | Cunninghamia lanceolata pectin methylesterase 8 (PME8) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cunninghamia | Cunninghamia lanceolata | |
| 17774529 | 17774529 | PRJNA734313_S_NODE_23134_length_193_cov_3.397260_g23021_i0 | PRJNA734313 | 23134 | 193 | 3.39726 | 6.5567118 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.017 | NTclustered | gi|2835530370|dbj|LC777197.1| | 3329 | g23021 | i0 | 100 | 0.725388601036269 | 28 | 0 | 15 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 17774532 | 17774532 | PRJNA734313_S_NODE_25694_length_183_cov_1.250000_g25581_i0 | PRJNA734313 | 25694 | 183 | 1.25 | 2.2875 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|2835530376|dbj|LC777199.1| | 3329 | g25581 | i0 | 100 | 0.306010928961749 | 28 | 0 | 15 | 0 | 156 | 183 | 404 | 377 | Picea abies Pa-Kumamoto-2022 PaDdl mRNA for D-alanine-D-alanine ligase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 17774536 | 17774536 | PRJNA734313_S_NODE_7134_length_344_cov_2.377104_g7021_i0 | PRJNA734313 | 7134 | 344 | 2.377104 | 8.17723776 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.033 | NTclustered | gi|1228858195|ref|XM_022129704.1| | 4232 | g7021 | i0 | 100 | 0.261627906976744 | 28 | 0 | 8 | 0 | 65 | 92 | 615 | 588 | PREDICTED: Helianthus annuus kinesin-related protein 4-like (LOC110881447), mRNA | blastn | 90 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 20323278 | 20323278 | PRJNA734313_S_NODE_7236_length_342_cov_1.210169_g7123_i0 | PRJNA734313 | 7236 | 342 | 1.210169 | 4.13877798 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.032 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g7123 | i0 | 100 | 0.16374269005848 | 28 | 0 | 8 | 0 | 315 | 342 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 22394224 | 22394224 | PRJNA734313_S_NODE_12618_length_264_cov_13.686636_g12505_i0 | PRJNA734313 | 12618 | 264 | 13.686636 | 36.13271904 | Luculia yunnanensis | 1043446 | Plants | Plants | 52.8 | 0.024 | NTclustered | gi|363453795|gb|JN871303.1| | 1043446 | g12505 | i0 | 96.774 | 0.117424242424242 | 31 | 1 | 12 | 0 | 38 | 68 | 59 | 89 | Luculia yunnanensis clone MH8 microsatellite sequence | blastn | 31 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Gentianales | Rubiaceae | Luculia | Luculia yunnanensis | |
| 22874221 | 22874221 | PRJNA734313_S_NODE_11538_length_276_cov_11.078603_g11425_i0 | PRJNA734313 | 11538 | 276 | 11.078603 | 30.57694428 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.025 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g11425 | i0 | 100 | 0.202898550724638 | 28 | 0 | 10 | 0 | 249 | 276 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 22874226 | 22874226 | PRJNA734313_S_NODE_15718_length_237_cov_1.815789_g15605_i0 | PRJNA734313 | 15718 | 237 | 1.815789 | 4.30341993 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.021 | NTclustered | gi|2835530370|dbj|LC777197.1| | 3329 | g15605 | i0 | 100 | 0.725738396624473 | 28 | 0 | 12 | 0 | 210 | 237 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds | blastn | 172 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 23669761 | 23669761 | PRJNA734313_S_NODE_4539_length_408_cov_7.049861_g4428_i0 | PRJNA734313 | 4539 | 408 | 7.049861 | 28.76343288 | Triticum aestivum | 4565 | Plants | Plants | 56.5 | 0.003 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g4428 | i0 | 100 | 0.281862745098039 | 30 | 0 | 7 | 0 | 1 | 30 | 6 | 35 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 115 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 24943150 | 24943150 | PRJNA734313_S_NODE_12480_length_266_cov_2.100457_g12367_i0 | PRJNA734313 | 12480 | 266 | 2.100457 | 5.58721562 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.024 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g12367 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 1 | 28 | 29 | 56 | 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 | |
| 25423417 | 25423417 | PRJNA734313_S_NODE_7080_length_345_cov_2.929530_g6967_i0 | PRJNA734313 | 7080 | 345 | 2.92953 | 10.1068785 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.033 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g6967 | i0 | 100 | 0.16231884057971 | 28 | 0 | 8 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies |
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);;