metadata: contig_metadata: 6 rows where bioproject = "PRJNA494251" and tax

6 rows where bioproject = "PRJNA494251" 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
8128328	8128328	PRJNA494251_P_NODE_27207_length_282_cov_1.444976_g26893_i0	PRJNA494251	27207	282	1.444976	4.07483232	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	60.2	1.55e-4	NTclustered	gi\|2493469906\|ref\|XM_055489449.1\|	2943436	g26893	i0	100	6.85106382978723	32	0	11	0	219	250	226	257	PREDICTED: Paramacrobiotus metropolitanus flotillin-1-like (LOC129593235), mRNA	blastn	1932	60.2	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
9403566	9403566	PRJNA494251_P_NODE_7068_length_490_cov_2.170264_g6765_i0	PRJNA494251	7068	490	2.170264	10.6342936	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	220	1.2399999999999999e-52	NTclustered	gi\|2493491302\|ref\|XM_055494843.1\|	2943436	g6765	i0	77.871	1.90816326530612	357	77	73	2	133	488	1602	1247	PREDICTED: Paramacrobiotus metropolitanus V-type proton ATPase subunit B (LOC129597357), mRNA	blastn	935	220	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
20877025	20877025	PRJNA494251_P_NODE_25237_length_290_cov_1.161290_g24923_i0	PRJNA494251	25237	290	1.16129	3.367741	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	136	1.13e-38	NR	GAU95967.1	947166	g24923	i0	63.5	13.851724137931	96	35	99.3	0	290	3	24	119	GAU95967.1 hypothetical protein RvY_07482 [Ramazzottius varieornatus]	diamond	4017	136	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
23427693	23427693	PRJNA494251_P_NODE_25539_length_288_cov_2.883721_g25225_i0	PRJNA494251	25539	288	2.883721	8.30511648	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	106	2.02e-18	NTclustered	gi\|2493423832\|ref\|XM_055477276.1\|	2943436	g25225	i0	73.864	3.40625	264	69	92	0	1	264	472	735	PREDICTED: Paramacrobiotus metropolitanus ADP-ribosylation factor 1 (LOC129584880), transcript variant X1, mRNA	blastn	981	106	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
27993044	27993044	PRJNA494251_P_NODE_43165_length_246_cov_0.890173_g42851_i0	PRJNA494251	43165	246	0.890173	2.18982558	Ramazzottius varieornatus	947166	Tardigrada	other_Eukaryota	73.2	7.34e-13	NR	GAU97700.1	947166	g42851	i0	47.9	0.890243902439024	73	37	87.8	1	233	18	448	520	GAU97700.1 hypothetical protein RvY_08950-1 [Ramazzottius varieornatus]	diamond	219	73.2	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Ramazzottiidae	Ramazzottius	Ramazzottius varieornatus
29729219	29729219	PRJNA494251_P_NODE_33610_length_260_cov_1.566845_g33296_i0	PRJNA494251	33610	260	1.566845	4.073797	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	42.7	0.0443	NR	XP_055338329.1	2943436	g33296	i0	32.9	0.842307692307692	73	45	84.2	2	219	1	117	185	XP_055338329.1 WD repeat and FYVE domain-containing protein 2-like [Paramacrobiotus metropolitanus]	diamond	219	42.7	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);;