contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1057075" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1451225 | 1451225 | PRJNA1057075_S_NODE_10182_length_155_cov_5.764151_g10083_i0 | PRJNA1057075 | 10182 | 155 | 5.764151 | 8.93443405 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 2.53e-59 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g10083 | i0 | 99.248 | 65 | 133 | 1 | 86 | 0 | 2 | 134 | 1289 | 1421 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 10075 | 241 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4839337 | 4839337 | PRJNA1057075_S_NODE_3664_length_231_cov_1968.186813_g3565_i0 | PRJNA1057075 | 3664 | 231 | 1968.186813 | 4546.51153803 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 4.02e-74 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3565 | i0 | 95.58 | 40.1645021645022 | 181 | 8 | 78 | 0 | 46 | 226 | 370 | 190 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 9278 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 5279346 | 5279346 | PRJNA1057075_S_NODE_4105_length_221_cov_1.744186_g4006_i0 | PRJNA1057075 | 4105 | 221 | 1.744186 | 3.85465106 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 5.37e-13 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g4006 | i0 | 94.643 | 6.55656108597285 | 56 | 3 | 25 | 0 | 1 | 56 | 848 | 903 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 1449 | 87.9 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 12930315 | 12930315 | PRJNA1057075_S_NODE_2511_length_264_cov_10.600000_g2412_i0 | PRJNA1057075 | 2511 | 264 | 10.6 | 27.984 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.25e-104 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g2412 | i0 | 93.87 | 63.0643939393939 | 261 | 14 | 98 | 2 | 5 | 264 | 18 | 277 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 16649 | 392 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 14205274 | 14205274 | PRJNA1057075_S_NODE_2212_length_275_cov_449.575221_g2113_i0 | PRJNA1057075 | 2212 | 275 | 449.575221 | 1236.33185775 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.11e-40 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g2113 | i0 | 84.699 | 29.8 | 183 | 25 | 65 | 2 | 1 | 180 | 2294 | 2476 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 8195 | 180 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 15479403 | 15479403 | PRJNA1057075_S_NODE_2353_length_269_cov_52640.877273_g2254_i0 | PRJNA1057075 | 2353 | 269 | 52640.877273 | 141603.95986437 | Placidida sp. | 2810146 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.43e-24 | NTclustered | gi|2048770203|gb|MT042900.1| | 2810146 | g2254 | i0 | 83.212 | 18.2230483271375 | 137 | 23 | 51 | 0 | 10 | 146 | 257 | 393 | Placidida sp. strain HFCC1258 ribosomal protein S15A mRNA, complete cds | blastn | 4902 | 126 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidida sp. | |||||
| 15479411 | 15479411 | PRJNA1057075_S_NODE_3853_length_227_cov_1.398876_g3754_i0 | PRJNA1057075 | 3853 | 227 | 1.398876 | 3.17544852 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 4.81e-113 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g3754 | i0 | 100 | 103.066079295154 | 227 | 0 | 100 | 0 | 1 | 227 | 954 | 728 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 23396 | 420 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 16753487 | 16753487 | PRJNA1057075_S_NODE_1134_length_340_cov_9.426117_g1035_i0 | PRJNA1057075 | 1134 | 340 | 9.426117 | 32.0487978 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 7.119999999999998e-163 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g1035 | i0 | 99.08 | 93.7735294117647 | 326 | 3 | 96 | 0 | 15 | 340 | 1396 | 1071 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31883 | 586 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 19302325 | 19302325 | PRJNA1057075_S_NODE_8716_length_165_cov_4.362069_g8617_i0 | PRJNA1057075 | 8716 | 165 | 4.362069 | 7.19741385 | Pseudellipsoidion edaphicum | 1431838 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.47e-75 | NTclustered | gi|1567482280|ref|NC_040299.1| | 1431838 | g8617 | i0 | 98.78 | 126.818181818182 | 164 | 2 | 99 | 0 | 1 | 164 | 39597 | 39760 | Pseudellipsoidion edaphicum strain CAUP Q 401 plastid, complete genome | blastn | 20925 | 292 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Neomonodaceae | Pseudellipsoidion | Pseudellipsoidion edaphicum | |||
| 21853462 | 21853462 | PRJNA1057075_S_NODE_5178_length_200_cov_1.993377_g5079_i0 | PRJNA1057075 | 5178 | 200 | 1.993377 | 3.986754 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.83e-20 | NTclustered | gi|219123891|ref|XM_002182214.1| | 556484 | g5079 | i0 | 85.714 | 1.05 | 105 | 15 | 53 | 0 | 21 | 125 | 321 | 425 | Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA | blastn | 210 | 111 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 23128900 | 23128900 | PRJNA1057075_S_NODE_4199_length_219_cov_1.482353_g4100_i0 | PRJNA1057075 | 4199 | 219 | 1.482353 | 3.24635307 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 3.17e-15 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g4100 | i0 | 86.364 | 1.15525114155251 | 88 | 10 | 40 | 2 | 83 | 169 | 854581 | 854667 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 253 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24402569 | 24402569 | PRJNA1057075_S_NODE_2980_length_249_cov_490.885000_g2881_i0 | PRJNA1057075 | 2980 | 249 | 490.885 | 1222.30365 | Hydrurus foetidus | 2996 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.74e-19 | NTclustered | gi|219903754|emb|FM955257.1| | 2996 | g2881 | i0 | 89.535 | 33.9839357429719 | 86 | 7 | 34 | 2 | 19 | 102 | 1765 | 1850 | Hydrurus foetidus partial 28S rRNA gene | blastn | 8462 | 108 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus |
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);;