metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
3984240	3984240	PRJNA1011844_P_NODE_79544_length_402_cov_3.212766_g71027_i0	PRJNA1011844	79544	402	3.212766	12.91531932	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	54.7	0.011	NTclustered	gi\|1133470922\|ref\|XM_019999823.1\|	400682	g71027	i0	100	0.0721393034825871	29	0	7	0	356	384	2152	2180	PREDICTED: Amphimedon queenslandica tyrosine-protein kinase Abl-like (LOC109584185), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
7808198	7808198	PRJNA1011844_P_NODE_100187_length_326_cov_5.237154_g91617_i0	PRJNA1011844	100187	326	5.237154	17.07312204	Oscarella lobularis	121494	Porifera	other_Eukaryota	58.4	6.59e-4	NTclustered	gi\|2746782349\|ref\|XM_065975165.1\|	121494	g91617	i0	100	1.25153374233129	31	0	10	0	72	102	6620	6590	PREDICTED: Oscarella lobularis helicase domino-like (LOC136187541), transcript variant X3, mRNA	blastn	408	58.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
13755326	13755326	PRJNA1011844_P_NODE_147951_length_249_cov_9.863636_g139372_i0	PRJNA1011844	147951	249	9.863636	24.56045364	Lyssacinosida	60884	Porifera	other_Eukaryota	84.2	7.99e-12	NTclustered	gi\|190350203\|emb\|AM886358.1\|	472226	g139372	i0	78.723	29.8674698795181	141	19	54	7	6	140	321	186	Bathydorus spinosus partial 28S rRNA gene, isolated from Antarctica	blastn	7437	84.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Rossellidae	Bathydorus	Bathydorus spinosus
13755487	13755487	PRJNA1011844_P_NODE_173851_length_219_cov_4.267123_g165270_i0	PRJNA1011844	173851	219	4.267123	9.34499937	Metazoa	33208	Porifera	other_Eukaryota	80.5	8.89e-11	NTclustered	gi\|254808918\|gb\|FJ670591.1\|	76786	g165270	i0	85	21.8493150684932	80	11	37	1	131	210	253	331	Cliona viridis haplotype C21 cytochrome oxidase subunit I (cox1) gene, partial cds; mitochondrial	blastn	4785	80.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Clionaida	Clionaidae	Cliona	Cliona viridis
14186333	14186333	PRJNA1011844_P_NODE_78852_length_405_cov_3.819277_g70339_i0	PRJNA1011844	78852	405	3.819277	15.46807185	Sycon ciliatum	27933	Porifera	other_Eukaryota	52.8	0.039	NTclustered	gi\|2732916010\|ref\|XM_065324795.1\|	27933	g70339	i0	100	0.0691358024691358	28	0	7	0	175	202	3301	3274	PREDICTED: Sycon ciliatum uncharacterized LOC135811566 (LOC135811566), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
18007981	18007981	PRJNA1011844_P_NODE_145055_length_251_cov_8.320225_g136476_i0	PRJNA1011844	145055	251	8.320225	20.88376475	Ascaltis sp. OV-2012	1169944	Porifera	other_Eukaryota	102	2.23e-17	NTclustered	gi\|385158749\|gb\|JQ272287.1\|	1169944	g136476	i0	81.538	47.1235059760956	130	18	51	6	102	229	2679	2554	Ascaltis sp. OV-2012 voucher QM G313824 28S ribosomal RNA gene, partial sequence	blastn	11828	102	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Leucascidae	Ascaltis	Ascaltis sp. OV-2012
22678938	22678938	PRJNA1011844_P_NODE_32998_length_892_cov_6.445665_g25914_i0	PRJNA1011844	32998	892	6.445665	57.4953318	root	1	Root_unresolved	Root_unresolved	69.4	8.94e-7	NTclustered	gi\|2732914321\|ref\|XM_065324004.1\|	27933	g25914	i0	95.349	4.31838565022422	43	2	5	0	488	530	311	353	PREDICTED: Sycon ciliatum putative uncharacterized protein DDB_G0271606 (LOC135810513), partial mRNA	blastn	3852	69.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
23108134	23108134	PRJNA1011844_P_NODE_115039_length_291_cov_3.770642_g106463_i0	PRJNA1011844	115039	291	3.770642	10.97256822	Sycon ciliatum	27933	Porifera	other_Eukaryota	52.8	0.027	NTclustered	gi\|2732930227\|ref\|XM_065332160.1\|	27933	g106463	i0	100	0.0962199312714777	28	0	10	0	186	213	811	784	PREDICTED: Sycon ciliatum mucin-2-like (LOC135819008), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
23954526	23954526	PRJNA1011844_P_NODE_48219_length_647_cov_9.432056_g40013_i0	PRJNA1011844	48219	647	9.432056	61.02540232	Opisthokonta	33154	Porifera	other_Eukaryota	58.4	0.001	NTclustered	gi\|2746788916\|ref\|XM_065978525.1\|	121494	g40013	i0	94.595	0.420401854714065	37	2	6	0	559	595	1313	1349	PREDICTED: Oscarella lobularis uncharacterized protein (LOC136190389), transcript variant X1, mRNA	blastn	272	58.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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