contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577561 | 577561 | PRJNA603943_P_NODE_52861_length_251_cov_0.865169_g52669_i0 | PRJNA603943 | 52861 | 251 | 0.865169 | 2.17157419 | Blastocystis hominis | 12968 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.99e-97 | NTclustered | gi|8918241|dbj|AB023581.1| | 12968 | g52669 | i0 | 99.024 | 39.589641434263 | 205 | 2 | 82 | 0 | 47 | 251 | 1107 | 1311 | Blastocystis hominis mRNA for vacuolar ATPase B subunit, complete cds | blastn | 9937 | 368 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 1143118 | 1143118 | PRJNA603943_P_NODE_39181_length_294_cov_2.574661_g38989_i0 | PRJNA603943 | 39181 | 294 | 2.574661 | 7.56950334 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.35e-139 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g38989 | i0 | 97.959 | 86.5476190476191 | 294 | 4 | 100 | 1 | 1 | 294 | 2359 | 2068 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25445 | 508 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 1853650 | 1853650 | PRJNA603943_P_NODE_6262_length_613_cov_12.059259_g6076_i0 | PRJNA603943 | 6262 | 613 | 12.059259 | 73.92325767 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 3.3600000000000007e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g6076 | i0 | 79.05 | 13.6933115823817 | 358 | 71 | 58 | 4 | 104 | 459 | 482 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 8394 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 3129132 | 3129132 | PRJNA603943_P_NODE_9263_length_521_cov_2.555804_g9074_i0 | PRJNA603943 | 9263 | 521 | 2.555804 | 13.31573884 | Spumella-like flagellate JBAF32 | 293190 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 1.13e-162 | NTclustered | gi|161015614|gb|EF577217.1| | 293190 | g9074 | i0 | 87.066 | 100.030710172745 | 518 | 67 | 99 | 0 | 1 | 518 | 104 | 621 | Spumella-like flagellate JBAF32 alpha-tubulin gene, partial cds | blastn | 52116 | 586 | 1 | Eukaryota | Sar | Chrysophyceae | Spumella-like flagellate JBAF32 | ||||||
| 4404895 | 4404895 | PRJNA603943_P_NODE_40224_length_291_cov_0.871560_g40032_i0 | PRJNA603943 | 40224 | 291 | 0.87156 | 2.5362396 | Cryptosporidium sp. horse genotype | 564992 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 6.599999999999998e-93 | NTclustered | gi|2274500370|gb|ON419491.1| | 564992 | g40032 | i0 | 89.362 | 97.1030927835052 | 282 | 28 | 97 | 2 | 8 | 288 | 43 | 323 | Cryptosporidium sp. horse genotype isolate HN16 actin gene, partial cds | blastn | 28257 | 353 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. horse genotype | ||
| 4405256 | 4405256 | PRJNA603943_P_NODE_53224_length_251_cov_0.865169_g53032_i0 | PRJNA603943 | 53224 | 251 | 0.865169 | 2.17157419 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|296005543|ref|XM_002809043.1| | 36329 | g53032 | i0 | 96.97 | 0.386454183266932 | 33 | 1 | 13 | 0 | 7 | 39 | 3300 | 3268 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1359600), partial mRNA | blastn | 97 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 4971236 | 4971236 | PRJNA603943_P_NODE_32464_length_319_cov_1.560976_g32272_i0 | PRJNA603943 | 32464 | 319 | 1.560976 | 4.97951344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.15e-53 | NTclustered | gi|676383892|ref|XM_009036977.1| | 44056 | g32272 | i0 | 81.618 | 70.4388714733542 | 272 | 47 | 85 | 3 | 9 | 279 | 1329 | 1060 | Aureococcus anophagefferens hypothetical protein partial mRNA | blastn | 22470 | 222 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 8229875 | 8229875 | PRJNA603943_P_NODE_20427_length_380_cov_1.003257_g20235_i0 | PRJNA603943 | 20427 | 380 | 1.003257 | 3.8123766 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.55e-60 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g20235 | i0 | 78.904 | 86.7868421052632 | 365 | 75 | 96 | 2 | 17 | 380 | 1307 | 944 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 32979 | 246 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 10781123 | 10781123 | PRJNA603943_P_NODE_269_length_2116_cov_2.628977_g217_i0 | PRJNA603943 | 269 | 2116 | 2.628977 | 55.62915332 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 1746 | 0 | NTclustered | gi|53829571|gb|AY582838.1| | 289359 | g217 | i0 | 97.368 | 69.7778827977316 | 1026 | 27 | 48 | 0 | 116 | 1141 | 1 | 1026 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 HSP70 gene, partial cds | blastn | 147650 | 1746 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 12057084 | 12057084 | PRJNA603943_P_NODE_61690_length_246_cov_0.890173_g61498_i0 | PRJNA603943 | 61690 | 246 | 0.890173 | 2.18982558 | Blastocystis sp. subtype 3 | 944168 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|1079281423|gb|HQ909888.2| | 944168 | g61498 | i0 | 100 | 4 | 246 | 0 | 100 | 0 | 1 | 246 | 25240 | 24995 | Blastocystis sp. subtype 3 strain DMP/IH478 mitochondrion, complete genome | blastn | 984 | 455 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. subtype 3 | |||
| 14605985 | 14605985 | PRJNA603943_P_NODE_35052_length_309_cov_1.305085_g34860_i0 | PRJNA603943 | 35052 | 309 | 1.305085 | 4.03271265 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.65e-62 | NTclustered | gi|675210554|ref|XM_008915914.1| | 761204 | g34860 | i0 | 81.494 | 72.7281553398058 | 308 | 55 | 99 | 2 | 2 | 308 | 571 | 877 | Phytophthora parasitica INRA-310 ATP-dependent RNA helicase eIF4A partial mRNA | blastn | 22473 | 252 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14606151 | 14606151 | PRJNA603943_P_NODE_40452_length_290_cov_1.064516_g40260_i0 | PRJNA603943 | 40452 | 290 | 1.064516 | 3.0870964 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 2.9099999999999993e-126 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g40260 | i0 | 95.517 | 105.5 | 290 | 13 | 100 | 0 | 1 | 290 | 3390 | 3679 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 30595 | 464 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 15171185 | 15171185 | PRJNA603943_P_NODE_10532_length_494_cov_4.078385_g10341_i0 | PRJNA603943 | 10532 | 494 | 4.078385 | 20.1472219 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 907 | 0 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g10341 | i0 | 99.798 | 99.0728744939271 | 494 | 1 | 100 | 0 | 1 | 494 | 1308 | 815 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 48942 | 913 | 0.993428258488499 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 15880528 | 15880528 | PRJNA603943_P_NODE_54893_length_250_cov_0.870056_g54701_i0 | PRJNA603943 | 54893 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.48e-62 | NTclustered | gi|146185323|ref|XM_001031586.2| | 312017 | g54701 | i0 | 88.78 | 0.82 | 205 | 21 | 82 | 2 | 47 | 250 | 391 | 188 | Tetrahymena thermophila SB210 40S ribosomal protein S13 partial mRNA | blastn | 205 | 250 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 16445923 | 16445923 | PRJNA603943_P_NODE_5333_length_656_cov_2.355060_g5151_i0 | PRJNA603943 | 5333 | 656 | 2.35506 | 15.4491936 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 4.199999999999999e-133 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g5151 | i0 | 86.057 | 67.7256097560976 | 459 | 59 | 70 | 4 | 50 | 506 | 28 | 483 | Pythium splendens calmodulin mRNA, complete cds | blastn | 44428 | 492 | 0.991869918699187 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 17154441 | 17154441 | PRJNA603943_P_NODE_23354_length_361_cov_2.118056_g23162_i0 | PRJNA603943 | 23354 | 361 | 2.118056 | 7.64618216 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 5.45e-35 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g23162 | i0 | 84.524 | 6.18282548476454 | 168 | 21 | 45 | 4 | 198 | 361 | 2284 | 2450 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 2232 | 161 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 17154864 | 17154864 | PRJNA603943_P_NODE_37994_length_299_cov_0.902655_g37802_i0 | PRJNA603943 | 37994 | 299 | 0.902655 | 2.69893845 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 5.65e-44 | NTclustered | gi|301114940|ref|XM_002999194.1| | 403677 | g37802 | i0 | 79.699 | 11.3979933110368 | 266 | 52 | 89 | 2 | 35 | 299 | 854 | 590 | Phytophthora infestans T30-4 pyrophosphate-energized vacuolar membrane proton pump, putative (PITG_05615), partial mRNA | blastn | 3408 | 191 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 20978687 | 20978687 | PRJNA603943_P_NODE_10697_length_491_cov_8.131579_g10506_i0 | PRJNA603943 | 10697 | 491 | 8.131579 | 39.92605289 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.61e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g10506 | i0 | 80.533 | 68.8146639511202 | 375 | 65 | 75 | 4 | 121 | 488 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33788 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20979602 | 20979602 | PRJNA603943_P_NODE_4437_length_708_cov_3.820472_g4259_i0 | PRJNA603943 | 4437 | 708 | 3.820472 | 27.04894176 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 941 | 0 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g4259 | i0 | 99.612 | 70.1186440677966 | 515 | 2 | 73 | 0 | 1 | 515 | 389 | 903 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 49644 | 941 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 23530552 | 23530552 | PRJNA603943_P_NODE_679_length_1521_cov_27.987569_g598_i0 | PRJNA603943 | 679 | 1521 | 27.987569 | 425.69092449 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 2235 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g598 | i0 | 99.352 | 85.5351742274819 | 1234 | 8 | 81 | 0 | 181 | 1414 | 1238 | 5 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 130099 | 2235 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 |
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);;