metadata: contig_metadata: 5 rows where bioproject = "PRJEB2925", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJEB2925", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1300332	1300332	PRJEB2925_P_NODE_13562_length_282_cov_2.773279_g12284_i0	PRJEB2925	13562	282	2.773279	7.82064678	Blastocladiella sp.	2169676	Fungi	Fungi	209	1.46e-49	NTclustered	gi\|1866582625\|gb\|MT730800.1\|	2169676	g12284	i0	95.489	48.5	133	3	74	3	145	275	3951	3820	Blastocladiella sp. isolate JEL0735 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	13677	209	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella sp.
1300345	1300345	PRJEB2925_P_NODE_15002_length_261_cov_2.123894_g13724_i0	PRJEB2925	15002	261	2.123894	5.54336334	Fungi	4751	Fungi	Fungi	127	1.35e-35	NR	KAJ3373363.1	64504	g13724	i0	67.8	9	87	28	100	0	261	1	40	126	KAJ3373363.1 60S ribosomal protein L32 [Allomyces arbusculus]	diamond	2349	128	0.9921875	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
10228967	10228967	PRJEB2925_P_NODE_9569_length_380_cov_18.301449_g8298_i0	PRJEB2925	9569	380	18.301449	69.5455062	Catenophlyctis variabilis	945688	Fungi	Fungi	180	1.5899999999999999e-40	NTclustered	gi\|82398236\|gb\|DQ273780.1\|	945688	g8298	i0	93.443	41.8578947368421	122	6	45	2	1	121	2545	2665	Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence	blastn	15906	180	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenophlyctis	Catenophlyctis variabilis
24251984	24251984	PRJEB2925_P_NODE_9880_length_370_cov_5.462687_g8608_i0	PRJEB2925	9880	370	5.462687	20.2119419	Blastocladiella emersonii	4808	Fungi	Fungi	407	6.52e-109	NTclustered	gi\|2440036\|emb\|X90411.1\|	4808	g8608	i0	88.184	75.8513513513514	347	33	92	7	1	341	2210	1866	B.emersonii DNA for 28S ribosomal RNA gene	blastn	28065	407	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
30500687	30500687	PRJEB2925_P_NODE_11173_length_332_cov_3.501684_g9899_i0	PRJEB2925	11173	332	3.501684	11.62559088	Eukaryota	2759	Fungi	Fungi	83.6	2.8e-18	NR	KAJ1509468.1	945690	g9899	i0	58.2	1.72590361445783	79	28	70.5	2	98	331	7	81	KAJ1509468.1 hypothetical protein HMI54_002374, partial [Coelomomyces lativittatus]	diamond	573	84	0.995238095238095	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Coelomomycetaceae	Coelomomyces	Coelomomyces lativittatus

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