contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1036688" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2720083 | 2720083 | PRJNA1036688_P_NODE_3643_length_338_cov_20.687708_g3352_i0 | PRJNA1036688 | 3643 | 338 | 20.687708 | 69.92445304 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 562 | 1.19e-155 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g3352 | i0 | 96.746 | 20.3195266272189 | 338 | 9 | 100 | 2 | 1 | 338 | 8822 | 8487 | Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 6868 | 562 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 2720096 | 2720096 | PRJNA1036688_P_NODE_5423_length_258_cov_2.443439_g5131_i0 | PRJNA1036688 | 5423 | 258 | 2.443439 | 6.30407262 | Trebouxia lynnae | 1825957 | Plants | Plants | 405 | 1.56e-108 | NTclustered | gi|1750939486|gb|MH917293.1| | 1825957 | g5131 | i0 | 96 | 99.7441860465116 | 250 | 9 | 97 | 1 | 1 | 250 | 17310 | 17558 | Trebouxia sp. TR9 mitochondrion, complete genome | blastn | 25734 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 5272540 | 5272540 | PRJNA1036688_P_NODE_8765_length_184_cov_2.639456_g8473_i0 | PRJNA1036688 | 8765 | 184 | 2.639456 | 4.85659904 | Trebouxia sp. I15 | 2884548 | Plants | Plants | 324 | 3.01e-84 | NTclustered | gi|2117340442|gb|OK533751.1| | 2884548 | g8473 | i0 | 98.37 | 92.8913043478261 | 184 | 3 | 100 | 0 | 1 | 184 | 98 | 281 | Trebouxia sp. I15 voucher 16569 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17092 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. I15 | |
| 6111250 | 6111250 | PRJNA1036688_P_NODE_3905_length_322_cov_6.859649_g3613_i0 | PRJNA1036688 | 3905 | 322 | 6.859649 | 22.08806978 | Watanabeales | 2981622 | Plants | Plants | 359 | 1.5899999999999998e-94 | NTclustered | gi|294358549|gb|GU732422.1| | 63676 | g3613 | i0 | 86.997 | 91.8229813664596 | 323 | 37 | 100 | 5 | 1 | 322 | 273 | 591 | Pseudochlorella sp. CCAP 211/1A isolate YSR03 28S ribosomal RNA gene, partial sequence | blastn | 29567 | 361 | 0.994459833795014 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 7385887 | 7385887 | PRJNA1036688_P_NODE_9746_length_172_cov_65.111111_g9454_i0 | PRJNA1036688 | 9746 | 172 | 65.111111 | 111.99111092 | Trebouxia | 13786 | Plants | Plants | 291 | 2.81e-74 | NTclustered | gi|255506485|gb|FJ687229.1| | 53269 | g9454 | i0 | 97.093 | 166.046511627907 | 172 | 5 | 100 | 0 | 1 | 172 | 1225 | 1054 | Trebouxia gelatinosa strain UTEX 906 23S ribosomal RNA gene, partial sequence; and hypothetical protein gene, complete cds; chloroplast | blastn | 28560 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia gelatinosa | |
| 9097274 | 9097274 | PRJNA1036688_P_NODE_6948_length_215_cov_2.432584_g6656_i0 | PRJNA1036688 | 6948 | 215 | 2.432584 | 5.2300556 | Trebouxia sp. I15 | 2884548 | Plants | Plants | 366 | 5.96e-97 | NTclustered | gi|2117340341|gb|OK533711.1| | 2884548 | g6656 | i0 | 97.235 | 49.2651162790698 | 217 | 4 | 100 | 1 | 1 | 215 | 263 | 47 | Trebouxia sp. I15 voucher 16218 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 10592 | 366 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. I15 | |
| 10372889 | 10372889 | PRJNA1036688_P_NODE_3709_length_334_cov_17.212121_g3418_i0 | PRJNA1036688 | 3709 | 334 | 17.212121 | 57.48848414 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 374 | 5.9199999999999995e-99 | NTclustered | gi|94448902|emb|AM159502.1| | 285713 | g3418 | i0 | 94.286 | 64.0898203592814 | 245 | 13 | 73 | 1 | 91 | 334 | 1221 | 977 | Uncultured Trebouxia photobiont partial 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and partial 26S rRNA gene, clone L-66-Ia | blastn | 21406 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 11648186 | 11648186 | PRJNA1036688_P_NODE_5470_length_256_cov_14.703196_g5178_i0 | PRJNA1036688 | 5470 | 256 | 14.703196 | 37.64018176 | Trebouxia sp. I15 | 2884548 | Plants | Plants | 435 | 1.98e-117 | NTclustered | gi|2117341232|gb|OK534053.1| | 2884548 | g5178 | i0 | 97.266 | 98.6171875 | 256 | 7 | 100 | 0 | 1 | 256 | 418 | 673 | Trebouxia sp. I15 voucher 16517a internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 25246 | 435 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. I15 | |
| 12923337 | 12923337 | PRJNA1036688_P_NODE_11151_length_159_cov_1.475410_g10859_i0 | PRJNA1036688 | 11151 | 159 | 1.47541 | 2.3459019 | Trebouxia lynnae | 1825957 | Plants | Plants | 156 | 9.75e-34 | NTclustered | gi|1016111943|gb|KU716051.1| | 1825957 | g10859 | i0 | 84.906 | 2 | 159 | 18 | 97 | 5 | 1 | 154 | 5722 | 5879 | Trebouxia lynnae 26S-18S intergenic spacer region, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence; and 26S-18S rRNA intergenic spacer region, partial sequence | blastn | 318 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 14198304 | 14198304 | PRJNA1036688_P_NODE_9612_length_174_cov_1.715328_g9320_i0 | PRJNA1036688 | 9612 | 174 | 1.715328 | 2.98467072 | Trebouxia gelatinosa | 53269 | Plants | Plants | 246 | 6.26e-61 | NTclustered | gi|5918299|emb|AJ249568.1| | 53269 | g9320 | i0 | 92.941 | 36.2701149425287 | 170 | 10 | 97 | 2 | 1 | 169 | 317 | 149 | Trebouxia gelatinosa 18S rRNA gene, 5.8S rRNA gene, internal transcribed spacer 1 (ITS1) and internal transcribed spacer 2 (ITS2) | blastn | 6311 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia gelatinosa | |
| 17585891 | 17585891 | PRJNA1036688_P_NODE_10754_length_162_cov_12.584000_g10462_i0 | PRJNA1036688 | 10754 | 162 | 12.584 | 20.38608 | Stichococcaceae | 2910630 | Plants | Plants | 300 | 4.36e-77 | NTclustered | gi|557844190|gb|KF144234.1| | 154978 | g10462 | i0 | 100 | 100 | 162 | 0 | 100 | 0 | 1 | 162 | 1423 | 1262 | Stichococcus mirabilis isolate WB69 18S ribosomal RNA gene, partial sequence | blastn | 16200 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus mirabilis | |
| 18859709 | 18859709 | PRJNA1036688_P_NODE_4735_length_282_cov_7.922449_g4443_i0 | PRJNA1036688 | 4735 | 282 | 7.922449 | 22.34130618 | Trebouxia | 13786 | Plants | Plants | 499 | 7.729999999999999e-137 | NTclustered | gi|2105089|emb|Z95382.1| | 53269 | g4443 | i0 | 98.587 | 91.0035460992908 | 283 | 3 | 100 | 1 | 1 | 282 | 588 | 306 | T.gelatinosa 26S rRNA gene | blastn | 25663 | 499 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia gelatinosa | |
| 20134478 | 20134478 | PRJNA1036688_P_NODE_5576_length_252_cov_9.804651_g5284_i0 | PRJNA1036688 | 5576 | 252 | 9.804651 | 24.70772052 | Eukaryota | 2759 | Plants | Plants | 433 | 6.98e-117 | NTclustered | gi|399532147|gb|JQ627431.1| | 171245 | g5284 | i0 | 97.619 | 99.8769841269841 | 252 | 6 | 100 | 0 | 1 | 252 | 449 | 700 | Uncultured Chlorophyta clone B1_4_1E_144 small subunit ribosomal RNA gene, partial sequence | blastn | 25169 | 433 | 1 | Eukaryota | Viridiplantae | Chlorophyta | uncultured Chlorophyta | ||||||
| 20134500 | 20134500 | PRJNA1036688_P_NODE_8696_length_185_cov_2.824324_g8404_i0 | PRJNA1036688 | 8696 | 185 | 2.824324 | 5.2249994 | Prasiolaceae | 135266 | Plants | Plants | 281 | 1.8500000000000002e-71 | NTclustered | gi|806639636|gb|KR017749.1| | 173492 | g8404 | i0 | 94.086 | 129.497297297297 | 186 | 9 | 100 | 2 | 1 | 185 | 3105 | 2921 | Prasiola crispa clone Contig2 chloroplast sequence | blastn | 23957 | 281 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Prasiola | Prasiola crispa | |
| 20570799 | 20570799 | PRJNA1036688_P_NODE_11377_length_157_cov_1.608333_g11085_i0 | PRJNA1036688 | 11377 | 157 | 1.608333 | 2.52508281 | Microspora stagnorum | 163317 | Plants | Plants | 250 | 4.28e-62 | NTclustered | gi|563940464|ref|NC_022862.1| | 163317 | g11085 | i0 | 95.541 | 6.42675159235669 | 157 | 6 | 100 | 1 | 1 | 157 | 1968 | 1813 | Microspora stagnorum culture-collection SAG:51.86 mitochondrion, complete genome | blastn | 1009 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Microsporaceae | Microspora | Microspora stagnorum | ||
| 21410112 | 21410112 | PRJNA1036688_P_NODE_11577_length_155_cov_3.271186_g11285_i0 | PRJNA1036688 | 11577 | 155 | 3.271186 | 5.0703383 | Trebouxiophyceae | 75966 | Plants | Plants | 235 | 1.18e-57 | NTclustered | gi|746948124|ref|NC_025531.1| | 33092 | g11285 | i0 | 94.156 | 124.793548387097 | 154 | 9 | 99 | 0 | 1 | 154 | 145882 | 146035 | Koliella longiseta culture-collection UTEX:339 chloroplast, complete genome | blastn | 19343 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 21846594 | 21846594 | PRJNA1036688_P_NODE_3518_length_345_cov_7.814935_g3227_i0 | PRJNA1036688 | 3518 | 345 | 7.814935 | 26.96152575 | Stichococcus bacillaris | 37433 | Plants | Plants | 322 | 2.25e-83 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g3227 | i0 | 96.41 | 15.4086956521739 | 195 | 7 | 57 | 0 | 151 | 345 | 7182 | 6988 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 5316 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 22684945 | 22684945 | PRJNA1036688_P_NODE_7258_length_208_cov_16.836257_g6966_i0 | PRJNA1036688 | 7258 | 208 | 16.836257 | 35.01941456 | Trebouxia | 13786 | Plants | Plants | 340 | 3.4699999999999996e-89 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g6966 | i0 | 96.154 | 101.317307692308 | 208 | 8 | 100 | 0 | 1 | 208 | 6610 | 6817 | Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21074 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 22684951 | 22684951 | PRJNA1036688_P_NODE_8318_length_190_cov_14.163399_g8026_i0 | PRJNA1036688 | 8318 | 190 | 14.163399 | 26.9104581 | Trebouxia | 13786 | Plants | Plants | 351 | 1.4399999999999997e-92 | NTclustered | gi|49781197|gb|AY648107.1| | 283661 | g8026 | i0 | 100 | 100.152631578947 | 190 | 0 | 100 | 0 | 1 | 190 | 1417 | 1228 | Trebouxia sp. Wei 22-c 26S ribosomal RNA gene, partial sequence | blastn | 19029 | 351 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Wei 22-c | |
| 23121920 | 23121920 | PRJNA1036688_P_NODE_2519_length_431_cov_32.192893_g2230_i0 | PRJNA1036688 | 2519 | 431 | 32.192893 | 138.75136883 | Trebouxia asymmetrica | 13787 | Plants | Plants | 710 | 0 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g2230 | i0 | 96.503 | 112.480278422274 | 429 | 15 | 99 | 0 | 3 | 431 | 1782 | 1354 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 48479 | 710 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 24395707 | 24395707 | PRJNA1036688_P_NODE_2800_length_403_cov_2.464481_g2510_i0 | PRJNA1036688 | 2800 | 403 | 2.464481 | 9.93185843 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 87.9 | 1.06e-12 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g2510 | i0 | 75.369 | 0.503722084367246 | 203 | 38 | 49 | 8 | 63 | 259 | 480 | 676 | Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 203 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont |
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);;