metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
2916656	2916656	PRJNA195897_P_NODE_3303_length_269_cov_1.136364_g3270_i0	PRJNA195897	3303	269	1.136364	3.05681916	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	145	3.95e-30	NTclustered	gi\|2707444340\|ref\|XM_054906817.2\|	7653	g3270	i0	81.714	2.02602230483271	175	30	65	2	83	256	633	460	PREDICTED: Lytechinus pictus NHP2-like protein 1 (LOC129269324), mRNA	blastn	545	145	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
6743681	6743681	PRJNA195897_P_NODE_7226_length_185_cov_3.397059_g7193_i0	PRJNA195897	7226	185	3.397059	6.28455915	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	143	9.11e-30	NTclustered	gi\|1752404478\|ref\|XM_030974615.1\|	7668	g7193	i0	85.401	50.2702702702703	137	20	74	0	36	172	537	673	PREDICTED: Strongylocentrotus purpuratus 60S acidic ribosomal protein P0 (LOC100888621), mRNA	blastn	9300	143	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
13119751	13119751	PRJNA195897_P_NODE_2271_length_335_cov_2.195804_g2238_i0	PRJNA195897	2271	335	2.195804	7.3559434	Asterias rubens	7604	Echinodermata	other_Eukaryota	52.8	0.032	NTclustered	gi\|1834295194\|ref\|XM_033785995.1\|	7604	g2238	i0	100	0.250746268656716	28	0	8	0	102	129	2012	2039	PREDICTED: Asterias rubens nucleolin-like (LOC117302181), transcript variant X1, mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
13119776	13119776	PRJNA195897_P_NODE_511_length_748_cov_3.536481_g483_i0	PRJNA195897	511	748	3.536481	26.45287788	Diadema antillarum	105358	Echinodermata	other_Eukaryota	331	8.6e-86	NTclustered	gi\|2919435354\|ref\|XM_071637819.1\|	105358	g483	i0	79.825	46.6510695187166	456	90	61	2	41	495	32	486	PREDICTED: Diadema antillarum ubiquitin-ribosomal protein eS31 fusion protein (LOC139726824), mRNA	blastn	34895	331	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
15668753	15668753	PRJNA195897_P_NODE_1433_length_442_cov_1.536896_g1400_i0	PRJNA195897	1433	442	1.536896	6.79308032	Diadema antillarum	105358	Echinodermata	other_Eukaryota	246	1.83e-60	NTclustered	gi\|2919420483\|ref\|XM_071635166.1\|	105358	g1400	i0	77.471	65.2466063348416	435	82	97	12	1	427	498	72	PREDICTED: Diadema antillarum large ribosomal subunit protein uL15-like (LOC139723966), mRNA	blastn	28839	246	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
16943246	16943246	PRJNA195897_P_NODE_2134_length_349_cov_1.806667_g2101_i0	PRJNA195897	2134	349	1.806667	6.30526783	Acanthaster planci	133434	Echinodermata	other_Eukaryota	113	1.49e-20	NTclustered	gi\|1229161455\|ref\|XM_022237963.1\|	133434	g2101	i0	79.375	8.99426934097421	160	33	46	0	2	161	583	742	PREDICTED: Acanthaster planci V-type proton ATPase subunit D-like (LOC110980903), mRNA	blastn	3139	113	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
18217690	18217690	PRJNA195897_P_NODE_535_length_731_cov_8.335777_g506_i0	PRJNA195897	535	731	8.335777	60.93452987	Acanthaster planci	133434	Echinodermata	other_Eukaryota	401	6.309999999999999e-107	NTclustered	gi\|1229182411\|ref\|XM_022249129.1\|	133434	g506	i0	82.43	82.6142270861833	461	79	63	2	231	690	526	67	PREDICTED: Acanthaster planci ubiquitin-40S ribosomal protein S27a (LOC110986865), mRNA	blastn	60391	401	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
20767536	20767536	PRJNA195897_P_NODE_6477_length_194_cov_1.075862_g6444_i0	PRJNA195897	6477	194	1.075862	2.08717228	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	97.1	7.63e-16	NTclustered	gi\|1752359409\|ref\|XM_780676.5\|	7668	g6444	i0	87.805	16.5670103092784	82	10	42	0	52	133	262	181	PREDICTED: Strongylocentrotus purpuratus cytochrome c oxidase subunit 6B1 (LOC580629), mRNA	blastn	3214	97.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
24592223	24592223	PRJNA195897_P_NODE_4160_length_234_cov_2.140541_g4127_i0	PRJNA195897	4160	234	2.140541	5.00886594	Paracentrotus lividus	7656	Echinodermata	other_Eukaryota	104	5.7e-18	NTclustered	gi\|21928181\|gb\|AY125980.1\|	7656	g4127	i0	79.375	8.11111111111111	160	24	67	8	31	187	276	429	Paracentrotus lividus 60S ribosomal protein L27A-related mRNA, complete cds	blastn	1898	104	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Echinidae	Paracentrotus	Paracentrotus lividus

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