metadata: contig_metadata: 10 rows where bioproject = "PRJNA1123309", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA1123309", 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
1552890	1552890	PRJNA1123309_P_NODE_36642_length_279_cov_1.126214_g36262_i0	PRJNA1123309	36642	279	1.126214	3.14213706	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	111	1.47e-28	NR	XP_065830102.1	121494	g36262	i0	71.8	20.010752688172	71	18	76.3	1	215	3	1	69	XP_065830102.1 ADP-ribosylation factor 4-like [Oscarella lobularis]	diamond	5583	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
24504059	24504059	PRJNA1123309_P_NODE_18980_length_361_cov_1.826389_g18601_i0	PRJNA1123309	18980	361	1.826389	6.59326429	Corticium candelabrum	121492	Porifera	other_Eukaryota	140	6.14e-39	NR	XP_062511913.1	121492	g18601	i0	94.4	8.90858725761773	71	4	59	0	213	1	1	71	XP_062511913.1 ras-related protein Rab-11A-like [Corticium candelabrum]	diamond	3216	140	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28333459	28333459	PRJNA1123309_P_NODE_51786_length_250_cov_1.525424_g51406_i0	PRJNA1123309	51786	250	1.525424	3.81356	Corticium candelabrum	121492	Porifera	other_Eukaryota	47	0.0013	NR	XP_062508855.1	121492	g51406	i0	38.2	1.176	68	30	81.6	1	241	38	74	129	XP_062508855.1 uncharacterized protein LOC134185084 isoform X2 [Corticium candelabrum]	diamond	294	47	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
29091417	29091417	PRJNA1123309_P_NODE_57108_length_247_cov_0.896552_g56728_i0	PRJNA1123309	57108	247	0.896552	2.21448344	Sycon ciliatum	27933	Porifera	other_Eukaryota	60.1	3.17e-8	NR	XP_065195124.1	27933	g56728	i0	41.9	3.8502024291498	62	36	75.3	0	13	198	893	954	XP_065195124.1 deleted in malignant brain tumors 1 protein-like [Sycon ciliatum]	diamond	951	60.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29459034	29459034	PRJNA1123309_P_NODE_6890_length_565_cov_2.264228_g6530_i0	PRJNA1123309	6890	565	2.264228	12.7928882	root	1	Root_unresolved	Root_unresolved	82.8	1.06e-14	NR	KAI6646112.1	111878	g6530	i0	32.1	2.98407079646018	187	117	97.2	5	11	559	318	498	KAI6646112.1 hypothetical protein LOD99_9463 [Oopsacas minuta]	diamond	1686	82.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30418107	30418107	PRJNA1123309_P_NODE_11093_length_455_cov_2.905759_g10717_i0	PRJNA1123309	11093	455	2.905759	13.22120345	Geodia barretti	519541	Porifera	other_Eukaryota	125	3.62e-33	NR	CAI8030757.1	519541	g10717	i0	50	0.989010989010989	150	60	94.3	6	27	455	18	159	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	450	125	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30533255	30533255	PRJNA1123309_P_NODE_31513_length_291_cov_2.463303_g31133_i0	PRJNA1123309	31513	291	2.463303	7.16821173	Metazoa	33208	Porifera	other_Eukaryota	55.8	1.72e-6	NR	XP_064381805.1	6063	g31133	i0	46.2	2.15463917525773	65	35	67	0	276	82	253	317	XP_064381805.1 sperm-associated antigen 1-like [Halichondria panicea]	diamond	627	55.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30638762	30638762	PRJNA1123309_P_NODE_29013_length_301_cov_3.043860_g28633_i0	PRJNA1123309	29013	301	3.04386	9.1620186	Corticium candelabrum	121492	Porifera	other_Eukaryota	116	1.19e-30	NR	XP_062523249.1	121492	g28633	i0	59.8	5.18272425249169	92	35	90.7	2	23	295	8	98	XP_062523249.1 peroxiredoxin-5, mitochondrial-like [Corticium candelabrum]	diamond	1560	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31112650	31112650	PRJNA1123309_P_NODE_54535_length_249_cov_0.886364_g54155_i0	PRJNA1123309	54535	249	0.886364	2.20704636	Sycon ciliatum	27933	Porifera	other_Eukaryota	51.6	3.07e-5	NR	XP_065178488.1	27933	g54155	i0	40.9	0.795180722891566	66	35	79.5	1	5	202	1082	1143	XP_065178488.1 E3 ubiquitin-protein ligase TRIP12-like isoform X11 [Sycon ciliatum]	diamond	198	51.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32209121	32209121	PRJNA1123309_P_NODE_53138_length_250_cov_0.875706_g52758_i0	PRJNA1123309	53138	250	0.875706	2.189265	root	1	Root_unresolved	Root_unresolved	105	2.34e-24	NR	XP_064406980.1	6063	g52758	i0	49.4	11.496	79	40	94.8	0	237	1	106	184	XP_064406980.1 alpha-glucosidase 2-like [Halichondria panicea]	diamond	2874	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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