contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2690208 | 2690208 | PRJEB81327_P_NODE_59883_length_244_cov_0.900585_g59275_i0 | PRJEB81327 | 59883 | 244 | 0.900585 | 2.1974274 | Bracteacoccus minor | 50037 | Plants | Plants | 444 | 3.11e-120 | NTclustered | gi|674840682|ref|NC_024756.1| | 50037 | g59275 | i0 | 99.588 | 1.99590163934426 | 243 | 1 | 99 | 0 | 1 | 243 | 1285 | 1527 | Bracteacoccus minor strain UTEX B66 mitochondrion, complete genome | blastn | 487 | 444 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 3547767 | 3547767 | PRJEB81327_P_NODE_59743_length_244_cov_0.900585_g59135_i0 | PRJEB81327 | 59743 | 244 | 0.900585 | 2.1974274 | Ulva | 3118 | Plants | Plants | 305 | 1.53e-78 | NTclustered | gi|1001185347|gb|KU161104.1| | 3117 | g59135 | i0 | 90.87 | 45.1270491803279 | 230 | 18 | 94 | 3 | 7 | 235 | 9868 | 10095 | Ulva prolifera mitochondrion, complete genome | blastn | 11011 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 3966374 | 3966374 | PRJEB81327_P_NODE_7744_length_503_cov_1.788372_g7139_i0 | PRJEB81327 | 7744 | 503 | 1.788372 | 8.99551116 | Bracteacoccus minor | 50037 | Plants | Plants | 843 | 0 | NTclustered | gi|674840682|ref|NC_024756.1| | 50037 | g7139 | i0 | 98.734 | 39.1431411530815 | 474 | 6 | 100 | 0 | 30 | 503 | 11183 | 11656 | Bracteacoccus minor strain UTEX B66 mitochondrion, complete genome | blastn | 19689 | 843 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 6517718 | 6517718 | PRJEB81327_P_NODE_12626_length_380_cov_33.198697_g12018_i0 | PRJEB81327 | 12626 | 380 | 33.198697 | 126.1550486 | Pediastrum duplex | 3105 | Plants | Plants | 370 | 8.8e-98 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g12018 | i0 | 93.227 | 91.7921052631579 | 251 | 17 | 90 | 0 | 1 | 251 | 2889 | 3139 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 34881 | 370 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 6518465 | 6518465 | PRJEB81327_P_NODE_8146_length_488_cov_1.419277_g7539_i0 | PRJEB81327 | 8146 | 488 | 1.419277 | 6.92607176 | Bracteacoccus minor | 50037 | Plants | Plants | 891 | 0 | NTclustered | gi|1008861662|ref|NC_029674.1| | 50037 | g7539 | i0 | 99.59 | 88.7991803278689 | 488 | 2 | 100 | 0 | 1 | 488 | 36672 | 37159 | Bracteacoccus minor strain UTEX 66 chloroplast, complete genome | blastn | 43334 | 891 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 10343225 | 10343225 | PRJEB81327_P_NODE_689_length_1696_cov_6.879236_g493_i0 | PRJEB81327 | 689 | 1696 | 6.879236 | 116.67184256 | Bracteacoccus minor | 50037 | Plants | Plants | 3112 | 0 | NTclustered | gi|1008861662|ref|NC_029674.1| | 50037 | g493 | i0 | 99.823 | 142.526533018868 | 1694 | 3 | 99 | 0 | 1 | 1694 | 2875 | 1182 | Bracteacoccus minor strain UTEX 66 chloroplast, complete genome | blastn | 241725 | 3112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 11618099 | 11618099 | PRJEB81327_P_NODE_13330_length_370_cov_1.377104_g12722_i0 | PRJEB81327 | 13330 | 370 | 1.377104 | 5.0952848 | Polytomella parva | 51329 | Plants | Plants | 235 | 3.25e-57 | NTclustered | gi|1861356367|gb|MT377411.1| | 51329 | g12722 | i0 | 78.284 | 22.4837837837838 | 373 | 75 | 100 | 5 | 1 | 370 | 653 | 284 | Polytomella parva clone 0016300147 40S ribosomal protein S2 (RPS2) mRNA, complete cds; plastid | blastn | 8319 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 14168018 | 14168018 | PRJEB81327_P_NODE_20352_length_308_cov_1.310638_g19744_i0 | PRJEB81327 | 20352 | 308 | 1.310638 | 4.03676504 | Bracteacoccus minor | 50037 | Plants | Plants | 569 | 6.419999999999998e-158 | NTclustered | gi|1008861662|ref|NC_029674.1| | 50037 | g19744 | i0 | 100 | 119.902597402597 | 308 | 0 | 100 | 0 | 1 | 308 | 7693 | 8000 | Bracteacoccus minor strain UTEX 66 chloroplast, complete genome | blastn | 36930 | 569 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 15024737 | 15024737 | PRJEB81327_P_NODE_20652_length_305_cov_16.008621_g20044_i0 | PRJEB81327 | 20652 | 305 | 16.008621 | 48.82629405 | Bracteacoccus | 50036 | Plants | Plants | 564 | 2.95e-156 | NTclustered | gi|1914023927|gb|MW075319.1| | 50037 | g20044 | i0 | 100 | 100.003278688525 | 305 | 0 | 100 | 0 | 1 | 305 | 67 | 371 | Bracteacoccus minor strain SAG 221-1 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 | 30501 | 564 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 15442089 | 15442089 | PRJEB81327_P_NODE_16893_length_328_cov_3.337255_g16285_i0 | PRJEB81327 | 16893 | 328 | 3.337255 | 10.9461964 | Bracteacoccus minor | 50037 | Plants | Plants | 579 | 1.1399999999999999e-160 | NTclustered | gi|674840682|ref|NC_024756.1| | 50037 | g16285 | i0 | 98.476 | 10.8262195121951 | 328 | 5 | 100 | 0 | 1 | 328 | 29856 | 30183 | Bracteacoccus minor strain UTEX B66 mitochondrion, complete genome | blastn | 3551 | 579 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 15442600 | 15442600 | PRJEB81327_P_NODE_56013_length_246_cov_0.890173_g55405_i0 | PRJEB81327 | 56013 | 246 | 0.890173 | 2.18982558 | Bracteacoccus minor | 50037 | Plants | Plants | 351 | 1.96e-92 | NTclustered | gi|674840682|ref|NC_024756.1| | 50037 | g55405 | i0 | 98.98 | 1.79674796747967 | 196 | 2 | 80 | 0 | 1 | 196 | 44008 | 43813 | Bracteacoccus minor strain UTEX B66 mitochondrion, complete genome | blastn | 442 | 351 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 17575189 | 17575189 | PRJEB81327_P_NODE_7414_length_516_cov_16.029345_g6810_i0 | PRJEB81327 | 7414 | 516 | 16.029345 | 82.7114202 | Bracteacoccus | 50036 | Plants | Plants | 948 | 0 | NTclustered | gi|1914023927|gb|MW075319.1| | 50037 | g6810 | i0 | 99.806 | 99.9941860465116 | 516 | 1 | 100 | 0 | 1 | 516 | 576 | 1091 | Bracteacoccus minor strain SAG 221-1 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 | 51597 | 948 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 17991241 | 17991241 | PRJEB81327_P_NODE_26475_length_285_cov_1.146226_g25867_i0 | PRJEB81327 | 26475 | 285 | 1.146226 | 3.2667441 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 161 | 4.19e-35 | NTclustered | gi|545376366|ref|XM_005652223.1| | 574566 | g25867 | i0 | 84.431 | 14.2175438596491 | 167 | 22 | 58 | 3 | 1 | 165 | 301 | 465 | Coccomyxa subellipsoidea C-169 60S ribosomal protein L18a-2 partial mRNA | blastn | 4052 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19265365 | 19265365 | PRJEB81327_P_NODE_3636_length_793_cov_15.093056_g3102_i0 | PRJEB81327 | 3636 | 793 | 15.093056 | 119.68793408 | Bracteacoccus minor | 50037 | Plants | Plants | 1465 | 0 | NTclustered | gi|1008861662|ref|NC_029674.1| | 50037 | g3102 | i0 | 100 | 147.504413619168 | 793 | 0 | 100 | 0 | 1 | 793 | 2908 | 3700 | Bracteacoccus minor strain UTEX 66 chloroplast, complete genome | blastn | 116971 | 1465 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 20540772 | 20540772 | PRJEB81327_P_NODE_36157_length_267_cov_16.149485_g35549_i0 | PRJEB81327 | 36157 | 267 | 16.149485 | 43.11912495 | Bracteacoccus minor | 50037 | Plants | Plants | 494 | 3.38e-135 | NTclustered | gi|1008861662|ref|NC_029674.1| | 50037 | g35549 | i0 | 100 | 132.85393258427 | 267 | 0 | 100 | 0 | 1 | 267 | 3967 | 4233 | Bracteacoccus minor strain UTEX 66 chloroplast, complete genome | blastn | 35472 | 494 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 21399342 | 21399342 | PRJEB81327_P_NODE_67717_length_230_cov_3.878981_g67109_i0 | PRJEB81327 | 67717 | 230 | 3.878981 | 8.9216563 | root | 1 | Root_unresolved | Root_unresolved | 425 | 1.05e-114 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g67109 | i0 | 100 | 100.147826086957 | 230 | 0 | 100 | 0 | 1 | 230 | 619 | 848 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 23034 | 425 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 22673780 | 22673780 | PRJEB81327_P_NODE_26358_length_285_cov_1.367925_g25750_i0 | PRJEB81327 | 26358 | 285 | 1.367925 | 3.89858625 | Chlamydomonadaceae | 3051 | Plants | Plants | 392 | 1.3699999999999999e-104 | NTclustered | gi|1867187245|gb|MT735194.1| | 179866 | g25750 | i0 | 92.419 | 97.8035087719298 | 277 | 17 | 97 | 3 | 9 | 285 | 2398 | 2670 | Heterochlamydomonas inaequalis strain LC006-34-2-2 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 | 27874 | 392 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Heterochlamydomonas | Heterochlamydomonas inaequalis |
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);;