contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1143173" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 286334 | 286334 | PRJNA1143173_P_NODE_3321_length_447_cov_6.572193_g3295_i0 | PRJNA1143173 | 3321 | 447 | 6.572193 | 29.37770271 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 2.33e-79 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g3295 | i0 | 84.498 | 0.736017897091723 | 329 | 34 | 73 | 12 | 1 | 325 | 649 | 964 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 329 | 309 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 4113092 | 4113092 | PRJNA1143173_P_NODE_17224_length_295_cov_2.932432_g17198_i0 | PRJNA1143173 | 17224 | 295 | 2.932432 | 8.6506744 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2806430765|ref|XM_068522508.1| | 2853592 | g17198 | i0 | 100 | 0.386440677966102 | 29 | 0 | 10 | 0 | 236 | 264 | 392 | 364 | MAG: Porospora cf. gigantea B uncharacterized protein (KVP17_004375), partial mRNA | blastn | 114 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 4113504 | 4113504 | PRJNA1143173_P_NODE_37024_length_237_cov_3.384146_g36998_i0 | PRJNA1143173 | 37024 | 237 | 3.384146 | 8.02042602 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4e-118 | NTclustered | gi|1209404931|gb|KX442736.1| | 2003111 | g36998 | i0 | 100 | 76.789029535865 | 237 | 0 | 100 | 0 | 1 | 237 | 1131 | 1367 | Poteriospumella sp. strain JBAS36 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 | 18199 | 438 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 7939463 | 7939463 | PRJNA1143173_P_NODE_33487_length_248_cov_1.457143_g33461_i0 | PRJNA1143173 | 33487 | 248 | 1.457143 | 3.61371464 | uncultured Ochromonas | 240148 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.45e-71 | NTclustered | gi|390198152|gb|JQ859673.1| | 240148 | g33461 | i0 | 87.449 | 83.1935483870968 | 247 | 25 | 98 | 5 | 1 | 242 | 114 | 359 | Uncultured Ochromonas sp. clone SV462 16S ribosomal RNA gene, partial sequence; plastid | blastn | 20632 | 279 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | uncultured Ochromonas | |||
| 9960911 | 9960911 | PRJNA1143173_P_NODE_30688_length_256_cov_2.120219_g30662_i0 | PRJNA1143173 | 30688 | 256 | 2.120219 | 5.42776064 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.95e-127 | NTclustered | gi|166046545|emb|CU367662.1| | 100861 | g30662 | i0 | 99.609 | 44.34765625 | 256 | 1 | 100 | 0 | 1 | 256 | 422 | 167 | Aphanomyces euteiches cDNA | blastn | 11353 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10490229 | 10490229 | PRJNA1143173_P_NODE_44249_length_200_cov_4.629921_g44223_i0 | PRJNA1143173 | 44249 | 200 | 4.629921 | 9.259842 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.02e-76 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g44223 | i0 | 93.5 | 1.29 | 200 | 13 | 100 | 0 | 1 | 200 | 241 | 440 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 258 | 298 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 11765251 | 11765251 | PRJNA1143173_P_NODE_42530_length_211_cov_7.297101_g42504_i0 | PRJNA1143173 | 42530 | 211 | 7.297101 | 15.39688311 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 2.17e-71 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g42504 | i0 | 90.952 | 115.725118483412 | 210 | 17 | 99 | 2 | 1 | 210 | 681 | 888 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 24418 | 281 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 18137823 | 18137823 | PRJNA1143173_P_NODE_17775_length_293_cov_5.550000_g17749_i0 | PRJNA1143173 | 17775 | 293 | 5.55 | 16.2615 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.5299999999999993e-52 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g17749 | i0 | 94.366 | 2.43344709897611 | 142 | 8 | 99 | 0 | 150 | 291 | 157471 | 157330 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 713 | 219 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19412174 | 19412174 | PRJNA1143173_P_NODE_23876_length_275_cov_5.851485_g23850_i0 | PRJNA1143173 | 23876 | 275 | 5.851485 | 16.09158375 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.859999999999999e-96 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g23850 | i0 | 90.545 | 7.86181818181818 | 275 | 26 | 100 | 0 | 1 | 275 | 157437 | 157711 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2162 | 364 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 25259052 | 25259052 | PRJNA1143173_P_NODE_2260_length_505_cov_4.368056_g2234_i0 | PRJNA1143173 | 2260 | 505 | 4.368056 | 22.0586828 | Chromulinales | 96792 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 4.079999999999999e-137 | NTclustered | gi|2055919756|gb|MZ420314.1| | 1955568 | g2234 | i0 | 89.646 | 78.2455445544554 | 396 | 30 | 78 | 6 | 1 | 394 | 1448 | 1834 | Spumella sp. strain Woeam021018A5 large subunit ribosomal RNA gene, partial sequence | blastn | 39514 | 503 | 0.996023856858847 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. |
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);;