metadata: contig_metadata: 4 rows where bioproject = "PRJNA1263632", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1263632", 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
30249935	30249935	PRJNA1263632_P_NODE_4652_length_290_cov_3.552995_g4634_i0	PRJNA1263632	4652	290	3.552995	10.3036855	root	1	Root_unresolved	Root_unresolved	47	0.00206	NR	XP_065051366.1	499914	g4634	i0	41.5	1.30344827586207	65	30	59	1	184	14	257	321	XP_065051366.1 membrane-associated tyrosine- and threonine-specific cdc2-inhibitory kinase-like isoform X1 [Rhopilema esculentum]	diamond	378	47.4	0.991561181434599	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
30769091	30769091	PRJNA1263632_P_NODE_4094_length_307_cov_1.393162_g4076_i0	PRJNA1263632	4094	307	1.393162	4.27700734	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	79.3	5.28e-15	NR	XP_001630185.2	45351	g4076	i0	47.6	0.820846905537459	84	42	82.1	1	54	305	41	122	XP_001630185.2 cathepsin B-like cysteine proteinase 4 isoform X1 [Nematostella vectensis]	diamond	252	79.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31021799	31021799	PRJNA1263632_P_NODE_5215_length_277_cov_1.093137_g5197_i0	PRJNA1263632	5215	277	1.093137	3.02798949	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	55.8	1.25e-6	NR	XP_027052021.1	46731	g5197	i0	42.2	0.693140794223827	64	32	68.2	2	214	26	197	256	XP_027052021.1 protein eyes shut homolog [Pocillopora damicornis]	diamond	192	55.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
32128888	32128888	PRJNA1263632_P_NODE_5038_length_281_cov_1.427885_g5020_i0	PRJNA1263632	5038	281	1.427885	4.01235685	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	81.6	1.24e-15	NR	XP_066914400.1	252671	g5020	i0	50.8	0.672597864768683	63	31	67.3	0	191	3	16	78	XP_066914400.1 uncharacterized protein [Clytia hemisphaerica]	diamond	189	81.6	1	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);;