contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA763718" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020233 | 2020233 | PRJNA763718_S_NODE_8262_length_154_cov_1.324786_g8054_i0 | PRJNA763718 | 8262 | 154 | 1.324786 | 2.04017044 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 4.42e-22 | NTclustered | gi|309254527|gb|GU554463.1| | 187300 | g8054 | i0 | 81.579 | 0.987012987012987 | 152 | 18 | 95 | 7 | 8 | 154 | 353 | 207 | uncultured dinoflagellate clone 1061048708507_r mRNA sequence | blastn | 152 | 117 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 2480859 | 2480859 | PRJNA763718_S_NODE_4702_length_202_cov_3.787879_g4494_i0 | PRJNA763718 | 4702 | 202 | 3.787879 | 7.65151558 | Condylostoma | 40632 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.71e-22 | NTclustered | gi|1216628401|gb|KX099195.1| | 396044 | g4494 | i0 | 86.486 | 46.8465346534653 | 111 | 12 | 54 | 3 | 49 | 158 | 112 | 4 | Condylostoma spatiosum clone CS2 internal transcribed spacer 1 and 5.8S ribosomal RNA gene, partial sequence | blastn | 9463 | 119 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Condylostomatidae | Condylostoma | Condylostoma spatiosum | ||
| 3757153 | 3757153 | PRJNA763718_S_NODE_3483_length_238_cov_5.855721_g3275_i0 | PRJNA763718 | 3483 | 238 | 5.855721 | 13.93661598 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 9.399999999999999e-41 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g3275 | i0 | 80.658 | 91.436974789916 | 243 | 37 | 100 | 8 | 1 | 238 | 894 | 1131 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 21762 | 180 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4572530 | 4572530 | PRJNA763718_S_NODE_6224_length_175_cov_1.717391_g6016_i0 | PRJNA763718 | 6224 | 175 | 1.717391 | 3.00543425 | Plasmodium inui | 52288 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.06e-29 | NTclustered | gi|672189677|ref|XM_008816915.1| | 1237626 | g6016 | i0 | 88.136 | 10.7485714285714 | 118 | 14 | 67 | 0 | 3 | 120 | 558 | 675 | Plasmodium inui San Antonio 1 60S ribosomal protein L8 partial mRNA | blastn | 1881 | 141 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium inui | ||
| 6309469 | 6309469 | PRJNA763718_S_NODE_7885_length_157_cov_1.300000_g7677_i0 | PRJNA763718 | 7885 | 157 | 1.3 | 2.041 | Placidia | 159341 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 5.9e-16 | NTclustered | gi|2163288147|gb|MZ440320.1| | 2810144 | g7677 | i0 | 93.75 | 32.1910828025478 | 64 | 4 | 41 | 0 | 94 | 157 | 1284 | 1221 | Placidia abyssalis strain HFCC745 elongation factor 1-alpha (ef1a) mRNA, complete cds | blastn | 5054 | 97.1 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidiaceae | Placidia | Placidia abyssalis | |||
| 15233900 | 15233900 | PRJNA763718_S_NODE_2892_length_265_cov_1.412281_g2684_i0 | PRJNA763718 | 2892 | 265 | 1.412281 | 3.74254465 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.02e-70 | NTclustered | gi|92790159|emb|AJ965265.1| | 5987 | g2684 | i0 | 86.26 | 236.803773584906 | 262 | 30 | 98 | 6 | 7 | 265 | 494 | 236 | Isotricha prostoma partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) | blastn | 62753 | 279 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha prostoma | ||
| 17322519 | 17322519 | PRJNA763718_S_NODE_8614_length_151_cov_2.333333_g8406_i0 | PRJNA763718 | 8614 | 151 | 2.333333 | 3.52333283 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.21e-17 | NTclustered | gi|2794937619|ref|XM_067858233.1| | 5871 | g8406 | i0 | 94.03 | 23.887417218543 | 67 | 4 | 44 | 0 | 73 | 139 | 190 | 124 | Babesia caballi fumarate reductase (BcabD6B2_17000), partial mRNA | blastn | 3607 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 18595827 | 18595827 | PRJNA763718_S_NODE_2055_length_326_cov_9.297578_g1847_i0 | PRJNA763718 | 2055 | 326 | 9.297578 | 30.31010428 | Chromulina sp. SAG 17.97 | 984084 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.34e-18 | NTclustered | gi|323690579|gb|GU935638.1| | 984084 | g1847 | i0 | 82.906 | 11.3803680981595 | 117 | 18 | 36 | 2 | 33 | 148 | 1589 | 1474 | Chromulina sp. SAG 17.97 28S ribosomal RNA gene, partial sequence | blastn | 3710 | 104 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Chromulina | Chromulina sp. SAG 17.97 | |||
| 18595834 | 18595834 | PRJNA763718_S_NODE_4195_length_214_cov_3.327684_g3987_i0 | PRJNA763718 | 4195 | 214 | 3.327684 | 7.12124376 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.08e-34 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g3987 | i0 | 80.556 | 51.7242990654206 | 216 | 35 | 100 | 6 | 1 | 214 | 2514 | 2304 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 11069 | 159 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 21607586 | 21607586 | PRJNA763718_S_NODE_5417_length_188_cov_1.721854_g5209_i0 | PRJNA763718 | 5417 | 188 | 1.721854 | 3.23708552 | root | 1 | Root_unresolved | Root_unresolved | 71.3 | 4.45e-8 | NTclustered | gi|159993|gb|M34540.1|PARCAM | 5888 | g5209 | i0 | 88.136 | 2.20744680851064 | 59 | 7 | 31 | 0 | 130 | 188 | 563 | 505 | P.tetraurelia calmodulin gene, complete cds | blastn | 415 | 71.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 23697136 | 23697136 | PRJNA763718_S_NODE_4159_length_215_cov_7.275281_g3951_i0 | PRJNA763718 | 4159 | 215 | 7.275281 | 15.64185415 | uncultured marine bolidophyte | 588886 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 6.4e-47 | NTclustered | gi|223047886|gb|FJ032654.1| | 588886 | g3951 | i0 | 91.156 | 73.4790697674419 | 147 | 13 | 68 | 0 | 1 | 147 | 1904 | 1758 | Uncultured marine bolidophyte clone DH114_3A83 28S ribosomal RNA gene, partial sequence | blastn | 15798 | 200 | 1 | Eukaryota | Sar | Bolidophyceae | uncultured marine bolidophyte |
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);;