contig_metadata
8 rows where bioproject = "PRJEB83711", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3970631 | 3970631 | PRJEB83711_P_NODE_61564_length_251_cov_0.876404_g61298_i0 | PRJEB83711 | 61564 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.73e-26 | NR | AAL50117.1 | 77619 | g61298 | i0 | 73.2 | 5.09163346613546 | 71 | 19 | 84.9 | 0 | 249 | 37 | 110 | 180 | AAL50117.1 actin, partial [Vorticella microstoma] | diamond | 1278 | 110 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella microstoma | ||
| 6522488 | 6522488 | PRJEB83711_P_NODE_51686_length_263_cov_5.063158_g51420_i0 | PRJEB83711 | 51686 | 263 | 5.063158 | 13.31610554 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 4.389999999999998e-119 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g51420 | i0 | 96.947 | 83.7528517110266 | 262 | 8 | 99 | 0 | 1 | 262 | 367 | 628 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 22027 | 440 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 12897216 | 12897216 | PRJEB83711_P_NODE_28331_length_335_cov_11.629771_g28065_i0 | PRJEB83711 | 28331 | 335 | 11.629771 | 38.95973285 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 569 | 7.049999999999998e-158 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g28065 | i0 | 98.16 | 93.5880597014925 | 326 | 6 | 97 | 0 | 1 | 326 | 1493 | 1818 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 31352 | 569 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 13752214 | 13752214 | PRJEB83711_P_NODE_54771_length_258_cov_1.167568_g54505_i0 | PRJEB83711 | 54771 | 258 | 1.167568 | 3.01232544 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.2699999999999985e-130 | NTclustered | gi|16943682|emb|AJ310486.1| | 114678 | g54505 | i0 | 100 | 99.984496124031 | 258 | 0 | 100 | 0 | 1 | 258 | 309 | 52 | Onychodromus grandis 18S rRNA gene | blastn | 25796 | 477 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Onychodromus | Onychodromus grandis | ||
| 17576510 | 17576510 | PRJEB83711_P_NODE_42634_length_282_cov_6.693780_g42368_i0 | PRJEB83711 | 42634 | 282 | 6.69378 | 18.8764596 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 7.67e-142 | NTclustered | gi|10930|emb|X56531.1| | 6026 | g42368 | i0 | 99.645 | 99.9964539007092 | 282 | 1 | 100 | 0 | 1 | 282 | 343 | 62 | O.henneguyi small subunit ribosomal RNA gene | blastn | 28199 | 521 | 0.990403071017274 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 20545154 | 20545154 | PRJEB83711_P_NODE_47397_length_272_cov_1.567839_g47131_i0 | PRJEB83711 | 47397 | 272 | 1.567839 | 4.26452208 | Epistylis sp. 8 | 2979171 | SAR_Eukaryotes | SAR_Eukaryotes | 503 | 5.729999999999998e-138 | NTclustered | gi|2304601484|gb|OP458305.1| | 2979171 | g47131 | i0 | 100 | 95.7316176470588 | 272 | 0 | 100 | 0 | 1 | 272 | 1787 | 1516 | Epistylis sp. 8 large subunit ribosomal RNA gene, partial sequence | blastn | 26039 | 503 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. 8 | ||
| 27981977 | 27981977 | PRJEB83711_P_NODE_58525_length_253_cov_0.866667_g58259_i0 | PRJEB83711 | 58525 | 253 | 0.866667 | 2.19266751 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 9.82e-10 | NR | CAG9325523.1 | 1481888 | g58259 | i0 | 48.4 | 2.53754940711462 | 62 | 28 | 73.5 | 1 | 219 | 34 | 47 | 104 | CAG9325523.1 unnamed protein product [Blepharisma stoltei] | diamond | 642 | 64.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30919204 | 30919204 | PRJEB83711_P_NODE_67474_length_248_cov_0.891429_g67208_i0 | PRJEB83711 | 67474 | 248 | 0.891429 | 2.21074392 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 6.26e-4 | NR | KRX00730.1 | 266149 | g67208 | i0 | 90.5 | 0.254032258064516 | 21 | 2 | 25.4 | 0 | 121 | 183 | 134 | 154 | KRX00730.1 hypothetical protein PPERSA_02990 [Pseudocohnilembus persalinus] | diamond | 63 | 47 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;