contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA383995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3626525 | 3626525 | PRJNA383995_P_NODE_17663_length_163_cov_0.894737_g17564_i0 | PRJNA383995 | 17663 | 163 | 0.894737 | 1.45842131 | Triticum | 4564 | Plants | Plants | 248 | 1.61e-61 | NTclustered | gi|300681419|emb|FN564427.1| | 4565 | g17564 | i0 | 94.41 | 27.0736196319018 | 161 | 9 | 100 | 0 | 2 | 162 | 590177 | 590337 | Triticum aestivum chromosome 3B-specific BAC library, contig ctg0079b | blastn | 4413 | 250 | 0.992 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 3626541 | 3626541 | PRJNA383995_P_NODE_9663_length_209_cov_2.468750_g9564_i0 | PRJNA383995 | 9663 | 209 | 2.46875 | 5.1596875 | Vigna | 3913 | Plants | Plants | 387 | 4.42e-103 | NTclustered | gi|2688570838|gb|CP144689.1| | 3915 | g9564 | i0 | 100 | 157.052631578947 | 209 | 0 | 100 | 0 | 1 | 209 | 1386921 | 1387129 | Vigna mungo isolate Urdbean chloroplast, partial sequence | blastn | 32824 | 387 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna mungo | |
| 5508962 | 5508962 | PRJNA383995_P_NODE_17605_length_163_cov_0.894737_g17506_i0 | PRJNA383995 | 17605 | 163 | 0.894737 | 1.45842131 | Oryza sativa | 4530 | Plants | Plants | 300 | 4.39e-77 | NTclustered | gi|30725921|gb|AC099043.6| | 39947 | g17506 | i0 | 100 | 6.20245398773006 | 162 | 0 | 99 | 0 | 2 | 163 | 70206 | 70045 | Oryza sativa chromosome 3 BAC OSJNBa0079B15 genomic sequence, complete sequence | blastn | 1011 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 9333359 | 9333359 | PRJNA383995_P_NODE_6248_length_254_cov_1.180488_g6149_i0 | PRJNA383995 | 6248 | 254 | 1.180488 | 2.99843952 | Ananas comosus | 4615 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|1885257722|emb|LR862139.1| | 296719 | g6149 | i0 | 100 | 0.114173228346457 | 29 | 0 | 11 | 0 | 5 | 33 | 19294046 | 19294018 | Ananas comosus var. bracteatus genome assembly, chromosome: 11 | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 11883968 | 11883968 | PRJNA383995_P_NODE_7270_length_237_cov_1.803191_g7171_i0 | PRJNA383995 | 7270 | 237 | 1.803191 | 4.27356267 | Cannabis sativa | 3483 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2748541248|gb|CP158646.1| | 3483 | g7171 | i0 | 100 | 0.379746835443038 | 30 | 0 | 13 | 0 | 119 | 148 | 75903640 | 75903611 | Cannabis sativa cultivar ERBxHO40_23 chromosome 3 | blastn | 90 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 13159003 | 13159003 | PRJNA383995_P_NODE_19171_length_161_cov_0.910714_g19072_i0 | PRJNA383995 | 19171 | 161 | 0.910714 | 1.46624954 | Allium sativum | 4682 | Plants | Plants | 171 | 3.54e-38 | NTclustered | gi|2221770600|gb|MK770769.1| | 4682 | g19072 | i0 | 93.103 | 0.720496894409938 | 116 | 8 | 72 | 0 | 1 | 116 | 116 | 1 | Allium sativum satellite AsatSAT189 sequence | blastn | 116 | 171 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Amaryllidaceae | Allium | Allium sativum | |
| 13829288 | 13829288 | PRJNA383995_P_NODE_9731_length_209_cov_1.093750_g9632_i0 | PRJNA383995 | 9731 | 209 | 1.09375 | 2.2859375 | Poaceae | 4479 | Plants | Plants | 52.8 | 0.018 | NTclustered | gi|1897958810|ref|XR_004853261.1| | 4577 | g9632 | i0 | 100 | 0.669856459330144 | 28 | 0 | 13 | 0 | 155 | 182 | 182 | 209 | PREDICTED: Zea mays uncharacterized lncRNA (LOC118473579), transcript variant X2, ncRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 16378297 | 16378297 | PRJNA383995_P_NODE_18433_length_162_cov_0.902655_g18334_i0 | PRJNA383995 | 18433 | 162 | 0.902655 | 1.4623011 | Poaceae | 4479 | Plants | Plants | 300 | 4.36e-77 | NTclustered | gi|2155905707|emb|OV049916.1| | 4529 | g18334 | i0 | 100 | 101 | 162 | 0 | 100 | 0 | 1 | 162 | 49167 | 49006 | Oryza rufipogon genome assembly, organelle: plastid:chloroplast | blastn | 16362 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza rufipogon | |
| 16378299 | 16378299 | PRJNA383995_P_NODE_18993_length_161_cov_0.910714_g18894_i0 | PRJNA383995 | 18993 | 161 | 0.910714 | 1.46624954 | Magnoliopsida | 3398 | Plants | Plants | 298 | 1.56e-76 | NTclustered | gi|2646016675|ref|XR_009883389.1| | 3486 | g18894 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 1452 | 1612 | PREDICTED: Humulus lupulus 18S ribosomal RNA (LOC133811861), rRNA | blastn | 16100 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 18256770 | 18256770 | PRJNA383995_P_NODE_13195_length_181_cov_1.515152_g13096_i0 | PRJNA383995 | 13195 | 181 | 1.515152 | 2.74242512 | Triticum aestivum | 4565 | Plants | Plants | 335 | 1.36e-87 | NTclustered | gi|2123746588|ref|XR_006435168.1| | 4565 | g13096 | i0 | 100 | 2 | 181 | 0 | 100 | 0 | 1 | 181 | 5608 | 5428 | PREDICTED: Triticum aestivum homeobox protein cut-like 1 (LOC123072473), transcript variant X4, misc_RNA | blastn | 362 | 335 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 18256782 | 18256782 | PRJNA383995_P_NODE_16555_length_165_cov_0.879310_g16456_i0 | PRJNA383995 | 16555 | 165 | 0.87931 | 1.4508615 | Cicer arietinum | 3827 | Plants | Plants | 305 | 9.59e-79 | NTclustered | gi|1535865752|ref|XM_004494231.3| | 3827 | g16456 | i0 | 100 | 53.3393939393939 | 165 | 0 | 100 | 0 | 1 | 165 | 105 | 269 | PREDICTED: Cicer arietinum 60S ribosomal protein L35a-1-like (LOC101514440), mRNA | blastn | 8801 | 305 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Cicer | Cicer arietinum | |
| 22081734 | 22081734 | PRJNA383995_P_NODE_18558_length_162_cov_0.902655_g18459_i0 | PRJNA383995 | 18558 | 162 | 0.902655 | 1.4623011 | Malus domestica | 3750 | Plants | Plants | 52.8 | 0.013 | NTclustered | gi|2810943380|gb|CP168778.1| | 3750 | g18459 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 18 | 45 | 20799741 | 20799714 | Malus domestica cultivar Golden Delicious chromosome 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 24631669 | 24631669 | PRJNA383995_P_NODE_18280_length_162_cov_0.902655_g18181_i0 | PRJNA383995 | 18280 | 162 | 0.902655 | 1.4623011 | Triticum monococcum | 4568 | Plants | Plants | 246 | 5.76e-61 | NTclustered | gi|2581912921|emb|OY737857.1| | 4568 | g18181 | i0 | 98.561 | 121.493827160494 | 139 | 2 | 86 | 0 | 24 | 162 | 33139502 | 33139364 | Triticum monococcum genome assembly, chromosome: UA | blastn | 19682 | 246 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum monococcum |
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);;