contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668504 | 668504 | PRJNA688931_P_NODE_29761_length_186_cov_1.459854_g29548_i0 | PRJNA688931 | 29761 | 186 | 1.459854 | 2.71532844 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 9.11e-35 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g29548 | i0 | 86.275 | 28.8709677419355 | 153 | 13 | 80 | 5 | 1 | 149 | 1647 | 1795 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 5370 | 159 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 5772001 | 5772001 | PRJNA688931_P_NODE_13985_length_277_cov_1.982456_g13772_i0 | PRJNA688931 | 13985 | 277 | 1.982456 | 5.49140312 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.89e-23 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g13772 | i0 | 85.593 | 47.2851985559567 | 118 | 13 | 43 | 2 | 1 | 118 | 8749 | 8862 | Phytocercomonas venanatans 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 | 13098 | 121 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 5772011 | 5772011 | PRJNA688931_P_NODE_15445_length_262_cov_2.023474_g15232_i0 | PRJNA688931 | 15445 | 262 | 2.023474 | 5.30150188 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.02e-60 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g15232 | i0 | 83.895 | 41.8129770992366 | 267 | 33 | 100 | 10 | 1 | 262 | 3986 | 3725 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 10955 | 246 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 7556027 | 7556027 | PRJNA688931_P_NODE_39426_length_165_cov_0.896552_g39213_i0 | PRJNA688931 | 39426 | 165 | 0.896552 | 1.4793108 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.59e-79 | NTclustered | gi|1002343613|gb|KU738491.1| | 175275 | g39213 | i0 | 100 | 96.6727272727273 | 165 | 0 | 100 | 0 | 1 | 165 | 40 | 204 | Uncultured Cercozoa clone OTU_433 18S ribosomal RNA gene, partial sequence | blastn | 15951 | 305 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 8321609 | 8321609 | PRJNA688931_P_NODE_24027_length_209_cov_0.968750_g23814_i0 | PRJNA688931 | 24027 | 209 | 0.96875 | 2.0246875 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 9.78e-85 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g23814 | i0 | 94.737 | 96.2248803827751 | 209 | 11 | 100 | 0 | 1 | 209 | 1642 | 1434 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 20111 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12147820 | 12147820 | PRJNA688931_P_NODE_27790_length_193_cov_1.430556_g27577_i0 | PRJNA688931 | 27790 | 193 | 1.430556 | 2.76097308 | Mesofila sp. ATCC PRA-54 | 439948 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.2399999999999999e-28 | NTclustered | gi|160337355|gb|EF455774.1| | 439948 | g27577 | i0 | 90.476 | 8.32124352331606 | 105 | 10 | 54 | 0 | 89 | 193 | 465 | 361 | Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds | blastn | 1606 | 139 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila sp. ATCC PRA-54 | ||||
| 14697639 | 14697639 | PRJNA688931_P_NODE_9172_length_351_cov_2.059603_g8959_i0 | PRJNA688931 | 9172 | 351 | 2.059603 | 7.22920653 | Bodomorpha sp. HFCC 927 | 1043717 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 4.619999999999999e-130 | NTclustered | gi|336245481|gb|HM536172.1| | 1043717 | g8959 | i0 | 91.218 | 99.97150997151 | 353 | 27 | 100 | 4 | 1 | 351 | 1297 | 1647 | Bodomorpha sp. HFCC 927 18S ribosomal RNA gene, partial sequence | blastn | 35090 | 477 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 927 | |||
| 17246474 | 17246474 | PRJNA688931_P_NODE_37934_length_166_cov_1.435897_g37721_i0 | PRJNA688931 | 37934 | 166 | 1.435897 | 2.38358902 | Mesofila sp. ATCC PRA-54 | 439948 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.32e-37 | NTclustered | gi|160337400|gb|EF455798.1| | 439948 | g37721 | i0 | 84.94 | 98.6084337349398 | 166 | 25 | 100 | 0 | 1 | 166 | 650 | 485 | Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds | blastn | 16369 | 169 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila sp. ATCC PRA-54 | ||||
| 21580288 | 21580288 | PRJNA688931_P_NODE_40677_length_164_cov_0.904348_g40464_i0 | PRJNA688931 | 40677 | 164 | 0.904348 | 1.48313072 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 3.78e-8 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g40464 | i0 | 97.561 | 7.21341463414634 | 41 | 1 | 25 | 0 | 124 | 164 | 2257 | 2297 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 1183 | 71.3 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 24894690 | 24894690 | PRJNA688931_P_NODE_27440_length_194_cov_2.703448_g27227_i0 | PRJNA688931 | 27440 | 194 | 2.703448 | 5.24468912 | uncultured Bodomorpha | 1586269 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.16e-78 | NTclustered | gi|1723854301|gb|MN323309.1| | 1586269 | g27227 | i0 | 100 | 92.5721649484536 | 165 | 0 | 85 | 0 | 1 | 165 | 162 | 326 | Uncultured Bodomorpha clone OTU0038 small subunit ribosomal RNA gene, partial sequence | blastn | 17959 | 305 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | uncultured Bodomorpha |
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);;