contig_metadata
11 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);;