metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8700088	8700088	PRJNA1227535_P_NODE_5327_length_322_cov_1.184739_g5204_i0	PRJNA1227535	5327	322	1.184739	3.81485958	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	259	1.66e-64	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g5204	i0	96.226	2.1055900621118	159	4	49	1	1	157	2924	3082	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	678	259	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
11814006	11814006	PRJNA1227535_P_NODE_27930_length_245_cov_1.813953_g27806_i0	PRJNA1227535	27930	245	1.813953	4.44418485	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	372	1.49e-98	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g27806	i0	93.927	39.4040816326531	247	13	100	1	1	245	116085	116331	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	9654	372	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20173283	20173283	PRJNA1227535_P_NODE_2496_length_432_cov_2.835655_g2374_i0	PRJNA1227535	2496	432	2.835655	12.2500296	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	702	0	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g2374	i0	96.056	71.4722222222222	431	17	99	0	1	431	55	485	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	30876	702	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
22012055	22012055	PRJNA1227535_P_NODE_25098_length_249_cov_0.886364_g24974_i0	PRJNA1227535	25098	249	0.886364	2.20704636	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	351	1.98e-92	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g24974	i0	92.683	36.9076305220884	246	15	100	3	1	245	96675	96432	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	9190	351	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
23287785	23287785	PRJNA1227535_P_NODE_6359_length_312_cov_3.430962_g6236_i0	PRJNA1227535	6359	312	3.430962	10.70460144	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.029	NTclustered	gi\|145479822\|ref\|XM_001425897.1\|	5888	g6236	i0	100	0.0897435897435897	28	0	9	0	278	305	473	446	Paramecium tetraurelia uncharacterized protein (GSPATT00004909001), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia

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