metadata: contig_metadata: 13 rows where bioproject = "PRJEB83101" and tax

13 rows where bioproject = "PRJEB83101" 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
2691209	2691209	PRJEB83101_P_NODE_14803_length_491_cov_2.916268_g14506_i0	PRJEB83101	14803	491	2.916268	14.31887588	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	795	0	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g14506	i0	99.77	39.4989816700611	434	0	88	1	1	434	433	1	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	19394	795	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
2692634	2692634	PRJEB83101_P_NODE_6523_length_795_cov_7.303324_g6258_i0	PRJEB83101	6523	795	7.303324	58.0614258	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	1443	0	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g6258	i0	99.373	22.3232704402516	797	3	100	1	1	795	1530	734	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	17747	1443	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
6520413	6520413	PRJEB83101_P_NODE_52186_length_272_cov_1.919598_g51881_i0	PRJEB83101	52186	272	1.919598	5.22130656	Cystodiscus axonis	1112367	Cnidaria	other_Eukaryota	95.3	4.09e-15	NTclustered	gi\|331704058\|gb\|HQ822248.1\|	1112367	g51881	i0	82.569	28.5220588235294	109	18	40	1	164	272	536	429	Cystodiscus axonis isolate CTAUSIFA4 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence	blastn	7758	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Cystodiscus	Cystodiscus axonis
7793561	7793561	PRJEB83101_P_NODE_19087_length_424_cov_4.840456_g18784_i0	PRJEB83101	19087	424	4.840456	20.52353344	Henneguya laseeae	1940169	Cnidaria	other_Eukaryota	65.8	5.25e-6	NTclustered	gi\|2089706642\|gb\|OK030701.1\|	1940169	g18784	i0	95.122	0.162735849056604	41	2	10	0	1	41	53	13	Henneguya laseeae large subunit ribosomal RNA gene, partial sequence	blastn	69	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya laseeae
9925679	9925679	PRJEB83101_P_NODE_25048_length_366_cov_7.996587_g24743_i0	PRJEB83101	25048	366	7.996587	29.26750842	Metazoa	33208	Cnidaria	other_Eukaryota	62.1	5.77e-5	NTclustered	gi\|2663986577\|emb\|OY756918.1\|	59785	g24743	i0	95	9.5655737704918	40	0	10	1	78	115	4659	4698	Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	3501	62.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
12895805	12895805	PRJEB83101_P_NODE_54071_length_269_cov_1.841837_g53766_i0	PRJEB83101	54071	269	1.841837	4.95454153	Henneguya laseeae	1940169	Cnidaria	other_Eukaryota	117	8.62e-22	NTclustered	gi\|2089706642\|gb\|OK030701.1\|	1940169	g53766	i0	92.593	14.3197026022305	81	6	30	0	187	267	1126	1206	Henneguya laseeae large subunit ribosomal RNA gene, partial sequence	blastn	3852	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya laseeae
14169741	14169741	PRJEB83101_P_NODE_20892_length_404_cov_2.214502_g20589_i0	PRJEB83101	20892	404	2.214502	8.94658808	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	161	6.17e-35	NTclustered	gi\|2202645736\|ref\|XM_046996402.1\|	2897299	g20589	i0	83.051	4.25	177	30	44	0	2	178	273	449	PREDICTED: Xenia sp. Carnegie-2017 histone H2A (LOC124445656), mRNA	blastn	1717	161	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
14171617	14171617	PRJEB83101_P_NODE_87952_length_237_cov_2.737805_g87647_i0	PRJEB83101	87952	237	2.737805	6.48859785	Zschokkella nova	371529	Cnidaria	other_Eukaryota	69.4	2.11e-7	NTclustered	gi\|312184073\|gb\|GU471279.1\|	371529	g87647	i0	97.5	0.168776371308017	40	1	17	0	198	237	738	777	Zschokkella nova isolate 170 28S ribosomal RNA gene, partial sequence	blastn	40	69.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Zschokkella	Zschokkella nova
16719895	16719895	PRJEB83101_P_NODE_89594_length_230_cov_4.751592_g89289_i0	PRJEB83101	89594	230	4.751592	10.9286616	Chloromyxum trilineatum	2302366	Cnidaria	other_Eukaryota	224	4.11e-54	NTclustered	gi\|1594455348\|dbj\|LC417364.2\|	2302366	g89289	i0	84.416	2.98695652173913	231	32	100	4	1	230	1445	1672	Chloromyxum trilineatum MPM<JPN>:21458 gene for 18S ribosomal RNA, partial sequence	blastn	687	224	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Chloromyxidae	Chloromyxum	Chloromyxum trilineatum
17993434	17993434	PRJEB83101_P_NODE_40415_length_294_cov_1.800905_g40110_i0	PRJEB83101	40415	294	1.800905	5.2946607	Myxobolus sp. 'branchicola'	1446104	Cnidaria	other_Eukaryota	237	7.02e-58	NTclustered	gi\|573041015\|gb\|JN616264.1\|	1446104	g40110	i0	89.362	59.0340136054422	188	20	64	0	1	188	3771	3584	Myxobolus sp. 'branchicola' voucher CQ-20090225 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	17356	237	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus sp. 'branchicola'
20542513	20542513	PRJEB83101_P_NODE_27737_length_348_cov_7.160000_g27432_i0	PRJEB83101	27737	348	7.16	24.9168	Triactinomyxon sp.	148348	Cnidaria	other_Eukaryota	322	2.28e-83	NTclustered	gi\|2708035443\|gb\|PP575756.1\|	148348	g27432	i0	83.523	8.50574712643678	352	50	100	8	1	348	184	531	Triactinomyxon sp. isolate Monakhovo small subunit ribosomal RNA gene, partial sequence	blastn	2960	322	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa			Triactinomyxon	Triactinomyxon sp.
21819337	21819337	PRJEB83101_P_NODE_6738_length_782_cov_2.346968_g6466_i0	PRJEB83101	6738	782	2.346968	18.35328976	Chloromyxum cristatum	650990	Cnidaria	other_Eukaryota	110	4.59e-19	NTclustered	gi\|241911748\|gb\|FJ417054.1\|	650990	g6466	i0	100	6.8542199488491	59	0	8	0	724	782	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
27532528	27532528	PRJEB83101_P_NODE_75623_length_247_cov_1.781609_g75318_i0	PRJEB83101	75623	247	1.781609	4.40057423	Metazoa	33208	Cnidaria	other_Eukaryota	115	7.5599999999999995e-28	NR	XP_066928579.1	252671	g75318	i0	63.8	33.5587044534413	80	29	97.2	0	247	8	1236	1315	XP_066928579.1 ATP-binding cassette sub-family C member 4-like [Clytia hemisphaerica]	diamond	8289	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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