metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA399711" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA399711" 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
33020401	33020401	PRJNA399711_S_NODE_78716_length_169_cov_1.871212_g78574_i0	PRJNA399711	78716	169	1.871212	3.16234828	Porites lobata	104759	Cnidaria	other_Eukaryota	47	4.48e-4	NR	CAH3119332.1	104759	g78574	i0	50	3.53254437869822	30	14	53.3	1	68	157	1142	1170	CAH3119332.1 unnamed protein product [Porites lobata]	diamond	597	47.4	0.991561181434599	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
33054268	33054268	PRJNA399711_S_NODE_36869_length_222_cov_3.005405_g36727_i0	PRJNA399711	36869	222	3.005405	6.6719991	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.9	0.0118	NR	CAB4025004.1	317549	g36727	i0	43.2	0.594594594594595	44	25	59.5	0	219	88	597	640	CAB4025004.1 Transposon TX1 uncharacterized 149 kDa, partial [Paramuricea clavata]	diamond	132	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
33111836	33111836	PRJNA399711_S_NODE_53110_length_195_cov_1.512658_g52968_i0	PRJNA399711	53110	195	1.512658	2.9496831	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.5	5.07e-8	NR	XP_020605355.1	48498	g52968	i0	78.8	2.03076923076923	33	7	50.8	0	193	95	384	416	XP_020605355.1 eukaryotic initiation factor 4A-I-like [Orbicella faveolata]	diamond	396	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
33122782	33122782	PRJNA399711_S_NODE_76311_length_171_cov_1.417910_g76169_i0	PRJNA399711	76311	171	1.41791	2.4246261	Acropora millepora	45264	Cnidaria	other_Eukaryota	58.2	1.65e-8	NR	XP_029191643.2	45264	g76169	i0	60.5	3.78947368421053	43	10	75.4	1	168	40	143	178	XP_029191643.2 ADP-ribosylation factor-like protein 3 [Acropora millepora]	diamond	648	58.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
33173929	33173929	PRJNA399711_S_NODE_58288_length_188_cov_4.423841_g58146_i0	PRJNA399711	58288	188	4.423841	8.31682108	Porites evermanni	104178	Cnidaria	other_Eukaryota	53.1	4.76e-7	NR	CAH3019457.1	104178	g58146	i0	41	1.86702127659574	61	36	97.3	0	6	188	37	97	CAH3019457.1 unnamed protein product, partial [Porites evermanni]	diamond	351	53.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni

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