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

9 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax_phylum = "Platyhelminthes"

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
2071929	2071929	PRJNA800053_P_NODE_11722_length_289_cov_3.324074_g11558_i0	PRJNA800053	11722	289	3.324074	9.60657386	Gyrodactylus salaris	37629	Platyhelminthes	Platyhelminthes	167	9.16e-37	NTclustered	gi\|12711312\|emb\|AJ276032.1\|	37629	g11558	i0	77.509	2	289	55	97	9	9	289	2275	2561	Gyrodactylus salaris ribosomal RNA IGS (2619 bp)	blastn	578	167	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus salaris
2495459	2495459	PRJNA800053_P_NODE_1742_length_630_cov_1.903052_g1589_i0	PRJNA800053	1742	630	1.903052	11.9892276	Gyrodactylus	37846	Platyhelminthes	Platyhelminthes	1147	0	NTclustered	gi\|1941833495\|gb\|MW353802.1\|	2907319	g1589	i0	99.524	98.9619047619048	630	3	100	0	1	630	1032	403	Gyrodactylus banmae internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence	blastn	62346	1147	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus banmae
9724240	9724240	PRJNA800053_P_NODE_12768_length_281_cov_1.480769_g12604_i0	PRJNA800053	12768	281	1.480769	4.16096089	Gyrodactylus salaris	37629	Platyhelminthes	Platyhelminthes	278	3.9300000000000005e-70	NTclustered	gi\|254031904\|gb\|FJ972055.1\|	37629	g12604	i0	84.615	63.2135231316726	273	40	97	2	10	281	304	33	Gyrodactylus salaris elongation factor 1 alpha gene, partial cds	blastn	17763	278	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus salaris
11000156	11000156	PRJNA800053_P_NODE_4709_length_415_cov_86.111111_g4546_i0	PRJNA800053	4709	415	86.111111	357.36111065	Gyrodactylus salaris	37629	Platyhelminthes	Platyhelminthes	704	0	NTclustered	gi\|44885231\|emb\|AJ542394.1\|	37629	g4546	i0	97.122	86.4626506024096	417	10	100	2	1	415	3183	2767	Gyrodactylus salaris 28S rRNA gene	blastn	35882	704	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus salaris
16098798	16098798	PRJNA800053_P_NODE_3393_length_479_cov_141.401478_g3230_i0	PRJNA800053	3393	479	141.401478	677.31307962	Gyrodactylus sp. h XJ-2022	2993691	Platyhelminthes	Platyhelminthes	880	0	NTclustered	gi\|2326463201\|gb\|OP793860.1\|	2993691	g3230	i0	99.791	82.0897703549061	479	1	100	0	1	479	132	610	Gyrodactylus sp. h XJ-2022 isolate JX202202-4 small subunit ribosomal RNA gene, partial sequence	blastn	39321	880	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus sp. h XJ-2022
17797512	17797512	PRJNA800053_P_NODE_8614_length_326_cov_21.411067_g8450_i0	PRJNA800053	8614	326	21.411067	69.80007842	Gyrodactylus	37846	Platyhelminthes	Platyhelminthes	592	1.4599999999999996e-164	NTclustered	gi\|40994727\|emb\|AJ566375.1\|	147591	g8450	i0	99.387	95.1472392638037	326	2	100	0	1	326	381	56	Gyrodactylus gobiensis 18S rRNA gene	blastn	31018	592	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus gobiensis
19923063	19923063	PRJNA800053_P_NODE_3696_length_461_cov_239.479381_g3533_i0	PRJNA800053	3696	461	239.479381	1103.99994641	Gyrodactylus salaris	37629	Platyhelminthes	Platyhelminthes	795	0	NTclustered	gi\|44885231\|emb\|AJ542394.1\|	37629	g3533	i0	97.821	35.1453362255965	459	10	99	0	3	461	3818	3360	Gyrodactylus salaris 28S rRNA gene	blastn	16202	798	0.996240601503759	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus salaris
21621955	21621955	PRJNA800053_P_NODE_15377_length_263_cov_1.247368_g15213_i0	PRJNA800053	15377	263	1.247368	3.28057784	Gyrodactylus	37846	Platyhelminthes	Platyhelminthes	398	2.6799999999999995e-106	NTclustered	gi\|1607200663\|ref\|NC_041379.1\|	83195	g15213	i0	93.939	13.3231939163498	264	14	100	2	1	263	9703	9441	Gyrodactylus gurleyi mitochondrion, complete genome	blastn	3504	398	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus gurleyi
25022864	25022864	PRJNA800053_P_NODE_25260_length_202_cov_237.914729_g25096_i0	PRJNA800053	25260	202	237.914729	480.58775258	Gyrodactylus sp. h XJ-2022	2993691	Platyhelminthes	Platyhelminthes	374	3.3e-99	NTclustered	gi\|2326463201\|gb\|OP793860.1\|	2993691	g25096	i0	100	100.173267326733	202	0	100	0	1	202	905	1106	Gyrodactylus sp. h XJ-2022 isolate JX202202-4 small subunit ribosomal RNA gene, partial sequence	blastn	20235	374	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Gyrodactylidea	Gyrodactylidae	Gyrodactylus	Gyrodactylus sp. h XJ-2022

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