metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
177306	177306	PRJNA1059246_P_NODE_56401_length_269_cov_1.341837_g55775_i0	PRJNA1059246	56401	269	1.341837	3.60954153	Acanthaster planci	133434	Echinodermata	other_Eukaryota	63.9	1.14e-5	NTclustered	gi\|1229135955\|ref\|XM_022224258.1\|	133434	g55775	i0	89.796	0.546468401486989	49	5	18	0	221	269	418	370	PREDICTED: Acanthaster planci cytochrome c-like (LOC110973420), transcript variant X2, mRNA	blastn	147	63.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
5279465	5279465	PRJNA1059246_P_NODE_12625_length_667_cov_3.500000_g12044_i0	PRJNA1059246	12625	667	3.5	23.345	Diadema antillarum	105358	Echinodermata	other_Eukaryota	183	2.2599999999999996e-41	NTclustered	gi\|2919508882\|ref\|XM_071651221.1\|	105358	g12044	i0	82.609	1.70914542728636	207	36	31	0	225	431	316	522	PREDICTED: Diadema antillarum ATP synthase F(0) complex subunit C1, mitochondrial-like (LOC139740637), mRNA	blastn	1140	183	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
5279660	5279660	PRJNA1059246_P_NODE_26685_length_430_cov_1.112045_g26060_i0	PRJNA1059246	26685	430	1.112045	4.7817935	Diadema antillarum	105358	Echinodermata	other_Eukaryota	58.4	8.92e-4	NTclustered	gi\|2919514496\|ref\|XM_071652245.1\|	105358	g26060	i0	100	0.144186046511628	31	0	7	0	176	206	290	320	PREDICTED: Diadema antillarum homeobox protein OTX-like (LOC139741665), mRNA	blastn	62	58.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
6555464	6555464	PRJNA1059246_P_NODE_9946_length_764_cov_3.120116_g9408_i0	PRJNA1059246	9946	764	3.120116	23.83768624	Asterias rubens	7604	Echinodermata	other_Eukaryota	453	1.7999999999999994e-122	NTclustered	gi\|1834300977\|ref\|XM_033770552.1\|	7604	g9408	i0	81.718	63.4829842931937	547	96	71	4	204	748	109	653	PREDICTED: Asterias rubens adenosylhomocysteinase B-like (LOC117289432), mRNA	blastn	48501	453	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
10380163	10380163	PRJNA1059246_P_NODE_22009_length_482_cov_1.039120_g21390_i0	PRJNA1059246	22009	482	1.03912	5.0085584	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	52.8	0.047	NTclustered	gi\|2037981505\|ref\|XM_041603297.1\|	7654	g21390	i0	96.875	0.132780082987552	32	0	7	1	450	481	1544	1574	PREDICTED: Lytechinus variegatus transcription cofactor vestigial-like protein 4 (LOC121410914), transcript variant X2, mRNA	blastn	64	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
10380602	10380602	PRJNA1059246_P_NODE_5909_length_1018_cov_2.739683_g5469_i0	PRJNA1059246	5909	1018	2.739683	27.88997294	Diadema antillarum	105358	Echinodermata	other_Eukaryota	344	1.5199999999999999e-89	NTclustered	gi\|2919569988\|ref\|XM_071626294.1\|	105358	g5469	i0	83.246	35.4911591355599	382	56	37	7	1	378	487	110	PREDICTED: Diadema antillarum dual specificity tyrosine-phosphorylation-regulated kinase 1A-like (LOC139714613), partial mRNA	blastn	36130	344	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
12930685	12930685	PRJNA1059246_P_NODE_32011_length_384_cov_2.697749_g31385_i0	PRJNA1059246	32011	384	2.697749	10.35935616	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	279	1.5400000000000002e-70	NTclustered	gi\|1752375065\|ref\|XM_030991330.1\|	7668	g31385	i0	86.667	52.2604166666667	255	30	66	3	132	384	276	24	PREDICTED: Strongylocentrotus purpuratus dynein light chain LC6, flagellar outer arm (LOC115926537), mRNA	blastn	20068	279	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
14205820	14205820	PRJNA1059246_P_NODE_45852_length_308_cov_1.310638_g45226_i0	PRJNA1059246	45852	308	1.310638	4.03676504	Patiria miniata	46514	Echinodermata	other_Eukaryota	169	2.7399999999999997e-37	NTclustered	gi\|1944866833\|ref\|XM_038198323.1\|	46514	g45226	i0	76.898	3.17532467532468	303	66	98	4	7	307	1212	1512	PREDICTED: Patiria miniata protein transport protein Sec61 subunit alpha (LOC119726588), mRNA	blastn	978	169	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
14206071	14206071	PRJNA1059246_P_NODE_67352_length_246_cov_0.890173_g66726_i0	PRJNA1059246	67352	246	0.890173	2.18982558	Patiria miniata	46514	Echinodermata	other_Eukaryota	171	5.879999999999999e-38	NTclustered	gi\|1944880371\|ref\|XM_038202264.1\|	46514	g66726	i0	85.714	12.0040650406504	161	23	65	0	86	246	182	342	PREDICTED: Patiria miniata heat shock cognate 71 kDa protein-like (LOC119729619), mRNA	blastn	2953	171	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
16754456	16754456	PRJNA1059246_P_NODE_8954_length_809_cov_13.596467_g8431_i0	PRJNA1059246	8954	809	13.596467	109.99541803	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	178	1.2899999999999999e-39	NTclustered	gi\|1752399365\|ref\|XM_011667624.2\|	7668	g8431	i0	83.077	27.6563658838072	195	33	24	0	363	557	583	389	PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA	blastn	22374	178	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
19303091	19303091	PRJNA1059246_P_NODE_636_length_2616_cov_2.906410_g568_i0	PRJNA1059246	636	2616	2.90641	76.0316856	Asterias rubens	7604	Echinodermata	other_Eukaryota	270	6.879999999999999e-67	NTclustered	gi\|1834288451\|ref\|XM_033784271.1\|	7604	g568	i0	72.046	23.3902905198777	1041	247	39	41	110	1128	3795	2777	PREDICTED: Asterias rubens pumilio homolog 2-like (LOC117300609), transcript variant X2, mRNA	blastn	61189	270	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
20138006	20138006	PRJNA1059246_P_NODE_67676_length_245_cov_3.011628_g67050_i0	PRJNA1059246	67676	245	3.011628	7.3784886	Lytechinus	7652	Echinodermata	other_Eukaryota	75	4.72e-9	NTclustered	gi\|2707421248\|ref\|XM_064102300.1\|	7653	g67050	i0	90.909	0.448979591836735	55	5	22	0	15	69	3104	3158	PREDICTED: Lytechinus pictus dynein regulatory complex subunit 7-like (LOC129265359), mRNA	blastn	110	75	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus

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