contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25539973 | 25539973 | PRJNA1233465b_S_NODE_47073_length_359_cov_4.538710_g45388_i0 | PRJNA1233465 | 47073 | 359 | 4.53871 | 16.2939689 | Tupiella akineta | 160070 | Plants | Plants | 54.7 | 0.009 | NTclustered | gi|108796875|ref|NC_008114.1| | 160070 | g45388 | i0 | 87.755 | 0.136490250696379 | 49 | 3 | 13 | 2 | 53 | 98 | 81231 | 81279 | Pseudendoclonium akinetum chloroplast, complete genome | blastn | 49 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Tupiellaceae | Tupiella | Tupiella akineta | |
| 25543671 | 25543671 | PRJNA1233465d_S_NODE_47225_length_249_cov_1.495000_g46114_i0 | PRJNA1233465 | 47225 | 249 | 1.495 | 3.72255 | Chlorella variabilis | 554065 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|552812280|ref|XM_005843609.1| | 554065 | g46114 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 127 | 154 | 675 | 702 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_140054) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 25555787 | 25555787 | PRJNA1233465f_S_NODE_204217_length_176_cov_1.889764_g201937_i0 | PRJNA1233465 | 204217 | 176 | 1.889764 | 3.32598464 | Oedogonium cardiacum | 55995 | Plants | Plants | 128 | 2.4e-25 | NTclustered | gi|6120018|gb|AF183478.1| | 55995 | g201937 | i0 | 82.237 | 283.125 | 152 | 23 | 86 | 4 | 1 | 152 | 2050 | 1903 | Oedogonium cardiacum strain UTEX 40 28S ribosomal RNA gene, partial sequence | blastn | 49830 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Oedogoniales | Oedogoniaceae | Oedogonium | Oedogonium cardiacum | |
| 25673868 | 25673868 | PRJNA1233465b_S_NODE_224394_length_199_cov_1.906667_g222709_i0 | PRJNA1233465 | 224394 | 199 | 1.906667 | 3.79426733 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|302832581|ref|XM_002947809.1| | 3068 | g222709 | i0 | 100 | 0.14572864321608 | 29 | 0 | 15 | 0 | 89 | 117 | 814 | 786 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_88185), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 25680178 | 25680178 | PRJNA1233465d_S_NODE_64850_length_218_cov_1.207101_g63739_i0 | PRJNA1233465 | 64850 | 218 | 1.207101 | 2.63148018 | Bryopsis sp. HV | 3115439 | Plants | Plants | 67.6 | 6.88e-7 | NTclustered | gi|1381384260|ref|NC_037363.1| | 1979421 | g63739 | i0 | 100 | 1.65596330275229 | 36 | 0 | 17 | 0 | 156 | 191 | 78374 | 78409 | Bryopsis sp. HV04063 chloroplast, complete genome | blastn | 361 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. HV04063 | |
| 25696856 | 25696856 | PRJNA1233465f_S_NODE_79610_length_263_cov_1.929907_g77330_i0 | PRJNA1233465 | 79610 | 263 | 1.929907 | 5.07565541 | Chlorella variabilis | 554065 | Plants | Plants | 52.8 | 0.024 | NTclustered | gi|552812280|ref|XM_005843609.1| | 554065 | g77330 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 85 | 112 | 675 | 702 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_140054) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 26075666 | 26075666 | PRJNA1233465a_S_NODE_13733_length_478_cov_1.951049_g12492_i0 | PRJNA1233465 | 13733 | 478 | 1.951049 | 9.32601422 | Kalinella pachyderma | 2704665 | Plants | Plants | 60.2 | 2.78e-4 | NTclustered | gi|2473928347|ref|NC_072901.1| | 2704665 | g12492 | i0 | 100 | 1.37238493723849 | 32 | 0 | 7 | 0 | 22 | 53 | 266953 | 266984 | Kalinella pachyderma clone 2601 chloroplast, complete genome | blastn | 656 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Kalinella | Kalinella pachyderma | |
| 26234156 | 26234156 | PRJNA1233465f_S_NODE_152814_length_199_cov_1.353333_g150534_i0 | PRJNA1233465 | 152814 | 199 | 1.353333 | 2.69313267 | Microspora stagnorum | 163317 | Plants | Plants | 315 | 1.99e-81 | NTclustered | gi|563940464|ref|NC_022862.1| | 163317 | g150534 | i0 | 95.876 | 2.66331658291457 | 194 | 8 | 97 | 0 | 1 | 194 | 1831 | 1638 | Microspora stagnorum culture-collection SAG:51.86 mitochondrion, complete genome | blastn | 530 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Microsporaceae | Microspora | Microspora stagnorum | ||
| 26301709 | 26301709 | PRJNA1233465d_S_NODE_50286_length_242_cov_5044.383420_g49175_i0 | PRJNA1233465 | 50286 | 242 | 5044.38342 | 12207.4078764 | Eukaryota | 2759 | Plants | Plants | 119 | 2.12e-22 | NTclustered | gi|167201|gb|M63000.1|CAUUGEAB | 3092 | g49175 | i0 | 100 | 26.9297520661157 | 64 | 0 | 26 | 0 | 51 | 114 | 425 | 488 | Characium hindakii 18S ribosomal RNA gene | blastn | 6517 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Neochloridaceae | Characiopodium | Characiopodium hindakii | |
| 26483377 | 26483377 | PRJNA1233465a_S_NODE_112504_length_219_cov_0.900000_g111230_i0 | PRJNA1233465 | 112504 | 219 | 0.9 | 1.971 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|2082243636|ref|XM_043061489.1| | 3055 | g111230 | i0 | 100 | 0.264840182648402 | 29 | 0 | 13 | 0 | 151 | 179 | 487 | 515 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g205701v5), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26486936 | 26486936 | PRJNA1233465a_S_NODE_28752_length_359_cov_3.987097_g27478_i0 | PRJNA1233465 | 28752 | 359 | 3.987097 | 14.31367823 | Tupiella akineta | 160070 | Plants | Plants | 54.7 | 0.009 | NTclustered | gi|108796875|ref|NC_008114.1| | 160070 | g27478 | i0 | 87.755 | 0.136490250696379 | 49 | 3 | 13 | 2 | 260 | 305 | 81279 | 81231 | Pseudendoclonium akinetum chloroplast, complete genome | blastn | 49 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Tupiellaceae | Tupiella | Tupiella akineta |
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);;