metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA263496" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA263496" and tax_phylum = "Cnidaria"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
4196202	4196202	PRJNA263496_P_NODE_13924_length_209_cov_2.350000_g13671_i0	PRJNA263496	13924	209	2.35	4.9115	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	387	4.42e-103	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g13671	i0	100	31.861244019138802	209	0	100	0	1	209	1329	1537	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	6659	387	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
5472820	5472820	PRJNA263496_P_NODE_2865_length_529_cov_1.391667_g2619_i0	PRJNA263496	2865	529	1.391667	7.36191843	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	928	0	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g2619	i0	98.134	30.2948960302457	536	3	100	1	1	529	682	1217	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	16026	928	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
8022471	8022471	PRJNA263496_P_NODE_12987_length_217_cov_1.505952_g12734_i0	PRJNA263496	12987	217	1.505952	3.26791584	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	401	1.6499999999999994e-107	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g12734	i0	100	98.7557603686636	217	0	100	0	1	217	2318	2534	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	21430	401	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
8022576	8022576	PRJNA263496_P_NODE_16467_length_192_cov_1.405594_g16214_i0	PRJNA263496	16467	192	1.405594	2.69874048	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	235	1.53e-57	NTclustered	gi\|2782873191\|ref\|XM_067061560.1\|	252671	g16214	i0	89.305	90.9010416666667	187	20	97	0	4	190	1282	1468	PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA	blastn	17453	235	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
9297703	9297703	PRJNA263496_P_NODE_9048_length_263_cov_1.906542_g8795_i0	PRJNA263496	9048	263	1.906542	5.01420546	Bivalvulida gen. n. sp. a JO-2023	3073449	Cnidaria	other_Eukaryota	204	6.26e-48	NTclustered	gi\|2572825558\|gb\|OR509833.1\|	3073449	g8795	i0	87.027	52.5703422053232	185	18	70	4	1	184	602	423	Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence	blastn	13826	204	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida			Bivalvulida gen. n. sp. a JO-2023
15672307	15672307	PRJNA263496_P_NODE_6933_length_309_cov_1.426923_g6680_i0	PRJNA263496	6933	309	1.426923	4.40919207	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	562	1.08e-155	NTclustered	gi\|681870001\|gb\|KM001684.1\|	1542451	g6680	i0	99.357	25.7766990291262	311	0	100	1	1	309	1947	2257	Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence	blastn	7965	562	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
16946330	16946330	PRJNA263496_P_NODE_11394_length_232_cov_1.393443_g11141_i0	PRJNA263496	11394	232	1.393443	3.23278776	Chloromyxum cristatum	650990	Cnidaria	other_Eukaryota	110	1.21e-19	NTclustered	gi\|241911748\|gb\|FJ417054.1\|	650990	g11141	i0	100	23.1034482758621	59	0	25	0	174	232	3001	2943	Chloromyxum cristatum isolate M0178 28S large subunit ribosomal RNA gene, partial sequence	blastn	5360	110	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Chloromyxidae	Chloromyxum	Chloromyxum cristatum
19494986	19494986	PRJNA263496_P_NODE_13556_length_212_cov_1.625767_g13303_i0	PRJNA263496	13556	212	1.625767	3.44662604	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	62.1	3.1e-5	NTclustered	gi\|2744898063\|ref\|XM_065814701.1\|	6087	g13303	i0	97.222	0.169811320754717	36	1	17	0	52	87	1026	1061	PREDICTED: Hydra vulgaris arginine--tRNA ligase, cytoplasmic (LOC100214624), mRNA	blastn	36	62.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
20183290	20183290	PRJNA263496_P_NODE_10816_length_239_cov_1.610526_g10563_i0	PRJNA263496	10816	239	1.610526	3.84915714	Myxobolus	35588	Cnidaria	other_Eukaryota	213	9.31e-51	NTclustered	gi\|237512527\|gb\|FJ981820.1\|	59783	g10563	i0	83.682	79.9205020920502	239	26	100	11	1	239	1108	1333	Myxobolus cerebralis 28S large subunit ribosomal RNA gene, partial sequence	blastn	19101	215	0.990697674418605	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus cerebralis
21458949	21458949	PRJNA263496_P_NODE_20777_length_168_cov_1.411765_g20524_i0	PRJNA263496	20777	168	1.411765	2.3717652	Henneguya	35590	Cnidaria	other_Eukaryota	137	3.79e-28	NTclustered	gi\|241911746\|gb\|FJ417052.1\|	650981	g20524	i0	94.444	47.8095238095238	90	3	53	2	75	163	2244	2156	Henneguya sp. M0375 28S large subunit ribosomal RNA gene, partial sequence	blastn	8032	137	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya sp. M0375

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);;