contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726490 | 726490 | PRJNA751877_P_NODE_2921_length_516_cov_2.085779_g2799_i0 | PRJNA751877 | 2921 | 516 | 2.085779 | 10.76261964 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.35e-32 | NTclustered | gi|669145241|ref|XM_008609961.1| | 1156394 | g2799 | i0 | 75.51 | 30.5910852713178 | 343 | 68 | 65 | 14 | 92 | 426 | 452 | 118 | Saprolegnia diclina VS20 50S ribosomal protein L22e mRNA | blastn | 15785 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 726554 | 726554 | PRJNA751877_P_NODE_5041_length_434_cov_3.958449_g4919_i0 | PRJNA751877 | 5041 | 434 | 3.958449 | 17.17966866 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 2.71e-128 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g4919 | i0 | 87.05 | 8.66820276497696 | 417 | 54 | 96 | 0 | 18 | 434 | 438 | 22 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 3762 | 472 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2002597 | 2002597 | PRJNA751877_P_NODE_5542_length_420_cov_2.293948_g5420_i0 | PRJNA751877 | 5542 | 420 | 2.293948 | 9.6345816 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.66e-90 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g5420 | i0 | 81.971 | 84.697619047619 | 416 | 67 | 98 | 6 | 8 | 419 | 426 | 15 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 35573 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3277877 | 3277877 | PRJNA751877_P_NODE_3123_length_505_cov_3.671296_g3001_i0 | PRJNA751877 | 3123 | 505 | 3.671296 | 18.5400448 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.29e-47 | NTclustered | gi|2794929698|ref|XM_067885402.1| | 164328 | g3001 | i0 | 77.778 | 42.6376237623762 | 342 | 69 | 67 | 6 | 140 | 476 | 368 | 29 | Phytophthora ramorum 60S ribosomal protein L18a (KRP23_14565), partial mRNA | blastn | 21532 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 5829990 | 5829990 | PRJNA751877_P_NODE_24385_length_249_cov_0.875000_g24263_i0 | PRJNA751877 | 24385 | 249 | 0.875 | 2.17875 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.64e-25 | NTclustered | gi|2795026484|ref|XM_067934071.1| | 4785 | g24263 | i0 | 82.877 | 6.37349397590361 | 146 | 21 | 58 | 3 | 106 | 249 | 631 | 488 | Phytophthora cinnamomi Transketolase (IUM83_09620), partial mRNA | blastn | 1587 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6304493 | 6304493 | PRJNA751877_P_NODE_7985_length_373_cov_13.603333_g7863_i0 | PRJNA751877 | 7985 | 373 | 13.603333 | 50.74043209 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 689 | 0 | NTclustered | gi|82470179|gb|DQ244022.1| | 175274 | g7863 | i0 | 100 | 95.5951742627346 | 373 | 0 | 100 | 0 | 1 | 373 | 383 | 11 | Uncultured alveolate clone PAB6AU2004 18S ribosomal RNA gene, partial sequence | blastn | 35657 | 689 | 1 | Eukaryota | Sar | uncultured alveolate | |||||||
| 8379440 | 8379440 | PRJNA751877_P_NODE_12167_length_324_cov_2.760956_g12045_i0 | PRJNA751877 | 12167 | 324 | 2.760956 | 8.94549744 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 5.719999999999998e-99 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g12045 | i0 | 88.498 | 65.4814814814815 | 313 | 30 | 96 | 6 | 15 | 324 | 40 | 349 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 21216 | 374 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 10930595 | 10930595 | PRJNA751877_P_NODE_9089_length_358_cov_2.617544_g8967_i0 | PRJNA751877 | 9089 | 358 | 2.617544 | 9.37080752 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 2.1299999999999992e-148 | NTclustered | gi|21632109|gb|AY041125.1| | 151077 | g8967 | i0 | 93.838 | 99.7430167597765 | 357 | 22 | 99 | 0 | 1 | 357 | 501 | 145 | Chilodonella uncinata clone 5 alpha-tubulin gene, partial cds | blastn | 35708 | 538 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11403807 | 11403807 | PRJNA751877_P_NODE_12929_length_317_cov_1.737705_g12807_i0 | PRJNA751877 | 12929 | 317 | 1.737705 | 5.50852485 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 9.669999999999998e-72 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g12807 | i0 | 94.149 | 51.3186119873817 | 188 | 8 | 59 | 3 | 2 | 189 | 1763 | 1947 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16268 | 283 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11404241 | 11404241 | PRJNA751877_P_NODE_7549_length_380_cov_1.420195_g7427_i0 | PRJNA751877 | 7549 | 380 | 1.420195 | 5.396741 | root | 1 | Root_unresolved | Root_unresolved | 691 | 0 | NTclustered | gi|613433395|gb|KJ410683.1| | 145522 | g7427 | i0 | 99.474 | 178.034210526316 | 380 | 2 | 100 | 0 | 1 | 380 | 65380 | 65001 | Nannochloropsis oceanica strain LAMB0001 chloroplast, partial genome | blastn | 67653 | 691 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis oceanica | |||
| 13479974 | 13479974 | PRJNA751877_P_NODE_13171_length_315_cov_1.272727_g13049_i0 | PRJNA751877 | 13171 | 315 | 1.272727 | 4.00909005 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 5.7e-79 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13049 | i0 | 84.81 | 53.2761904761905 | 316 | 37 | 99 | 9 | 1 | 313 | 3701 | 4008 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16782 | 307 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13480264 | 13480264 | PRJNA751877_P_NODE_25771_length_247_cov_0.885057_g25649_i0 | PRJNA751877 | 25771 | 247 | 0.885057 | 2.18609079 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.71e-8 | NTclustered | gi|2794888530|ref|XM_067886608.1| | 164328 | g25649 | i0 | 92.157 | 0.206477732793522 | 51 | 4 | 21 | 0 | 145 | 195 | 471 | 421 | Phytophthora ramorum tRNA (adenine(58)-N(1))-methyltransferase non-catalytic subunit trm6 (KRP23_1938), partial mRNA | blastn | 51 | 73.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 13480498 | 13480498 | PRJNA751877_P_NODE_9691_length_351_cov_1.107914_g9569_i0 | PRJNA751877 | 9691 | 351 | 1.107914 | 3.88877814 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 531 | 3.4899999999999992e-146 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g9569 | i0 | 94.051 | 74.9059829059829 | 353 | 16 | 100 | 4 | 1 | 351 | 2433 | 2782 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 26292 | 531 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13954299 | 13954299 | PRJNA751877_P_NODE_3711_length_479_cov_1.660099_g3589_i0 | PRJNA751877 | 3711 | 479 | 1.660099 | 7.95187421 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 880 | 0 | NTclustered | gi|89077592|gb|DQ388599.1| | 63136 | g3589 | i0 | 99.792 | 98.5407098121086 | 480 | 0 | 100 | 1 | 1 | 479 | 1233 | 1712 | Colpoda steinii strain Sp1 small subunit ribosomal RNA gene, partial sequence | blastn | 47201 | 880 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 14755463 | 14755463 | PRJNA751877_P_NODE_7172_length_387_cov_0.980892_g7050_i0 | PRJNA751877 | 7172 | 387 | 0.980892 | 3.79605204 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 1.4699999999999994e-110 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g7050 | i0 | 86.269 | 112.087855297158 | 386 | 45 | 99 | 8 | 3 | 387 | 6306 | 5928 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 43378 | 412 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 16029075 | 16029075 | PRJNA751877_P_NODE_25253_length_247_cov_1.327586_g25131_i0 | PRJNA751877 | 25253 | 247 | 1.327586 | 3.27913742 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 7.269999999999999e-72 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g25131 | i0 | 88.017 | 69.8137651821862 | 242 | 25 | 98 | 3 | 1 | 242 | 280 | 43 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 17244 | 283 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 16503255 | 16503255 | PRJNA751877_P_NODE_27713_length_244_cov_0.900585_g27591_i0 | PRJNA751877 | 27713 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 407 | 4.08e-109 | NTclustered | gi|166044630|emb|CU367539.1| | 100861 | g27591 | i0 | 96.721 | 98.4180327868852 | 244 | 8 | 100 | 0 | 1 | 244 | 168 | 411 | Aphanomyces euteiches cDNA | blastn | 24014 | 407 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19853465 | 19853465 | PRJNA751877_P_NODE_2356_length_554_cov_2.241164_g2235_i0 | PRJNA751877 | 2356 | 554 | 2.241164 | 12.41604856 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 4.3799999999999996e-157 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g2235 | i0 | 86.038 | 4.01083032490975 | 530 | 72 | 95 | 2 | 1 | 529 | 18 | 546 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 2222 | 568 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20326563 | 20326563 | PRJNA751877_P_NODE_18256_length_276_cov_1.517241_g18134_i0 | PRJNA751877 | 18256 | 276 | 1.517241 | 4.18758516 | root | 1 | Root_unresolved | Root_unresolved | 488 | 1.6299999999999995e-133 | NTclustered | gi|166044608|emb|CU367517.1| | 100861 | g18134 | i0 | 98.551 | 99.6992753623188 | 276 | 4 | 100 | 0 | 1 | 276 | 472 | 747 | Aphanomyces euteiches cDNA | blastn | 27517 | 488 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23679166 | 23679166 | PRJNA751877_P_NODE_15879_length_290_cov_1.774194_g15757_i0 | PRJNA751877 | 15879 | 290 | 1.774194 | 5.1451626 | Lingulaulax polyedra | 160621 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 9.59e-7 | NTclustered | gi|376374749|gb|JQ616830.1| | 160621 | g15757 | i0 | 100 | 11.8034482758621 | 36 | 0 | 12 | 0 | 1 | 36 | 611 | 576 | Lingulodinium polyedrum isolate LPCQ-1 28S ribosomal RNA gene, partial sequence | blastn | 3423 | 67.6 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Lingulodiniaceae | Lingulaulax | Lingulaulax polyedra | |||
| 24953086 | 24953086 | PRJNA751877_P_NODE_4900_length_438_cov_2.378082_g4778_i0 | PRJNA751877 | 4900 | 438 | 2.378082 | 10.41599916 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.85e-45 | NTclustered | gi|301114940|ref|XM_002999194.1| | 403677 | g4778 | i0 | 81.59 | 10.9543378995434 | 239 | 42 | 54 | 2 | 201 | 438 | 855 | 618 | Phytophthora infestans T30-4 pyrophosphate-energized vacuolar membrane proton pump, putative (PITG_05615), partial mRNA | blastn | 4798 | 196 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 25426978 | 25426978 | PRJNA751877_P_NODE_4620_length_447_cov_1.235294_g4498_i0 | PRJNA751877 | 4620 | 447 | 1.235294 | 5.52176418 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 8.189999999999997e-94 | NTclustered | gi|813119301|ref|XM_012340833.1| | 695850 | g4498 | i0 | 82.716 | 76.4093959731544 | 405 | 66 | 90 | 4 | 45 | 447 | 962 | 560 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 34155 | 359 | 0.994428969359331 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;