metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA914897" 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
3445790	3445790	PRJNA914897_P_NODE_3623_length_1048_cov_2.604103_g3346_i0	PRJNA914897	3623	1048	2.604103	27.29099944	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	63.9	4.92e-5	NTclustered	gi\|1176093422\|ref\|XM_020761567.1\|	48498	g3346	i0	91.304	0.0438931297709924	46	4	4	0	480	525	908	863	PREDICTED: Orbicella faveolata zinc finger CCCH domain-containing protein 15-like (LOC110055198), mRNA	blastn	46	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
16197691	16197691	PRJNA914897_P_NODE_2053_length_1326_cov_3.138069_g1865_i0	PRJNA914897	2053	1326	3.138069	41.61079494	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	54.7	0.038	NTclustered	gi\|2918369536\|emb\|OZ237718.1\|	317547	g1865	i0	100	0.0218702865761689	29	0	2	0	590	618	61359945	61359917	Eunicella cavolini genome assembly, chromosome: 2	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
17473053	17473053	PRJNA914897_P_NODE_2454_length_1240_cov_6.263068_g2239_i0	PRJNA914897	2454	1240	6.263068	77.6620432	Montipora capricornis	246305	Cnidaria	other_Eukaryota	326	6.76e-84	NTclustered	gi\|2812169954\|ref\|XM_068897760.1\|	246305	g2239	i0	73.908	8.03790322580645	870	201	69	25	284	1140	389	1245	PREDICTED: Montipora capricornis 26S proteasome regulatory subunit 7 (LOC138051540), mRNA	blastn	9967	326	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
21296948	21296948	PRJNA914897_P_NODE_37497_length_249_cov_2.613636_g37073_i0	PRJNA914897	37497	249	2.613636	6.50795364	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2518947658\|ref\|XM_057444391.1\|	13093	g37073	i0	100	0.112449799196787	28	0	11	0	40	67	1209	1182	PREDICTED: Hydractinia symbiolongicarpus G kinase-anchoring protein 1-like (LOC130631364), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
22928635	22928635	PRJNA914897_P_NODE_10218_length_589_cov_2.029070_g9801_i0	PRJNA914897	10218	589	2.02907	11.9512223	Montipora	46703	Cnidaria	other_Eukaryota	56.5	0.005	NTclustered	gi\|2812134930\|ref\|XM_068880660.1\|	246305	g9801	i0	96.97	0.168081494057725	33	1	6	0	540	572	2615	2647	PREDICTED: Montipora capricornis uncharacterized protein (LOC138032938), mRNA	blastn	99	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis

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