contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA691918" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1179215 | 1179215 | PRJNA691918_S_NODE_61_length_247_cov_14034.324074_g60_i0 | PRJNA691918 | 61 | 247 | 14034.324074 | 34664.78046278 | Scenedesmaceae | 3086 | Plants | Plants | 335 | 1.9799999999999992e-87 | NTclustered | gi|2692951646|ref|NC_086753.1| | 113531 | g60 | i0 | 96.552 | 120.890688259109 | 203 | 6 | 84 | 1 | 3 | 204 | 82459 | 82661 | Tetradesmus distendus strain FBCC-A1020 chloroplast, complete genome | blastn | 29860 | 337 | 0.99406528189911 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus distendus | |
| 7051113 | 7051113 | PRJNA691918_S_NODE_366_length_168_cov_9.912409_g365_i0 | PRJNA691918 | 366 | 168 | 9.912409 | 16.65284712 | Coelastrum microporum | 55409 | Plants | Plants | 257 | 2.79e-64 | NTclustered | gi|2386955046|ref|NC_068582.1| | 55409 | g365 | i0 | 97.351 | 99.25 | 151 | 4 | 90 | 0 | 1 | 151 | 86812 | 86962 | Coelastrum microporum chloroplast, complete genome | blastn | 16674 | 257 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrum | Coelastrum microporum | |
| 10876541 | 10876541 | PRJNA691918_S_NODE_9_length_335_cov_86.023026_g8_i0 | PRJNA691918 | 9 | 335 | 86.023026 | 288.1771371 | Tetradesmus obliquus | 3088 | Plants | Plants | 577 | 4.2199999999999986e-160 | NTclustered | gi|1240946771|gb|KX756229.1| | 3088 | g8 | i0 | 97.904 | 121.113432835821 | 334 | 6 | 99 | 1 | 1 | 333 | 80881 | 80548 | Tetradesmus obliquus chloroplast, complete genome | blastn | 40573 | 577 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 11382744 | 11382744 | PRJNA691918_S_NODE_209_length_193_cov_18879.975309_g208_i0 | PRJNA691918 | 209 | 193 | 18879.975309 | 36438.35234637 | Scenedesmaceae | 3086 | Plants | Plants | 252 | 1.53e-62 | NTclustered | gi|1090895397|gb|KX131180.1| | 1867922 | g208 | i0 | 98.592 | 109.953367875648 | 142 | 2 | 75 | 0 | 49 | 190 | 114080 | 113939 | Hariotina sp. MMOGRB0030F chloroplast, complete genome | blastn | 21221 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Hariotina | Hariotina sp. MMOGRB0030F | |
| 13426262 | 13426262 | PRJNA691918_S_NODE_91_length_227_cov_15340.581633_g90_i0 | PRJNA691918 | 91 | 227 | 15340.581633 | 34823.12030691 | Tetradesmus obliquus | 3088 | Plants | Plants | 302 | 1.82e-77 | NTclustered | gi|406668623|gb|JX401406.1| | 3088 | g90 | i0 | 97.714 | 77.0837004405286 | 175 | 4 | 77 | 0 | 5 | 179 | 61 | 235 | Acutodesmus obliquus isolate SE001 large subunit ribosomal RNA gene, partial sequence | blastn | 17498 | 302 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 15207815 | 15207815 | PRJNA691918_S_NODE_132_length_214_cov_17032.622951_g131_i0 | PRJNA691918 | 132 | 214 | 17032.622951 | 36449.81311514 | Chlorophyta | 3041 | Plants | Plants | 300 | 6.1e-77 | NTclustered | gi|359385314|emb|FR865731.1| | 3088 | g131 | i0 | 99.394 | 77.1028037383178 | 165 | 1 | 77 | 0 | 1 | 165 | 946 | 1110 | Scenedesmus obliquus genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 276/52 | blastn | 16500 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 16482059 | 16482059 | PRJNA691918_S_NODE_133_length_214_cov_16984.901639_g132_i0 | PRJNA691918 | 133 | 214 | 16984.901639 | 36347.68950746 | Chlorophyta | 3041 | Plants | Plants | 294 | 2.8400000000000003e-75 | NTclustered | gi|359385314|emb|FR865731.1| | 3088 | g132 | i0 | 98.788 | 77.1028037383178 | 165 | 2 | 77 | 0 | 1 | 165 | 946 | 1110 | Scenedesmus obliquus genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 276/52 | blastn | 16500 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 17250352 | 17250352 | PRJNA691918_S_NODE_94_length_226_cov_15346.517949_g93_i0 | PRJNA691918 | 94 | 226 | 15346.517949 | 34683.13056474 | Desmodesmus sp. HH 10203 | 2050669 | Plants | Plants | 300 | 6.51e-77 | NTclustered | gi|1273809525|gb|MF326555.1| | 2050669 | g93 | i0 | 96.667 | 79.3893805309735 | 180 | 6 | 80 | 0 | 46 | 225 | 1390 | 1211 | Desmodesmus sp. HH 10203 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 | 17942 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus sp. HH 10203 | |
| 22856599 | 22856599 | PRJNA691918_S_NODE_58_length_248_cov_14318.188940_g57_i0 | PRJNA691918 | 58 | 248 | 14318.18894 | 35509.1085712 | Scenedesmaceae | 3086 | Plants | Plants | 346 | 9.19e-91 | NTclustered | gi|2692951646|ref|NC_086753.1| | 113531 | g57 | i0 | 97.537 | 117.737903225806 | 203 | 4 | 84 | 1 | 45 | 246 | 82661 | 82459 | Tetradesmus distendus strain FBCC-A1020 chloroplast, complete genome | blastn | 29199 | 348 | 0.994252873563218 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus distendus | |
| 23625184 | 23625184 | PRJNA691918_S_NODE_179_length_199_cov_15961.517857_g178_i0 | PRJNA691918 | 179 | 199 | 15961.517857 | 31763.42053543 | Pectinodesmus pectinatus | 91197 | Plants | Plants | 76.8 | 1.02e-9 | NTclustered | gi|1331211015|ref|NC_036659.1| | 91197 | g178 | i0 | 94 | 20.4221105527638 | 50 | 3 | 25 | 0 | 147 | 196 | 12708 | 12659 | Pectinodesmus pectinatus mitochondrion, complete genome | blastn | 4064 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Pectinodesmus | Pectinodesmus pectinatus | |
| 23625186 | 23625186 | PRJNA691918_S_NODE_219_length_192_cov_19082.596273_g218_i0 | PRJNA691918 | 219 | 192 | 19082.596273 | 36638.58484416 | Desmodesmus abundans | 77547 | Plants | Plants | 246 | 7.07e-61 | NTclustered | gi|2312613210|ref|NC_066651.1| | 77547 | g218 | i0 | 97.887 | 108.822916666667 | 142 | 3 | 76 | 0 | 4 | 145 | 74418 | 74559 | Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome | blastn | 20894 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus abundans | |
| 23625190 | 23625190 | PRJNA691918_S_NODE_59_length_248_cov_14255.944700_g58_i0 | PRJNA691918 | 59 | 248 | 14255.9447 | 35354.742856 | Coelastrum microporum | 55409 | Plants | Plants | 340 | 4.27e-89 | NTclustered | gi|2386955046|ref|NC_068582.1| | 55409 | g58 | i0 | 97.03 | 120.387096774194 | 202 | 6 | 84 | 0 | 3 | 204 | 88173 | 88374 | Coelastrum microporum chloroplast, complete genome | blastn | 29856 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrum | Coelastrum microporum | |
| 24898763 | 24898763 | PRJNA691918_S_NODE_180_length_199_cov_10799.880952_g179_i0 | PRJNA691918 | 180 | 199 | 10799.880952 | 21491.76309448 | Tetradesmus obliquus | 3088 | Plants | Plants | 246 | 7.379999999999999e-61 | NTclustered | gi|1240946771|gb|KX756229.1| | 3088 | g179 | i0 | 100 | 38.2914572864322 | 133 | 0 | 67 | 0 | 48 | 180 | 82240 | 82108 | Tetradesmus obliquus chloroplast, complete genome | blastn | 7620 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 25405679 | 25405679 | PRJNA691918_S_NODE_120_length_218_cov_16108.834225_g119_i0 | PRJNA691918 | 120 | 218 | 16108.834225 | 35117.2586105 | Scenedesmaceae | 3086 | Plants | Plants | 300 | 6.23e-77 | NTclustered | gi|109156688|gb|DQ644505.1| | 3073 | g119 | i0 | 98.81 | 77.0688073394495 | 168 | 2 | 77 | 0 | 51 | 218 | 235 | 68 | 'Chlorella' fusca strain KCTC AG10033 18S ribosomal RNA gene, partial sequence | blastn | 16801 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus fuscus |
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);;