metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA168635" 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
364516	364516	PRJNA168635_P_NODE_29001_length_165_cov_0.896552_g28585_i0	PRJNA168635	29001	165	0.896552	1.4793108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.4	8.189999999999999e-23	NR	XP_002164853.1	6087	g28585	i0	83.3	251.345454545455	54	9	98.2	0	164	3	335	388	XP_002164853.1 spliceosome RNA helicase DDX39B [Hydra vulgaris]	diamond	41472	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27060125	27060125	PRJNA168635_P_NODE_28702_length_165_cov_1.543103_g28286_i0	PRJNA168635	28702	165	1.543103	2.54611995	Metazoa	33208	Cnidaria	other_Eukaryota	46.6	5.55e-4	NR	XP_065684241.1	6087	g28286	i0	50	1.8	46	22	83.6	1	163	26	145	189	XP_065684241.1 uncharacterized protein LOC124807903 [Hydra vulgaris]	diamond	297	46.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27502690	27502690	PRJNA168635_P_NODE_23323_length_173_cov_1.653226_g22907_i0	PRJNA168635	23323	173	1.653226	2.86008098	Cnidaria	6073	Cnidaria	other_Eukaryota	57	4.56e-8	NR	KAK2567157.1	6130	g22907	i0	49.1	11.4797687861272	55	28	95.4	0	173	9	118	172	KAK2567157.1 Endothelial differentiation-related factor 1 [Acropora cervicornis]	diamond	1986	57	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
28575986	28575986	PRJNA168635_P_NODE_29487_length_164_cov_2.652174_g29071_i0	PRJNA168635	29487	164	2.652174	4.34956536	root	1	Root_unresolved	Root_unresolved	58.9	2.46e-8	NR	XP_057300642.1	13093	g29071	i0	68.6	7.68292682926829	35	11	64	0	145	41	104	138	XP_057300642.1 uncharacterized protein LOC130634949 isoform X1 [Hydractinia symbiolongicarpus]	diamond	1260	58.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29649167	29649167	PRJNA168635_P_NODE_17750_length_190_cov_3.609929_g17334_i0	PRJNA168635	17750	190	3.609929	6.8588651	root	1	Root_unresolved	Root_unresolved	96.7	1.0399999999999997e-23	NR	XP_028410526.1	151771	g17334	i0	83.6	2.63684210526316	55	9	86.8	0	21	185	1	55	XP_028410526.1 60S ribosomal protein L27a-like [Dendronephthya gigantea]	diamond	501	96.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
30565308	30565308	PRJNA168635_P_NODE_23773_length_172_cov_1.650407_g23357_i0	PRJNA168635	23773	172	1.650407	2.83870004	Metazoa	33208	Cnidaria	other_Eukaryota	72	1.33e-13	NR	XP_031562005.1	6105	g23357	i0	63.6	9.61046511627907	55	20	95.9	0	1	165	81	135	XP_031562005.1 60S ribosomal protein L13-like [Actinia tenebrosa]	diamond	1653	72.4	0.994475138121547	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa

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