metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
2181229	2181229	PRJNA929922_P_NODE_124922_length_248_cov_0.880000_g124382_i0	PRJNA929922	124922	248	0.88	2.1824	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|2729092880\|ref\|XM_065209192.1\|	499914	g124382	i0	100	0.112903225806452	28	0	11	0	219	246	1503	1476	PREDICTED: Rhopilema esculentum serine/threonine-protein kinase ULK4-like (LOC135691353), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
6357747	6357747	PRJNA929922_P_NODE_36345_length_355_cov_1.404255_g35805_i0	PRJNA929922	36345	355	1.404255	4.98510525	Acropora	6127	Cnidaria	other_Eukaryota	52.8	0.034	NTclustered	gi\|2114117970\|ref\|XM_029344511.2\|	45264	g35805	i0	100	0.157746478873239	28	0	8	0	140	167	4829	4802	PREDICTED: Acropora millepora sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like (LOC114964975), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
9834187	9834187	PRJNA929922_P_NODE_142748_length_245_cov_0.872093_g142208_i0	PRJNA929922	142748	245	0.872093	2.13662785	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|1778060746\|ref\|XM_031711846.1\|	6105	g142208	i0	92.308	0.159183673469388	39	2	16	1	72	109	831	793	PREDICTED: Actinia tenebrosa QRFP-like peptide receptor (LOC116302524), mRNA	blastn	39	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
13659039	13659039	PRJNA929922_P_NODE_101491_length_255_cov_1.664835_g100951_i0	PRJNA929922	101491	255	1.664835	4.24532925	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2917940756\|emb\|OZ237571.1\|	6108	g100951	i0	100	0.109803921568627	28	0	11	0	110	137	7670927	7670900	Anemonia sulcata genome assembly, chromosome: 17	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
14935414	14935414	PRJNA929922_P_NODE_77592_length_282_cov_1.105263_g77052_i0	PRJNA929922	77592	282	1.105263	3.11684166	Acropora digitifera	70779	Cnidaria	other_Eukaryota	52.8	0.026	NTclustered	gi\|1005446366\|ref\|XM_015904991.1\|	70779	g77052	i0	100	0.099290780141844	28	0	10	0	50	77	1839	1812	PREDICTED: Acropora digitifera uncharacterized LOC107339686 (LOC107339686), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
16208382	16208382	PRJNA929922_P_NODE_104073_length_253_cov_0.972222_g103533_i0	PRJNA929922	104073	253	0.972222	2.45972166	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|1778051379\|ref\|XM_031707284.1\|	6105	g103533	i0	87.5	0.189723320158103	48	4	19	2	197	243	869	915	PREDICTED: Actinia tenebrosa ER degradation-enhancing alpha-mannosidase-like protein 1 (LOC116298741), mRNA	blastn	48	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
20380033	20380033	PRJNA929922_P_NODE_28136_length_383_cov_0.832258_g27596_i0	PRJNA929922	28136	383	0.832258	3.18754814	Pocilloporidae	46729	Cnidaria	other_Eukaryota	52.8	0.037	NTclustered	gi\|1524850784\|ref\|XM_027183365.1\|	46731	g27596	i0	100	0.29242819843342	28	0	7	0	169	196	310	283	PREDICTED: Pocillopora damicornis pyridoxal phosphate homeostasis protein-like (LOC113667433), transcript variant X2, mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis

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