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

5 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
4272247	4272247	PRJNA473641_P_NODE_6024_length_378_cov_1.636066_g5941_i0	PRJNA473641	6024	378	1.636066	6.18432948	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	243	1.9900000000000002e-59	NTclustered	gi\|1270064534\|ref\|XM_022939185.1\|	50429	g5941	i0	80.573	131.727513227513	314	61	83	0	62	375	1677	1364	PREDICTED: Stylophora pistillata polyubiquitin-C (LOC111333579), mRNA	blastn	49793	243	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
7473454	7473454	PRJNA473641_P_NODE_21706_length_246_cov_0.890173_g21623_i0	PRJNA473641	21706	246	0.890173	2.18982558	Opisthokonta	33154	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|2917940735\|emb\|OZ237565.1\|	6108	g21623	i0	100	7.44715447154472	29	0	12	0	216	244	7233977	7233949	Anemonia sulcata genome assembly, chromosome: 11	blastn	1832	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
13198451	13198451	PRJNA473641_P_NODE_13691_length_279_cov_1.495146_g13608_i0	PRJNA473641	13691	279	1.495146	4.17145734	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	169	2.4499999999999997e-37	NTclustered	gi\|1176083403\|ref\|XM_020756232.1\|	48498	g13608	i0	80.909	24.663082437276	220	37	78	5	62	279	567	351	PREDICTED: Orbicella faveolata histone H2A (LOC110050313), mRNA	blastn	6881	169	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
14473618	14473618	PRJNA473641_P_NODE_19352_length_249_cov_0.875000_g19269_i0	PRJNA473641	19352	249	0.875	2.17875	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2744840719\|ref\|XM_065788159.1\|	6087	g19269	i0	100	0.112449799196787	28	0	11	0	176	203	1913	1940	PREDICTED: Hydra vulgaris FERM, ARHGEF and pleckstrin domain-containing protein 2 (LOC100203284), transcript variant X2, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
19570739	19570739	PRJNA473641_P_NODE_20296_length_247_cov_1.643678_g20213_i0	PRJNA473641	20296	247	1.643678	4.05988466	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|2918369551\|emb\|OZ237723.1\|	317547	g20213	i0	100	0.11336032388664	28	0	11	0	100	127	9143687	9143714	Eunicella cavolini genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini

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