metadata: contig_metadata: 5 rows where bioproject = "PRJNA827593", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA827593", 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
14849523	14849523	PRJNA827593_P_NODE_54892_length_268_cov_1.184615_g54593_i0	PRJNA827593	54892	268	1.184615	3.1747682	Acropora digitifera	70779	Cnidaria	other_Eukaryota	52.8	0.025	NTclustered	gi\|1005452296\|ref\|XM_015907806.1\|	70779	g54593	i0	100	0.104477611940299	28	0	10	0	187	214	2210	2237	PREDICTED: Acropora digitifera uncharacterized LOC107342323 (LOC107342323), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
27781124	27781124	PRJNA827593_P_NODE_10244_length_690_cov_2.388979_g9955_i0	PRJNA827593	10244	690	2.388979	16.4839551	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	94.4	3.95e-18	NR	XP_028407200.1	151771	g9955	i0	33.1	0.669565217391304	154	97	64.3	1	652	209	689	842	XP_028407200.1 lymphoid-specific helicase-like [Dendronephthya gigantea]	diamond	462	94.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
28349337	28349337	PRJNA827593_P_NODE_1886_length_1724_cov_2.357965_g1724_i0	PRJNA827593	1886	1724	2.357965	40.6513166	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	61.2	9.91e-6	NR	XP_065653976.1	6087	g1724	i0	39.8	0.509860788863109	93	55	16.2	1	538	816	7	98	XP_065653976.1 homeobox protein 2-like isoform X4 [Hydra vulgaris]	diamond	879	61.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28642334	28642334	PRJNA827593_P_NODE_19787_length_479_cov_1.581281_g19489_i0	PRJNA827593	19787	479	1.581281	7.57433599	Metazoa	33208	Cnidaria	other_Eukaryota	189	1.11e-52	NR	XP_065672741.1	6087	g19489	i0	58	8.43632567849687	150	61	92.7	1	18	461	399	548	XP_065672741.1 3-hydroxy-3-methylglutaryl-coenzyme A reductase isoform X2 [Hydra vulgaris]	diamond	4041	189	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29494672	29494672	PRJNA827593_P_NODE_31250_length_369_cov_2.108108_g30951_i0	PRJNA827593	31250	369	2.108108	7.77891852	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	70.9	2.12e-11	NR	XP_028396329.1	151771	g30951	i0	50.8	2.13821138211382	61	27	49.6	1	183	365	187	244	XP_028396329.1 sphingomyelin phosphodiesterase-like [Dendronephthya gigantea]	diamond	789	71.6	0.990223463687151	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea

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