contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2270629 | 2270629 | PRJEB73599_P_NODE_7122_length_215_cov_3.586022_g6835_i0 | PRJEB73599 | 7122 | 215 | 3.586022 | 7.7099473 | Chlorophyceae | 3166 | Plants | Plants | 364 | 2.139999999999999e-96 | NTclustered | gi|15281674|gb|AF395514.1| | 106201 | g6835 | i0 | 97.209 | 99.9906976744186 | 215 | 6 | 100 | 0 | 1 | 215 | 1465 | 1679 | Tetraspora sp. UTEX-LB 234 strain UTEX LB 234 26S ribosomal RNA gene, partial sequence | blastn | 21498 | 364 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Tetrasporales | Tetrasporaceae | Tetraspora | Tetraspora sp. UTEX-LB 234 | |
| 2685230 | 2685230 | PRJEB73599_P_NODE_1603_length_588_cov_3.228980_g1382_i0 | PRJEB73599 | 1603 | 588 | 3.22898 | 18.9864024 | Hafniomonas laevis | 436124 | Plants | Plants | 324 | 1.12e-83 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1382 | i0 | 82.368 | 42.1292517006803 | 397 | 46 | 92 | 12 | 1 | 382 | 135027 | 134640 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 24772 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 3961277 | 3961277 | PRJEB73599_P_NODE_3964_length_348_cov_2.686520_g3677_i0 | PRJEB73599 | 3964 | 348 | 2.68652 | 9.3490896 | Hafniomonas laevis | 436124 | Plants | Plants | 473 | 5.94e-129 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g3677 | i0 | 94.481 | 112.324712643678 | 308 | 16 | 89 | 1 | 40 | 347 | 136949 | 137255 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 39089 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 5237709 | 5237709 | PRJEB73599_P_NODE_2045_length_517_cov_3.536885_g1793_i0 | PRJEB73599 | 2045 | 517 | 3.536885 | 18.28569545 | Hafniomonas laevis | 436124 | Plants | Plants | 494 | 7e-135 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1793 | i0 | 84.211 | 131.056092843327 | 532 | 58 | 99 | 14 | 2 | 517 | 134506 | 135027 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 67756 | 494 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 9062430 | 9062430 | PRJEB73599_P_NODE_2248_length_492_cov_2.492441_g1989_i0 | PRJEB73599 | 2248 | 492 | 2.492441 | 12.26280972 | Hafniomonas laevis | 436124 | Plants | Plants | 634 | 3.749999999999999e-177 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1989 | i0 | 91.045 | 144.591463414634 | 469 | 42 | 95 | 0 | 24 | 492 | 133000 | 132532 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 71139 | 634 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 9062489 | 9062489 | PRJEB73599_P_NODE_9288_length_166_cov_1.635036_g9001_i0 | PRJEB73599 | 9288 | 166 | 1.635036 | 2.71415976 | Hafniomonas laevis | 436124 | Plants | Plants | 235 | 1.2899999999999998e-57 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g9001 | i0 | 95.302 | 9.44578313253012 | 149 | 6 | 91 | 1 | 1 | 148 | 130761 | 130909 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 1568 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 11198814 | 11198814 | PRJEB73599_P_NODE_7369_length_207_cov_4.747191_g7082_i0 | PRJEB73599 | 7369 | 207 | 4.747191 | 9.82668537 | Hydrodictyaceae | 3103 | Plants | Plants | 150 | 6.24e-32 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g7082 | i0 | 79.907 | 27.1304347826087 | 214 | 35 | 100 | 8 | 1 | 207 | 3241 | 3029 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 5616 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 11198820 | 11198820 | PRJEB73599_P_NODE_9049_length_170_cov_2.099291_g8762_i0 | PRJEB73599 | 9049 | 170 | 2.099291 | 3.5687947 | Chlorophyceae | 3166 | Plants | Plants | 180 | 6.25e-41 | NTclustered | gi|9438172|gb|AF277656.1| | 132190 | g8762 | i0 | 91.538 | 78.8705882352941 | 130 | 11 | 76 | 0 | 41 | 170 | 433 | 304 | Pseudoschroederia antillarum culture SAG:15.86 strain SAG B 15.86 28S ribosomal RNA gene, partial sequence | blastn | 13408 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Schroederiaceae | Pseudoschroederia | Pseudoschroederia antillarum | |
| 12474464 | 12474464 | PRJEB73599_P_NODE_7670_length_199_cov_5.000000_g7383_i0 | PRJEB73599 | 7670 | 199 | 5 | 9.95 | Chlamydomonadaceae | 3051 | Plants | Plants | 272 | 1.2199999999999999e-68 | NTclustered | gi|66864302|gb|DQ015757.1| | 158507 | g7383 | i0 | 93.048 | 43.6482412060301 | 187 | 12 | 93 | 1 | 14 | 199 | 3228 | 3042 | Oogamochlamys gigantea strain SAG 44.91 26S ribosomal RNA gene, partial sequence | blastn | 8686 | 274 | 0.992700729927007 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Oogamochlamys | Oogamochlamys gigantea | |
| 12888713 | 12888713 | PRJEB73599_P_NODE_2751_length_440_cov_3.963504_g2474_i0 | PRJEB73599 | 2751 | 440 | 3.963504 | 17.4394176 | Hafniomonas laevis | 436124 | Plants | Plants | 518 | 3.4899999999999996e-142 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g2474 | i0 | 93.642 | 126.170454545455 | 346 | 22 | 95 | 0 | 3 | 348 | 135515 | 135170 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 55515 | 518 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 12888745 | 12888745 | PRJEB73599_P_NODE_5611_length_265_cov_3.394068_g5324_i0 | PRJEB73599 | 5611 | 265 | 3.394068 | 8.9942802 | Stephanosphaera pluvialis | 51712 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|952954307|gb|KT625385.1| | 51712 | g5324 | i0 | 100 | 20.0377358490566 | 30 | 0 | 11 | 0 | 236 | 265 | 2202 | 2173 | Stephanosphaera pluvialis clone contig-65e chloroplast, partial genome | blastn | 5310 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Stephanosphaera | Stephanosphaera pluvialis | |
| 15437662 | 15437662 | PRJEB73599_P_NODE_5113_length_286_cov_11.684825_g4826_i0 | PRJEB73599 | 5113 | 286 | 11.684825 | 33.4185995 | Pseudopediastrum boryanum | 55410 | Plants | Plants | 438 | 1.7399999999999996e-118 | NTclustered | gi|1388162763|gb|MF276983.1| | 55410 | g4826 | i0 | 94.406 | 131.269230769231 | 286 | 15 | 100 | 1 | 1 | 286 | 95722 | 95438 | Pseudopediastrum boryanum chloroplast, complete genome | blastn | 37543 | 438 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pseudopediastrum | Pseudopediastrum boryanum | |
| 16298160 | 16298160 | PRJEB73599_P_NODE_7613_length_201_cov_2.110465_g7326_i0 | PRJEB73599 | 7613 | 201 | 2.110465 | 4.24203465 | Chlamydomonadales | 3042 | Plants | Plants | 263 | 7.419999999999999e-66 | NTclustered | gi|397121|emb|X68924.1| | 133709 | g7326 | i0 | 95.21 | 129.124378109453 | 167 | 7 | 83 | 1 | 2 | 167 | 570 | 404 | Chloroplast Chlamydomonas sp. 66.72 rrnL gene, exon 2 | blastn | 25954 | 265 | 0.992452830188679 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. 66.72 | |
| 17986785 | 17986785 | PRJEB73599_P_NODE_6995_length_219_cov_3.147368_g6708_i0 | PRJEB73599 | 6995 | 219 | 3.147368 | 6.89273592 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 265 | 2.29e-66 | NTclustered | gi|822624806|gb|KP313859.1| | 1653778 | g6708 | i0 | 88.584 | 35.9315068493151 | 219 | 24 | 100 | 1 | 1 | 219 | 6382 | 6165 | Chlamydomonas sp. UWO 241 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7869 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 24361037 | 24361037 | PRJEB73599_P_NODE_9140_length_168_cov_4.028777_g8853_i0 | PRJEB73599 | 9140 | 168 | 4.028777 | 6.76834536 | Corbierea radiosa | 51318 | Plants | Plants | 305 | 9.81e-79 | NTclustered | gi|18654306|gb|L42987.1|RTCCPRGOLB | 51318 | g8853 | i0 | 100 | 133.642857142857 | 165 | 0 | 98 | 0 | 4 | 168 | 1717 | 1553 | Carteria radiosa large subunit ribosomal RNA gene, complete sequence; chloroplast gene for chloroplast product | blastn | 22452 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Corbierea | Corbierea radiosa |
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);;