contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1003464 | 1003464 | PRJNA1020854_S_NODE_39581_length_158_cov_8.317829_g36817_i0 | PRJNA1020854 | 39581 | 158 | 8.317829 | 13.14216982 | Jaagichlorella | 2304164 | Plants | Plants | 209 | 7.32e-50 | NTclustered | gi|478437260|gb|KC470085.1| | 445995 | g36817 | i0 | 90.506 | 44.398734177215204 | 158 | 15 | 100 | 0 | 1 | 158 | 3167 | 3324 | Heveochlorella hainangensis strain SAG 2360 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 7015 | 209 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella hainangensis | |
| 2711236 | 2711236 | PRJNA1020854_S_NODE_23183_length_223_cov_9.510309_g20419_i0 | PRJNA1020854 | 23183 | 223 | 9.510309 | 21.20798907 | Trebouxia asymmetrica | 13787 | Plants | Plants | 294 | 2.98e-75 | NTclustered | gi|1356679026|gb|MH035884.1| | 13787 | g20419 | i0 | 93.846 | 79.865470852017907 | 195 | 12 | 87 | 0 | 9 | 203 | 534 | 340 | Trebouxia asymmetrica isolate C. paramerae Javalambre 2 large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 17810 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 2711261 | 2711261 | PRJNA1020854_S_NODE_24303_length_216_cov_393.117647_g21539_i0 | PRJNA1020854 | 24303 | 216 | 393.117647 | 849.13411752 | Trebouxia aggregata | 160068 | Plants | Plants | 326 | 1.02e-84 | NTclustered | gi|162134245|gb|EU123948.1| | 160068 | g21539 | i0 | 95.567 | 88.4305555555556 | 203 | 9 | 94 | 0 | 14 | 216 | 14859 | 15061 | Trebouxia aggregata strain SAG 219-1d ribosomal protein S2 (rps2) gene, complete cds; tRNA-Met (trnMe(cau)) and large subunit ribosomal RNA (rnl) genes, complete sequence; putative site-specific DNA endonuclease (orf365) gene, complete cds; small subunit ribosomal RNA (rns) and tRNA-Met (trnMf(cau)) genes, complete sequence; cytochrome c oxidase subunit 1 (cox1), putative site-specific DNA endonuclease (orf335), and putative site-specific DNA endonuclease (orf256) genes, complete cds; tRNA-Phe (trnF(gaa)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; and apocytochrome b (cob) and putative site-specific DNA endonuclease (orf334) genes, complete cds; mitochondrial | blastn | 19101 | 326 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 7380916 | 7380916 | PRJNA1020854_S_NODE_26086_length_206_cov_5.971751_g23322_i0 | PRJNA1020854 | 26086 | 206 | 5.971751 | 12.30180706 | Eukaryota | 2759 | Plants | Plants | 377 | 2.62e-100 | NTclustered | gi|359385338|emb|FR865755.1| | 173490 | g23322 | i0 | 100 | 98.8009708737864 | 204 | 0 | 99 | 0 | 1 | 204 | 2579 | 2376 | Pseudendocloniopsis botryoides genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 465/1 | blastn | 20353 | 377 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Planophilaceae | Planophila | Planophila laetevirens | |
| 14189394 | 14189394 | PRJNA1020854_S_NODE_17992_length_265_cov_5.419492_g15228_i0 | PRJNA1020854 | 17992 | 265 | 5.419492 | 14.3616538 | Trebouxia sp. ex Placidium sp. PJ-2019a | 2571973 | Plants | Plants | 466 | 7.2999999999999995e-127 | NTclustered | gi|1691252205|emb|LR586036.1| | 2571973 | g15228 | i0 | 98.851 | 98.3358490566038 | 261 | 3 | 98 | 0 | 1 | 261 | 167 | 427 | Trebouxia sp. ex Placidium sp. PJ-2019a partial 26S rRNA gene, isolate Trebouxia sp. pj16 ex Placidium sp. PJ-2019a | blastn | 26059 | 466 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. ex Placidium sp. PJ-2019a | |
| 16738191 | 16738191 | PRJNA1020854_S_NODE_43074_length_151_cov_1.909836_g40310_i0 | PRJNA1020854 | 43074 | 151 | 1.909836 | 2.88385236 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 139 | 9.19e-29 | NTclustered | gi|2917929626|emb|OZ234914.1| | 3350044 | g40310 | i0 | 97.531 | 0.947019867549669 | 81 | 2 | 93 | 0 | 3 | 83 | 1766317 | 1766397 | Trebouxia sp. SL0000003 genome assembly, chromosome: 9 | blastn | 143 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 18012776 | 18012776 | PRJNA1020854_S_NODE_28155_length_196_cov_1177.736527_g25391_i0 | PRJNA1020854 | 28155 | 196 | 1177.736527 | 2308.36359292 | uncultured Symbiochloris | 2562465 | Plants | Plants | 244 | 2.61e-60 | NTclustered | gi|2509725906|gb|OR042192.1| | 2562465 | g25391 | i0 | 96 | 177.397959183673 | 150 | 6 | 77 | 0 | 1 | 150 | 1162 | 1013 | Uncultured Symbiochloris clone BW01 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 34770 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Symbiochloris | ||||
| 23955581 | 23955581 | PRJNA1020854_S_NODE_23659_length_220_cov_62.010471_g20895_i0 | PRJNA1020854 | 23659 | 220 | 62.010471 | 136.4230362 | Trebouxia | 13786 | Plants | Plants | 401 | 1.6799999999999993e-107 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g20895 | i0 | 99.545 | 101.568181818182 | 220 | 1 | 100 | 0 | 1 | 220 | 518 | 299 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 22345 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica |
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);;