metadata: contig_metadata: 10 rows where bioproject = "PRJNA1160211" and tax

10 rows where bioproject = "PRJNA1160211" 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
4136775	4136775	PRJNA1160211_S_NODE_231884_length_278_cov_1.404878_g230651_i0	PRJNA1160211	231884	278	1.404878	3.90556084	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	119	2.3699999999999998e-32	NR	XP_011409769.1	400682	g230651	i0	67.4	2.9136690647482	92	30	99.3	0	277	2	21	112	XP_011409769.1 PREDICTED: 40S ribosomal protein S24-like [Amphimedon queenslandica]	diamond	810	119	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
10513818	10513818	PRJNA1160211_S_NODE_260289_length_253_cov_9.150000_g259056_i0	PRJNA1160211	260289	253	9.15	23.1495	uncultured Plakinidae sp.	417971	Porifera	other_Eukaryota	322	1.58e-83	NTclustered	gi\|166083713\|gb\|EF024236.1\|	417971	g259056	i0	91.176	29.6284584980237	238	19	93	2	1	236	602	839	Uncultured Plakinidae sp. clone Elev_18S_603 18S ribosomal RNA gene, partial sequence	blastn	7496	322	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae		uncultured Plakinidae sp.
13063933	13063933	PRJNA1160211_S_NODE_295331_length_221_cov_4.939189_g294098_i0	PRJNA1160211	295331	221	4.939189	10.91560769	Corticium candelabrum	121492	Porifera	other_Eukaryota	52.8	0.02	NTclustered	gi\|2664319586\|ref\|XM_062648256.1\|	121492	g294098	i0	100	0.506787330316742	28	0	13	0	144	171	2326	2299	PREDICTED: Corticium candelabrum uncharacterized LOC134181057 (LOC134181057), mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
17616360	17616360	PRJNA1160211_S_NODE_246774_length_264_cov_5.738220_g245541_i0	PRJNA1160211	246774	264	5.73822	15.1489008	Poecilosclerida	27925	Porifera	other_Eukaryota	187	6.34e-43	NTclustered	gi\|1937049806\|gb\|MW291468.1\|	1035643	g245541	i0	89.726	56.2083333333333	146	15	55	0	19	164	2190	2045	Tsitsikamma favus voucher TIC2018-003D internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	14839	187	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Poecilosclerida	Latrunculiidae	Tsitsikamma	Tsitsikamma favus
18161268	18161268	PRJNA1160211_S_NODE_194675_length_317_cov_1.577869_g193442_i0	PRJNA1160211	194675	317	1.577869	5.00184473	Ptilocaulis spiculifer	798311	Porifera	other_Eukaryota	95.3	4.86e-15	NTclustered	gi\|512765322\|gb\|KC869560.1\|	798311	g193442	i0	82.203	37.7318611987382	118	14	37	7	133	248	1227	1339	Ptilocaulis spiculifer voucher NCI205 28S ribosomal RNA gene, partial sequence	blastn	11961	95.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Axinellida	Axinellidae	Ptilocaulis	Ptilocaulis spiculifer
27388278	27388278	PRJNA1160211_S_NODE_274643_length_245_cov_1.790698_g273410_i0	PRJNA1160211	274643	245	1.790698	4.3872101	Oscarella lobularis	121494	Porifera	other_Eukaryota	47.4	8.84e-4	NR	XP_065846603.1	121494	g273410	i0	39.2	1.95918367346939	79	46	96.7	1	237	1	162	238	XP_065846603.1 protein F37C4.5-like [Oscarella lobularis]	diamond	480	47.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28051135	28051135	PRJNA1160211_S_NODE_39345_length_612_cov_4.948052_g38209_i0	PRJNA1160211	39345	612	4.948052	30.28207824	Halichondria panicea	6063	Porifera	other_Eukaryota	53.1	2.27e-4	NR	XP_064383978.1	6063	g38209	i0	30.9	0.46078431372549	94	61	46.1	2	225	506	16	105	XP_064383978.1 TNF receptor-associated factor 5-like [Halichondria panicea]	diamond	282	53.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30134879	30134879	PRJNA1160211_S_NODE_32152_length_642_cov_3.022847_g31046_i0	PRJNA1160211	32152	642	3.022847	19.40667774	Oopsacas minuta	111878	Porifera	other_Eukaryota	124	1.78e-29	NR	KAI6646008.1	111878	g31046	i0	32	1.90654205607477	200	117	85.5	3	5	553	210	407	KAI6646008.1 hypothetical protein LOD99_13261 [Oopsacas minuta]	diamond	1224	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30754878	30754878	PRJNA1160211_S_NODE_138874_length_391_cov_3.352201_g137641_i0	PRJNA1160211	138874	391	3.352201	13.10710591	Metazoa	33208	Porifera	other_Eukaryota	73.2	1.77e-12	NR	XP_065915441.1	196820	g137641	i0	75.6	1.88746803069054	41	10	31.5	0	164	286	202	242	XP_065915441.1 proteasome subunit beta type-5-like [Dysidea avara]	diamond	738	73.9	0.990527740189445	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32475023	32475023	PRJNA1160211_S_NODE_217299_length_292_cov_2.397260_g216066_i0	PRJNA1160211	217299	292	2.39726	6.9999992	Geodia barretti	519541	Porifera	other_Eukaryota	53.9	3e-6	NR	CAI8030757.1	519541	g216066	i0	40	2.3527397260274	65	37	66.8	1	282	88	110	172	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	687	53.9	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);;