contig_metadata
14 rows where bioproject = "PRJNA546018" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 510750 | 510750 | PRJNA546018_S_NODE_19481_length_367_cov_8.591503_g19156_i0 | PRJNA546018 | 19481 | 367 | 8.591503 | 31.53081601 | Gonium pectorale | 33097 | Plants | Plants | 104 | 9.49e-18 | NTclustered | gi|459172117|ref|NC_020437.1| | 33097 | g19156 | i0 | 90.909 | 4.0708446866485 | 77 | 7 | 21 | 0 | 63 | 139 | 9644 | 9720 | Gonium pectorale mitochondrion, complete genome | blastn | 1494 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 2394687 | 2394687 | PRJNA546018_S_NODE_40722_length_241_cov_22.761111_g40397_i0 | PRJNA546018 | 40722 | 241 | 22.761111 | 54.85427751 | Chlorophyta | 3041 | Plants | Plants | 117 | 7.58e-22 | NTclustered | gi|15281672|gb|AF395512.1| | 51713 | g40397 | i0 | 97.101 | 35.2199170124481 | 69 | 2 | 29 | 0 | 11 | 79 | 1834 | 1902 | Stephanosphaera sp. UTEX-LB 2409 strain UTEX LB 2409 26S ribosomal RNA gene, partial sequence | blastn | 8488 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Stephanosphaera | Stephanosphaera sp. UTEX-LB 2409 | |
| 3061813 | 3061813 | PRJNA546018_S_NODE_30643_length_283_cov_2.581081_g30318_i0 | PRJNA546018 | 30643 | 283 | 2.581081 | 7.30445923 | Trentepohlia sp. YN1317 | 2907467 | Plants | Plants | 316 | 8.39e-82 | NTclustered | gi|2172948447|gb|MZ334626.1| | 2907467 | g30318 | i0 | 89.37 | 67.339222614841 | 254 | 24 | 90 | 2 | 1 | 254 | 49972 | 50222 | Trentepohlia sp. YN1317 chloroplast, complete genome | blastn | 19057 | 316 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Trentepohlia | Trentepohlia sp. YN1317 | |
| 8164104 | 8164104 | PRJNA546018_S_NODE_51967_length_210_cov_1.691275_g51642_i0 | PRJNA546018 | 51967 | 210 | 1.691275 | 3.5516775 | Pseudochlorella signiensis | 173497 | Plants | Plants | 143 | 1.06e-29 | NTclustered | gi|2724824453|gb|PP746560.1| | 173497 | g51642 | i0 | 82.609 | 19.147619047619 | 161 | 28 | 77 | 0 | 10 | 170 | 2568 | 2728 | Pseudochlorella signiensis culture SAG:7.90 mitochondrion, complete genome | blastn | 4021 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 10715244 | 10715244 | PRJNA546018_S_NODE_41969_length_237_cov_2.215909_g41644_i0 | PRJNA546018 | 41969 | 237 | 2.215909 | 5.25170433 | Koliella corcontica | 155904 | Plants | Plants | 69.4 | 2.11e-7 | NTclustered | gi|2724824266|gb|PP746555.1| | 155904 | g41644 | i0 | 87.931 | 0.244725738396624 | 58 | 7 | 24 | 0 | 178 | 235 | 43099 | 43042 | Koliella corcontica culture SAG:24.84 mitochondrion, complete genome | blastn | 58 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella corcontica | |
| 13872973 | 13872973 | PRJNA546018_S_NODE_13351_length_460_cov_6.012531_g13027_i0 | PRJNA546018 | 13351 | 460 | 6.012531 | 27.6576426 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 2.06e-5 | NTclustered | gi|520624|emb|Z33463.1| | 3140 | g13027 | i0 | 100 | 7.35652173913043 | 34 | 0 | 7 | 0 | 1 | 34 | 1104 | 1137 | B.oerstedi gene for 18S rRNA | blastn | 3384 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Dasycladales | Dasycladaceae | Batophora | Batophora oerstedii | |
| 19637131 | 19637131 | PRJNA546018_S_NODE_32596_length_273_cov_2.849057_g32271_i0 | PRJNA546018 | 32596 | 273 | 2.849057 | 7.77792561 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 359 | 1.32e-94 | NTclustered | gi|2917930141|emb|OZ234926.1| | 3350044 | g32271 | i0 | 94.093 | 3.71428571428571 | 237 | 13 | 87 | 1 | 25 | 261 | 113208 | 112973 | Trebouxia sp. SL0000003 genome assembly, organelle: mitochondrion | blastn | 1014 | 359 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 19637181 | 19637181 | PRJNA546018_S_NODE_35816_length_259_cov_2.126263_g35491_i0 | PRJNA546018 | 35816 | 259 | 2.126263 | 5.50702117 | Picochlorum sp. | 2812594 | Plants | Plants | 102 | 2.31e-17 | NTclustered | gi|2632235332|gb|OR922714.1| | 2812594 | g35491 | i0 | 92.958 | 23.8610038610039 | 71 | 4 | 27 | 1 | 1 | 70 | 3753 | 3823 | Picochlorum sp. strain AGSB0128 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 | 6180 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. | |||
| 20912899 | 20912899 | PRJNA546018_S_NODE_26377_length_309_cov_3.487903_g26052_i0 | PRJNA546018 | 26377 | 309 | 3.487903 | 10.77762027 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 542 | 1.3999999999999995e-149 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g26052 | i0 | 100 | 89.57928802589 | 293 | 0 | 95 | 0 | 1 | 293 | 6544 | 6252 | 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 | 27680 | 542 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 20913040 | 20913040 | PRJNA546018_S_NODE_34717_length_263_cov_5.118812_g34392_i0 | PRJNA546018 | 34717 | 263 | 5.118812 | 13.46247556 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 420 | 5.71e-113 | NTclustered | gi|1601875646|gb|MK694759.1| | 2315456 | g34392 | i0 | 95.437 | 100.794676806084 | 263 | 12 | 100 | 0 | 1 | 263 | 4550 | 4288 | Coccomyxa sp. Obi 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 | 26509 | 420 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 22796399 | 22796399 | PRJNA546018_S_NODE_32338_length_274_cov_5.769953_g32013_i0 | PRJNA546018 | 32338 | 274 | 5.769953 | 15.80967122 | Coccomyxa | 41891 | Plants | Plants | 291 | 4.9e-74 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g32013 | i0 | 85.971 | 101.405109489051 | 278 | 32 | 100 | 6 | 1 | 274 | 1129 | 855 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 27785 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24736893 | 24736893 | PRJNA546018_S_NODE_30600_length_283_cov_4.914414_g30275_i0 | PRJNA546018 | 30600 | 283 | 4.914414 | 13.90779162 | Koliella longiseta | 33092 | Plants | Plants | 374 | 4.9099999999999985e-99 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g30275 | i0 | 92.366 | 93.2862190812721 | 262 | 20 | 93 | 0 | 22 | 283 | 4689 | 4950 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 26400 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 28151959 | 28151959 | PRJNA546018_S_NODE_44645_length_229_cov_1.547619_g44320_i0 | PRJNA546018 | 44645 | 229 | 1.547619 | 3.54404751 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 43.9 | 0.0124 | NR | KAL4424952.1 | 554058 | g44320 | i0 | 32.8 | 1.51965065502183 | 58 | 32 | 76 | 1 | 11 | 184 | 373 | 423 | KAL4424952.1 hypothetical protein ABPG77_009681 [Micractinium sp. CCAP 211/92] | diamond | 348 | 43.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 30741382 | 30741382 | PRJNA546018_S_NODE_44554_length_229_cov_2.053571_g44229_i0 | PRJNA546018 | 44554 | 229 | 2.053571 | 4.70267759 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 43.9 | 0.0115 | NR | KAA6423816.1 | 2608996 | g44229 | i0 | 64.3 | 0.366812227074236 | 28 | 10 | 36.7 | 0 | 11 | 94 | 250 | 277 | KAA6423816.1 MAG: light-harvesting of photosystem I [Trebouxia sp. A1-2] | diamond | 84 | 43.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 |
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);;