contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA290839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372910 | 372910 | PRJNA290839_P_NODE_601_length_330_cov_1.684825_g580_i0 | PRJNA290839 | 601 | 330 | 1.684825 | 5.5599225 | Oryza sativa | 4530 | Plants | Plants | 510 | 4.26e-140 | NTclustered | gi|32993583|dbj|AK108374.1| | 39947 | g580 | i0 | 94.545 | 66.9727272727273 | 330 | 18 | 100 | 0 | 1 | 330 | 671 | 342 | Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence | blastn | 22101 | 510 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 9300980 | 9300980 | PRJNA290839_P_NODE_728_length_300_cov_3.409692_g707_i0 | PRJNA290839 | 728 | 300 | 3.409692 | 10.229076 | Oryza sativa | 4530 | Plants | Plants | 481 | 2.999999999999999e-131 | NTclustered | gi|116641691|emb|CT837030.1| | 39946 | g707 | i0 | 95.652 | 0.996666666666667 | 299 | 13 | 99 | 0 | 1 | 299 | 16 | 314 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCPI012C10, full insert sequence | blastn | 299 | 481 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 11851579 | 11851579 | PRJNA290839_P_NODE_50_length_1372_cov_3.555812_g33_i0 | PRJNA290839 | 50 | 1372 | 3.555812 | 48.78574064 | Oryza sativa | 4530 | Plants | Plants | 1105 | 0 | NTclustered | gi|32993583|dbj|AK108374.1| | 39947 | g33 | i0 | 91.076 | 48.7463556851312 | 818 | 72 | 60 | 1 | 555 | 1372 | 1 | 817 | Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence | blastn | 66880 | 1105 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 12537998 | 12537998 | PRJNA290839_P_NODE_890_length_271_cov_1.570707_g869_i0 | PRJNA290839 | 890 | 271 | 1.570707 | 4.25661597 | Poaceae | 4479 | Plants | Plants | 501 | 2.05e-137 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g869 | i0 | 100 | 192 | 271 | 0 | 100 | 0 | 1 | 271 | 97769 | 97499 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 52032 | 501 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 16361968 | 16361968 | PRJNA290839_P_NODE_973_length_257_cov_1.684783_g952_i0 | PRJNA290839 | 973 | 257 | 1.684783 | 4.32989231 | Streptophyta | 35493 | Plants | Plants | 161 | 3.72e-35 | NTclustered | gi|1173203591|dbj|AK407401.1| | 3369 | g952 | i0 | 78.175 | 58.0972762645914 | 252 | 55 | 98 | 0 | 2 | 253 | 307 | 558 | Cryptomeria japonica mRNA, clone: CFFL011_E08, expressed in female strobili | blastn | 14931 | 161 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 21461252 | 21461252 | PRJNA290839_P_NODE_957_length_259_cov_1.344086_g936_i0 | PRJNA290839 | 957 | 259 | 1.344086 | 3.48118274 | Poaceae | 4479 | Plants | Plants | 479 | 9.13e-131 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g936 | i0 | 100 | 196 | 259 | 0 | 100 | 0 | 1 | 259 | 96521 | 96779 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 50764 | 479 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 23324952 | 23324952 | PRJNA290839_P_NODE_1299_length_248_cov_0.885714_g1278_i0 | PRJNA290839 | 1299 | 248 | 0.885714 | 2.19657072 | Populus nigra | 3691 | Plants | Plants | 145 | 3.6e-30 | NTclustered | gi|2645385715|ref|XM_062107710.1| | 3691 | g1278 | i0 | 80.952 | 52.2661290322581 | 189 | 30 | 75 | 6 | 49 | 234 | 331 | 146 | PREDICTED: Populus nigra large ribosomal subunit protein uL15x-like (LOC133688281), mRNA | blastn | 12962 | 145 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus nigra |
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);;