metadata: contig_metadata: 3 rows where bioproject = "PRJNA610520", tax_kingdom = "Metazoa" and tax

3 rows where bioproject = "PRJNA610520", tax_kingdom = "Metazoa" 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
27648911	27648911	PRJNA610520_S_NODE_14344_length_388_cov_2.895238_g14254_i0	PRJNA610520	14344	388	2.895238	11.23352344	Corticium candelabrum	121492	Porifera	other_Eukaryota	58.2	1.27e-7	NR	XP_062503112.1	121492	g14254	i0	39.5	0.664948453608247	86	49	64.2	2	384	136	63	148	XP_062503112.1 uncharacterized protein LOC134180053 [Corticium candelabrum]	diamond	258	58.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28848408	28848408	PRJNA610520_S_NODE_58028_length_256_cov_2.103825_g57938_i0	PRJNA610520	58028	256	2.103825	5.385792	Halichondria panicea	6063	Porifera	other_Eukaryota	73.6	1.69e-14	NR	XP_064391039.1	6063	g57938	i0	56.5	0.7265625	62	26	71.5	1	253	71	62	123	XP_064391039.1 NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 6-like [Halichondria panicea]	diamond	186	73.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30440939	30440939	PRJNA610520_S_NODE_46153_length_280_cov_3.487923_g46063_i0	PRJNA610520	46153	280	3.487923	9.7661844	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.5	2.34e-22	NR	XP_065183319.1	27933	g46063	i0	76.4	3.525	55	13	58.9	0	280	116	126	180	XP_065183319.1 60S ribosome subunit biogenesis protein NIP7 homolog [Sycon ciliatum]	diamond	987	96.3	0.991692627206646	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);;