metadata: contig_metadata: 8 rows where bioproject = "PRJNA674048", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA674048", tax_clade = "Opisthokonta" and tax_phylum = "Porifera"

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
26923625	26923625	PRJNA674048_P_NODE_7142_length_371_cov_1.689441_g6939_i0	PRJNA674048	7142	371	1.689441	6.26782611	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	84	9.14e-17	NR	XP_003383765.1	400682	g6939	i0	52.1	0.590296495956873	73	34	59	1	144	362	36	107	XP_003383765.1 PREDICTED: countin-3-like [Amphimedon queenslandica]	diamond	219	84	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28293705	28293705	PRJNA674048_P_NODE_17446_length_212_cov_2.963190_g17243_i0	PRJNA674048	17446	212	2.96319	6.2819628	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	108	1.8e-25	NR	XP_065837186.1	121494	g17243	i0	75.7	19.811320754717	70	17	99.1	0	1	210	399	468	XP_065837186.1 ATP synthase subunit alpha, mitochondrial-like [Oscarella lobularis]	diamond	4200	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28439892	28439892	PRJNA674048_P_NODE_26866_length_169_cov_1.375000_g26663_i0	PRJNA674048	26866	169	1.375	2.32375	Oscarella lobularis	121494	Porifera	other_Eukaryota	75.5	3.95e-14	NR	XP_065840369.1	121494	g26663	i0	58.2	2.89349112426035	55	23	97.6	0	169	5	764	818	XP_065840369.1 beta-galactosidase BoGH2A-like [Oscarella lobularis]	diamond	489	75.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28830447	28830447	PRJNA674048_P_NODE_30268_length_165_cov_0.896552_g30065_i0	PRJNA674048	30268	165	0.896552	1.4793108	Porifera	6040	Porifera	other_Eukaryota	89.4	4.96e-19	NR	XP_065827522.1	121494	g30065	i0	70.4	3.98181818181818	54	16	98.2	0	1	162	285	338	XP_065827522.1 copine-3-like [Oscarella lobularis]	diamond	657	89.7	0.996655518394649	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29702349	29702349	PRJNA674048_P_NODE_32510_length_162_cov_0.920354_g32307_i0	PRJNA674048	32510	162	0.920354	1.49097348	Oscarella lobularis	121494	Porifera	other_Eukaryota	76.3	1.78e-14	NR	XP_065840528.1	121494	g32307	i0	64.7	1.88888888888889	51	18	94.4	0	154	2	145	195	XP_065840528.1 uncharacterized protein [Oscarella lobularis]	diamond	306	76.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30587118	30587118	PRJNA674048_P_NODE_29333_length_166_cov_0.888889_g29130_i0	PRJNA674048	29333	166	0.888889	1.47555574	Geodia barretti	519541	Porifera	other_Eukaryota	52	6.85e-6	NR	CAI8012763.1	519541	g29130	i0	48	0.903614457831325	50	24	90.4	1	152	3	278	325	CAI8012763.1 hypothetical protein GBAR_LOCUS8158 [Geodia barretti]	diamond	150	52	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32199913	32199913	PRJNA674048_P_NODE_30358_length_165_cov_0.896552_g30155_i0	PRJNA674048	30358	165	0.896552	1.4793108	Corticium candelabrum	121492	Porifera	other_Eukaryota	65.1	1.74e-10	NR	XP_062510528.1	121492	g30155	i0	58	4.61818181818182	50	20	89.1	1	165	19	567	616	XP_062510528.1 uncharacterized protein LOC134186555 [Corticium candelabrum]	diamond	762	65.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32199914	32199914	PRJNA674048_P_NODE_31158_length_164_cov_0.904348_g30955_i0	PRJNA674048	31158	164	0.904348	1.48313072	Corticium candelabrum	121492	Porifera	other_Eukaryota	53.5	1.99e-6	NR	XP_062499001.1	121492	g30955	i0	61.8	1.24390243902439	34	13	62.2	0	9	110	1004	1037	XP_062499001.1 fibrillin-2-like [Corticium candelabrum]	diamond	204	53.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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