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

9 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
344508	344508	PRJNA1237347_P_NODE_514901_length_246_cov_0.890173_g508328_i0	PRJNA1237347	514901	246	0.890173	2.18982558	Dysidea avara	196820	Porifera	other_Eukaryota	52.8	0.022	NTclustered	gi\|2749505581\|ref\|XM_066057401.1\|	196820	g508328	i0	100	0.113821138211382	28	0	11	0	169	196	728	755	PREDICTED: Dysidea avara uncharacterized protein (LOC136262971), transcript variant X2, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
1620022	1620022	PRJNA1237347_P_NODE_559762_length_237_cov_30.554878_g553189_i0	PRJNA1237347	559762	237	30.554878	72.41506086	Chondrosia collectrix	1090546	Porifera	other_Eukaryota	191	4.3200000000000003e-44	NTclustered	gi\|512765402\|gb\|KC869640.1\|	1090546	g553189	i0	87.574	85.1097046413502	169	15	83	5	71	237	2956	2792	Chondrosia collectrix voucher P43 28S ribosomal RNA gene, partial sequence	blastn	20171	191	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Chondrillida	Chondrillidae	Chondrosia	Chondrosia collectrix
5446682	5446682	PRJNA1237347_P_NODE_442205_length_262_cov_1.629630_g435632_i0	PRJNA1237347	442205	262	1.62963	4.2696306	Sycon ciliatum	27933	Porifera	other_Eukaryota	65.8	3.07e-6	NTclustered	gi\|2732888590\|ref\|XM_065322792.1\|	27933	g435632	i0	93.478	13.5916030534351	46	0	17	3	141	184	764	808	PREDICTED: Sycon ciliatum Golgi apparatus protein 1-like (LOC135809439), mRNA	blastn	3561	65.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
6151361	6151361	PRJNA1237347_P_NODE_371145_length_292_cov_1.666667_g364572_i0	PRJNA1237347	371145	292	1.666667	4.86666764	Metazoa	33208	Porifera	other_Eukaryota	121	7.31e-23	NTclustered	gi\|2732896170\|ref\|XM_065319436.1\|	27933	g364572	i0	91.011	33.3424657534247	89	8	30	0	204	292	464	376	PREDICTED: Sycon ciliatum histone H3 (LOC135805408), mRNA	blastn	9736	121	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
9977694	9977694	PRJNA1237347_P_NODE_568868_length_204_cov_7.908397_g562294_i0	PRJNA1237347	568868	204	7.908397	16.13312988	Metazoa	33208	Porifera	other_Eukaryota	206	1.29e-48	NTclustered	gi\|512765218\|gb\|KC869456.1\|	1161177	g562294	i0	85.024	100.916666666667	207	25	100	6	1	204	3075	2872	Thrinacophora cervicornis voucher NCI418 28S ribosomal RNA gene, partial sequence	blastn	20587	206	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Axinellida	Raspailiidae	Thrinacophora	Thrinacophora cervicornis
15642373	15642373	PRJNA1237347_P_NODE_244213_length_380_cov_1.719870_g237640_i0	PRJNA1237347	244213	380	1.71987	6.535506	Tethya californiana	283519	Porifera	other_Eukaryota	316	1.16e-81	NTclustered	gi\|1818220375\|gb\|MT139598.1\|	283519	g237640	i0	82.258	97.2657894736842	372	61	97	4	10	377	528	898	Tethya californiana voucher CASIZ 235109 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	36961	316	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tethyida	Tethyidae	Tethya	Tethya californiana
15644141	15644141	PRJNA1237347_P_NODE_333593_length_312_cov_2.560669_g327020_i0	PRJNA1237347	333593	312	2.560669	7.98928728	Oscarella lobularis	121494	Porifera	other_Eukaryota	54.7	0.008	NTclustered	gi\|2746790406\|ref\|XM_065979274.1\|	121494	g327020	i0	96.97	0.195512820512821	33	0	11	1	161	193	769	800	PREDICTED: Oscarella lobularis neurofilament heavy polypeptide-like (LOC136190985), mRNA	blastn	61	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
20745687	20745687	PRJNA1237347_P_NODE_48937_length_1069_cov_4.940763_g44065_i0	PRJNA1237347	48937	1069	4.940763	52.81675647	Halichondria panicea	6063	Porifera	other_Eukaryota	54.7	0.03	NTclustered	gi\|2719044360\|ref\|XM_064530375.1\|	6063	g44065	i0	96.875	0.0299345182413471	32	1	3	0	1023	1054	842	811	PREDICTED: Halichondria panicea periodic tryptophan protein 1 homolog (LOC135334979), mRNA	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
21451472	21451472	PRJNA1237347_P_NODE_69697_length_858_cov_11.668790_g63907_i0	PRJNA1237347	69697	858	11.66879	100.1182182	Tethyida	1779163	Porifera	other_Eukaryota	124	1.81e-23	NTclustered	gi\|147931669\|gb\|AY626308.2\|	283613	g63907	i0	96.053	9.07808857808858	76	3	9	0	3	78	2375	2300	Axos cliftoni voucher G300111 28S large subunit ribosomal RNA gene, complete sequence	blastn	7789	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tethyida	Hemiasterellidae	Axos	Axos cliftoni

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