metadata: contig_metadata: 4 rows where bioproject = "PRJNA1137393", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA1137393", tax_kingdom = "Metazoa" 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
9960256	9960256	PRJNA1137393_P_NODE_6828_length_325_cov_2.721014_g6312_i0	PRJNA1137393	6828	325	2.721014	8.8432955	Apolemia	316169	Cnidaria	other_Eukaryota	244	4.69e-60	NTclustered	gi\|2523517620\|gb\|OQ957201.1\|	316193	g6312	i0	81.695	91.9569230769231	295	52	90	2	18	311	14847	15140	Apolemia sp. 3 CWD-2005 voucher YPM:IZ:35090 mitochondrion, complete genome	blastn	29886	244	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Siphonophorae	Apolemiidae	Apolemia	Apolemia sp. 3 CWD-2005
15587602	15587602	PRJNA1137393_P_NODE_34313_length_175_cov_1.531746_g33797_i0	PRJNA1137393	34313	175	1.531746	2.6805555	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	52.8	0.015	NTclustered	gi\|2918369535\|emb\|OZ237717.1\|	317547	g33797	i0	100	0.16	28	0	16	0	5	32	44014840	44014867	Eunicella cavolini genome assembly, chromosome: 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
21433954	21433954	PRJNA1137393_P_NODE_2497_length_612_cov_39.374778_g2010_i0	PRJNA1137393	2497	612	39.374778	240.97364136	Anthoathecata	406427	Cnidaria	other_Eukaryota	401	5.229999999999999e-107	NTclustered	gi\|429474262\|gb\|JQ410732.1\|	13093	g2010	i0	81.349	82.3529411764706	504	84	82	9	1	500	1378	881	Hydractinia symbiolongicarpus isolate 075 28S ribosomal RNA gene, partial sequence	blastn	50400	401	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29123333	29123333	PRJNA1137393_P_NODE_46729_length_168_cov_0.873950_g46213_i0	PRJNA1137393	46729	168	0.87395	1.468236	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	43.1	0.00124	NR	EDO34211.1	45351	g46213	i0	67.9	0.5	28	9	50	0	87	4	1	28	EDO34211.1 predicted protein, partial [Nematostella vectensis]	diamond	84	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis

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