contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA326068" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6172081 | 6172081 | PRJNA326068_P_NODE_2125_length_744_cov_4.117483_g1607_i0 | PRJNA326068 | 2125 | 744 | 4.117483 | 30.63407352 | Trebouxia | 13786 | Plants | Plants | 536 | 1.6899999999999999e-147 | NTclustered | gi|1827552207|gb|MT274564.1| | 300846 | g1607 | i0 | 94.302 | 48.0497311827957 | 351 | 18 | 47 | 2 | 1 | 350 | 196 | 545 | Trebouxia crenulata strain CCAP_219_2 large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 35749 | 536 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia crenulata | |
| 10593166 | 10593166 | PRJNA326068_P_NODE_9889_length_320_cov_1.824742_g8930_i0 | PRJNA326068 | 9889 | 320 | 1.824742 | 5.8391744 | Myrmecia israelensis | 3171 | Plants | Plants | 316 | 9.64e-82 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g8930 | i0 | 97.312 | 79.1625 | 186 | 5 | 58 | 0 | 2 | 187 | 2254 | 2439 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 25332 | 316 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 15097010 | 15097010 | PRJNA326068_P_NODE_10292_length_309_cov_38.235714_g9332_i0 | PRJNA326068 | 10292 | 309 | 38.235714 | 118.14835626 | Trebouxia | 13786 | Plants | Plants | 488 | 1.86e-133 | NTclustered | gi|2236816602|gb|ON479854.1| | 160068 | g9332 | i0 | 95.161 | 99.9190938511327 | 310 | 13 | 100 | 2 | 1 | 309 | 12 | 320 | Trebouxia aggregata clone LN-K1 small subunit ribosomal RNA gene, partial sequence | blastn | 30875 | 488 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 15692091 | 15692091 | PRJNA326068_P_NODE_17353_length_193_cov_2.176829_g16390_i0 | PRJNA326068 | 17353 | 193 | 2.176829 | 4.20127997 | Chlorella vulgaris | 3077 | Plants | Plants | 213 | 7.21e-51 | NTclustered | gi|77627727|dbj|AB237642.1| | 3077 | g16390 | i0 | 86.667 | 102.756476683938 | 195 | 23 | 100 | 3 | 1 | 193 | 1913 | 2106 | Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence | blastn | 19832 | 213 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 19515299 | 19515299 | PRJNA326068_P_NODE_18436_length_173_cov_3.458333_g17473_i0 | PRJNA326068 | 18436 | 173 | 3.458333 | 5.98291609 | Myrmecia israelensis | 3171 | Plants | Plants | 320 | 3.61e-83 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g17473 | i0 | 100 | 137.98265895953801 | 173 | 0 | 100 | 0 | 1 | 173 | 5106 | 4934 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 23871 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 20195276 | 20195276 | PRJNA326068_P_NODE_7816_length_376_cov_102.711816_g6873_i0 | PRJNA326068 | 7816 | 376 | 102.711816 | 386.19642816 | Eukaryota | 2759 | Plants | Plants | 673 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g6873 | i0 | 98.936 | 99.718085106383 | 376 | 4 | 100 | 0 | 1 | 376 | 871 | 496 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 37494 | 673 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23341344 | 23341344 | PRJNA326068_P_NODE_2119_length_745_cov_5.008380_g1601_i0 | PRJNA326068 | 2119 | 745 | 5.00838 | 37.312431 | Trebouxia aggregata | 160068 | Plants | Plants | 459 | 3.7599999999999996e-124 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g1601 | i0 | 84.156 | 129.276510067114 | 486 | 64 | 64 | 11 | 79 | 555 | 2265 | 1784 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 96311 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata |
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);;