metadata: contig_metadata: 7 rows where bioproject = "PRJNA900999", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJNA900999", tax_clade = "Opisthokonta" 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
2153422	2153422	PRJNA900999_S_NODE_5662_length_186_cov_18.630573_g5606_i0	PRJNA900999	5662	186	18.630573	34.65286578	Nausithoe rubra	168762	Cnidaria	other_Eukaryota	91.6	3.37e-14	NTclustered	gi\|66864835\|gb\|AY920776.1\|	168762	g5606	i0	80.159	1.69354838709677	126	21	67	4	45	168	3306	3183	Nausithoe rubra large subunit 28S ribosomal RNA gene, partial sequence	blastn	315	91.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Coronatae	Nausithoidae	Nausithoe	Nausithoe rubra
2153442	2153442	PRJNA900999_S_NODE_8542_length_158_cov_8.604651_g8486_i0	PRJNA900999	8542	158	8.604651	13.59534858	Symplectoscyphus tricuspidatus	308614	Cnidaria	other_Eukaryota	73.1	1e-8	NTclustered	gi\|1006165264\|gb\|KT190774.1\|	308614	g8486	i0	83.333	3.0506329113924	84	8	53	3	67	149	2489	2411	Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence	blastn	482	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Symplectoscyphus	Symplectoscyphus tricuspidatus
8530945	8530945	PRJNA900999_S_NODE_3107_length_234_cov_226.965854_g3051_i0	PRJNA900999	3107	234	226.965854	531.10009836	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	165	2.58e-36	NTclustered	gi\|2518994150\|ref\|XM_057448279.1\|	13093	g3051	i0	87.586	52.6752136752137	145	15	61	2	42	183	1472	1328	PREDICTED: Hydractinia symbiolongicarpus tubulin alpha-2/alpha-4 chain (LOC130641471), mRNA	blastn	12326	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
13631860	13631860	PRJNA900999_S_NODE_7131_length_170_cov_4.574468_g7075_i0	PRJNA900999	7131	170	4.574468	7.7765956	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2519002640\|ref\|XM_057452941.1\|	13093	g7075	i0	100	0.170588235294118	29	0	17	0	5	33	794	766	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130647178 (LOC130647178), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
27947890	27947890	PRJNA900999_S_NODE_7185_length_170_cov_2.141844_g7129_i0	PRJNA900999	7185	170	2.141844	3.6411348	Metazoa	33208	Cnidaria	other_Eukaryota	49.7	4.96e-5	NR	XP_065676795.1	6087	g7129	i0	57.5	3.44117647058824	40	17	70.6	0	31	150	626	665	XP_065676795.1 DNA transposase THAP9-like isoform X2 [Hydra vulgaris]	diamond	585	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28918840	28918840	PRJNA900999_S_NODE_4328_length_207_cov_3.803371_g4272_i0	PRJNA900999	4328	207	3.803371	7.87297797	Porites lobata	104759	Cnidaria	other_Eukaryota	47.4	5.66e-4	NR	CAH3119332.1	104759	g4272	i0	50	2.88405797101449	30	14	43.5	1	123	34	1142	1170	CAH3119332.1 unnamed protein product [Porites lobata]	diamond	597	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
30213624	30213624	PRJNA900999_S_NODE_3812_length_217_cov_7.930851_g3756_i0	PRJNA900999	3812	217	7.930851	17.20994667	Porites lobata	104759	Cnidaria	other_Eukaryota	43.9	0.00373	NR	CAH3175177.1	104759	g3756	i0	51.1	0.622119815668203	45	20	62.2	1	211	77	83	125	CAH3175177.1 unnamed protein product [Porites lobata]	diamond	135	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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