metadata: contig_metadata: 5 rows where bioproject = "PRJNA682078" and tax

5 rows where bioproject = "PRJNA682078" and tax_phylum = "Tardigrada"

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
29260852	29260852	PRJNA682078_P_NODE_75309_length_399_cov_1.088957_g73534_i0	PRJNA682078	75309	399	1.088957	4.34493843	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	47	0.00215	NR	OQV12681.1	2072580	g73534	i0	39.7	0.43609022556390997	58	35	43.6	0	396	223	78	135	OQV12681.1 hypothetical protein BV898_13089 [Hypsibius exemplaris]	diamond	174	47	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
30492916	30492916	PRJNA682078_P_NODE_74073_length_402_cov_1.185410_g72298_i0	PRJNA682078	74073	402	1.18541	4.7653482	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	97.4	1.69e-22	NR	GAV09740.1	947166	g72298	i0	46.8	0.813432835820896	109	57	80.6	1	73	396	29	137	GAV09740.1 hypothetical protein RvY_19228 [Ramazzottius varieornatus]	diamond	327	97.4	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
31599267	31599267	PRJNA682078_P_NODE_65336_length_426_cov_1.345609_g63561_i0	PRJNA682078	65336	426	1.345609	5.73229434	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	99.8	3.4e-21	NR	XP_055351591.1	2943436	g63561	i0	51.6	0.669014084507042	95	46	66.9	0	425	141	816	910	XP_055351591.1 uncharacterized protein LOC129597910 [Paramacrobiotus metropolitanus]	diamond	285	99.8	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
32485070	32485070	PRJNA682078_P_NODE_117959_length_328_cov_0.905882_g116182_i0	PRJNA682078	117959	328	0.905882	2.97129296	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	87	8.04e-18	NR	GAU91757.1	947166	g116182	i0	58.6	0.640243902439024	70	28	64	1	234	25	64	132	GAU91757.1 hypothetical protein RvY_03953 [Ramazzottius varieornatus]	diamond	210	87	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
32800032	32800032	PRJNA682078_P_NODE_245820_length_248_cov_0.880000_g244043_i0	PRJNA682078	245820	248	0.88	2.1824	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	52.8	1.16e-5	NR	XP_055336340.1	2943436	g244043	i0	50.9	3.66532258064516	57	28	69	0	8	178	301	357	XP_055336340.1 uncharacterized protein LOC129586883 [Paramacrobiotus metropolitanus]	diamond	909	52.8	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus

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