metadata: contig_metadata: 14 rows where bioproject = "PRJNA1263632" and tax

14 rows where bioproject = "PRJNA1263632" 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
5466964	5466964	PRJNA1263632_P_NODE_1905_length_438_cov_7.073973_g1887_i0	PRJNA1263632	1905	438	7.073973	30.98400174	Ripella sp. 805	1217113	Discosea	other_Eukaryota	695	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g1887	i0	95.434	101.719178082192	438	16	100	2	1	438	998	565	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	44553	695	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
14392786	14392786	PRJNA1263632_P_NODE_1272_length_531_cov_1.351528_g1254_i0	PRJNA1263632	1272	531	1.351528	7.17661368	Vannella persistens	303303	Discosea	other_Eukaryota	948	0	NTclustered	gi\|165968548\|gb\|EU377588.1\|	303303	g1254	i0	98.87	90.6139359698682	531	6	100	0	1	531	559	29	Vannella persistens strain CRIB69 18S ribosomal RNA gene, partial sequence	blastn	48116	948	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella persistens
15666627	15666627	PRJNA1263632_P_NODE_4873_length_285_cov_1.872642_g4855_i0	PRJNA1263632	4873	285	1.872642	5.3370297	Thecamoeba similis	242545	Discosea	other_Eukaryota	322	1.82e-83	NTclustered	gi\|33946350\|gb\|AY294154.1\|	242545	g4855	i0	88.39	83.8771929824561	267	31	94	0	19	285	25	291	Thecamoeba similis actin mRNA, complete cds	blastn	23905	322	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Thecamoebida	Thecamoeba	Thecamoeba similis
15666678	15666678	PRJNA1263632_P_NODE_6473_length_251_cov_0.865169_g6455_i0	PRJNA1263632	6473	251	0.865169	2.17157419	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	130	4.88e-35	NR	XP_004336240.1	1257118	g6455	i0	73.5	4.91235059760956	83	22	99.2	0	3	251	93	175	XP_004336240.1 protein serine/threonine kinase [Acanthamoeba castellanii str. Neff]	diamond	1233	130	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
18215353	18215353	PRJNA1263632_P_NODE_1395_length_505_cov_1.722222_g1377_i0	PRJNA1263632	1395	505	1.722222	8.6972211	Ripella sp. 805	1217113	Discosea	other_Eukaryota	776	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g1377	i0	94.499	100.889108910891	509	19	100	9	1	505	507	4	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	50949	776	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
18215565	18215565	PRJNA1263632_P_NODE_995_length_595_cov_2.867816_g977_i0	PRJNA1263632	995	595	2.867816	17.0635052	Ripella platypodia	2047821	Discosea	other_Eukaryota	935	0	NTclustered	gi\|1269228354\|gb\|MF683479.1\|	2047821	g977	i0	95.294	100.536134453782	595	18	99	6	3	595	1645	1059	Ripella platypodia clone 23.4.28 18S ribosomal RNA gene, partial sequence	blastn	59819	935	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella platypodia
24589987	24589987	PRJNA1263632_P_NODE_3300_length_338_cov_2.301887_g3282_i0	PRJNA1263632	3300	338	2.301887	7.78037806	Paravannella minima	1443144	Discosea	other_Eukaryota	412	1.2699999999999999e-110	NTclustered	gi\|571331049\|gb\|KF895376.1\|	1443144	g3282	i0	88.724	99.0532544378698	337	38	99	0	2	338	49	385	Paravannella minima strain CCAP 1533/1 clone 1 actin gene, partial cds	blastn	33480	412	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Paravannella	Paravannella minima
24590109	24590109	PRJNA1263632_P_NODE_8020_length_243_cov_0.905882_g8002_i0	PRJNA1263632	8020	243	0.905882	2.20129326	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	66.6	1.16e-11	NR	XP_004347153.1	1257118	g8002	i0	43.2	1.88888888888889	81	43	97.5	2	238	2	12	91	XP_004347153.1 EF hand domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	459	66.6	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26630757	26630757	PRJNA1263632_P_NODE_1941_length_434_cov_1.692521_g1923_i0	PRJNA1263632	1941	434	1.692521	7.34554114	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47.4	8.34e-4	NR	XP_004351526.1	1257118	g1923	i0	34.2	0.504608294930876	73	48	50.5	0	403	185	26	98	XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	219	47.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27042310	27042310	PRJNA1263632_P_NODE_8422_length_241_cov_0.916667_g8404_i0	PRJNA1263632	8422	241	0.916667	2.20916747	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	99.4	1.32e-24	NR	XP_004353726.1	1257118	g8404	i0	53.2	1.87966804979253	77	36	95.9	0	239	9	4	80	XP_004353726.1 LIM domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	453	99.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28526833	28526833	PRJNA1263632_P_NODE_5247_length_276_cov_1.177340_g5229_i0	PRJNA1263632	5247	276	1.17734	3.2494584	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	102	4.64e-23	NR	XP_004339395.1	1257118	g5229	i0	52.9	0.923913043478261	85	40	92.4	0	275	21	98	182	XP_004339395.1 5' nucleotidase family protein [Acanthamoeba castellanii str. Neff]	diamond	255	102	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30073748	30073748	PRJNA1263632_P_NODE_6632_length_250_cov_0.870056_g6614_i0	PRJNA1263632	6632	250	0.870056	2.17514	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47.8	1.09e-4	NR	XP_004351526.1	1257118	g6614	i0	46.9	0.588	49	26	58.8	0	35	181	26	74	XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	147	47.8	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31748899	31748899	PRJNA1263632_P_NODE_2577_length_379_cov_1.349673_g2559_i0	PRJNA1263632	2577	379	1.349673	5.11526067	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	139	8.81e-40	NR	7SOG_A	5755	g2559	i0	58.3	0.910290237467018	115	43	91	1	350	6	3	112	7SOG_A Chain A, Actophorin [Acanthamoeba castellanii]	diamond	345	139	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31875407	31875407	PRJNA1263632_P_NODE_7637_length_245_cov_0.895349_g7619_i0	PRJNA1263632	7637	245	0.895349	2.19360505	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	70.5	6.24e-12	NR	XP_004340550.1	1257118	g7619	i0	42.5	2.90204081632653	80	46	98	0	240	1	338	417	XP_004340550.1 ABC2 type transporter, putative [Acanthamoeba castellanii str. Neff]	diamond	711	70.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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