contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1101048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7863907 | 7863907 | PRJNA1101048_P_NODE_4127_length_308_cov_3.800000_g4071_i0 | PRJNA1101048 | 4127 | 308 | 3.8 | 11.704 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 6.75e-123 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g4071 | i0 | 93.485 | 77.288961038961 | 307 | 16 | 99 | 4 | 4 | 308 | 1665 | 1361 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 23805 | 453 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 9138818 | 9138818 | PRJNA1101048_P_NODE_2288_length_382_cov_2.608414_g2232_i0 | PRJNA1101048 | 2288 | 382 | 2.608414 | 9.96414148 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g2232 | i0 | 98.691 | 107.452879581152 | 382 | 5 | 100 | 0 | 1 | 382 | 2466 | 2085 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 41047 | 678 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11223259 | 11223259 | PRJNA1101048_P_NODE_1569_length_446_cov_1.276139_g1513_i0 | PRJNA1101048 | 1569 | 446 | 1.276139 | 5.69157994 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g1513 | i0 | 96.03 | 96.0896860986547 | 403 | 13 | 99 | 3 | 45 | 446 | 4306 | 3906 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 42856 | 658 | 0.990881458966565 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11689912 | 11689912 | PRJNA1101048_P_NODE_4790_length_292_cov_1.662100_g4734_i0 | PRJNA1101048 | 4790 | 292 | 1.6621 | 4.853332 | Craticula sp. RGastineau-2025a | 3393937 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.43e-16 | NTclustered | gi|2906190882|gb|PV031684.1| | 3393937 | g4734 | i0 | 83.636 | 62.9828767123288 | 110 | 13 | 37 | 5 | 44 | 151 | 55120 | 55014 | Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome | blastn | 18391 | 99 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Stauroneidaceae | Craticula | Craticula sp. RGastineau-2025a | ||
| 12498660 | 12498660 | PRJNA1101048_P_NODE_2110_length_395_cov_5.763975_g2054_i0 | PRJNA1101048 | 2110 | 395 | 5.763975 | 22.767701249999998 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 6.339999999999999e-179 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2054 | i0 | 96.164 | 92.3088607594937 | 391 | 15 | 99 | 0 | 5 | 395 | 1 | 391 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 36462 | 640 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 12965053 | 12965053 | PRJNA1101048_P_NODE_3991_length_312_cov_1.171548_g3935_i0 | PRJNA1101048 | 3991 | 312 | 1.171548 | 3.65522976 | Goussia balatonica | 947538 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 5.52e-94 | NTclustered | gi|324022100|gb|GU593717.1| | 947538 | g3935 | i0 | 95.909 | 69.025641025641 | 220 | 8 | 70 | 1 | 4 | 222 | 1787 | 2006 | Goussia balatonica strain 608 28S ribosomal RNA gene, partial sequence | blastn | 21536 | 357 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia balatonica | ||
| 15047524 | 15047524 | PRJNA1101048_P_NODE_6292_length_263_cov_2.321053_g6236_i0 | PRJNA1101048 | 6292 | 263 | 2.321053 | 6.10436939 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 7.77e-77 | NTclustered | gi|166041637|emb|CU357669.1| | 100861 | g6236 | i0 | 98.81 | 106.220532319392 | 168 | 2 | 87 | 0 | 1 | 168 | 55 | 222 | Aphanomyces euteiches cDNA | blastn | 27936 | 303 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20612407 | 20612407 | PRJNA1101048_P_NODE_3217_length_338_cov_1.162264_g3161_i0 | PRJNA1101048 | 3217 | 338 | 1.162264 | 3.92845232 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 4.669999999999999e-95 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g3161 | i0 | 88.235 | 84.6272189349112 | 306 | 30 | 89 | 6 | 10 | 311 | 330 | 27 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 28604 | 361 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 20612409 | 20612409 | PRJNA1101048_P_NODE_3857_length_316_cov_3.818930_g3801_i0 | PRJNA1101048 | 3857 | 316 | 3.81893 | 12.0678188 | Amphifilidae sp. H-1 | 1407012 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.46e-139 | NTclustered | gi|550533551|dbj|AB856528.1| | 1407012 | g3801 | i0 | 98.616 | 83.5791139240506 | 289 | 0 | 90 | 4 | 5 | 289 | 837 | 1125 | Amphifilidae sp. H-1 gene for 18S ribosomal RNA, partial sequence | blastn | 26411 | 508 | 1 | Eukaryota | Sar | Bigyra | Amphifilida | Amphifilaceae | Amphifilidae sp. H-1 | ||||
| 23972131 | 23972131 | PRJNA1101048_P_NODE_2979_length_347_cov_2.281022_g2923_i0 | PRJNA1101048 | 2979 | 347 | 2.281022 | 7.91514634 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 603 | 7.229999999999999e-168 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g2923 | i0 | 99.398 | 94.657060518732 | 332 | 2 | 96 | 0 | 2 | 333 | 230 | 561 | Aphanomyces euteiches cDNA | blastn | 32846 | 603 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;