contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 628217 | 628217 | PRJNA662254_P_NODE_12161_length_472_cov_8.298246_g11510_i0 | PRJNA662254 | 12161 | 472 | 8.298246 | 39.16772112 | Pellita digitata | 1485084 | Discosea | other_Eukaryota | 300 | 1.48e-76 | NTclustered | gi|608606230|gb|KF705037.1| | 1485084 | g11510 | i0 | 82.025 | 38.4300847457627 | 395 | 31 | 78 | 19 | 94 | 459 | 886 | 1269 | Pellita digitata clone 2 18S ribosomal RNA gene, partial sequence | blastn | 18139 | 300 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Pellitidae | Pellita | Pellita digitata | |||
| 3179089 | 3179089 | PRJNA662254_P_NODE_14263_length_435_cov_1.643646_g13612_i0 | PRJNA662254 | 14263 | 435 | 1.643646 | 7.1498601 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 54.7 | 0.012 | NTclustered | gi|470426339|ref|XM_004337838.1| | 1257118 | g13612 | i0 | 96.97 | 0.0758620689655172 | 33 | 0 | 8 | 1 | 199 | 231 | 1027 | 1058 | Acanthamoeba castellanii str. Neff Fbox domain containing protein (ACA1_187900), partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 4456148 | 4456148 | PRJNA662254_P_NODE_23024_length_343_cov_1.677778_g22373_i0 | PRJNA662254 | 23024 | 343 | 1.677778 | 5.75477854 | Vannella miroides | 218656 | Discosea | other_Eukaryota | 612 | 1.19e-170 | NTclustered | gi|27803574|gb|AY183888.1| | 218656 | g22373 | i0 | 98.834 | 96.8309037900875 | 343 | 4 | 100 | 0 | 1 | 343 | 1588 | 1930 | Vannella miroides small subunit ribosomal RNA gene, complete sequence | blastn | 33213 | 612 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella miroides | |||
| 4456303 | 4456303 | PRJNA662254_P_NODE_5884_length_710_cov_6.565149_g5282_i0 | PRJNA662254 | 5884 | 710 | 6.565149 | 46.6125579 | Vannella croatica | 1778588 | Discosea | other_Eukaryota | 1293 | 0 | NTclustered | gi|973761167|gb|KT345693.1| | 1778588 | g5282 | i0 | 99.577 | 82.9605633802817 | 710 | 1 | 99 | 2 | 2 | 710 | 1235 | 527 | Vannella croatica isolate KRKA 29.9.7.6.1 small subunit ribosomal RNA gene, partial sequence | blastn | 58902 | 1293 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella croatica | |||
| 7006864 | 7006864 | PRJNA662254_P_NODE_2506_length_1124_cov_8.314938_g2111_i0 | PRJNA662254 | 2506 | 1124 | 8.314938 | 93.45990312 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 1454 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g2111 | i0 | 90.537 | 97.9804270462633 | 1099 | 104 | 98 | 0 | 26 | 1124 | 1182 | 84 | Platyamoeba placida actin mRNA, partial cds | blastn | 110130 | 1454 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 8281631 | 8281631 | PRJNA662254_P_NODE_6887_length_648_cov_7.424348_g6268_i0 | PRJNA662254 | 6887 | 648 | 7.424348 | 48.10977504 | Vannella persistens | 303303 | Discosea | other_Eukaryota | 1151 | 0 | NTclustered | gi|165968548|gb|EU377588.1| | 303303 | g6268 | i0 | 98.764 | 81.858024691358 | 647 | 8 | 99 | 0 | 2 | 648 | 716 | 70 | Vannella persistens strain CRIB69 18S ribosomal RNA gene, partial sequence | blastn | 53044 | 1151 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella persistens | |||
| 23580860 | 23580860 | PRJNA662254_P_NODE_11819_length_479_cov_3.921182_g11168_i0 | PRJNA662254 | 11819 | 479 | 3.921182 | 18.78246178 | Vannella miroides | 218656 | Discosea | other_Eukaryota | 874 | 0 | NTclustered | gi|27803574|gb|AY183888.1| | 218656 | g11168 | i0 | 99.582 | 95.7286012526096 | 479 | 2 | 100 | 0 | 1 | 479 | 102 | 580 | Vannella miroides small subunit ribosomal RNA gene, complete sequence | blastn | 45854 | 874 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella miroides |
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);;