contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA853203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2116935 | 2116935 | PRJNA853203_P_NODE_46222_length_243_cov_0.917647_g46073_i0 | PRJNA853203 | 46222 | 243 | 0.917647 | 2.22988221 | Phytophthora litchii | 100870 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4399999999999996e-118 | NTclustered | gi|2248512916|ref|NC_063792.1| | 100870 | g46073 | i0 | 99.177 | 99.7901234567901 | 243 | 2 | 100 | 0 | 1 | 243 | 1081 | 839 | Phytophthora litchii isolate SHS3 mitochondrion, complete genome | blastn | 24249 | 438 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora litchii | ||
| 5944619 | 5944619 | PRJNA853203_P_NODE_29625_length_251_cov_2.039326_g29476_i0 | PRJNA853203 | 29625 | 251 | 2.039326 | 5.11870826 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.88e-16 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g29476 | i0 | 92.754 | 24.808764940239 | 69 | 4 | 27 | 1 | 184 | 251 | 206 | 138 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 6227 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 5944796 | 5944796 | PRJNA853203_P_NODE_8425_length_293_cov_2.195455_g8276_i0 | PRJNA853203 | 8425 | 293 | 2.195455 | 6.43268315 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 8.419999999999998e-107 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g8276 | i0 | 91.696 | 1.21843003412969 | 289 | 22 | 98 | 2 | 1 | 287 | 1208 | 920 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 357 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 8494332 | 8494332 | PRJNA853203_P_NODE_30207_length_251_cov_0.876404_g30058_i0 | PRJNA853203 | 30207 | 251 | 0.876404 | 2.19977404 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.09e-62 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g30058 | i0 | 87.907 | 28.5856573705179 | 215 | 25 | 100 | 1 | 25 | 238 | 302045 | 302259 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7175 | 252 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8887740 | 8887740 | PRJNA853203_P_NODE_5487_length_327_cov_1.181102_g5338_i0 | PRJNA853203 | 5487 | 327 | 1.181102 | 3.86220354 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.5199999999999998e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5338 | i0 | 95.399 | 72.5840978593272 | 326 | 13 | 99 | 2 | 3 | 327 | 177 | 501 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 23735 | 518 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9769659 | 9769659 | PRJNA853203_P_NODE_948_length_633_cov_3.501786_g802_i0 | PRJNA853203 | 948 | 633 | 3.501786 | 22.16630538 | Ebria tripartita | 361426 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 4.5599999999999997e-48 | NTclustered | gi|290760481|gb|GQ144684.1| | 361426 | g802 | i0 | 83.051 | 37.4296998420221 | 236 | 31 | 37 | 8 | 1 | 232 | 2924 | 2694 | Ebria tripartita large subunit ribosomal RNA gene, partial sequence | blastn | 23693 | 206 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ebriacea | Ebria | Ebria tripartita | |||
| 12320703 | 12320703 | PRJNA853203_P_NODE_35470_length_248_cov_1.177143_g35321_i0 | PRJNA853203 | 35470 | 248 | 1.177143 | 2.91931464 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.24e-59 | NTclustered | gi|301113801|ref|XM_002998625.1| | 403677 | g35321 | i0 | 84.274 | 1 | 248 | 39 | 100 | 0 | 1 | 248 | 3385 | 3632 | Phytophthora infestans T30-4 uncharacterized protein (PITG_06580), partial mRNA | blastn | 248 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 13595299 | 13595299 | PRJNA853203_P_NODE_44751_length_243_cov_1.611765_g44602_i0 | PRJNA853203 | 44751 | 243 | 1.611765 | 3.91658895 | Nitzschia sp. DOCU1 | 3041873 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 3.18e-100 | NTclustered | gi|2504366779|emb|OX596002.1| | 3041873 | g44602 | i0 | 94.694 | 106.17695473251 | 245 | 9 | 100 | 4 | 1 | 243 | 31785 | 31543 | Nitzschia sp. DOCU1 genome assembly, organelle: mitochondrion | blastn | 25801 | 377 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia sp. DOCU1 | ||
| 14869450 | 14869450 | PRJNA853203_P_NODE_3812_length_358_cov_1.547368_g3664_i0 | PRJNA853203 | 3812 | 358 | 1.547368 | 5.53957744 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 7.52e-163 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g3664 | i0 | 96.348 | 74.6480446927374 | 356 | 13 | 99 | 0 | 3 | 358 | 2316 | 1961 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 26724 | 586 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 15262749 | 15262749 | PRJNA853203_P_NODE_49912_length_228_cov_2.058065_g49763_i0 | PRJNA853203 | 49912 | 228 | 2.058065 | 4.6923882 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 2.38e-71 | NTclustered | gi|2235892989|tpg|BK012092.1| | 129355 | g49763 | i0 | 88.987 | 3.99122807017544 | 227 | 25 | 99 | 0 | 2 | 228 | 23050 | 23276 | TPA_asm: Phytophthora lateralis strain SMST21 mitochondrion, complete genome | blastn | 910 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lateralis | ||
| 19086287 | 19086287 | PRJNA853203_P_NODE_8895_length_292_cov_1.100457_g8746_i0 | PRJNA853203 | 8895 | 292 | 1.100457 | 3.21333444 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 3.17e-71 | NTclustered | gi|83034975|gb|DQ211604.1| | 352465 | g8746 | i0 | 98.137 | 48.3938356164384 | 161 | 3 | 55 | 0 | 1 | 161 | 383 | 543 | Bodomorpha sp. HFCC57 28S ribosomal RNA gene, partial sequence | blastn | 14131 | 281 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC57 | |||
| 19967995 | 19967995 | PRJNA853203_P_NODE_30836_length_251_cov_0.876404_g30687_i0 | PRJNA853203 | 30836 | 251 | 0.876404 | 2.19977404 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.1499999999999996e-124 | NTclustered | gi|695467766|ref|XM_009541409.1| | 67593 | g30687 | i0 | 99.602 | 87.4342629482072 | 251 | 1 | 100 | 0 | 1 | 251 | 251 | 1 | Phytophthora sojae hypothetical protein mRNA | blastn | 21946 | 459 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 22518344 | 22518344 | PRJNA853203_P_NODE_8018_length_297_cov_0.901786_g7869_i0 | PRJNA853203 | 8018 | 297 | 0.901786 | 2.67830442 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 8.14e-142 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g7869 | i0 | 97.98 | 14.1616161616162 | 297 | 6 | 100 | 0 | 1 | 297 | 1547 | 1251 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 4206 | 516 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24186155 | 24186155 | PRJNA853203_P_NODE_1559_length_486_cov_4.280872_g1412_i0 | PRJNA853203 | 1559 | 486 | 4.280872 | 20.80503792 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.5399999999999993e-28 | NTclustered | gi|1976646300|ref|XR_005506384.1| | 5851 | g1412 | i0 | 88.793 | 24.4794238683128 | 116 | 9 | 23 | 4 | 150 | 263 | 2235 | 2348 | Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA | blastn | 11897 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi |
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);;