contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA939415" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 915122 | 915122 | PRJNA939415_P_NODE_24901_length_310_cov_7.708861_g24479_i0 | PRJNA939415 | 24901 | 310 | 7.708861 | 23.8974691 | Ulva prolifera | 3117 | Plants | Plants | 76.8 | 1.72e-9 | NTclustered | gi|378940381|gb|JN936854.1| | 3117 | g24479 | i0 | 92.453 | 2.36451612903226 | 53 | 4 | 17 | 0 | 256 | 308 | 903 | 851 | Ulva prolifera pyruvate orthophosphate dikinase (PPDK) mRNA, complete cds | blastn | 733 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 2191783 | 2191783 | PRJNA939415_P_NODE_91462_length_244_cov_2.602339_g91040_i0 | PRJNA939415 | 91462 | 244 | 2.602339 | 6.34970716 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 248 | 2.6199999999999997e-61 | NTclustered | gi|545367482|ref|XM_005648504.1| | 574566 | g91040 | i0 | 91.667 | 0.737704918032787 | 180 | 13 | 73 | 2 | 1 | 179 | 567 | 745 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 180 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 3466809 | 3466809 | PRJNA939415_P_NODE_67643_length_266_cov_2.243523_g67221_i0 | PRJNA939415 | 67643 | 266 | 2.243523 | 5.96777118 | Paradoxia multiseta | 249350 | Plants | Plants | 69.4 | 2.42e-7 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g67221 | i0 | 91.837 | 0.308270676691729 | 49 | 4 | 18 | 0 | 1 | 49 | 59917 | 59965 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 82 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 6019069 | 6019069 | PRJNA939415_P_NODE_61945_length_272_cov_1.417085_g61523_i0 | PRJNA939415 | 61945 | 272 | 1.417085 | 3.8544712 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 115 | 3.14e-21 | NTclustered | gi|545363825|ref|XM_005646955.1| | 574566 | g61523 | i0 | 89.13 | 0.338235294117647 | 92 | 10 | 34 | 0 | 1 | 92 | 147 | 56 | Coccomyxa subellipsoidea C-169 WD40 repeat-like protein partial mRNA | blastn | 92 | 115 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 6019342 | 6019342 | PRJNA939415_P_NODE_77625_length_256_cov_3.174863_g77203_i0 | PRJNA939415 | 77625 | 256 | 3.174863 | 8.12764928 | Parietochloris pseudoalveolaris | 3102 | Plants | Plants | 171 | 6.16e-38 | NTclustered | gi|725650801|ref|NC_025532.1| | 3102 | g77203 | i0 | 84.091 | 12.1328125 | 176 | 28 | 69 | 0 | 80 | 255 | 108234 | 108059 | Ettlia pseudoalveolaris culture-collection UTEX:975 chloroplast, complete genome | blastn | 3106 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Parietochloris | Parietochloris pseudoalveolaris | |
| 6360293 | 6360293 | PRJNA939415_P_NODE_110505_length_204_cov_5.335878_g110083_i0 | PRJNA939415 | 110505 | 204 | 5.335878 | 10.88519112 | root | 1 | Root_unresolved | Root_unresolved | 377 | 2.59e-100 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g110083 | i0 | 100 | 99.7058823529412 | 204 | 0 | 100 | 0 | 1 | 204 | 601 | 804 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 20340 | 377 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 9844522 | 9844522 | PRJNA939415_P_NODE_99348_length_235_cov_6.160494_g98926_i0 | PRJNA939415 | 99348 | 235 | 6.160494 | 14.4771609 | Ankyra judayi | 52688 | Plants | Plants | 110 | 1.23e-19 | NTclustered | gi|1011057710|ref|NC_029735.1| | 52688 | g98926 | i0 | 100 | 25.5574468085106 | 59 | 0 | 25 | 0 | 1 | 59 | 77220 | 77162 | Ankyra judayi strain SAG 17.84 chloroplast, complete genome | blastn | 6006 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Sphaeropleaceae | Ankyra | Ankyra judayi | |
| 11119181 | 11119181 | PRJNA939415_P_NODE_43129_length_290_cov_3.225806_g42707_i0 | PRJNA939415 | 43129 | 290 | 3.225806 | 9.3548374 | Trebouxiophyceae sp. MX-AZ01 | 1208065 | Plants | Plants | 298 | 3.12e-76 | NTclustered | gi|409052464|ref|NC_018569.1| | 1208065 | g42707 | i0 | 85.816 | 32.2448275862069 | 282 | 39 | 97 | 1 | 10 | 290 | 89749 | 89468 | Trebouxiophyceae sp. MX-AZ01 chloroplast, complete genome | blastn | 9351 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiophyceae sp. MX-AZ01 | ||||
| 11119283 | 11119283 | PRJNA939415_P_NODE_48609_length_285_cov_1.938679_g48187_i0 | PRJNA939415 | 48609 | 285 | 1.938679 | 5.52523515 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 300 | 8.52e-77 | NTclustered | gi|545354668|ref|XM_005643111.1| | 574566 | g48187 | i0 | 85.714 | 1.00701754385965 | 287 | 38 | 99 | 1 | 2 | 285 | 2211 | 2497 | Coccomyxa subellipsoidea C-169 DUF185-domain-containing protein partial mRNA | blastn | 287 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 13668805 | 13668805 | PRJNA939415_P_NODE_26931_length_310_cov_4.215190_g26509_i0 | PRJNA939415 | 26931 | 310 | 4.21519 | 13.067089 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 134 | 1.01e-26 | NTclustered | gi|545364299|ref|XM_005647157.1| | 574566 | g26509 | i0 | 86.667 | 0.780645161290323 | 120 | 16 | 39 | 0 | 6 | 125 | 1979 | 1860 | Coccomyxa subellipsoidea C-169 P-loop containing nucleoside triphosphate hydrolase protein partial mRNA | blastn | 242 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 13669068 | 13669068 | PRJNA939415_P_NODE_41251_length_292_cov_4.785388_g40829_i0 | PRJNA939415 | 41251 | 292 | 4.785388 | 13.97333296 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 126 | 1.57e-24 | NTclustered | gi|545366727|ref|XM_005648192.1| | 574566 | g40829 | i0 | 91.304 | 0.315068493150685 | 92 | 8 | 32 | 0 | 21 | 112 | 422 | 331 | Coccomyxa subellipsoidea C-169 nucleotide-diphospho-sugar transferase partial mRNA | blastn | 92 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17493870 | 17493870 | PRJNA939415_P_NODE_44354_length_289_cov_2.425926_g43932_i0 | PRJNA939415 | 44354 | 289 | 2.425926 | 7.01092614 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 80.5 | 1.23e-10 | NTclustered | gi|545355381|ref|XM_005643434.1| | 574566 | g43932 | i0 | 91.379 | 0.200692041522491 | 58 | 5 | 20 | 0 | 1 | 58 | 280 | 337 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 58 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17494684 | 17494684 | PRJNA939415_P_NODE_91234_length_244_cov_3.543860_g90812_i0 | PRJNA939415 | 91234 | 244 | 3.54386 | 8.6470184 | Trebouxiophyceae sp. MX-AZ01 | 1208065 | Plants | Plants | 211 | 3.43e-50 | NTclustered | gi|409052422|ref|NC_018568.1| | 1208065 | g90812 | i0 | 90.123 | 0.938524590163934 | 162 | 16 | 66 | 0 | 83 | 244 | 58058 | 58219 | Trebouxiophyceae sp. MX-AZ01 mitochondrion, complete genome | blastn | 229 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiophyceae sp. MX-AZ01 | ||||
| 20041728 | 20041728 | PRJNA939415_P_NODE_21016_length_340_cov_2.524345_g20596_i0 | PRJNA939415 | 21016 | 340 | 2.524345 | 8.582773 | Pseudococcomyxa simplex | 464287 | Plants | Plants | 200 | 1.08e-46 | NTclustered | gi|1584178652|gb|MK422488.1| | 464287 | g20596 | i0 | 94.574 | 0.379411764705882 | 129 | 7 | 38 | 0 | 2 | 130 | 179 | 51 | Pseudococcomyxa simplex catalase variant Cat4 mRNA, partial cds | blastn | 129 | 200 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Oocystaceae | Pseudococcomyxa | Pseudococcomyxa simplex | |
| 20043084 | 20043084 | PRJNA939415_P_NODE_92756_length_243_cov_2.482353_g92334_i0 | PRJNA939415 | 92756 | 243 | 2.482353 | 6.03211779 | Chlorella variabilis | 554065 | Plants | Plants | 226 | 1.2199999999999999e-54 | NTclustered | gi|552848854|ref|XM_005852141.1| | 554065 | g92334 | i0 | 84.581 | 6 | 227 | 35 | 93 | 0 | 2 | 228 | 3943 | 4169 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_133427) mRNA, complete cds | blastn | 1458 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23867233 | 23867233 | PRJNA939415_P_NODE_109479_length_208_cov_12.555556_g109057_i0 | PRJNA939415 | 109479 | 208 | 12.555556 | 26.11555648 | Aphanochaete elegans | 764105 | Plants | Plants | 95.3 | 2.98e-15 | NTclustered | gi|1834978037|ref|NC_047440.1| | 764105 | g109057 | i0 | 92.424 | 0.6875 | 66 | 5 | 32 | 0 | 21 | 86 | 132675 | 132610 | Aphanochaete elegans chloroplast, complete genome | blastn | 143 | 95.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Aphanochaetaceae | Aphanochaete | Aphanochaete elegans | |
| 25141494 | 25141494 | PRJNA939415_P_NODE_34700_length_309_cov_3.101695_g34278_i0 | PRJNA939415 | 34700 | 309 | 3.101695 | 9.58423755 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 110 | 1.69e-19 | NTclustered | gi|545360537|ref|XM_005645586.1| | 574566 | g34278 | i0 | 85.714 | 0.339805825242718 | 105 | 13 | 34 | 2 | 3 | 106 | 367 | 470 | Coccomyxa subellipsoidea C-169 urea active transporter-like protein 2 partial mRNA | blastn | 105 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea |
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);;