metadata: contig_metadata: 10 rows where bioproject = "PRJNA495391" and tax

10 rows where bioproject = "PRJNA495391" 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
475847	475847	PRJNA495391_S_NODE_1421_length_1299_cov_2721.225475_g665_i0	PRJNA495391	1421	1299	2721.225475	35348.71892025	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	1251	0	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g665	i0	100	44.5696689761355	677	0	52	0	552	1228	677	1	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	57896	1251	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
1752141	1752141	PRJNA495391_S_NODE_68022_length_153_cov_1.347458_g66970_i0	PRJNA495391	68022	153	1.347458	2.06161074	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	150	4.3199999999999996e-32	NTclustered	gi\|2744890083\|ref\|XR_010641937.1\|	6087	g66970	i0	84.314	1	153	24	100	0	1	153	73	225	PREDICTED: Hydra vulgaris uncharacterized LOC136087622 (LOC136087622), transcript variant X1, ncRNA	blastn	153	150	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
3027747	3027747	PRJNA495391_S_NODE_52503_length_171_cov_1.632353_g51451_i0	PRJNA495391	52503	171	1.632353	2.79132363	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	183	4.869999999999999e-42	NTclustered	gi\|2744890083\|ref\|XR_010641937.1\|	6087	g51451	i0	85.965	1.43859649122807	171	24	100	0	1	171	447	617	PREDICTED: Hydra vulgaris uncharacterized LOC136087622 (LOC136087622), transcript variant X1, ncRNA	blastn	246	183	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
24702484	24702484	PRJNA495391_S_NODE_40800_length_192_cov_1.757962_g39748_i0	PRJNA495391	40800	192	1.757962	3.37528704	Montipora capricornis	246305	Cnidaria	other_Eukaryota	126	9.6e-25	NTclustered	gi\|2812140899\|ref\|XM_068880408.1\|	246305	g39748	i0	82.979	0.734375	141	22	73	2	33	172	169	308	PREDICTED: Montipora capricornis small ribosomal subunit protein eS17-like (LOC138032703), mRNA	blastn	141	126	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
26887341	26887341	PRJNA495391_S_NODE_33361_length_211_cov_1.352273_g32309_i0	PRJNA495391	33361	211	1.352273	2.85329603	Porites evermanni	104178	Cnidaria	other_Eukaryota	74.3	1.83e-13	NR	CAH3140314.1	104178	g32309	i0	52.9	0.995260663507109	70	33	99.5	0	211	2	858	927	CAH3140314.1 unnamed protein product [Porites evermanni]	diamond	210	74.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
28403431	28403431	PRJNA495391_S_NODE_30386_length_220_cov_1.610811_g29334_i0	PRJNA495391	30386	220	1.610811	3.5437842	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	44.3	0.0075	NR	XP_065070945.1	499914	g29334	i0	41.8	0.913636363636364	67	33	84.5	3	218	33	52	117	XP_065070945.1 cysteine and glycine-rich protein 2-like [Rhopilema esculentum]	diamond	201	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
28671678	28671678	PRJNA495391_S_NODE_55407_length_167_cov_1.492424_g54355_i0	PRJNA495391	55407	167	1.492424	2.49234808	Opisthokonta	33154	Cnidaria	other_Eukaryota	75.9	8.94e-15	NR	XP_031562458.1	6105	g54355	i0	63	8.73053892215569	54	20	97	0	162	1	121	174	XP_031562458.1 60S ribosomal protein L7a-like [Actinia tenebrosa]	diamond	1458	75.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
30345832	30345832	PRJNA495391_S_NODE_9492_length_392_cov_2.196078_g8440_i0	PRJNA495391	9492	392	2.196078	8.60862576	Metazoa	33208	Cnidaria	other_Eukaryota	79.7	5.85e-16	NR	XP_027055145.1	46731	g8440	i0	46.8	1.26275510204082	79	41	59.7	1	375	142	70	148	XP_027055145.1 lipopolysaccharide-induced tumor necrosis factor-alpha factor homolog [Pocillopora damicornis]	diamond	495	79.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
32652873	32652873	PRJNA495391_S_NODE_54780_length_168_cov_1.270677_g53728_i0	PRJNA495391	54780	168	1.270677	2.13473736	Metazoa	33208	Cnidaria	other_Eukaryota	56.6	1.69e-7	NR	KAK2552181.1	6130	g53728	i0	50	2.375	46	23	82.1	0	140	3	862	907	KAK2552181.1 Transposon Tf2-6 polyprotein [Acropora cervicornis]	diamond	399	56.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
32652875	32652875	PRJNA495391_S_NODE_9600_length_390_cov_2.157746_g8548_i0	PRJNA495391	9600	390	2.157746	8.4152094	Metazoa	33208	Cnidaria	other_Eukaryota	85.5	4.11e-17	NR	XP_031554159.1	6105	g8548	i0	58	4.98461538461538	69	29	53.1	0	96	302	188	256	XP_031554159.1 40S ribosomal protein S2 [Actinia tenebrosa]	diamond	1944	85.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa

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