metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA532380" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA532380" 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
1117381	1117381	PRJNA532380_P_NODE_6141_length_393_cov_3.072674_g5816_i0	PRJNA532380	6141	393	3.072674	12.07560882	Metazoa	33208	Cnidaria	other_Eukaryota	250	1.24e-61	NTclustered	gi\|2518994030\|ref\|XM_057448216.1\|	13093	g5816	i0	80.24	18.6666666666667	334	65	85	1	26	359	204	536	PREDICTED: Hydractinia symbiolongicarpus cdc42 homolog (LOC130641417), mRNA	blastn	7336	250	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
4330462	4330462	PRJNA532380_P_NODE_13384_length_248_cov_1.467337_g13059_i0	PRJNA532380	13384	248	1.467337	3.63899576	Myxobolus nagaraensis	402991	Cnidaria	other_Eukaryota	207	4.52e-49	NTclustered	gi\|2806899035\|dbj\|LC764520.1\|	402991	g13059	i0	90.062	61.1088709677419	161	15	65	1	52	212	475	634	Myxobolus nagaraensis mx18003 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence, clone: mx18003its2	blastn	15155	207	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus nagaraensis
4331219	4331219	PRJNA532380_P_NODE_7304_length_354_cov_1.363934_g6979_i0	PRJNA532380	7304	354	1.363934	4.82832636	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	230	1.4399999999999996e-55	NTclustered	gi\|2744858827\|ref\|XM_065796443.1\|	6087	g6979	i0	79.143	78.728813559322	350	59	97	12	12	354	1249	1591	PREDICTED: Hydra vulgaris tubulin alpha-1 chain (LOC100200835), mRNA	blastn	27870	230	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
5607598	5607598	PRJNA532380_P_NODE_21945_length_191_cov_2.147887_g21620_i0	PRJNA532380	21945	191	2.147887	4.10246417	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	141	3.41e-29	NTclustered	gi\|1270074121\|ref\|XM_022944331.1\|	50429	g21620	i0	80.311	2.02094240837696	193	32	99	6	1	190	1249	1060	PREDICTED: Stylophora pistillata phosphoenolpyruvate carboxykinase [GTP], mitochondrial-like (LOC111337936), mRNA	blastn	386	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
10045978	10045978	PRJNA532380_P_NODE_26988_length_170_cov_1.289256_g26663_i0	PRJNA532380	26988	170	1.289256	2.1917352	Metazoa	33208	Cnidaria	other_Eukaryota	198	1.73e-46	NTclustered	gi\|1778050053\|ref\|XM_031706597.1\|	6105	g26663	i0	88.024	97.9352941176471	167	20	98	0	4	170	827	661	PREDICTED: Actinia tenebrosa endoplasmic reticulum chaperone BiP-like (LOC116298213), mRNA	blastn	16649	198	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
11982697	11982697	PRJNA532380_P_NODE_27590_length_169_cov_0.866667_g27265_i0	PRJNA532380	27590	169	0.866667	1.46466723	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	187	3.71e-43	NTclustered	gi\|1778072373\|ref\|XM_031717844.1\|	6105	g27265	i0	86.826	14.5798816568047	167	22	99	0	3	169	1899	1733	PREDICTED: Actinia tenebrosa DNA replication licensing factor mcm2-like (LOC116307557), mRNA	blastn	2464	187	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
19630070	19630070	PRJNA532380_P_NODE_31516_length_164_cov_0.904348_g31191_i0	PRJNA532380	31516	164	0.904348	1.48313072	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	106	1.04e-18	NTclustered	gi\|1603805354\|ref\|XM_028550952.1\|	151771	g31191	i0	80.556	2.76219512195122	144	23	86	4	23	163	154	295	PREDICTED: Dendronephthya gigantea SUMO-conjugating enzyme UBC9-B (LOC114529184), mRNA	blastn	453	106	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
20243954	20243954	PRJNA532380_P_NODE_7016_length_363_cov_3.707006_g6691_i0	PRJNA532380	7016	363	3.707006	13.45643178	Myxobolus	35588	Cnidaria	other_Eukaryota	180	1.51e-40	NTclustered	gi\|2663986577\|emb\|OY756918.1\|	59785	g6691	i0	90.977	33.9807162534435	133	12	37	0	27	159	6424	6556	Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	12335	180	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
20906020	20906020	PRJNA532380_P_NODE_26157_length_173_cov_1.806452_g25832_i0	PRJNA532380	26157	173	1.806452	3.12516196	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	110	8.5e-20	NTclustered	gi\|1619636646\|ref\|XR_002334581.2\|	2652724	g25832	i0	86.139	1.16763005780347	101	14	58	0	73	173	508	408	PREDICTED: Exaiptasia diaphana zinc finger HIT domain-containing protein 1 (LOC110237933), transcript variant X2, misc_RNA	blastn	202	110	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
20906269	20906269	PRJNA532380_P_NODE_4537_length_475_cov_3.004695_g4212_i0	PRJNA532380	4537	475	3.004695	14.27230125	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	795	0	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g4212	i0	99.77	42.3221052631579	434	0	91	1	1	434	433	1	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	20103	795	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
22180874	22180874	PRJNA532380_P_NODE_3938_length_516_cov_6.882227_g3617_i0	PRJNA532380	3938	516	6.882227	35.51229132	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	953	0	NTclustered	gi\|681870001\|gb\|KM001684.1\|	1542451	g3617	i0	100	45.5503875968992	516	0	100	0	1	516	2009	2524	Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence	blastn	23504	953	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
22181002	22181002	PRJNA532380_P_NODE_778_length_1181_cov_4.645760_g645_i0	PRJNA532380	778	1181	4.64576	54.8664256	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	2159	0	NTclustered	gi\|681870005\|gb\|KM001688.1\|	1542451	g645	i0	99.661	41.0279424216765	1181	4	100	0	1	1181	634	1814	Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence	blastn	48454	2159	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
24069372	24069372	PRJNA532380_P_NODE_1099_length_1001_cov_3.586134_g922_i0	PRJNA532380	1099	1001	3.586134	35.89720134	Myxobolus	35588	Cnidaria	other_Eukaryota	357	1.92e-93	NTclustered	gi\|2806899062\|dbj\|LC764547.1\|	402991	g922	i0	97.156	27.962037962038	211	6	28	0	1	211	3308	3098	Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3	blastn	27990	357	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus nagaraensis

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