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

5 rows where bioproject = "PRJNA738523", tax_clade = "Opisthokonta" and tax_phylum = "Placozoa"

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
21599917	21599917	PRJNA738523_P_NODE_13937_length_245_cov_0.895349_g13866_i0	PRJNA738523	13937	245	0.895349	2.19360505	Trichoplax sp. H2	287889	Placozoa	other_Eukaryota	107	1.91e-26	NR	RDD41778.1	287889	g13866	i0	67.6	1.76326530612245	74	24	90.6	0	13	234	178	251	RDD41778.1 RNA-binding protein 42 [Trichoplax sp. H2]	diamond	432	107	1	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax sp. H2
28420858	28420858	PRJNA738523_P_NODE_9846_length_257_cov_0.983696_g9775_i0	PRJNA738523	9846	257	0.983696	2.52809872	Trichoplax	10227	Placozoa	other_Eukaryota	58.2	9.45e-9	NR	XP_002118375.1	10228	g9775	i0	34.3	3.37354085603113	70	46	81.7	0	246	37	20	89	XP_002118375.1 expressed hypothetical protein, partial [Trichoplax adhaerens]	diamond	867	58.2	1	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax adhaerens
31579766	31579766	PRJNA738523_P_NODE_10896_length_251_cov_0.865169_g10825_i0	PRJNA738523	10896	251	0.865169	2.17157419	Metazoa	33208	Placozoa	other_Eukaryota	86.3	1.89e-17	NR	XP_002113815.1	10228	g10825	i0	51.2	4.01593625498008	84	40	99.2	1	1	249	404	487	XP_002113815.1 uncharacterized protein TRIADDRAFT_26388 [Trichoplax adhaerens]	diamond	1008	86.7	0.995386389850058	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax adhaerens
32212424	32212424	PRJNA738523_P_NODE_12078_length_248_cov_1.280000_g12007_i0	PRJNA738523	12078	248	1.28	3.1744	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87.4	2.08e-19	NR	XP_002111209.1	10228	g12007	i0	47.6	2.77016129032258	84	42	99.2	2	3	248	94	177	XP_002111209.1 uncharacterized protein TRIADDRAFT_54943 [Trichoplax adhaerens]	diamond	687	88.2	0.99092970521542	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax adhaerens
32802112	32802112	PRJNA738523_P_NODE_3940_length_347_cov_1.036496_g3869_i0	PRJNA738523	3940	347	1.036496	3.59664112	Trichoplax sp. H2	287889	Placozoa	other_Eukaryota	56.2	1.28e-7	NR	RDD46310.1	287889	g3869	i0	49.3	0.596541786743516	69	27	59.7	2	332	126	28	88	RDD46310.1 cAMP-regulated phosphoprotein 19 [Trichoplax sp. H2]	diamond	207	56.2	1	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax sp. H2

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