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

5 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax_phylum = "Tubulinea"

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
5503232	5503232	PRJNA376117_P_NODE_12025_length_390_cov_2.154574_g11723_i0	PRJNA376117	12025	390	2.154574	8.4028386	Saccamoeba lacustris	704142	Tubulinea	other_Eukaryota	660	0	NTclustered	gi\|423292025\|gb\|JQ519458.1\|	704142	g11723	i0	97.179	100.348717948718	390	11	100	0	1	390	740	351	Saccamoeba lacustris clone JG10.115_b9 actin gene, partial cds	blastn	39136	660	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba lacustris
8726398	8726398	PRJNA376117_P_NODE_31947_length_257_cov_3.211957_g31645_i0	PRJNA376117	31947	257	3.211957	8.25472949	Flabellulidae	136457	Tubulinea	other_Eukaryota	431	2.57e-116	NTclustered	gi\|30721610\|gb\|AY277797.1\|	136459	g31645	i0	96.887	98.3618677042802	257	8	100	0	1	257	1093	837	Paraflabellula hoguae 18S ribosomal RNA gene, partial sequence	blastn	25279	431	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Paraflabellula	Paraflabellula hoguae
18251300	18251300	PRJNA376117_P_NODE_1375_length_1426_cov_9.886918_g1193_i0	PRJNA376117	1375	1426	9.886918	140.98745068	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1236	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g1193	i0	82.925	35.6199158485273	1388	222	96	11	16	1391	1	1385	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	50794	1236	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
20801185	20801185	PRJNA376117_P_NODE_17417_length_330_cov_6.614786_g17115_i0	PRJNA376117	17417	330	6.614786	21.8287938	Rhizamoeba saxonica	200886	Tubulinea	other_Eukaryota	305	2.16e-78	NTclustered	gi\|300078497\|gb\|GU001159.1\|	200886	g17115	i0	90.336	73.030303030303	238	16	72	6	93	330	3747	3977	Rhizamoeba saxonica 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	24100	305	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba saxonica
23351639	23351639	PRJNA376117_P_NODE_1399_length_1412_cov_9.300224_g1193_i1	PRJNA376117	1399	1412	9.300224	131.31916288	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1260	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g1193	i1	83.225	35.0148725212465	1389	218	98	11	16	1392	1	1386	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	49441	1260	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea

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