contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA929952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1254773 | 1254773 | PRJNA929952_P_NODE_18101_length_233_cov_8.352941_g16807_i0 | PRJNA929952 | 18101 | 233 | 8.352941 | 19.46235253 | Eukaryota | 2759 | Plants | Plants | 431 | 2.2899999999999996e-116 | NTclustered | gi|1777704|gb|U42794.1|POU42794 | 4403 | g16807 | i0 | 100 | 99.9742489270386 | 233 | 0 | 100 | 0 | 1 | 233 | 862 | 630 | Platanus occidentalis 18S ribosomal RNA gene, partial sequence | blastn | 23294 | 431 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Platanaceae | Platanus | Platanus occidentalis | |
| 5083118 | 5083118 | PRJNA929952_P_NODE_3884_length_633_cov_23.476821_g2986_i0 | PRJNA929952 | 3884 | 633 | 23.476821 | 148.60827693 | Thismia | 147077 | Plants | Plants | 141 | 1.3e-28 | NTclustered | gi|1464923131|gb|MG008378.1| | 2305413 | g2986 | i0 | 89.286 | 1.95734597156398 | 112 | 12 | 18 | 0 | 174 | 285 | 776 | 665 | Thismia acuminata isolate Bor6/17 26S ribosomal RNA gene, partial sequence | blastn | 1239 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Dioscoreales | Thismiaceae | Thismia | Thismia acuminata | |
| 6012410 | 6012410 | PRJNA929952_P_NODE_21305_length_190_cov_2.869565_g20011_i0 | PRJNA929952 | 21305 | 190 | 2.869565 | 5.4521735 | Lotus japonicus | 34305 | Plants | Plants | 339 | 1.12e-88 | NTclustered | gi|388505617|gb|BT141081.1| | 34305 | g20011 | i0 | 98.942 | 37.1368421052632 | 189 | 2 | 99 | 0 | 2 | 190 | 276 | 88 | Lotus japonicus clone JCVI-FLLj-20H3 unknown mRNA | blastn | 7056 | 339 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 6012431 | 6012431 | PRJNA929952_P_NODE_6865_length_467_cov_8.408676_g1757_i1 | PRJNA929952 | 6865 | 467 | 8.408676 | 39.26851692 | Meryta sinclairii | 46403 | Plants | Plants | 126 | 2.64e-24 | NTclustered | gi|37778878|gb|AY189086.1| | 46403 | g1757 | i1 | 86.726 | 0.777301927194861 | 113 | 15 | 24 | 0 | 218 | 330 | 1922 | 1810 | Meryta sinclairii 26S large subunit ribosomal RNA gene, partial sequence | blastn | 363 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Araliaceae | Meryta | Meryta sinclairii | |
| 6358826 | 6358826 | PRJNA929952_P_NODE_22925_length_169_cov_5.521429_g21631_i0 | PRJNA929952 | 22925 | 169 | 5.521429 | 9.33121501 | Magnoliopsida | 3398 | Plants | Plants | 298 | 1.64e-76 | NTclustered | gi|1721134033|emb|LR130855.1| | 38872 | g21631 | i0 | 100 | 95.4674556213018 | 161 | 0 | 95 | 0 | 1 | 161 | 4113 | 3953 | Fraxinus americana genomic DNA containing ETS-18S-ITS1-5.8S-ITS2-26S region, specimen voucher R.E. Weaver & J. Nickerson 968-79 (A) | blastn | 16134 | 300 | 0.993333333333333 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Fraxinus | Fraxinus americana | |
| 8907604 | 8907604 | PRJNA929952_P_NODE_22287_length_176_cov_6.469388_g20993_i0 | PRJNA929952 | 22287 | 176 | 6.469388 | 11.38612288 | Fraxinus | 38871 | Plants | Plants | 250 | 4.91e-62 | NTclustered | gi|1721134040|emb|LR130862.1| | 38874 | g20993 | i0 | 91.579 | 107.744318181818 | 190 | 2 | 100 | 1 | 1 | 176 | 3252 | 3063 | Fraxinus ornus genomic DNA containing ETS-18S-ITS1-5.8S-ITS2-26S region, specimen voucher Kepos 45349 (K) | blastn | 18963 | 250 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Fraxinus | Fraxinus ornus | |
| 8907609 | 8907609 | PRJNA929952_P_NODE_23047_length_168_cov_2.582734_g21753_i0 | PRJNA929952 | 23047 | 168 | 2.582734 | 4.33899312 | Magnoliopsida | 3398 | Plants | Plants | 311 | 2.11e-80 | NTclustered | gi|2742370619|gb|PP274534.1| | 3694 | g21753 | i0 | 100 | 199 | 168 | 0 | 100 | 0 | 1 | 168 | 106754 | 106921 | Populus trichocarpa chloroplast, complete genome | blastn | 33432 | 311 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus trichocarpa | |
| 11112775 | 11112775 | PRJNA929952_P_NODE_12249_length_313_cov_7.665493_g10956_i0 | PRJNA929952 | 12249 | 313 | 7.665493 | 23.99299309 | Medicago truncatula | 3880 | Plants | Plants | 224 | 5.86e-54 | NTclustered | gi|90656477|gb|DQ455530.1| | 3880 | g10956 | i0 | 91.463 | 6.21086261980831 | 164 | 12 | 52 | 2 | 7 | 170 | 22 | 183 | Medicago truncatula cDNA-AFLP fragment BT43M22_480 sequence | blastn | 1944 | 224 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Medicago | Medicago truncatula | |
| 11112820 | 11112820 | PRJNA929952_P_NODE_7609_length_439_cov_14.968293_g6385_i0 | PRJNA929952 | 7609 | 439 | 14.968293 | 65.71080627 | Platanus occidentalis | 4403 | Plants | Plants | 673 | 0 | NTclustered | gi|9799460|gb|AF274662.1| | 4403 | g6385 | i0 | 99.459 | 84.5580865603645 | 370 | 2 | 84 | 0 | 1 | 370 | 1868 | 1499 | Platanus occidentalis 26S ribosomal RNA gene, complete sequence | blastn | 37121 | 673 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Platanaceae | Platanus | Platanus occidentalis | |
| 14008796 | 14008796 | PRJNA929952_P_NODE_21631_length_186_cov_1.955414_g20337_i0 | PRJNA929952 | 21631 | 186 | 1.955414 | 3.63707004 | Eukaryota | 2759 | Plants | Plants | 69.4 | 1.58e-7 | NTclustered | gi|1767162939|gb|MN585746.1| | 3144 | g20337 | i0 | 93.617 | 23.2956989247312 | 47 | 2 | 25 | 1 | 98 | 144 | 882 | 927 | Chlorokybus atmophyticus isolate SAG 48.80 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 | 4333 | 69.4 | 1 | Eukaryota | Viridiplantae | Streptophyta | Chlorokybophyceae | Chlorokybales | Chlorokybaceae | Chlorokybus | Chlorokybus atmophyticus | ||
| 14937111 | 14937111 | PRJNA929952_P_NODE_19772_length_214_cov_3.962162_g18478_i0 | PRJNA929952 | 19772 | 214 | 3.962162 | 8.47902668 | Avellara fistulosa | 1940801 | Plants | Plants | 82.4 | 2.4e-11 | NTclustered | gi|2918392936|emb|OZ238137.1| | 1940801 | g18478 | i0 | 77.059 | 1.72897196261682 | 170 | 21 | 78 | 14 | 6 | 171 | 87616021 | 87616176 | Avellara fistulosa genome assembly, chromosome: 5 | blastn | 370 | 82.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Avellara | Avellara fistulosa | |
| 14937135 | 14937135 | PRJNA929952_P_NODE_7072_length_459_cov_22.520930_g5879_i0 | PRJNA929952 | 7072 | 459 | 22.52093 | 103.3710687 | Lolium perenne | 4522 | Plants | Plants | 67.6 | 1.59e-6 | NTclustered | gi|2922501898|ref|XR_007861731.2| | 4522 | g5879 | i0 | 100 | 0.459694989106754 | 36 | 0 | 8 | 0 | 422 | 457 | 409 | 374 | PREDICTED: Lolium perenne 28S ribosomal RNA (LOC127318176), rRNA | blastn | 211 | 67.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 17487421 | 17487421 | PRJNA929952_P_NODE_18114_length_233_cov_3.906863_g16820_i0 | PRJNA929952 | 18114 | 233 | 3.906863 | 9.10299079 | Cannabis sativa | 3483 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|2748540810|gb|CP158644.1| | 3483 | g16820 | i0 | 100 | 0.240343347639485 | 28 | 0 | 12 | 0 | 135 | 162 | 27755581 | 27755608 | Cannabis sativa cultivar ERBxHO40_23 chromosome 5 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 17487438 | 17487438 | PRJNA929952_P_NODE_2394_length_777_cov_13.542781_g1757_i0 | PRJNA929952 | 2394 | 777 | 13.542781 | 105.22740837 | Meryta sinclairii | 46403 | Plants | Plants | 126 | 4.53e-24 | NTclustered | gi|37778878|gb|AY189086.1| | 46403 | g1757 | i0 | 86.726 | 0.459459459459459 | 113 | 15 | 15 | 0 | 218 | 330 | 1922 | 1810 | Meryta sinclairii 26S large subunit ribosomal RNA gene, partial sequence | blastn | 357 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Araliaceae | Meryta | Meryta sinclairii | |
| 18760765 | 18760765 | PRJNA929952_P_NODE_17515_length_239_cov_2.285714_g16221_i0 | PRJNA929952 | 17515 | 239 | 2.285714 | 5.46285646 | Lotus japonicus | 34305 | Plants | Plants | 178 | 3.4e-40 | NTclustered | gi|388514026|gb|BT145281.1| | 34305 | g16221 | i0 | 93.443 | 0.510460251046025 | 122 | 4 | 49 | 2 | 1 | 118 | 680 | 559 | Lotus japonicus clone JCVI-FLLj-5K6 unknown mRNA | blastn | 122 | 178 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 20381144 | 20381144 | PRJNA929952_P_NODE_21116_length_193_cov_2.268293_g19822_i0 | PRJNA929952 | 21116 | 193 | 2.268293 | 4.37780549 | Magnoliopsida | 3398 | Plants | Plants | 357 | 3.1499999999999996e-94 | NTclustered | gi|66969392|gb|DQ008804.1| | 3426 | g19822 | i0 | 100 | 105 | 193 | 0 | 100 | 0 | 1 | 193 | 1343 | 1151 | Canella winterana large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 20265 | 357 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Canellales | Canellaceae | Canella | Canella winterana | |
| 22932619 | 22932619 | PRJNA929952_P_NODE_12978_length_299_cov_5.255556_g11685_i0 | PRJNA929952 | 12978 | 299 | 5.255556 | 15.71411244 | Magnoliopsida | 3398 | Plants | Plants | 351 | 2.45e-92 | NTclustered | gi|9799460|gb|AF274662.1| | 4403 | g11685 | i0 | 95.475 | 96.6755852842809 | 221 | 9 | 97 | 1 | 80 | 299 | 3132 | 3352 | Platanus occidentalis 26S ribosomal RNA gene, complete sequence | blastn | 28906 | 351 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Platanaceae | Platanus | Platanus occidentalis | |
| 23861459 | 23861459 | PRJNA929952_P_NODE_20059_length_209_cov_9.672222_g18765_i0 | PRJNA929952 | 20059 | 209 | 9.672222 | 20.21494398 | Coleochaete pulvinata | 173054 | Plants | Plants | 100 | 6.45e-17 | NTclustered | gi|992369556|gb|KU130816.1| | 173054 | g18765 | i0 | 89.157 | 30.0717703349282 | 83 | 6 | 39 | 2 | 129 | 209 | 5757 | 5838 | Coleochaete pulvinata strain 56a6 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 6285 | 100 | 1 | Eukaryota | Viridiplantae | Streptophyta | Coleochaetophyceae | Coleochaetales | Coleochaetaceae | Coleochaete | Coleochaete pulvinata | ||
| 23861465 | 23861465 | PRJNA929952_P_NODE_23099_length_167_cov_4.913043_g21805_i0 | PRJNA929952 | 23099 | 167 | 4.913043 | 8.20478181 | Medicago truncatula | 3880 | Plants | Plants | 211 | 2.18e-50 | NTclustered | gi|90656068|gb|DQ455121.1| | 3880 | g21805 | i0 | 90.361 | 41.5988023952096 | 166 | 9 | 99 | 5 | 2 | 166 | 9 | 168 | Medicago truncatula cDNA-AFLP fragment BC21M12_49 sequence | blastn | 6947 | 211 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Medicago | Medicago truncatula | |
| 24206372 | 24206372 | PRJNA929952_P_NODE_11779_length_323_cov_4.578231_g10486_i0 | PRJNA929952 | 11779 | 323 | 4.578231 | 14.78768613 | Magnoliopsida | 3398 | Plants | Plants | 582 | 8.699999999999998e-162 | NTclustered | gi|66969353|gb|DQ008765.1| | 3472 | g10486 | i0 | 99.377 | 113.684210526316 | 321 | 2 | 99 | 0 | 3 | 323 | 1044 | 724 | Sanguinaria canadensis large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 36720 | 582 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Sanguinaria | Sanguinaria canadensis | |
| 24206389 | 24206389 | PRJNA929952_P_NODE_19399_length_220_cov_2.586387_g18105_i0 | PRJNA929952 | 19399 | 220 | 2.586387 | 5.6900514 | Macadamia | 4329 | Plants | Plants | 407 | 3.61e-109 | NTclustered | gi|2072687540|gb|MW566571.1| | 4330 | g18105 | i0 | 100 | 130.422727272727 | 220 | 0 | 100 | 0 | 1 | 220 | 12584 | 12365 | Macadamia ternifolia mitochondrion, complete genome | blastn | 28693 | 407 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Proteaceae | Macadamia | Macadamia ternifolia | |
| 25135280 | 25135280 | PRJNA929952_P_NODE_11840_length_322_cov_2.784983_g10547_i0 | PRJNA929952 | 11840 | 322 | 2.784983 | 8.96764526 | Hordeum vulgare | 4513 | Plants | Plants | 143 | 1.74e-29 | NTclustered | gi|326496930|dbj|AK367289.1| | 112509 | g10547 | i0 | 86.466 | 27.3167701863354 | 133 | 14 | 40 | 2 | 1 | 129 | 681 | 549 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2054B13 | blastn | 8796 | 143 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 25135300 | 25135300 | PRJNA929952_P_NODE_20880_length_196_cov_2.874251_g19586_i0 | PRJNA929952 | 20880 | 196 | 2.874251 | 5.63353196 | Olea paniculata | 126553 | Plants | Plants | 357 | 3.2099999999999996e-94 | NTclustered | gi|2890973707|gb|OK244395.1| | 126553 | g19586 | i0 | 99.49 | 100 | 196 | 1 | 100 | 0 | 1 | 196 | 3599 | 3794 | Olea paniculata voucher P:B.C. Sen 73 (P00444406) external transcribed spacer, partial sequence; 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; and external transcribed spacer, partial sequence | blastn | 19600 | 357 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Olea | Olea paniculata |
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);;