metadata: contig_metadata: 10 rows where bioproject = "PRJNA692200" and tax

10 rows where bioproject = "PRJNA692200" 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
3223812	3223812	PRJNA692200_S_NODE_4783_length_293_cov_3.651639_g4726_i0	PRJNA692200	4783	293	3.651639	10.69930227	Acropora millepora	45264	Cnidaria	other_Eukaryota	52.8	0.027	NTclustered	gi\|2114135399\|ref\|XM_029355121.2\|	45264	g4726	i0	100	0.286689419795222	28	0	10	0	183	210	605	578	PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
10876987	10876987	PRJNA692200_S_NODE_5369_length_282_cov_6.815451_g5312_i0	PRJNA692200	5369	282	6.815451	19.21957182	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	65.8	3.34e-6	NTclustered	gi\|2917940752\|emb\|OZ237570.1\|	6108	g5312	i0	93.333	1.18085106382979	45	2	16	1	93	136	8541690	8541734	Anemonia sulcata genome assembly, chromosome: 16	blastn	333	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
10877043	10877043	PRJNA692200_S_NODE_7469_length_250_cov_8.442786_g7412_i0	PRJNA692200	7469	250	8.442786	21.106965	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940766\|emb\|OZ237573.1\|	6108	g7412	i0	100	1.204	30	0	12	0	84	113	11609410	11609381	Anemonia sulcata genome assembly, chromosome: 19	blastn	301	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
16482094	16482094	PRJNA692200_S_NODE_20653_length_165_cov_1.750000_g20596_i0	PRJNA692200	20653	165	1.75	2.8875	Montipora foliosa	591990	Cnidaria	other_Eukaryota	92.8	5.15e-22	NR	XP_068705947.1	591990	g20596	i0	81.3	16.6727272727273	48	9	87.3	0	158	15	131	178	XP_068705947.1 large ribosomal subunit protein uL30-like [Montipora foliosa]	diamond	2751	92.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
17250489	17250489	PRJNA692200_S_NODE_15534_length_185_cov_2.705882_g15477_i0	PRJNA692200	15534	185	2.705882	5.0058817	Chloromyxum leydigi	279112	Cnidaria	other_Eukaryota	80.5	7.25e-11	NTclustered	gi\|241911749\|gb\|FJ417055.1\|	279112	g15477	i0	88.235	0.367567567567568	68	6	36	2	119	185	97	31	Chloromyxum leydigi isolate M0180 28S large subunit ribosomal RNA gene, partial sequence	blastn	68	80.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Chloromyxidae	Chloromyxum	Chloromyxum leydigi
18524590	18524590	PRJNA692200_S_NODE_1455_length_409_cov_1470.586111_g1400_i0	PRJNA692200	1455	409	1470.586111	6014.69719399	Sphaeromyxa sp. M0416	650982	Cnidaria	other_Eukaryota	89.8	2.99e-13	NTclustered	gi\|241911767\|gb\|FJ417073.1\|	650982	g1400	i0	88	10.6528117359413	75	9	18	0	25	99	1	75	Sphaeromyxa sp. M0416 28S large subunit ribosomal RNA gene, partial sequence	blastn	4357	89.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Sphaeromyxidae	Sphaeromyxa	Sphaeromyxa sp. M0416
21074968	21074968	PRJNA692200_S_NODE_10397_length_219_cov_18.082353_g10340_i0	PRJNA692200	10397	219	18.082353	39.60035307	Leuckartiara octona	13108	Cnidaria	other_Eukaryota	60.2	1.16e-4	NTclustered	gi\|952952512\|gb\|KT809325.1\|	13108	g10340	i0	91.111	0.401826484018265	45	3	20	1	68	111	759	715	Leuckartiara octona mitochondrion, partial genome	blastn	88	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Pandeidae	Leuckartiara	Leuckartiara octona
27504891	27504891	PRJNA692200_S_NODE_21403_length_163_cov_2.254386_g21346_i0	PRJNA692200	21403	163	2.254386	3.67464918	Metazoa	33208	Cnidaria	other_Eukaryota	87.8	9.03e-20	NR	XP_028404257.1	151771	g21346	i0	70.4	4.96932515337423	54	16	99.4	0	162	1	32	85	XP_028404257.1 40S ribosomal protein S8-like [Dendronephthya gigantea]	diamond	810	88.2	0.99546485260771	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
30315567	30315567	PRJNA692200_S_NODE_21212_length_164_cov_0.895652_g21155_i0	PRJNA692200	21212	164	0.895652	1.46886928	Metazoa	33208	Cnidaria	other_Eukaryota	42.7	0.0127	NR	XP_068750036.1	246305	g21155	i0	39.2	2.79878048780488	51	30	93.3	1	158	6	243	292	XP_068750036.1 nucleoside hydrolase-like [Montipora capricornis]	diamond	459	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
32390537	32390537	PRJNA692200_S_NODE_10079_length_223_cov_1.172414_g10022_i0	PRJNA692200	10079	223	1.172414	2.61448322	Porites lobata	104759	Cnidaria	other_Eukaryota	66.2	1.39e-10	NR	CAH3146431.1	104759	g10022	i0	57.7	1.38565022421525	52	19	70	1	158	3	284	332	CAH3146431.1 unnamed protein product [Porites lobata]	diamond	309	66.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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