contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA781427" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 760421 | 760421 | PRJNA781427_P_NODE_33961_length_396_cov_0.953560_g33080_i0 | PRJNA781427 | 33961 | 396 | 0.95356 | 3.7760976 | Chlorella variabilis | 554065 | Plants | Plants | 228 | 5.869999999999998e-55 | NTclustered | gi|552840926|ref|XM_005850117.1| | 554065 | g33080 | i0 | 79.341 | 68.8030303030303 | 334 | 61 | 83 | 8 | 67 | 396 | 81 | 410 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_56045) mRNA, complete cds | blastn | 27246 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 8413514 | 8413514 | PRJNA781427_P_NODE_32947_length_402_cov_2.340426_g32066_i0 | PRJNA781427 | 32947 | 402 | 2.340426 | 9.40851252 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|2082243632|ref|XM_043061492.1| | 3055 | g32066 | i0 | 100 | 0.0721393034825871 | 29 | 0 | 7 | 0 | 328 | 356 | 938 | 966 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g205800v5), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10964261 | 10964261 | PRJNA781427_P_NODE_22269_length_508_cov_3.708046_g21392_i0 | PRJNA781427 | 22269 | 508 | 3.708046 | 18.83687368 | Cylindrocapsa geminella | 52679 | Plants | Plants | 75 | 1.06e-8 | NTclustered | gi|6120012|gb|AF183472.1| | 52679 | g21392 | i0 | 97.727 | 8.85236220472441 | 44 | 0 | 8 | 1 | 27 | 69 | 615 | 572 | Cylindrocapsa geminella culture SAG:3.87 strain SAG 3.87 28S ribosomal RNA gene, partial sequence | blastn | 4497 | 75 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Cylindrocapsaceae | Cylindrocapsa | Cylindrocapsa geminella | |
| 10965333 | 10965333 | PRJNA781427_P_NODE_62609_length_280_cov_1.487923_g61725_i0 | PRJNA781427 | 62609 | 280 | 1.487923 | 4.1661844 | Myrmecia israelensis | 3171 | Plants | Plants | 512 | 9.85e-141 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g61725 | i0 | 99.643 | 113.210714285714 | 280 | 1 | 100 | 0 | 1 | 280 | 51354 | 51633 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 31699 | 512 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 13515543 | 13515543 | PRJNA781427_P_NODE_83611_length_247_cov_0.885057_g82727_i0 | PRJNA781427 | 83611 | 247 | 0.885057 | 2.18609079 | Asteromonas gracilis | 3156 | Plants | Plants | 289 | 1.56e-73 | NTclustered | gi|66864256|gb|DQ015711.1| | 3156 | g82727 | i0 | 87.903 | 8.34817813765182 | 248 | 27 | 99 | 3 | 2 | 247 | 1506 | 1752 | Asteromonas gracilis strain CCMP 813 26S ribosomal RNA gene, partial sequence | blastn | 2062 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Asteromonadaceae | Asteromonas | Asteromonas gracilis |
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);;