contig_metadata
6 rows where bioproject = "PRJNA864829", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11051042 | 11051042 | PRJNA864829_S_NODE_8509_length_213_cov_5.121951_g8423_i0 | PRJNA864829 | 8509 | 213 | 5.121951 | 10.90975563 | Pseudosincirra longicirrata | 2876852 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.069999999999999e-23 | NTclustered | gi|2283605183|gb|OP175938.1| | 2876852 | g8423 | i0 | 94.805 | 36.0610328638498 | 77 | 4 | 36 | 0 | 1 | 77 | 1232 | 1308 | Pseudosincirra longicirrata isolate GQ2018091202 large subunit ribosomal RNA gene, partial sequence | blastn | 7681 | 121 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Urostylida | Urostylidae | Pseudosincirra | Pseudosincirra longicirrata | ||
| 15264769 | 15264769 | PRJNA864829_S_NODE_12532_length_181_cov_1.219697_g12446_i0 | PRJNA864829 | 12532 | 181 | 1.219697 | 2.20765157 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.340000000000001e-86 | NTclustered | gi|111035905|emb|AJ781081.1| | 5908 | g12446 | i0 | 99.448 | 99.9889502762431 | 181 | 1 | 100 | 0 | 1 | 181 | 321 | 141 | Tetrahymena pyriformis partial 18S rRNA gene, strain CCAP 1630/1W | blastn | 18098 | 329 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 17425480 | 17425480 | PRJNA864829_S_NODE_5554_length_253_cov_4.406863_g5468_i0 | PRJNA864829 | 5554 | 253 | 4.406863 | 11.14936339 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g5468 | i0 | 100 | 72.9486166007905 | 253 | 0 | 100 | 0 | 1 | 253 | 2959 | 3211 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 18456 | 468 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 19088388 | 19088388 | PRJNA864829_S_NODE_6575_length_238_cov_1.661376_g6489_i0 | PRJNA864829 | 6575 | 238 | 1.661376 | 3.95407488 | Anteclevelandella | 2917660 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.43e-30 | NTclustered | gi|2506798598|gb|OQ993418.1| | 1324583 | g6489 | i0 | 92.157 | 41.7142857142857 | 102 | 8 | 43 | 0 | 89 | 190 | 495 | 394 | Anteclevelandella constricta isolate P136_SRU_CA internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9928 | 145 | 1 | Eukaryota | Sar | Ciliophora | Armophorea | Clevelandellida | Clevelandellidae | Anteclevelandella | Anteclevelandella constricta | ||
| 21249446 | 21249446 | PRJNA864829_S_NODE_4577_length_273_cov_3.553571_g4491_i0 | PRJNA864829 | 4577 | 273 | 3.553571 | 9.70124883 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.45e-137 | NTclustered | gi|111035921|emb|AJ781306.1| | 5908 | g4491 | i0 | 99.634 | 99.5091575091575 | 273 | 1 | 100 | 0 | 1 | 273 | 48 | 320 | Tetrahymena pyriformis partial 23S rRNA gene, strain CCAP 1630/1W | blastn | 27166 | 499 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 21638900 | 21638900 | PRJNA864829_S_NODE_12937_length_178_cov_2.069767_g12851_i0 | PRJNA864829 | 12937 | 178 | 2.069767 | 3.68418526 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.21e-86 | NTclustered | gi|166083588|gb|EF024111.1| | 404701 | g12851 | i0 | 100 | 100.134831460674 | 178 | 0 | 100 | 0 | 1 | 178 | 1578 | 1401 | Prorodontidae environmental sample clone Elev_18S_409 18S ribosomal RNA gene, partial sequence | blastn | 17824 | 329 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Prorodontidae environmental sample |
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);;