metadata: contig_metadata: 8 rows where bioproject = "PRJNA986547", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA986547", 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
974286	974286	PRJNA986547_P_NODE_7961_length_254_cov_5.265193_g7879_i0	PRJNA986547	7961	254	5.265193	13.37359022	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	102	4.89e-23	NR	XP_065643603.1	6087	g7879	i0	61.3	8.85826771653543	75	29	88.6	0	2	226	459	533	XP_065643603.1 propionyl-CoA carboxylase beta chain, mitochondrial isoform X2 [Hydra vulgaris]	diamond	2250	102	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
7650278	7650278	PRJNA986547_P_NODE_14466_length_225_cov_5.618421_g14384_i0	PRJNA986547	14466	225	5.618421	12.64144725	Leptothecata	500008	Cnidaria	other_Eukaryota	215	2.41e-51	NTclustered	gi\|62825457\|gb\|AY789865.1\|	314519	g14384	i0	83.929	35.8577777777778	224	36	99	0	1	224	243	20	Laomedea inornata voucher 564WA calmodulin gene, partial cds	blastn	8068	217	0.990783410138249	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Campanulariidae	Gonothyraea	Gonothyraea inornata
10200872	10200872	PRJNA986547_P_NODE_15208_length_216_cov_7.454545_g15126_i0	PRJNA986547	15208	216	7.454545	16.1018172	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	78.2	6.54e-15	NR	XP_057317585.1	13093	g15126	i0	56	10.2638888888889	75	28	98.6	2	214	2	24	97	XP_057317585.1 lysosomal aspartic protease-like [Hydractinia symbiolongicarpus]	diamond	2217	78.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
11177526	11177526	PRJNA986547_P_NODE_1649_length_362_cov_2.629758_g1567_i0	PRJNA986547	1649	362	2.629758	9.51972396	Acropora digitifera	70779	Cnidaria	other_Eukaryota	178	5.79e-52	NR	XP_015764694.1	70779	g1567	i0	78.5	17.5027624309392	107	23	88.7	0	359	39	293	399	XP_015764694.1 PREDICTED: LOW QUALITY PROTEIN: actin-related protein 2-like [Acropora digitifera]	diamond	6336	178	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
29811109	29811109	PRJNA986547_P_NODE_9351_length_248_cov_6.765714_g9269_i0	PRJNA986547	9351	248	6.765714	16.77897072	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	52	3.03e-6	NR	CAB4024356.1	317549	g9269	i0	67.7	0.774193548387097	31	10	37.5	0	248	156	76	106	CAB4024356.1 glutathione peroxidase-like, partial [Paramuricea clavata]	diamond	192	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30980415	30980415	PRJNA986547_P_NODE_2874_length_310_cov_3.721519_g2792_i0	PRJNA986547	2874	310	3.721519	11.5367089	Metazoa	33208	Cnidaria	other_Eukaryota	83.6	2.77e-18	NR	XP_057293273.1	13093	g2792	i0	38.8	1.91612903225806	103	53	95.8	3	310	14	8	104	XP_057293273.1 uncharacterized protein LOC130621921 [Hydractinia symbiolongicarpus]	diamond	594	83.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
31581072	31581072	PRJNA986547_P_NODE_12296_length_240_cov_2.892216_g12214_i0	PRJNA986547	12296	240	2.892216	6.9413184	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	84.3	7.9e-19	NR	XP_020604647.1	48498	g12214	i0	49.4	76.5375	83	38	100	2	1	240	32	113	XP_020604647.1 60S ribosomal protein L31-like isoform X2 [Orbicella faveolata]	diamond	18369	84.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
32334611	32334611	PRJNA986547_P_NODE_5579_length_273_cov_2.825000_g5497_i0	PRJNA986547	5579	273	2.825	7.71225	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	45.4	0.00588	NR	RMX50720.1	46731	g5497	i0	46.7	0.989010989010989	45	24	49.5	0	4	138	131	175	RMX50720.1 hypothetical protein pdam_00013206, partial [Pocillopora damicornis]	diamond	270	45.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis

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