contig_metadata
9 rows where bioproject = "PRJEB29441", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26519 | 26519 | PRJEB29441_P_NODE_31181_length_187_cov_2.485507_g30740_i0 | PRJEB29441 | 31181 | 187 | 2.485507 | 4.64789809 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 9.229999999999999e-30 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g30740 | i0 | 80.729 | 7.83422459893048 | 192 | 29 | 99 | 5 | 1 | 186 | 1684 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 1465 | 143 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 8953750 | 8953750 | PRJEB29441_P_NODE_44928_length_162_cov_2.707965_g44487_i0 | PRJEB29441 | 44928 | 162 | 2.707965 | 4.3869033 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.04e-70 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g44487 | i0 | 97.531 | 1 | 162 | 4 | 100 | 0 | 1 | 162 | 589 | 428 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 162 | 278 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11191595 | 11191595 | PRJEB29441_P_NODE_28189_length_197_cov_2.668919_g27748_i0 | PRJEB29441 | 28189 | 197 | 2.668919 | 5.25777043 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.51e-90 | NTclustered | gi|2493707699|dbj|LC764482.1| | 45107 | g27748 | i0 | 97.99 | 101.005076142132 | 199 | 2 | 100 | 1 | 1 | 197 | 160 | 358 | Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence | blastn | 19898 | 344 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12779941 | 12779941 | PRJEB29441_P_NODE_21451_length_228_cov_2.519553_g21010_i0 | PRJEB29441 | 21451 | 228 | 2.519553 | 5.74458084 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.52e-28 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g21010 | i0 | 79.204 | 11.1666666666667 | 226 | 28 | 96 | 13 | 11 | 228 | 4018 | 3804 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 2546 | 139 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15328894 | 15328894 | PRJEB29441_P_NODE_45113_length_162_cov_1.690265_g44672_i0 | PRJEB29441 | 45113 | 162 | 1.690265 | 2.7382293 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.07e-60 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g44672 | i0 | 95.425 | 88.7654320987654 | 153 | 7 | 94 | 0 | 10 | 162 | 1916 | 2068 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 14380 | 244 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 16603146 | 16603146 | PRJEB29441_P_NODE_17614_length_256_cov_2.265700_g17173_i0 | PRJEB29441 | 17614 | 256 | 2.2657 | 5.800192 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.3e-49 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g17173 | i0 | 82.4 | 28.5625 | 250 | 34 | 96 | 10 | 12 | 256 | 4021 | 3777 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 7312 | 209 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17878518 | 17878518 | PRJEB29441_P_NODE_8155_length_403_cov_2.898305_g7716_i0 | PRJEB29441 | 8155 | 403 | 2.898305 | 11.68016915 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 1.0799999999999996e-176 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g7716 | i0 | 95.037 | 100.637717121588 | 403 | 18 | 100 | 2 | 1 | 403 | 1201 | 1601 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 40557 | 632 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 19152176 | 19152176 | PRJEB29441_P_NODE_37376_length_170_cov_1.776860_g36935_i0 | PRJEB29441 | 37376 | 170 | 1.77686 | 3.020662 | Bodomorpha sp. HFCC56 | 352464 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.64e-81 | NTclustered | gi|83034974|gb|DQ211603.1| | 352464 | g36935 | i0 | 100 | 99.4882352941176 | 170 | 0 | 100 | 0 | 1 | 170 | 456 | 287 | Bodomorpha sp. HFCC56 28S ribosomal RNA gene, partial sequence | blastn | 16913 | 315 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC56 | |||
| 20427513 | 20427513 | PRJEB29441_P_NODE_47997_length_158_cov_2.412844_g47556_i0 | PRJEB29441 | 47997 | 158 | 2.412844 | 3.81229352 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 7.120000000000001e-70 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g47556 | i0 | 98.101 | 99.7784810126582 | 158 | 3 | 100 | 0 | 1 | 158 | 1185 | 1028 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15765 | 276 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;