metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_phylum = "Rhodophyta"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
194892	194892	PRJNA1089179_P_NODE_9721_length_295_cov_2.418919_g9703_i0	PRJNA1089179	9721	295	2.418919	7.13581105	Rhodellophyceae	661027	Rhodophyta	other_Eukaryota	70.1	1.59e-11	NR	YP_010338689.1	38265	g9703	i0	41.2	2.97966101694915	97	29	98.6	1	293	3	251	319	YP_010338689.1 putative reverse transcriptase/maturase [Glaucosphaera vacuolata]	diamond	879	70.1	1	Eukaryota	Rhodophyta	Rhodellophyceae	Glaucosphaerales	Glaucosphaeraceae	Glaucosphaera	Glaucosphaera vacuolata
27817263	27817263	PRJNA1089179_P_NODE_364_length_917_cov_2.691943_g353_i0	PRJNA1089179	364	917	2.691943	24.68511731	root	1	Root_unresolved	Root_unresolved	326	8.309999999999998e-103	NR	YP_010338686.1	38265	g353	i0	62.6	1.60959651035987	246	92	80.5	0	883	146	224	469	YP_010338686.1 putative reverse transcriptase/maturase [Glaucosphaera vacuolata]	diamond	1476	326	1	Eukaryota	Rhodophyta	Rhodellophyceae	Glaucosphaerales	Glaucosphaeraceae	Glaucosphaera	Glaucosphaera vacuolata
28078156	28078156	PRJNA1089179_P_NODE_4645_length_392_cov_1.742947_g4627_i0	PRJNA1089179	4645	392	1.742947	6.83235224	Rhodosorus marinus	101924	Rhodophyta	other_Eukaryota	83.6	2.05e-17	NR	KAJ8908848.1	101924	g4627	i0	67.3	0.397959183673469	52	17	39.8	0	5	160	87	138	KAJ8908848.1 hypothetical protein NDN08_005552 [Rhodosorus marinus]	diamond	156	83.6	1	Eukaryota	Rhodophyta	Stylonematophyceae	Stylonematales	Stylonemataceae	Rhodosorus	Rhodosorus marinus
28543499	28543499	PRJNA1089179_P_NODE_4867_length_385_cov_1.804487_g4849_i0	PRJNA1089179	4867	385	1.804487	6.94727495	Viridiplantae	33090	Rhodophyta	other_Eukaryota	80.1	7.16e-15	NR	PXF48879.1	448386	g4849	i0	59.1	2.07272727272727	66	22	51.4	1	13	210	237	297	PXF48879.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Gracilariopsis chorda]	diamond	798	80.1	1	Eukaryota	Rhodophyta	Florideophyceae	Gracilariales	Gracilariaceae	Gracilariopsis	Gracilariopsis chorda

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