metadata: contig_metadata: 8 rows where bioproject = "PRJNA1082072", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA1082072", 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
23145359	23145359	PRJNA1082072_P_NODE_1439_length_289_cov_1.351852_g1432_i0	PRJNA1082072	1439	289	1.351852	3.90685228	Metazoa	33208	Cnidaria	other_Eukaryota	103	1.3299999999999995e-23	NR	XP_057303152.1	13093	g1432	i0	50.6	1.87889273356401	85	42	88.2	0	34	288	312	396	XP_057303152.1 protein disulfide-isomerase A3-like [Hydractinia symbiolongicarpus]	diamond	543	103	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
23145374	23145374	PRJNA1082072_P_NODE_599_length_407_cov_1.074850_g592_i0	PRJNA1082072	599	407	1.07485	4.3746395	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	183	4.1199999999999985e-56	NR	KAJ7384493.1	174260	g592	i0	68.9	1.99017199017199	135	42	99.5	0	2	406	9	143	KAJ7384493.1 60S ribosomal protein L17 [Desmophyllum pertusum]	diamond	810	183	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
27596179	27596179	PRJNA1082072_P_NODE_2604_length_245_cov_1.011628_g2597_i0	PRJNA1082072	2604	245	1.011628	2.4784886	Porites	46719	Cnidaria	other_Eukaryota	57.4	2.55e-7	NR	CAH3187153.1	104178	g2597	i0	61.1	1.77551020408163	36	14	44.1	0	109	2	290	325	CAH3187153.1 unnamed protein product [Porites evermanni]	diamond	435	57.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
27659381	27659381	PRJNA1082072_P_NODE_624_length_400_cov_1.223242_g617_i0	PRJNA1082072	624	400	1.223242	4.892968	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	64.7	4.74e-9	NR	XP_022795499.1	50429	g617	i0	34.7	2.04	98	59	72	3	397	110	849	943	XP_022795499.1 proprotein convertase subtilisin/kexin type 6-like [Stylophora pistillata]	diamond	816	64.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
27731191	27731191	PRJNA1082072_P_NODE_704_length_385_cov_0.987179_g697_i0	PRJNA1082072	704	385	0.987179	3.80063915	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	163	1.27e-49	NR	XP_065654277.1	6087	g697	i0	84.3	1.96363636363636	83	13	64.7	0	364	116	18	100	XP_065654277.1 uncharacterized protein LOC136080866 [Hydra vulgaris]	diamond	756	163	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27920272	27920272	PRJNA1082072_P_NODE_2205_length_250_cov_0.870056_g2198_i0	PRJNA1082072	2205	250	0.870056	2.17514	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	77.4	2.23e-14	NR	CAB4001175.1	317549	g2198	i0	50.7	0.828	69	34	82.8	0	235	29	247	315	CAB4001175.1 nucleoredoxin-like [Paramuricea clavata]	diamond	207	77.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
29246381	29246381	PRJNA1082072_P_NODE_1469_length_288_cov_1.130233_g1462_i0	PRJNA1082072	1469	288	1.130233	3.25507104	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	64.3	1.75e-9	NR	KAK3738588.1	3060491	g1462	i0	38	1.125	108	54	99	1	1	285	803	910	KAK3738588.1 hypothetical protein QZH41_008676 [Actinostola sp. cb2023]	diamond	324	64.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
31900802	31900802	PRJNA1082072_P_NODE_1237_length_311_cov_1.294118_g1230_i0	PRJNA1082072	1237	311	1.294118	4.02470698	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	130	1.22e-36	NR	XP_028401732.1	151771	g1230	i0	64.6	0.954983922829582	99	26	87.8	2	37	309	5	102	XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea]	diamond	297	130	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea

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