contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 795090 | 795090 | PRJNA799842_P_NODE_51781_length_395_cov_0.956522_g50208_i0 | PRJNA799842 | 51781 | 395 | 0.956522 | 3.7782619 | Tetradesmus distendus | 113531 | Plants | Plants | 680 | 0 | NTclustered | gi|2692951646|ref|NC_086753.1| | 113531 | g50208 | i0 | 97.727 | 142.235443037975 | 396 | 8 | 100 | 1 | 1 | 395 | 81324 | 80929 | Tetradesmus distendus strain FBCC-A1020 chloroplast, complete genome | blastn | 56183 | 680 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus distendus | |
| 3343854 | 3343854 | PRJNA799842_P_NODE_107803_length_282_cov_0.870813_g106230_i0 | PRJNA799842 | 107803 | 282 | 0.870813 | 2.45569266 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 510 | 3.57e-140 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g106230 | i0 | 99.291 | 136.741134751773 | 282 | 2 | 100 | 0 | 1 | 282 | 132047 | 132328 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 38561 | 510 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 3770254 | 3770254 | PRJNA799842_P_NODE_111883_length_277_cov_1.132353_g110310_i0 | PRJNA799842 | 111883 | 277 | 1.132353 | 3.13661781 | Trebouxiophyceae | 75966 | Plants | Plants | 512 | 9.73e-141 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g110310 | i0 | 100 | 104.924187725632 | 277 | 0 | 100 | 0 | 1 | 277 | 4374 | 4650 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 29064 | 512 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 7171626 | 7171626 | PRJNA799842_P_NODE_133266_length_252_cov_1.720670_g131693_i0 | PRJNA799842 | 133266 | 252 | 1.72067 | 4.3360884 | Bracteacoccus aerius | 50041 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|1008861732|ref|NC_029675.1| | 50041 | g131693 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 10 | 37 | 25208 | 25235 | Bracteacoccus aerius strain UTEX 1250 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus aerius | |
| 12698108 | 12698108 | PRJNA799842_P_NODE_10990_length_946_cov_1.617411_g9805_i0 | PRJNA799842 | 10990 | 946 | 1.617411 | 15.30070806 | Eukaryota | 2759 | Plants | Plants | 660 | 0 | NTclustered | gi|969822364|gb|KT950949.1| | 3130 | g9805 | i0 | 80.457 | 94.6395348837209 | 875 | 161 | 92 | 10 | 51 | 920 | 2 | 871 | Bryopsis plumosa actin mRNA, partial cds | blastn | 89529 | 665 | 0.992481203007519 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis plumosa | |
| 13548935 | 13548935 | PRJNA799842_P_NODE_63251_length_358_cov_1.319298_g61678_i0 | PRJNA799842 | 63251 | 358 | 1.319298 | 4.72308684 | Myrmecia israelensis | 3171 | Plants | Plants | 662 | 0 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g61678 | i0 | 100 | 121.645251396648 | 358 | 0 | 100 | 0 | 1 | 358 | 3044 | 2687 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 43549 | 662 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 14822837 | 14822837 | PRJNA799842_P_NODE_24212_length_602_cov_1.625709_g22674_i0 | PRJNA799842 | 24212 | 602 | 1.625709 | 9.78676818 | Pleurastrum terricola | 34116 | Plants | Plants | 1112 | 0 | NTclustered | gi|153805558|ref|NC_009681.1| | 34116 | g22674 | i0 | 100 | 136.586378737542 | 602 | 0 | 100 | 0 | 1 | 602 | 1424 | 823 | Leptosira terrestris chloroplast, complete genome | blastn | 82225 | 1112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Pleurastraceae | Pleurastrum | Pleurastrum terricola | |
| 17373089 | 17373089 | PRJNA799842_P_NODE_33214_length_501_cov_1.077103_g31645_i0 | PRJNA799842 | 33214 | 501 | 1.077103 | 5.39628603 | Volvox carteri | 3067 | Plants | Plants | 156 | 3.63e-33 | NTclustered | gi|302841991|ref|XM_002952494.1| | 3068 | g31645 | i0 | 90 | 23.6986027944112 | 120 | 12 | 24 | 0 | 1 | 120 | 2127 | 2246 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_75431), mRNA | blastn | 11873 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 20345168 | 20345168 | PRJNA799842_P_NODE_139196_length_250_cov_1.774011_g137623_i0 | PRJNA799842 | 139196 | 250 | 1.774011 | 4.4350275 | Balticola | 1328802 | Plants | Plants | 350 | 7.17e-92 | NTclustered | gi|6120015|gb|AF183475.1| | 51690 | g137623 | i0 | 92.032 | 99.436 | 251 | 17 | 100 | 3 | 1 | 250 | 1646 | 1398 | Balticola zimbabwiensis strain UTEX LB 1758 28S ribosomal RNA gene, partial sequence | blastn | 24859 | 351 | 0.997150997150997 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Balticola | Balticola zimbabwiensis | |
| 22470063 | 22470063 | PRJNA799842_P_NODE_115778_length_272_cov_1.522613_g114205_i0 | PRJNA799842 | 115778 | 272 | 1.522613 | 4.14150736 | Pleurastrum terricola | 34116 | Plants | Plants | 492 | 1.24e-134 | NTclustered | gi|153805558|ref|NC_009681.1| | 34116 | g114205 | i0 | 99.265 | 104.411764705882 | 272 | 2 | 100 | 0 | 1 | 272 | 131290 | 131561 | Leptosira terrestris chloroplast, complete genome | blastn | 28400 | 492 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Pleurastraceae | Pleurastrum | Pleurastrum terricola |
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);;