metadata: contig_metadata: 7 rows where bioproject = "PRJNA1249535" and tax

7 rows where bioproject = "PRJNA1249535" and tax_phylum = "Nematomorpha"

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
6735731	6735731	PRJNA1249535_S_NODE_334406_length_230_cov_2.515924_g331023_i0	PRJNA1249535	334406	230	2.515924	5.7866252	Gordionus sp. m RMFG-2023	3053472	Nematomorpha	other_Eukaryota	54.7	0.006	NTclustered	gi\|2733951612\|ref\|XM_065460310.1\|	3053472	g331023	i0	90.476	0.182608695652174	42	2	18	2	178	218	3268	3308	PREDICTED: Gordionus sp. m RMFG-2023 26S proteasome non-ATPase regulatory subunit 2-like (LOC135925122), mRNA	blastn	42	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
18209045	18209045	PRJNA1249535_S_NODE_278795_length_264_cov_3.628272_g275412_i0	PRJNA1249535	278795	264	3.628272	9.57863808	Gordionus sp. m RMFG-2023	3053472	Nematomorpha	other_Eukaryota	52.8	0.024	NTclustered	gi\|2733959932\|ref\|XM_065464394.1\|	3053472	g275412	i0	96.774	0.117424242424242	31	1	12	0	45	75	219	189	PREDICTED: Gordionus sp. m RMFG-2023 protein KTI12 homolog (LOC135928063), mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
27958205	27958205	PRJNA1249535_S_NODE_7965_length_898_cov_16.706667_g5900_i0	PRJNA1249535	7965	898	16.706667	150.02586966	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	51.2	0.00377	NR	XP_065318822.1	3053472	g5900	i0	52.2	0.153674832962138	46	21	15	1	828	694	526	571	XP_065318822.1 uncharacterized protein LOC135926820 [Gordionus sp. m RMFG-2023]	diamond	138	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
28684532	28684532	PRJNA1249535_S_NODE_268527_length_270_cov_2.045685_g265144_i0	PRJNA1249535	268527	270	2.045685	5.5233495	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	47.8	8.45e-4	NR	XP_065317439.1	3053472	g265144	i0	44.8	1.95555555555556	58	32	64.4	0	206	33	113	170	XP_065317439.1 uncharacterized protein LOC135925845 [Gordionus sp. m RMFG-2023]	diamond	528	47.8	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
30516114	30516114	PRJNA1249535_S_NODE_85253_length_393_cov_4.715625_g81871_i0	PRJNA1249535	85253	393	4.715625	18.53240625	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	79.3	3.12e-14	NR	XP_065318822.1	3053472	g81871	i0	49.3	1.06870229007634	73	37	55.7	0	10	228	515	587	XP_065318822.1 uncharacterized protein LOC135926820 [Gordionus sp. m RMFG-2023]	diamond	420	79.3	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
31843568	31843568	PRJNA1249535_S_NODE_105137_length_369_cov_10.060811_g101754_i0	PRJNA1249535	105137	369	10.060811	37.12439259	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	46.6	0.00633	NR	XP_065316492.1	3053472	g101754	i0	49	0.796747967479675	49	25	39.8	0	325	179	330	378	XP_065316492.1 uncharacterized protein LOC135925202 [Gordionus sp. m RMFG-2023]	diamond	294	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023
32665808	32665808	PRJNA1249535_S_NODE_242480_length_284_cov_1.848341_g239097_i0	PRJNA1249535	242480	284	1.848341	5.24928844	Gordionus sp. m RMFG-2	3053472	Nematomorpha	other_Eukaryota	53.9	2.02e-6	NR	XP_065323797.1	3053472	g239097	i0	42.1	0.602112676056338	57	30	57	1	267	106	72	128	XP_065323797.1 CCHC-type zinc finger nucleic acid binding protein-like [Gordionus sp. m RMFG-2023]	diamond	171	53.9	1	Eukaryota	Opisthokonta	Metazoa	Nematomorpha	Gordioida	Chordodea	Parachordodidae	Gordionus	Gordionus sp. m RMFG-2023

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