metadata: contig_metadata: 9 rows where bioproject = "PRJNA404067" and tax

9 rows where bioproject = "PRJNA404067" 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
414809	414809	PRJNA404067_P_NODE_42481_length_186_cov_2.624000_g42094_i0	PRJNA404067	42481	186	2.624	4.88064	Vannella septentrionalis	197531	Discosea	other_Eukaryota	152	1.52e-32	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g42094	i0	98.824	46.247311827957	85	1	94	0	50	134	2219	2135	Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	8602	152	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
2965150	2965150	PRJNA404067_P_NODE_13363_length_286_cov_1.786667_g12976_i0	PRJNA404067	13363	286	1.786667	5.10986762	Vexillifera bacillipedes	1105345	Discosea	other_Eukaryota	503	6.069999999999998e-138	NTclustered	gi\|399764261\|gb\|JQ271772.1\|	1105345	g12976	i0	98.264	8.57692307692308	288	3	100	1	1	286	299	12	Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence	blastn	2453	503	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera bacillipedes
13168325	13168325	PRJNA404067_P_NODE_24791_length_223_cov_3.641975_g24404_i0	PRJNA404067	24791	223	3.641975	8.12160425	Vexillifera bacillipedes	1105345	Discosea	other_Eukaryota	401	1.7099999999999992e-107	NTclustered	gi\|354720325\|gb\|HQ687484.1\|	1105345	g24404	i0	99.103	16.9551569506726	223	2	100	0	1	223	882	1104	Vexillifera bacillipedes strain TIL2 small subunit ribosomal RNA gene, partial sequence	blastn	3781	401	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera bacillipedes
18266100	18266100	PRJNA404067_P_NODE_19235_length_239_cov_4.157303_g18848_i0	PRJNA404067	19235	239	4.157303	9.93595417	Cochliopodium larifeili	1017091	Discosea	other_Eukaryota	412	8.549999999999998e-111	NTclustered	gi\|330902861\|gb\|JF298256.1\|	1017091	g18848	i0	97.917	71.9707112970711	240	2	100	3	1	239	516	279	Cochliopodium larifeili clone 907 18S ribosomal RNA gene, partial sequence	blastn	17201	412	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium larifeili
20816507	20816507	PRJNA404067_P_NODE_41377_length_191_cov_2.176923_g40990_i0	PRJNA404067	41377	191	2.176923	4.15792293	Vexillifera bacillipedes	1105345	Discosea	other_Eukaryota	300	5.31e-77	NTclustered	gi\|354720325\|gb\|HQ687484.1\|	1105345	g40990	i0	95.312	26.4607329842932	192	3	100	4	1	191	220	406	Vexillifera bacillipedes strain TIL2 small subunit ribosomal RNA gene, partial sequence	blastn	5054	300	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera bacillipedes
24032917	24032917	PRJNA404067_P_NODE_14379_length_274_cov_1.197183_g13992_i0	PRJNA404067	14379	274	1.197183	3.28028142	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	119	4.26e-30	NR	NP_042542.1	5755	g13992	i0	76.5	0.930656934306569	85	19	93.1	1	2	256	139	222	NP_042542.1 NADH dehydrogenasesubunit 1 [Acanthamoeba castellanii]	diamond	255	119	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26758805	26758805	PRJNA404067_P_NODE_38781_length_201_cov_0.914286_g38394_i0	PRJNA404067	38781	201	0.914286	1.83771486	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	45.4	0.00233	NR	XP_004337724.1	1257118	g38394	i0	36.7	0.73134328358209	49	31	73.1	0	3	149	362	410	XP_004337724.1 uncharacterized protein ACA1_378610 [Acanthamoeba castellanii str. Neff]	diamond	147	45.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27328430	27328430	PRJNA404067_P_NODE_40783_length_193_cov_4.606061_g40396_i0	PRJNA404067	40783	193	4.606061	8.88969773	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	57	1.12e-8	NR	XP_004334523.1	1257118	g40396	i0	92.3	0.404145077720207	26	2	40.4	0	188	111	69	94	XP_004334523.1 ribosomal protein s27, putative [Acanthamoeba castellanii str. Neff]	diamond	78	57	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29412157	29412157	PRJNA404067_P_NODE_6529_length_483_cov_4.305687_g6152_i0	PRJNA404067	6529	483	4.305687	20.79646821	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	69.3	2.54e-10	NR	XP_004338928.1	1257118	g6152	i0	64.6	0.608695652173913	48	17	29.8	0	76	219	591	638	XP_004338928.1 long chain acylcoA synthetase [Acanthamoeba castellanii str. Neff]	diamond	294	69.3	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);;