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

5 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax_phylum = "Echinodermata"

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
5545587	5545587	PRJNA453567_P_NODE_29805_length_160_cov_1.902439_g29568_i0	PRJNA453567	29805	160	1.902439	3.0439024	Asterias rubens	7604	Echinodermata	other_Eukaryota	58.4	2.85e-4	NTclustered	gi\|1834265589\|ref\|XM_033771799.1\|	7604	g29568	i0	86.792	0.6625	53	5	33	2	2	53	1306	1357	PREDICTED: Asterias rubens major vault protein-like (LOC117290410), transcript variant X2, mRNA	blastn	106	58.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
9369640	9369640	PRJNA453567_P_NODE_14048_length_243_cov_1.495146_g13811_i0	PRJNA453567	14048	243	1.495146	3.63320478	Patiria miniata	46514	Echinodermata	other_Eukaryota	117	7.6600000000000005e-22	NTclustered	gi\|1944915618\|ref\|XM_038214657.1\|	46514	g13811	i0	81.208	5.11111111111111	149	24	60	3	1	147	1340	1194	PREDICTED: Patiria miniata probable ATP-dependent RNA helicase DDX41 (LOC119739648), mRNA	blastn	1242	117	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
9369649	9369649	PRJNA453567_P_NODE_15908_length_225_cov_2.489362_g15671_i0	PRJNA453567	15908	225	2.489362	5.6010645	Diadema antillarum	105358	Echinodermata	other_Eukaryota	69.4	1.99e-7	NTclustered	gi\|2919547692\|ref\|XM_071622116.1\|	105358	g15671	i0	90.385	0.364444444444444	52	5	23	0	157	208	756	705	PREDICTED: Diadema antillarum protein archease-like (LOC139710184), mRNA	blastn	82	69.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
15121245	15121245	PRJNA453567_P_NODE_7092_length_369_cov_2.500000_g6855_i0	PRJNA453567	7092	369	2.5	9.225	Metazoa	33208	Echinodermata	other_Eukaryota	54.7	0.01	NTclustered	gi\|347300958\|gb\|JF795158.1\|	307972	g6855	i0	100	1.49322493224932	29	0	8	0	19	47	607	579	Apostichopus japonicus clone AJ37 microsatellite sequence	blastn	551	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
23394013	23394013	PRJNA453567_P_NODE_19779_length_199_cov_1.444444_g19542_i0	PRJNA453567	19779	199	1.444444	2.87444356	Acanthaster planci	133434	Echinodermata	other_Eukaryota	117	6.0400000000000005e-22	NTclustered	gi\|1229168355\|ref\|XM_022241669.1\|	133434	g19542	i0	80.255	0.78894472361809	157	29	78	2	30	185	583	738	PREDICTED: Acanthaster planci kinesin-like protein KIF6 (LOC110982900), mRNA	blastn	157	117	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci

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