contig_metadata
6 rows where bioproject = "PRJNA827593", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5924713 | 5924713 | PRJNA827593_P_NODE_56025_length_264_cov_4.575916_g55726_i0 | PRJNA827593 | 56025 | 264 | 4.575916 | 12.08041824 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.5599999999999998e-128 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g55726 | i0 | 98.864 | 82.125 | 264 | 3 | 100 | 0 | 1 | 264 | 4257 | 4520 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21681 | 472 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 7199041 | 7199041 | PRJNA827593_P_NODE_21026_length_462_cov_2.778920_g20728_i0 | PRJNA827593 | 21026 | 462 | 2.77892 | 12.8386104 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.045 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g20728 | i0 | 100 | 0.0606060606060606 | 28 | 0 | 6 | 0 | 1 | 28 | 13 | 40 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 10156897 | 10156897 | PRJNA827593_P_NODE_37368_length_333_cov_2.346154_g37069_i0 | PRJNA827593 | 37368 | 333 | 2.346154 | 7.81269282 | Heterotrichida | 5957 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.09e-26 | NTclustered | gi|1820251590|gb|MT175584.1| | 219168 | g37069 | i0 | 86.29 | 25.0840840840841 | 124 | 15 | 37 | 2 | 8 | 130 | 749 | 871 | Peritromus kahli isolate CY2018101501 large subunit ribosomal RNA gene, partial sequence | blastn | 8353 | 135 | 0.992592592592593 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Peritromidae | Peritromus | Peritromus kahli | ||
| 16123421 | 16123421 | PRJNA827593_P_NODE_16973_length_522_cov_1.494432_g16676_i0 | PRJNA827593 | 16973 | 522 | 1.494432 | 7.80093504 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 7.279999999999998e-115 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g16676 | i0 | 81.992 | 62.2241379310345 | 522 | 77 | 98 | 15 | 10 | 522 | 6586 | 6073 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 32481 | 427 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 22906009 | 22906009 | PRJNA827593_P_NODE_59538_length_255_cov_1.631868_g59239_i0 | PRJNA827593 | 59538 | 255 | 1.631868 | 4.1612634 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.49e-91 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g59239 | i0 | 93.191 | 5.62352941176471 | 235 | 16 | 92 | 0 | 1 | 235 | 304 | 70 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1434 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24180034 | 24180034 | PRJNA827593_P_NODE_48039_length_289_cov_3.194444_g47740_i0 | PRJNA827593 | 48039 | 289 | 3.194444 | 9.23194316 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.21e-137 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g47740 | i0 | 97.931 | 99.2768166089965 | 290 | 5 | 100 | 1 | 1 | 289 | 2667 | 2956 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 28691 | 501 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata |
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);;