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

9 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax_phylum = "Cnidaria"

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
545613	545613	PRJNA562549_P_NODE_13361_length_314_cov_2.529644_g13128_i0	PRJNA562549	13361	314	2.529644	7.94308216	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	154	7.83e-33	NTclustered	gi\|1619683452\|ref\|XM_021056380.2\|	2652724	g13128	i0	83.735	0.528662420382166	166	23	52	3	36	199	94	257	PREDICTED: Exaiptasia diaphana NEDD8 (LOC110249798), mRNA	blastn	166	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
545851	545851	PRJNA562549_P_NODE_8041_length_404_cov_28.282799_g7808_i0	PRJNA562549	8041	404	28.282799	114.26250796	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	241	7.7e-59	NTclustered	gi\|2744853594\|ref\|XM_065793957.1\|	6087	g7808	i0	80.06	7.31930693069307	331	60	81	6	47	374	464	137	PREDICTED: Hydra vulgaris dynein light chain Tctex-type 1 (LOC136078338), mRNA	blastn	2957	241	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
2406221	2406221	PRJNA562549_P_NODE_25082_length_234_cov_2.000000_g24849_i0	PRJNA562549	25082	234	2	4.68	Opisthokonta	33154	Cnidaria	other_Eukaryota	147	9.34e-31	NTclustered	gi\|1778056593\|ref\|XM_031709719.1\|	6105	g24849	i0	81.215	69.6196581196581	181	34	77	0	53	233	815	635	PREDICTED: Actinia tenebrosa 60S ribosomal protein L8-like (LOC116300781), mRNA	blastn	16291	148	0.993243243243243	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
5649578	5649578	PRJNA562549_P_NODE_29565_length_217_cov_1.576923_g29332_i0	PRJNA562549	29565	217	1.576923	3.42192291	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	99	2.43e-16	NTclustered	gi\|2518994268\|ref\|XM_057448343.1\|	13093	g29332	i0	87.952	0.382488479262673	83	10	38	0	15	97	295	213	PREDICTED: Hydractinia symbiolongicarpus crooked neck-like protein 1 (LOC130641517), mRNA	blastn	83	99	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
6923836	6923836	PRJNA562549_P_NODE_3206_length_626_cov_50.870796_g3065_i0	PRJNA562549	3206	626	50.870796	318.45118296	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	320	1.54e-82	NTclustered	gi\|2782943885\|ref\|XM_067076883.1\|	252671	g3065	i0	81.654	69.7348242811502	387	69	62	2	43	428	115	500	PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eL40 fusion protein (LOC136820684), mRNA	blastn	43654	320	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
17123574	17123574	PRJNA562549_P_NODE_654_length_1213_cov_6.065104_g599_i0	PRJNA562549	654	1213	6.065104	73.56971152	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	475	6.2e-129	NTclustered	gi\|2782887240\|ref\|XM_067065339.1\|	252671	g599	i0	74.492	7.29348722176422	1133	271	93	17	83	1206	1234	111	PREDICTED: Clytia hemisphaerica sperm-associated antigen 6-like (LOC136808797), mRNA	blastn	8847	475	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
18397746	18397746	PRJNA562549_P_NODE_3875_length_576_cov_91.506796_g3691_i0	PRJNA562549	3875	576	91.506796	527.07914496	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	318	5.079999999999999e-82	NTclustered	gi\|1603811054\|ref\|XM_028553884.1\|	151771	g3691	i0	79.954	88.8055555555556	434	85	75	2	40	472	63	495	PREDICTED: Dendronephthya gigantea ubiquitin-40S ribosomal protein S27a (LOC114532392), mRNA	blastn	51152	318	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
19672387	19672387	PRJNA562549_P_NODE_8736_length_388_cov_3.394495_g8503_i0	PRJNA562549	8736	388	3.394495	13.1706406	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	241	7.370000000000001e-59	NTclustered	gi\|1176099516\|ref\|XM_020764781.1\|	48498	g8503	i0	81.724	4.98711340206186	290	51	74	2	100	388	481	193	PREDICTED: Orbicella faveolata ADP-ribosylation factor-like protein 1 (LOC110058190), mRNA	blastn	1935	241	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
23498126	23498126	PRJNA562549_P_NODE_26979_length_227_cov_1.174699_g26746_i0	PRJNA562549	26979	227	1.174699	2.66656673	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	165	2.49e-36	NTclustered	gi\|2782880893\|ref\|XR_010846612.1\|	252671	g26746	i0	80.269	6.85462555066079	223	40	97	3	1	221	6288	6508	PREDICTED: Clytia hemisphaerica dynein axonemal heavy chain 8-like (LOC136806799), transcript variant X2, misc_RNA	blastn	1556	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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