metadata: contig_metadata: 9 rows where bioproject = "PRJNA605033", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA605033", tax_clade = "Opisthokonta" 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
582205	582205	PRJNA605033_P_NODE_213321_length_161_cov_0.976190_g211752_i0	PRJNA605033	213321	161	0.97619	1.5716659	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	231	1.5999999999999997e-56	NTclustered	gi\|2037924712\|ref\|XR_005971168.1\|	7654	g211752	i0	92.262	3.12422360248447	168	6	100	5	1	161	16	183	PREDICTED: Lytechinus variegatus uncharacterized LOC121422456 (LOC121422456), ncRNA	blastn	503	231	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
4973802	4973802	PRJNA605033_P_NODE_47224_length_243_cov_3.903846_g45656_i0	PRJNA605033	47224	243	3.903846	9.48634578	root	1	Root_unresolved	Root_unresolved	322	1.51e-83	NTclustered	gi\|532656\|gb\|M10468.1\|SULRGA	7654	g45656	i0	100	45.8271604938272	174	0	93	0	70	243	190	17	Lytechinus variegatus 5S ribosomal RNA gene, complete sequence	blastn	11136	322	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
6959544	6959544	PRJNA605033_P_NODE_104926_length_222_cov_1.871658_g103357_i0	PRJNA605033	104926	222	1.871658	4.15508076	Asterias rubens	7604	Echinodermata	other_Eukaryota	91.6	4.17e-14	NTclustered	gi\|1834272065\|ref\|XM_033782155.1\|	7604	g103357	i0	96.364	0.495495495495495	55	2	25	0	164	218	4083	4029	PREDICTED: Asterias rubens phospholipid scramblase 1-like (LOC117298818), transcript variant X1, mRNA	blastn	110	91.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
8235015	8235015	PRJNA605033_P_NODE_174087_length_178_cov_1.587413_g172518_i0	PRJNA605033	174087	178	1.587413	2.82559514	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	329	6.21e-86	NTclustered	gi\|1418578911\|ref\|NC_037785.1\|	7654	g172518	i0	100	99.8539325842697	178	0	100	0	1	178	6144	6321	Lytechinus variegatus isolate Lv4 mitochondrion, complete genome	blastn	17774	329	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
17723626	17723626	PRJNA605033_P_NODE_47834_length_243_cov_1.019231_g46266_i0	PRJNA605033	47834	243	1.019231	2.47673133	Lytechinus	7652	Echinodermata	other_Eukaryota	444	3.09e-120	NTclustered	gi\|2707351026\|ref\|XR_008586834.2\|	7653	g46266	i0	99.588	97.8271604938272	243	1	100	0	1	243	2074	1832	PREDICTED: Lytechinus pictus large subunit ribosomal RNA (LOC129284211), rRNA	blastn	23772	444	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
18434508	18434508	PRJNA605033_P_NODE_226035_length_156_cov_3.181818_g224466_i0	PRJNA605033	226035	156	3.181818	4.96363608	Asterias rubens	7604	Echinodermata	other_Eukaryota	82.4	1.64e-11	NTclustered	gi\|1834270523\|ref\|XM_033787763.1\|	7604	g224466	i0	91.667	0.384615384615385	60	3	38	2	82	141	2073	2130	PREDICTED: Asterias rubens cryptochrome-1-like (LOC117303532), mRNA	blastn	60	82.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
20984205	20984205	PRJNA605033_P_NODE_176197_length_177_cov_1.408451_g174628_i0	PRJNA605033	176197	177	1.408451	2.49295827	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	322	1.03e-83	NTclustered	gi\|1418578911\|ref\|NC_037785.1\|	7654	g174628	i0	99.435	2	177	1	100	0	1	177	14878	15054	Lytechinus variegatus isolate Lv4 mitochondrion, complete genome	blastn	354	322	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
20985310	20985310	PRJNA605033_P_NODE_58217_length_228_cov_5.145078_g56649_i0	PRJNA605033	58217	228	5.145078	11.73077784	Pisaster ochraceus	7612	Echinodermata	other_Eukaryota	176	1.16e-39	NTclustered	gi\|1693290266\|ref\|NC_042741.1\|	7612	g56649	i0	100	30.0087719298246	95	0	73	0	132	226	3216	3310	Pisaster ochraceus voucher M0D055189C mitochondrion, complete genome	blastn	6842	176	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Pisaster	Pisaster ochraceus
22258700	22258700	PRJNA605033_P_NODE_151298_length_193_cov_2.000000_g149729_i0	PRJNA605033	151298	193	2	3.86	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	351	1.46e-92	NTclustered	gi\|2037957281\|ref\|XR_005971698.1\|	7654	g149729	i0	99.482	6.35751295336788	193	1	100	0	1	193	84	276	PREDICTED: Lytechinus variegatus uncharacterized LOC121427508 (LOC121427508), ncRNA	blastn	1227	351	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus

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