metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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
329201	329201	PRJNA1204310_P_NODE_37361_length_305_cov_1.008621_g37064_i0	PRJNA1204310	37361	305	1.008621	3.07629405	Haliclona caerulea	1131259	Porifera	other_Eukaryota	536	6.439999999999998e-148	NTclustered	gi\|2899163412\|gb\|PP464272.1\|	1131259	g37064	i0	98.361	1.90491803278689	305	5	100	0	1	305	16233	15929	Haliclona caerulea isolate H1810 mitochondrion, complete genome	blastn	581	536	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona caerulea
4156708	4156708	PRJNA1204310_P_NODE_60464_length_244_cov_0.912281_g60167_i0	PRJNA1204310	60464	244	0.912281	2.22596564	Haliclona caerulea	1131259	Porifera	other_Eukaryota	446	8.639999999999999e-121	NTclustered	gi\|2899163412\|gb\|PP464272.1\|	1131259	g60167	i0	99.59	3.50409836065574	244	1	100	0	1	244	6396	6639	Haliclona caerulea isolate H1810 mitochondrion, complete genome	blastn	855	446	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona caerulea
5432202	5432202	PRJNA1204310_P_NODE_27565_length_352_cov_1.985663_g27268_i0	PRJNA1204310	27565	352	1.985663	6.98953376	Oscarella lobularis	121494	Porifera	other_Eukaryota	84.2	1.18e-11	NTclustered	gi\|2746766111\|ref\|XM_065986994.1\|	121494	g27268	i0	77.397	1.07670454545455	146	29	41	3	7	150	408	265	PREDICTED: Oscarella lobularis serine/threonine-protein phosphatase 6 catalytic subunit-like (LOC136197263), mRNA	blastn	379	84.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
5432792	5432792	PRJNA1204310_P_NODE_53485_length_251_cov_0.876404_g53188_i0	PRJNA1204310	53485	251	0.876404	2.19977404	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	172	1.67e-38	NTclustered	gi\|1133479402\|ref\|XR_002187271.1\|	400682	g53188	i0	82.648	3.84860557768924	219	14	82	8	39	244	337	130	PREDICTED: Amphimedon queenslandica uncharacterized LOC109586889 (LOC109586889), ncRNA	blastn	966	172	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
7982820	7982820	PRJNA1204310_P_NODE_42407_length_285_cov_1.103774_g42110_i0	PRJNA1204310	42407	285	1.103774	3.1457559	Haliclona caerulea	1131259	Porifera	other_Eukaryota	527	3.59e-145	NTclustered	gi\|2899163412\|gb\|PP464272.1\|	1131259	g42110	i0	100	3.38947368421053	285	0	100	0	1	285	3134	3418	Haliclona caerulea isolate H1810 mitochondrion, complete genome	blastn	966	527	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona caerulea
11808126	11808126	PRJNA1204310_P_NODE_49950_length_256_cov_0.683060_g49653_i0	PRJNA1204310	49950	256	0.68306	1.7486336	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	243	1.2900000000000001e-59	NTclustered	gi\|76880593\|gb\|AC167702.2\|	400682	g49653	i0	84.109	12.76171875	258	34	100	5	1	256	4020	3768	Amphimedon queenslandica clone JGIBAYC-9C21, complete sequence	blastn	3267	243	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
13082169	13082169	PRJNA1204310_P_NODE_10931_length_531_cov_0.851528_g10636_i0	PRJNA1204310	10931	531	0.851528	4.52161368	Haliclona caerulea	1131259	Porifera	other_Eukaryota	976	0	NTclustered	gi\|2899163412\|gb\|PP464272.1\|	1131259	g10636	i0	99.812	3.00188323917137	531	1	100	0	1	531	7270	7800	Haliclona caerulea isolate H1810 mitochondrion, complete genome	blastn	1594	976	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona caerulea
13083300	13083300	PRJNA1204310_P_NODE_55991_length_248_cov_0.948571_g55694_i0	PRJNA1204310	55991	248	0.948571	2.35245608	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	159	1.28e-34	NTclustered	gi\|76880593\|gb\|AC167702.2\|	400682	g55694	i0	88.148	6.70967741935484	135	14	55	2	115	248	3362	3495	Amphimedon queenslandica clone JGIBAYC-9C21, complete sequence	blastn	1664	159	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
13083347	13083347	PRJNA1204310_P_NODE_58611_length_246_cov_0.901734_g58314_i0	PRJNA1204310	58611	246	0.901734	2.21826564	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	381	2.5e-101	NTclustered	gi\|1133458628\|ref\|XM_011404911.2\|	400682	g58314	i0	94.694	8.44715447154472	245	13	99	0	1	245	10203	10447	PREDICTED: Amphimedon queenslandica dynein heavy chain 5, axonemal-like (LOC100638042), mRNA	blastn	2078	381	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
15632475	15632475	PRJNA1204310_P_NODE_55373_length_249_cov_0.886364_g55076_i0	PRJNA1204310	55373	249	0.886364	2.20704636	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	104	6.13e-18	NTclustered	gi\|1133454268\|ref\|XM_019993536.1\|	400682	g55076	i0	98.305	0.236947791164659	59	1	24	0	191	249	212	270	PREDICTED: Amphimedon queenslandica tyrosine-protein kinase SRK2-like (LOC105316836), mRNA	blastn	59	104	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
16906862	16906862	PRJNA1204310_P_NODE_59374_length_245_cov_0.906977_g59077_i0	PRJNA1204310	59374	245	0.906977	2.22209365	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	130	9.93e-26	NTclustered	gi\|1133494445\|ref\|XM_020008067.1\|	400682	g59077	i0	79.581	0.779591836734694	191	31	75	5	1	184	830	641	PREDICTED: Amphimedon queenslandica uncharacterized LOC109592675 (LOC109592675), mRNA	blastn	191	130	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
18181115	18181115	PRJNA1204310_P_NODE_51135_length_253_cov_0.866667_g50838_i0	PRJNA1204310	51135	253	0.866667	2.19266751	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	87.9	6.29e-13	NTclustered	gi\|1133480812\|ref\|XM_011409096.2\|	400682	g50838	i0	86.25	0.316205533596838	80	11	32	0	1	80	319	240	PREDICTED: Amphimedon queenslandica transcription initiation factor IIA subunit 1-like (LOC105314744), mRNA	blastn	80	87.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
18181212	18181212	PRJNA1204310_P_NODE_55635_length_249_cov_0.886364_g55338_i0	PRJNA1204310	55635	249	0.886364	2.20704636	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	230	9.699999999999995e-56	NTclustered	gi\|1133454413\|ref\|XM_019993597.1\|	400682	g55338	i0	94.079	1.16064257028112	152	8	61	1	97	247	3312	3161	PREDICTED: Amphimedon queenslandica mucin-4-like (LOC100639475), mRNA	blastn	289	230	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
20731108	20731108	PRJNA1204310_P_NODE_55017_length_249_cov_0.886364_g54720_i0	PRJNA1204310	55017	249	0.886364	2.20704636	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	196	9.84e-46	NTclustered	gi\|761904516\|ref\|XM_011412034.1\|	400682	g54720	i0	83.262	3.23694779116466	233	20	86	3	36	249	587	355	PREDICTED: Amphimedon queenslandica ATP-dependent DNA helicase PIF1-like (LOC100638803), mRNA	blastn	806	196	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
22005987	22005987	PRJNA1204310_P_NODE_35558_length_313_cov_1.300000_g35261_i0	PRJNA1204310	35558	313	1.3	4.069	Haliclona caerulea	1131259	Porifera	other_Eukaryota	573	5.049999999999998e-159	NTclustered	gi\|2899163412\|gb\|PP464272.1\|	1131259	g35261	i0	99.681	3.03833865814696	313	1	100	0	1	313	18984	18672	Haliclona caerulea isolate H1810 mitochondrion, complete genome	blastn	951	573	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Chalinidae	Haliclona	Haliclona caerulea
23280853	23280853	PRJNA1204310_P_NODE_16419_length_441_cov_0.855978_g16122_i0	PRJNA1204310	16419	441	0.855978	3.77486298	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	499	1.27e-136	NTclustered	gi\|83582877\|gb\|AC167697.2\|	400682	g16122	i0	87.133	35.5510204081633	443	54	100	3	1	441	2671	2230	Amphimedon queenslandica clone JGIBAYC-5F12, complete sequence	blastn	15678	499	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
23281850	23281850	PRJNA1204310_P_NODE_60259_length_244_cov_0.912281_g59962_i0	PRJNA1204310	60259	244	0.912281	2.22596564	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	206	1.6e-48	NTclustered	gi\|1133460167\|ref\|XM_011405244.2\|	400682	g59962	i0	88.398	0.741803278688525	181	7	72	9	16	191	6676	6505	PREDICTED: Amphimedon queenslandica uncharacterized LOC100632830 (LOC100632830), mRNA	blastn	181	206	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica

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