metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA756891" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA756891" and tax_phylum = "Discosea"

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
2008042	2008042	PRJNA756891_P_NODE_3702_length_436_cov_2.961433_g3633_i0	PRJNA756891	3702	436	2.961433	12.91184788	Ripella sp. 805	1217113	Discosea	other_Eukaryota	686	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g3633	i0	95.205	101.252293577982	438	14	100	7	1	436	543	111	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	44146	686	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
4560430	4560430	PRJNA756891_P_NODE_2784_length_503_cov_1.272093_g2716_i0	PRJNA756891	2784	503	1.272093	6.39862779	Ripella tribonemae	2047823	Discosea	other_Eukaryota	736	0	NTclustered	gi\|1269228457\|gb\|MF683582.1\|	2047823	g2716	i0	93.124	100.455268389662	509	23	99	10	2	503	1651	1148	Ripella tribonemae clone 70.1.17 18S ribosomal RNA gene, partial sequence	blastn	50529	736	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella tribonemae
10936045	10936045	PRJNA756891_P_NODE_12629_length_250_cov_0.870056_g12560_i0	PRJNA756891	12629	250	0.870056	2.17514	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	110	1.32e-19	NTclustered	gi\|470517203\|ref\|XM_004353125.1\|	1257118	g12560	i0	95.588	4.444	68	3	27	0	92	159	1404	1337	Acanthamoeba castellanii str. Neff alanineglyoxylate aminotransferase (ACA1_072820), partial mRNA	blastn	1111	110	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
12681945	12681945	PRJNA756891_P_NODE_16730_length_235_cov_13.722222_g16661_i0	PRJNA756891	16730	235	13.722222	32.2472217	Vannella	95228	Discosea	other_Eukaryota	407	3.9e-109	NTclustered	gi\|399764213\|gb\|JQ271724.1\|	1215628	g16661	i0	97.872	88.0595744680851	235	5	100	0	1	235	374	140	Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence	blastn	20694	407	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. ACN1
14760970	14760970	PRJNA756891_P_NODE_5752_length_354_cov_2.167260_g5683_i0	PRJNA756891	5752	354	2.16726	7.6721004	Platyamoeba placida	3454475	Discosea	other_Eukaryota	477	4.6599999999999996e-130	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g5683	i0	90.96	102.124293785311	354	32	100	0	1	354	828	475	Platyamoeba placida actin mRNA, partial cds	blastn	36152	477	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida
14760986	14760986	PRJNA756891_P_NODE_8272_length_302_cov_1.310044_g8203_i0	PRJNA756891	8272	302	1.310044	3.95633288	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	171	7.44e-38	NTclustered	gi\|470529917\|ref\|XM_004368096.1\|	1257118	g8203	i0	85.03	54.0496688741722	167	25	55	0	135	301	121	287	Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA	blastn	16323	171	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
16505179	16505179	PRJNA756891_P_NODE_3233_length_464_cov_2.598465_g3165_i0	PRJNA756891	3233	464	2.598465	12.0568776	Ripella	1217112	Discosea	other_Eukaryota	697	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g3165	i0	93.991	101.551724137931	466	18	100	7	1	464	571	1028	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	47120	697	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
16505183	16505183	PRJNA756891_P_NODE_6053_length_346_cov_5.912088_g5984_i0	PRJNA756891	6053	346	5.912088	20.45582448	Vannella	95228	Discosea	other_Eukaryota	606	5.57e-169	NTclustered	gi\|399764213\|gb\|JQ271724.1\|	1215628	g5984	i0	98.266	77.7890173410405	346	6	100	0	1	346	1900	1555	Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence	blastn	26915	608	0.996710526315789	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. ACN1
17310109	17310109	PRJNA756891_P_NODE_15154_length_244_cov_0.900585_g15085_i0	PRJNA756891	15154	244	0.900585	2.1974274	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	111	3.58e-20	NTclustered	gi\|470458975\|ref\|XM_004341257.1\|	1257118	g15085	i0	88.421	1.40983606557377	95	8	39	3	19	112	2104	2196	Acanthamoeba castellanii str. Neff calponin domain containing protein (ACA1_263900), partial mRNA	blastn	344	111	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
23685060	23685060	PRJNA756891_P_NODE_7619_length_313_cov_1.670833_g7550_i0	PRJNA756891	7619	313	1.670833	5.22970729	Platyamoeba placida	3454475	Discosea	other_Eukaryota	427	4.16e-115	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g7550	i0	91.346	99.0830670926518	312	27	99	0	1	312	1156	845	Platyamoeba placida actin mRNA, partial cds	blastn	31013	427	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida

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