contig_metadata
16 rows where bioproject = "PRJEB83711" and tax_clade = "Sar"
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 | ||
| 7797008 | 7797008 | PRJEB83711_P_NODE_68067_length_247_cov_1.793103_g67801_i0 | PRJEB83711 | 68067 | 247 | 1.793103 | 4.42896441 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 6.16e-8 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g67801 | i0 | 86.364 | 0.267206477732794 | 66 | 8 | 27 | 1 | 182 | 247 | 935 | 999 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 66 | 71.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 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 | ||
| 12897818 | 12897818 | PRJEB83711_P_NODE_53331_length_260_cov_2.304813_g53065_i0 | PRJEB83711 | 53331 | 260 | 2.304813 | 5.9925138 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 9.569999999999998e-101 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g53065 | i0 | 94.4 | 2.22307692307692 | 250 | 8 | 95 | 4 | 1 | 248 | 1540 | 1295 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 578 | 379 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 13751990 | 13751990 | PRJEB83711_P_NODE_29471_length_330_cov_1.042802_g29205_i0 | PRJEB83711 | 29471 | 330 | 1.042802 | 3.4412466 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 5.479999999999998e-144 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g29205 | i0 | 95.181 | 1239.62121212121 | 332 | 14 | 100 | 1 | 1 | 330 | 71 | 402 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 409075 | 523 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 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 | ||
| 21821382 | 21821382 | PRJEB83711_P_NODE_69338_length_247_cov_0.896552_g69072_i0 | PRJEB83711 | 69338 | 247 | 0.896552 | 2.21448344 | Theileria annulata | 5874 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 1.9e-117 | NTclustered | gi|84994111|ref|XM_946685.1| | 5874 | g69072 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 11654 | 11900 | Theileria annulata uncharacterized protein (TA15945), partial mRNA | blastn | 247 | 435 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 22675505 | 22675505 | PRJEB83711_P_NODE_41278_length_286_cov_1.098592_g41012_i0 | PRJEB83711 | 41278 | 286 | 1.098592 | 3.14197312 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 4.659999999999998e-144 | NTclustered | gi|47935036|gb|AY613853.1| | 280247 | g41012 | i0 | 99.65 | 100.706293706294 | 286 | 1 | 100 | 0 | 1 | 286 | 67 | 352 | Eimeria arnyi 18S ribosomal RNA gene, partial sequence | blastn | 28802 | 523 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria arnyi | ||
| 23096710 | 23096710 | PRJEB83711_P_NODE_70219_length_246_cov_1.329480_g69953_i0 | PRJEB83711 | 70219 | 246 | 1.32948 | 3.2705208 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.2e-105 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g69953 | i0 | 95.547 | 45.130081300813 | 247 | 10 | 100 | 1 | 1 | 246 | 97363 | 97117 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 11102 | 394 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 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 | ||
| 30697750 | 30697750 | PRJEB83711_P_NODE_47834_length_271_cov_1.585859_g47568_i0 | PRJEB83711 | 47834 | 271 | 1.585859 | 4.29767789 | Thalassiosira oceanica | 159749 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00743 | NR | EJK44156.1 | 159749 | g47568 | i0 | 50 | 0.664206642066421 | 60 | 25 | 65.3 | 2 | 233 | 57 | 230 | 285 | EJK44156.1 hypothetical protein THAOC_37330 [Thalassiosira oceanica] | diamond | 180 | 45.1 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira oceanica | ||
| 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 | ||
| 32398254 | 32398254 | PRJEB83711_P_NODE_71179_length_246_cov_0.901734_g70913_i0 | PRJEB83711 | 71179 | 246 | 0.901734 | 2.21826564 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.09e-24 | NR | CAE8594869.1 | 89957 | g70913 | i0 | 68.8 | 4.57317073170732 | 77 | 22 | 93.9 | 1 | 244 | 14 | 662 | 736 | CAE8594869.1 unnamed protein product [Polarella glacialis] | diamond | 1125 | 104 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis |
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);;