contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA699078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3233021 | 3233021 | PRJNA699078_S_NODE_31083_length_309_cov_2.826923_g30134_i0 | PRJNA699078 | 31083 | 309 | 2.826923 | 8.73519207 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 5.939999999999999e-34 | NTclustered | gi|471218831|ref|XM_004023902.1| | 5932 | g30134 | i0 | 80.465 | 1.042071197411 | 215 | 34 | 68 | 8 | 72 | 282 | 230 | 20 | Ichthyophthirius multifiliis hypothetical protein (IMG5_202480) mRNA, complete cds | blastn | 322 | 158 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 3233068 | 3233068 | PRJNA699078_S_NODE_34243_length_296_cov_0.886640_g33294_i0 | PRJNA699078 | 34243 | 296 | 0.88664 | 2.6244544 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g33294 | i0 | 100 | 0.192567567567568 | 29 | 0 | 10 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 3735889 | 3735889 | PRJNA699078_S_NODE_17423_length_393_cov_4.860465_g16476_i0 | PRJNA699078 | 17423 | 393 | 4.860465 | 19.10162745 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 4.79e-11 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g16476 | i0 | 94.34 | 3.70737913486005 | 53 | 3 | 13 | 0 | 273 | 325 | 112 | 60 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 1457 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 5012416 | 5012416 | PRJNA699078_S_NODE_93404_length_173_cov_1.064516_g92455_i0 | PRJNA699078 | 93404 | 173 | 1.064516 | 1.84161268 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|2795616734|ref|XM_068062397.1| | 483139 | g92455 | i0 | 100 | 1.29479768786127 | 28 | 0 | 16 | 0 | 103 | 130 | 2080 | 2107 | Cystoisospora suis uba ts-n domain-containing protein (CSUI_002195), mRNA | blastn | 224 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 8335524 | 8335524 | PRJNA699078_S_NODE_49607_length_243_cov_1.587629_g48658_i0 | PRJNA699078 | 49607 | 243 | 1.587629 | 3.85793847 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g48658 | i0 | 100 | 0.234567901234568 | 29 | 0 | 12 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 9610601 | 9610601 | PRJNA699078_S_NODE_36708_length_286_cov_0.877637_g35759_i0 | PRJNA699078 | 36708 | 286 | 0.877637 | 2.51004182 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g35759 | i0 | 100 | 0.199300699300699 | 29 | 0 | 10 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 10887138 | 10887138 | PRJNA699078_S_NODE_98169_length_168_cov_2.184874_g97220_i0 | PRJNA699078 | 98169 | 168 | 2.184874 | 3.67058832 | Haplosporidium littoralis | 1296328 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 6.43e-16 | NTclustered | gi|605052145|gb|KJ150289.1| | 1296328 | g97220 | i0 | 86.17 | 1.94642857142857 | 94 | 8 | 55 | 4 | 1 | 92 | 4013 | 4103 | Haplosporidium littoralis small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 327 | 97.1 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Haplosporidiidae | Haplosporidium | Haplosporidium littoralis | ||
| 11387673 | 11387673 | PRJNA699078_S_NODE_32889_length_301_cov_2.345238_g31940_i0 | PRJNA699078 | 32889 | 301 | 2.345238 | 7.05916638 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|2695621|gb|U82548.1|PFU82548 | 5833 | g31940 | i0 | 100 | 0.186046511627907 | 28 | 0 | 9 | 0 | 266 | 293 | 1695 | 1668 | Plasmodium falciparum asparagine-rich protein gene, partial cds | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 12160973 | 12160973 | PRJNA699078_S_NODE_12930_length_438_cov_4.452442_g12001_i0 | PRJNA699078 | 12930 | 438 | 4.452442 | 19.50169596 | Boveria subcylindrica | 693871 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 2.23e-94 | NTclustered | gi|759083259|gb|KM221954.1| | 693871 | g12001 | i0 | 83.333 | 53.8013698630137 | 390 | 63 | 89 | 2 | 37 | 425 | 437 | 49 | Boveria subcylindrica voucher FXP2009030301 alpha-tubulin gene, partial cds | blastn | 23565 | 359 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Thigmotrichida | Hemispeiridae | Boveria | Boveria subcylindrica | ||
| 15212654 | 15212654 | PRJNA699078_S_NODE_100892_length_167_cov_0.881356_g99943_i0 | PRJNA699078 | 100892 | 167 | 0.881356 | 1.47186452 | root | 1 | Root_unresolved | Root_unresolved | 100 | 4.93e-17 | NTclustered | gi|1419234739|dbj|AP018511.1| | 303400 | g99943 | i0 | 84.848 | 27.9041916167665 | 99 | 15 | 59 | 0 | 1 | 99 | 98858 | 98760 | Nitzschia palea NIES-2729 chloroplast DNA complet genome | blastn | 4660 | 100 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia palea | ||
| 19809231 | 19809231 | PRJNA699078_S_NODE_48696_length_245_cov_3.474490_g47747_i0 | PRJNA699078 | 48696 | 245 | 3.47449 | 8.5125005 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.12e-32 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g47747 | i0 | 78.632 | 31.3387755102041 | 234 | 47 | 96 | 2 | 8 | 241 | 686 | 456 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 7678 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 23635406 | 23635406 | PRJNA699078_S_NODE_57879_length_223_cov_1.833333_g56930_i0 | PRJNA699078 | 57879 | 223 | 1.833333 | 4.08833259 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g56930 | i0 | 100 | 0.130044843049327 | 29 | 0 | 13 | 0 | 1 | 29 | 11 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 |
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);;