metadata: contig_metadata: 6 rows where bioproject = "PRJNA841653", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA841653", 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
7208832	7208832	PRJNA841653_P_NODE_4146_length_849_cov_2.331186_g3573_i0	PRJNA841653	4146	849	2.331186	19.79176914	Haliclona sp. BKON-2565	3127636	Porifera	other_Eukaryota	215	1.03e-50	NTclustered	gi\|2899163455\|gb\|PP464275.1\|	3127636	g3573	i0	77.957	29.9717314487633	372	63	43	12	478	839	1835	2197	Haliclona sp. BKON-2565 isolate H2565 mitochondrion, complete genome	blastn	25446	215	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona sp. BKON-2565
8483535	8483535	PRJNA841653_P_NODE_4707_length_793_cov_1.202778_g4112_i0	PRJNA841653	4707	793	1.202778	9.53802954	Opisthokonta	33154	Porifera	other_Eukaryota	302	2.3599999999999997e-99	NR	XP_064395651.1	6063	g4112	i0	59	12.9949558638083	244	100	92.3	0	3	734	48	291	XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea]	diamond	10305	302	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
16133737	16133737	PRJNA841653_P_NODE_6613_length_661_cov_14.880952_g5975_i0	PRJNA841653	6613	661	14.880952	98.36309272	Leucopsacus sp. BX12/6	472223	Porifera	other_Eukaryota	141	1.37e-28	NTclustered	gi\|190350210\|emb\|AM886365.1\|	472223	g5975	i0	87.097	18.8441754916793	124	16	19	0	153	276	590	713	Leucopsacus sp. BX12/6 partial 28S rRNA gene, isolated from Ireland	blastn	12456	141	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Leucopsacus	Leucopsacus sp. BX12/6
28160332	28160332	PRJNA841653_P_NODE_36505_length_272_cov_1.638191_g35831_i0	PRJNA841653	36505	272	1.638191	4.45587952	Corticium candelabrum	121492	Porifera	other_Eukaryota	58.9	7.11e-8	NR	XP_062508100.1	121492	g35831	i0	73.5	1.46691176470588	34	9	37.5	0	171	272	56	89	XP_062508100.1 ran-specific GTPase-activating protein-like [Corticium candelabrum]	diamond	399	58.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28223102	28223102	PRJNA841653_P_NODE_36306_length_273_cov_1.410000_g35632_i0	PRJNA841653	36306	273	1.41	3.8493	Halichondria panicea	6063	Porifera	other_Eukaryota	45.4	0.00534	NR	XP_064387443.1	6063	g35632	i0	36.7	1.37362637362637	60	38	65.9	0	241	62	211	270	XP_064387443.1 voltage-dependent anion-selective channel protein 2-like [Halichondria panicea]	diamond	375	45.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30054531	30054531	PRJNA841653_P_NODE_8491_length_580_cov_1.725838_g7827_i0	PRJNA841653	8491	580	1.725838	10.0098604	Geodia barretti	519541	Porifera	other_Eukaryota	117	1.49e-29	NR	CAI8030757.1	519541	g7827	i0	50.4	0.729310344827586	141	55	69.3	6	410	9	18	150	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	423	117	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti

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