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

8 rows where bioproject = "PRJDB9741", 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
1285183	1285183	PRJDB9741_P_NODE_22322_length_174_cov_1.624000_g22005_i0	PRJDB9741	22322	174	1.624	2.82576	Sycon ciliatum	27933	Porifera	other_Eukaryota	82.4	1.87e-11	NTclustered	gi\|2732926693\|ref\|XM_065330360.1\|	27933	g22005	i0	86.486	0.425287356321839	74	10	43	0	55	128	870	797	PREDICTED: Sycon ciliatum cathepsin B-like (LOC135817233), mRNA	blastn	74	82.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
16587714	16587714	PRJDB9741_P_NODE_15794_length_185_cov_1.514706_g15477_i0	PRJDB9741	15794	185	1.514706	2.8022061	Opisthokonta	33154	Porifera	other_Eukaryota	96.3	2.45e-22	NR	XP_003387052.1	400682	g15477	i0	79.3	3.76216216216216	58	12	94.1	0	176	3	58	115	XP_003387052.1 PREDICTED: 60S ribosomal protein L7a-like [Amphimedon queenslandica]	diamond	696	96.7	0.995863495346432	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
21687664	21687664	PRJDB9741_P_NODE_6658_length_243_cov_1.489691_g6341_i0	PRJDB9741	6658	243	1.489691	3.61994913	Metazoa	33208	Porifera	other_Eukaryota	118	1.9199999999999999e-31	NR	XP_062517332.1	121492	g6341	i0	71.1	30.1111111111111	76	22	93.8	0	12	239	68	143	XP_062517332.1 large ribosomal subunit protein uL22-like [Corticium candelabrum]	diamond	7317	119	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27784934	27784934	PRJDB9741_P_NODE_15604_length_185_cov_2.669118_g15287_i0	PRJDB9741	15604	185	2.669118	4.9378683	root	1	Root_unresolved	Root_unresolved	41.6	0.0218	NR	KAI6646665.1	111878	g15287	i0	48	1.47567567567568	50	24	81.1	1	181	32	77	124	KAI6646665.1 40S ribosomal protein S30 [Oopsacas minuta]	diamond	273	41.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
28358877	28358877	PRJDB9741_P_NODE_3026_length_403_cov_1.827684_g2711_i0	PRJDB9741	3026	403	1.827684	7.36556652	Geodia barretti	519541	Porifera	other_Eukaryota	119	4.89e-31	NR	CAI8030757.1	519541	g2711	i0	48.9	1.01985111662531	137	57	98.3	4	398	3	37	165	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	411	119	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
29243139	29243139	PRJDB9741_P_NODE_29489_length_166_cov_1.017094_g29172_i0	PRJDB9741	29489	166	1.017094	1.68837604	Sycon ciliatum	27933	Porifera	other_Eukaryota	83.2	6.39e-17	NR	XP_065183916.1	27933	g29172	i0	61.1	0.975903614457831	54	21	97.6	0	164	3	265	318	XP_065183916.1 coronin-2B-like [Sycon ciliatum]	diamond	162	83.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31454668	31454668	PRJDB9741_P_NODE_5816_length_261_cov_1.339623_g5500_i0	PRJDB9741	5816	261	1.339623	3.49641603	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	83.6	8.59e-18	NR	XP_003384590.1	400682	g5500	i0	45.3	0.988505747126437	86	47	98.9	0	3	260	18	103	XP_003384590.1 PREDICTED: tubulin polymerization-promoting protein family member 2-like [Amphimedon queenslandica]	diamond	258	83.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31986242	31986242	PRJDB9741_P_NODE_22538_length_174_cov_1.280000_g22221_i0	PRJDB9741	22538	174	1.28	2.2272	root	1	Root_unresolved	Root_unresolved	43.9	0.00438	NR	XP_065898438.1	196820	g22221	i0	41.8	2.68965517241379	55	32	94.8	0	9	173	69	123	XP_065898438.1 uncharacterized protein [Dysidea avara]	diamond	468	43.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara

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