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

9 rows where analysis = "blastn", bioproject = "PRJNA964500" and tax_clade = "Amoebozoa"

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
6045093	6045093	PRJNA964500_S_NODE_905_length_457_cov_12.439252_g817_i0	PRJNA964500	905	457	12.439252	56.84738164	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	627	5.789999999999998e-175	NTclustered	gi\|659103923\|gb\|KJ569725.1\|	1512276	g817	i0	91.416	44.7549234135667	466	26	100	11	1	457	1044	584	Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence	blastn	20453	627	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
13695478	13695478	PRJNA964500_S_NODE_2751_length_310_cov_9.793594_g2659_i0	PRJNA964500	2751	310	9.793594	30.3601414	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	460	4.06e-125	NTclustered	gi\|659103927\|gb\|KJ569727.1\|	1512276	g2659	i0	94.649	27.1064516129032	299	12	95	3	12	306	1432	1730	Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence	blastn	8403	460	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
17519862	17519862	PRJNA964500_S_NODE_16534_length_153_cov_16.564516_g16442_i0	PRJNA964500	16534	153	16.564516	25.34370948	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	233	4.17e-57	NTclustered	gi\|659103923\|gb\|KJ569725.1\|	1512276	g16442	i0	94.156	46.0457516339869	154	7	100	2	1	153	422	574	Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence	blastn	7045	233	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
17519866	17519866	PRJNA964500_S_NODE_1694_length_367_cov_57730.526627_g1602_i0	PRJNA964500	1694	367	57730.526627	211871.03272109	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	377	5.06e-100	NTclustered	gi\|659103926\|gb\|KJ569726.1\|	1512276	g1602	i0	92.251	244.065395095368	271	14	72	4	57	320	1720	1990	Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence	blastn	89572	377	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
19116845	19116845	PRJNA964500_S_NODE_11655_length_176_cov_3.040816_g11563_i0	PRJNA964500	11655	176	3.040816	5.35183616	Didymium	5792	Evosea	other_Eukaryota	265	1.7499999999999998e-66	NTclustered	gi\|2687\|emb\|X60210.1\|	5793	g11563	i0	94.706	8.22727272727273	170	9	97	0	1	170	2613	2444	D.iridis LSU rRNA gene	blastn	1448	265	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
20391804	20391804	PRJNA964500_S_NODE_4776_length_252_cov_307.278027_g4684_i0	PRJNA964500	4776	252	307.278027	774.34062804	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	220	5.919999999999999e-53	NTclustered	gi\|300078500\|gb\|GU001162.1\|	136499	g4684	i0	85.849	2288.54365079365	212	25	83	4	35	244	4282	4074	Phalansterium solitarium 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	576713	222	0.990990990990991	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium solitarium
22618951	22618951	PRJNA964500_S_NODE_5918_length_231_cov_334.188119_g5826_i0	PRJNA964500	5918	231	334.188119	771.97455489	Phalansterium solitarium	136499	Evosea	other_Eukaryota	265	2.44e-66	NTclustered	gi\|300078500\|gb\|GU001162.1\|	136499	g5826	i0	90.955	85.3896103896104	199	14	85	3	35	231	4282	4086	Phalansterium solitarium 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	19725	265	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium solitarium
22943236	22943236	PRJNA964500_S_NODE_8138_length_203_cov_14.890805_g8046_i0	PRJNA964500	8138	203	14.890805	30.22833415	Cochliopodium	313557	Discosea	other_Eukaryota	246	7.56e-61	NTclustered	gi\|59876024\|gb\|AY785057.1\|	313998	g8046	i0	97.902	46.8275862068966	143	2	70	1	27	169	452	593	Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence	blastn	9506	246	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium sp. strain Kiel
25167994	25167994	PRJNA964500_S_NODE_640_length_509_cov_19993.822917_g566_i0	PRJNA964500	640	509	19993.822917	101768.55864753	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	669	0	NTclustered	gi\|659103926\|gb\|KJ569726.1\|	1512276	g566	i0	96.135	112.194499017682	414	9	80	7	10	417	416	4	Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence	blastn	57107	669	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense

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