metadata: contig_metadata: 5 rows where bioproject = "PRJNA385396", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA385396", 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
6784551	6784551	PRJNA385396_P_NODE_16406_length_247_cov_1.327586_g16314_i0	PRJNA385396	16406	247	1.327586	3.27913742	Corticium candelabrum	121492	Porifera	other_Eukaryota	118	4.33e-32	NR	XP_062508220.1	121492	g16314	i0	83.9	9.78947368421053	62	10	75.3	0	245	60	69	130	XP_062508220.1 small ribosomal subunit protein uS8 [Corticium candelabrum]	diamond	2418	118	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27201440	27201440	PRJNA385396_P_NODE_18402_length_245_cov_0.895349_g18310_i0	PRJNA385396	18402	245	0.895349	2.19360505	Dysidea avara	196820	Porifera	other_Eukaryota	56.2	6.78e-7	NR	XP_065906455.1	196820	g18310	i0	50	0.83265306122449	68	31	80.8	2	199	2	159	225	XP_065906455.1 DNA mismatch repair protein Msh2-like isoform X3 [Dysidea avara]	diamond	204	56.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27408383	27408383	PRJNA385396_P_NODE_4223_length_386_cov_1.476038_g4131_i0	PRJNA385396	4223	386	1.476038	5.69750668	Opisthokonta	33154	Porifera	other_Eukaryota	119	3.43e-30	NR	XP_062513658.1	121492	g4131	i0	50	3.76943005181347	124	58	94	2	386	24	130	252	XP_062513658.1 small ribosomal subunit protein eS1-like [Corticium candelabrum]	diamond	1455	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27864760	27864760	PRJNA385396_P_NODE_21525_length_241_cov_0.916667_g21433_i0	PRJNA385396	21525	241	0.916667	2.20916747	Geodia barretti	519541	Porifera	other_Eukaryota	100	3.42e-24	NR	CAI8052487.1	519541	g21433	i0	71.9	1.59336099585062	64	18	79.7	0	30	221	139	202	CAI8052487.1 Acylpyruvase FAHD1, mitochondrial [Geodia barretti]	diamond	384	100	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
29222788	29222788	PRJNA385396_P_NODE_18729_length_244_cov_0.900585_g18637_i0	PRJNA385396	18729	244	0.900585	2.1974274	Sycon ciliatum	27933	Porifera	other_Eukaryota	67.4	7.62e-11	NR	XP_065185423.1	27933	g18637	i0	43.8	0.983606557377049	80	41	98.4	1	3	242	588	663	XP_065185423.1 uncharacterized protein LOC135815995 [Sycon ciliatum]	diamond	240	67.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum

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