contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 499548 | 499548 | PRJNA529241_P_NODE_25201_length_418_cov_5.566929_g22910_i0 | PRJNA529241 | 25201 | 418 | 5.566929 | 23.26976322 | Jenufa minuta | 993092 | Plants | Plants | 634 | 3.14e-177 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g22910 | i0 | 94.076 | 218.698564593301 | 422 | 18 | 100 | 5 | 1 | 418 | 103421 | 103003 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 91416 | 634 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 1773369 | 1773369 | PRJNA529241_P_NODE_113942_length_207_cov_1.100000_g111620_i0 | PRJNA529241 | 113942 | 207 | 1.1 | 2.277 | Prasiola crispa | 173492 | Plants | Plants | 333 | 5.779999999999999e-87 | NTclustered | gi|806639636|gb|KR017749.1| | 173492 | g111620 | i0 | 95.673 | 131.275362318841 | 208 | 7 | 100 | 2 | 1 | 207 | 3106 | 2900 | Prasiola crispa clone Contig2 chloroplast sequence | blastn | 27174 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Prasiola | Prasiola crispa | |
| 1773878 | 1773878 | PRJNA529241_P_NODE_151562_length_185_cov_1.844595_g149240_i0 | PRJNA529241 | 151562 | 185 | 1.844595 | 3.41250075 | Jenufa minuta | 993092 | Plants | Plants | 342 | 8.369999999999999e-90 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g149240 | i0 | 100 | 9.37837837837838 | 185 | 0 | 100 | 0 | 1 | 185 | 104694 | 104878 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 1735 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 3052179 | 3052179 | PRJNA529241_P_NODE_451463_length_156_cov_1.638655_g449141_i0 | PRJNA529241 | 451463 | 156 | 1.638655 | 2.5563018 | Chlorella endosymbiont of Stentor polymorphus | 2219871 | Plants | Plants | 237 | 3.31e-58 | NTclustered | gi|1401669229|gb|MH295835.1| | 2219871 | g449141 | i0 | 94.231 | 100.096153846154 | 156 | 8 | 100 | 1 | 1 | 156 | 1362 | 1208 | Chlorella endosymbiont of Stentor polymorphus 28S ribosomal RNA gene, partial sequence | blastn | 15615 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella endosymbiont of Stentor polymorphus | |
| 4944414 | 4944414 | PRJNA529241_P_NODE_49024_length_292_cov_1.686275_g46702_i0 | PRJNA529241 | 49024 | 292 | 1.686275 | 4.923923 | Watanabeales | 2981622 | Plants | Plants | 401 | 2.3299999999999993e-107 | NTclustered | gi|2663407540|emb|OY754499.1| | 1274662 | g46702 | i0 | 91.497 | 149.544520547945 | 294 | 22 | 100 | 3 | 1 | 292 | 158144 | 157852 | Coccomyxa viridis genome assembly, organelle: plastid | blastn | 43667 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 6219998 | 6219998 | PRJNA529241_P_NODE_54345_length_279_cov_3.252066_g52023_i0 | PRJNA529241 | 54345 | 279 | 3.252066 | 9.07326414 | Trebouxiophyceae | 75966 | Plants | Plants | 508 | 1.27e-139 | NTclustered | gi|328349687|emb|FN298931.1| | 3075 | g52023 | i0 | 99.64 | 98.8745519713262 | 278 | 1 | 99 | 0 | 1 | 278 | 10 | 287 | Auxenochlorella protothecoides 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene (partial), strain CCAP 211/7A | blastn | 27586 | 508 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 8154186 | 8154186 | PRJNA529241_P_NODE_457187_length_154_cov_2.717949_g454865_i0 | PRJNA529241 | 457187 | 154 | 2.717949 | 4.18564146 | Chlorella variabilis | 554065 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|552816487|ref|XM_005844636.1| | 554065 | g454865 | i0 | 84.746 | 0.383116883116883 | 59 | 3 | 34 | 4 | 83 | 135 | 1292 | 1234 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_138627) mRNA, complete cds | blastn | 59 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 9427731 | 9427731 | PRJNA529241_P_NODE_24948_length_421_cov_3.572917_g22657_i0 | PRJNA529241 | 24948 | 421 | 3.572917 | 15.04198057 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 630 | 4.0899999999999984e-176 | NTclustered | gi|440136375|gb|JX857664.1| | 3075 | g22657 | i0 | 97.832 | 47.0593824228028 | 369 | 1 | 88 | 3 | 53 | 421 | 388 | 27 | Auxenochlorella protothecoides strain 0710 clone CHLPROCpK12 large subunit ribosomal RNA, partial sequence | blastn | 19812 | 630 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 11977518 | 11977518 | PRJNA529241_P_NODE_157970_length_182_cov_1.344828_g155648_i0 | PRJNA529241 | 157970 | 182 | 1.344828 | 2.44758696 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 337 | 3.82e-88 | NTclustered | gi|741870561|ref|NC_026009.1| | 3075 | g155648 | i0 | 100 | 38.1923076923077 | 182 | 0 | 100 | 0 | 1 | 182 | 32661 | 32480 | Auxenochlorella protothecoides mitochondrion, complete genome | blastn | 6951 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 11977520 | 11977520 | PRJNA529241_P_NODE_158010_length_182_cov_1.344828_g155688_i0 | PRJNA529241 | 158010 | 182 | 1.344828 | 2.44758696 | Jenufa minuta | 993092 | Plants | Plants | 337 | 3.82e-88 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g155688 | i0 | 100 | 99.6373626373626 | 182 | 0 | 100 | 0 | 1 | 182 | 46160 | 46341 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 18134 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 14527608 | 14527608 | PRJNA529241_P_NODE_155712_length_183_cov_1.869863_g153390_i0 | PRJNA529241 | 155712 | 183 | 1.869863 | 3.42184929 | Jenufa minuta | 993092 | Plants | Plants | 333 | 4.97e-87 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g153390 | i0 | 99.454 | 60.8087431693989 | 183 | 1 | 100 | 0 | 1 | 183 | 34814 | 34632 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 11128 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 15803471 | 15803471 | PRJNA529241_P_NODE_423033_length_167_cov_1.130769_g420711_i0 | PRJNA529241 | 423033 | 167 | 1.130769 | 1.88838423 | Haematococcus lacustris | 44745 | Plants | Plants | 230 | 6.029999999999999e-56 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g420711 | i0 | 92.025 | 442.922155688623 | 163 | 13 | 98 | 0 | 1 | 163 | 3843 | 3681 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 73968 | 230 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 17694660 | 17694660 | PRJNA529241_P_NODE_7854_length_1081_cov_3.011494_g6616_i0 | PRJNA529241 | 7854 | 1081 | 3.011494 | 32.55425014 | Ulva | 3118 | Plants | Plants | 1181 | 0 | NTclustered | gi|2095862465|gb|MN853879.1| | 3117 | g6616 | i0 | 86.761 | 110.894542090657 | 1065 | 136 | 98 | 5 | 19 | 1081 | 24427 | 23366 | Ulva prolifera chloroplast, complete genome | blastn | 119877 | 1192 | 0.990771812080537 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 18352329 | 18352329 | PRJNA529241_P_NODE_422695_length_167_cov_1.453846_g420373_i0 | PRJNA529241 | 422695 | 167 | 1.453846 | 2.42792282 | Jenufa minuta | 993092 | Plants | Plants | 274 | 2.75e-69 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g420373 | i0 | 100 | 101.017964071856 | 148 | 0 | 89 | 0 | 20 | 167 | 45740 | 45887 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 16870 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 22175683 | 22175683 | PRJNA529241_P_NODE_173898_length_175_cov_1.695652_g171576_i0 | PRJNA529241 | 173898 | 175 | 1.695652 | 2.967391 | Jenufa minuta | 993092 | Plants | Plants | 217 | 4.94e-52 | NTclustered | gi|1829768154|ref|NC_046780.1| | 993092 | g171576 | i0 | 89.773 | 1.38285714285714 | 176 | 8 | 100 | 6 | 1 | 175 | 21660 | 21494 | Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome | blastn | 242 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 24724471 | 24724471 | PRJNA529241_P_NODE_13340_length_674_cov_6.676609_g11453_i0 | PRJNA529241 | 13340 | 674 | 6.676609 | 45.00034466 | Jenufa minuta | 993092 | Plants | Plants | 1243 | 0 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g11453 | i0 | 100 | 135.43175074184 | 673 | 0 | 99 | 0 | 1 | 673 | 103484 | 104156 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 91281 | 1243 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta |
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);;