metadata: contig_metadata: 7 rows where bioproject = "PRJNA801875", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA801875", 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
16524557	16524557	PRJNA801875_P_NODE_1573_length_304_cov_4.449814_g1470_i0	PRJNA801875	1573	304	4.449814	13.52743456	Nematostella	45350	Cnidaria	other_Eukaryota	99	3.59e-16	NTclustered	gi\|2211272922\|emb\|OW052000.1\|	45351	g1470	i0	85.263	14.2763157894737	95	14	31	0	68	162	16018	16112	Nematostella vectensis genome assembly, organelle: mitochondrion	blastn	4340	99	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
23753733	23753733	PRJNA801875_P_NODE_1559_length_306_cov_2.387454_g1456_i0	PRJNA801875	1559	306	2.387454	7.30560924	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	143	6.09e-41	NR	XP_065070902.1	499914	g1456	i0	67.3	10.5490196078431	107	30	100	1	1	306	70	176	XP_065070902.1 LOW QUALITY PROTEIN: large ribosomal subunit protein uL15-like [Rhopilema esculentum]	diamond	3228	143	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
26841744	26841744	PRJNA801875_P_NODE_3421_length_178_cov_1.069930_g3318_i0	PRJNA801875	3421	178	1.06993	1.9044754	Scleractinia	6125	Cnidaria	other_Eukaryota	78.6	3.58e-15	NR	XP_015773227.1	70779	g3318	i0	62.7	103.179775280899	59	21	97.8	1	3	176	533	591	XP_015773227.1 PREDICTED: probable E3 ubiquitin-protein ligase HERC1 [Acropora digitifera]	diamond	18366	79.3	0.991172761664565	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
30117218	30117218	PRJNA801875_P_NODE_1072_length_393_cov_2.173184_g969_i0	PRJNA801875	1072	393	2.173184	8.54061312	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	160	2.3199999999999997e-48	NR	XP_031552790.1	6105	g969	i0	69.4	2.54198473282443	111	27	79.4	2	59	370	3	113	XP_031552790.1 60S ribosomal protein L35a-like [Actinia tenebrosa]	diamond	999	160	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
30758208	30758208	PRJNA801875_P_NODE_4734_length_151_cov_1.008621_g4631_i0	PRJNA801875	4734	151	1.008621	1.52301771	Opisthokonta	33154	Cnidaria	other_Eukaryota	69.3	4.48e-12	NR	XP_031558139.1	6105	g4631	i0	63.3	20.9205298013245	49	18	97.4	0	2	148	517	565	XP_031558139.1 ubiquitin-like modifier-activating enzyme 1 [Actinia tenebrosa]	diamond	3159	69.7	0.994261119081779	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
31864474	31864474	PRJNA801875_P_NODE_1957_length_261_cov_1.522124_g1854_i0	PRJNA801875	1957	261	1.522124	3.97274364	Metazoa	33208	Cnidaria	other_Eukaryota	66.6	1.64e-10	NR	XP_031569994.1	6105	g1854	i0	53.8	15.6206896551724	65	29	74.7	1	8	202	149	212	XP_031569994.1 radial spoke head protein 3 homolog [Actinia tenebrosa]	diamond	4077	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
32393737	32393737	PRJNA801875_P_NODE_2019_length_254_cov_2.378995_g1916_i0	PRJNA801875	2019	254	2.378995	6.0426473	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	75.9	1.92e-15	NR	EDO38081.1	45351	g1916	i0	56.2	1.7244094488189	73	28	85	2	242	27	1	70	EDO38081.1 predicted protein, partial [Nematostella vectensis]	diamond	438	75.9	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);;