contig_metadata
9 rows where bioproject = "PRJNA1255065" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8013741 | 8013741 | PRJNA1255065_P_NODE_31827_length_436_cov_7.351421_g29611_i0 | PRJNA1255065 | 31827 | 436 | 7.351421 | 32.05219556 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 712 | 0 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g29611 | i0 | 96.136 | 100.688073394495 | 440 | 9 | 100 | 4 | 1 | 436 | 1003 | 568 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 43900 | 712 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 8705774 | 8705774 | PRJNA1255065_P_NODE_117007_length_167_cov_0.881356_g114779_i0 | PRJNA1255065 | 117007 | 167 | 0.881356 | 1.47186452 | Dermamoeba | 242548 | Discosea | other_Eukaryota | 132 | 1.7500000000000002e-26 | NTclustered | gi|33946341|gb|AY294148.1| | 242549 | g114779 | i0 | 86.179 | 29.1676646706587 | 123 | 15 | 74 | 2 | 4 | 126 | 997 | 877 | Dermamoeba algensis small subunit ribosomal RNA gene, partial sequence | blastn | 4871 | 132 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Dermamoeba | Dermamoeba algensis | ||||
| 8705959 | 8705959 | PRJNA1255065_P_NODE_155767_length_152_cov_5.291262_g153539_i0 | PRJNA1255065 | 155767 | 152 | 5.291262 | 8.04271824 | Ripella | 1217112 | Discosea | other_Eukaryota | 281 | 1.46e-71 | NTclustered | gi|1269228349|gb|MF683474.1| | 2047821 | g153539 | i0 | 100 | 100.5 | 152 | 0 | 100 | 0 | 1 | 152 | 542 | 391 | Ripella platypodia clone 23.4.22 18S ribosomal RNA gene, partial sequence | blastn | 15276 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 11839205 | 11839205 | PRJNA1255065_P_NODE_78590_length_203_cov_1.337662_g76362_i0 | PRJNA1255065 | 78590 | 203 | 1.337662 | 2.71545386 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 294 | 2.66e-75 | NTclustered | gi|145386781|gb|EF216906.1| | 437603 | g76362 | i0 | 92.754 | 95.7931034482759 | 207 | 10 | 100 | 4 | 1 | 203 | 1418 | 1213 | Neoparamoeba perurans strain GD-D1/1 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19446 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 17631180 | 17631180 | PRJNA1255065_P_NODE_73094_length_213_cov_1.158537_g70866_i0 | PRJNA1255065 | 73094 | 213 | 1.158537 | 2.46768381 | Vannella | 95228 | Discosea | other_Eukaryota | 300 | 6.06e-77 | NTclustered | gi|399764226|gb|JQ271737.1| | 1215641 | g70866 | i0 | 94.388 | 92.9342723004695 | 196 | 9 | 92 | 2 | 1 | 195 | 1037 | 843 | Vannella sp. ELH6 18S ribosomal RNA gene, partial sequence | blastn | 19795 | 300 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ELH6 | |||
| 20761572 | 20761572 | PRJNA1255065_P_NODE_129077_length_165_cov_0.896552_g126849_i0 | PRJNA1255065 | 129077 | 165 | 0.896552 | 1.4793108 | Acanthamoeba healyi | 65661 | Discosea | other_Eukaryota | 75 | 2.94e-9 | NTclustered | gi|28194604|gb|AF479548.1| | 65661 | g126849 | i0 | 88.525 | 0.36969696969697 | 61 | 7 | 37 | 0 | 30 | 90 | 292 | 232 | Acanthamoeba healyi strain CDC V013 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 61 | 75 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba healyi | |||
| 20762033 | 20762033 | PRJNA1255065_P_NODE_65337_length_230_cov_2.801105_g63109_i0 | PRJNA1255065 | 65337 | 230 | 2.801105 | 6.4425415 | Korotnevella jeppesenii | 1678066 | Discosea | other_Eukaryota | 398 | 2.2899999999999997e-106 | NTclustered | gi|861553759|gb|KP719186.1| | 1678066 | g63109 | i0 | 97.835 | 69.6739130434783 | 231 | 3 | 100 | 2 | 1 | 230 | 147 | 376 | Korotnevella jeppesenii strain A4DVDPB clone 4 small subunit ribosomal RNA gene, partial sequence | blastn | 16025 | 398 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Korotnevella | Korotnevella jeppesenii | ||
| 21454850 | 21454850 | PRJNA1255065_P_NODE_115817_length_167_cov_2.237288_g113589_i0 | PRJNA1255065 | 115817 | 167 | 2.237288 | 3.73627096 | Ripella | 1217112 | Discosea | other_Eukaryota | 291 | 2.7299999999999993e-74 | NTclustered | gi|1269228355|gb|MF683480.1| | 2047821 | g113589 | i0 | 98.204 | 100.125748502994 | 167 | 1 | 99 | 2 | 2 | 167 | 1143 | 1308 | Ripella platypodia clone 23.4.29 18S ribosomal RNA gene, partial sequence | blastn | 16721 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 21455417 | 21455417 | PRJNA1255065_P_NODE_87677_length_189_cov_1.471429_g85449_i0 | PRJNA1255065 | 87677 | 189 | 1.471429 | 2.78100081 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 94.7 | 8.549999999999999e-23 | NR | XP_004349731.1 | 1257118 | g85449 | i0 | 65.6 | 3.87301587301587 | 61 | 21 | 96.8 | 0 | 184 | 2 | 40 | 100 | XP_004349731.1 ribosomal protein S13p/S18e, putative [Acanthamoeba castellanii str. Neff] | diamond | 732 | 94.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;