metadata: contig_metadata: 12 rows where bioproject = "PRJNA815356" and tax

12 rows where bioproject = "PRJNA815356" and tax_phylum = "Chordata"

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
819150	819150	PRJNA815356_P_NODE_8801_length_253_cov_0.866667_g8638_i0	PRJNA815356	8801	253	0.866667	2.19266751	Canis lupus	9612	Chordata	Chordata	468	1.92e-127	NTclustered	gi\|2272660176\|ref\|XM_049109386.1\|	286419	g8638	i0	100	83.6086956521739	253	0	100	0	1	253	4079	3827	PREDICTED: Canis lupus dingo retinoic acid induced 14 (RAI14), transcript variant X12, mRNA	blastn	21153	468	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
5922383	5922383	PRJNA815356_P_NODE_9685_length_248_cov_0.891429_g9522_i0	PRJNA815356	9685	248	0.891429	2.21074392	Mus musculus	10090	Chordata	Chordata	99	2.84e-16	NTclustered	gi\|51854671\|gb\|AC147558.3\|	10090	g9522	i0	86.667	0.838709677419355	90	11	36	1	1	90	101371	101459	Mus musculus BAC clone RP23-470N2 from 8, complete sequence	blastn	208	99	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7197323	7197323	PRJNA815356_P_NODE_7966_length_263_cov_2.205263_g7803_i0	PRJNA815356	7966	263	2.205263	5.79984169	Mus musculus	10090	Chordata	Chordata	56.5	0.002	NTclustered	gi\|23338374\|emb\|AL929181.2\|	10090	g7803	i0	100	0.114068441064639	30	0	11	0	171	200	79642	79671	Mouse DNA sequence from clone RP23-391E20 on chromosome 4, complete sequence	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8880919	8880919	PRJNA815356_P_NODE_10287_length_244_cov_1.368421_g10124_i0	PRJNA815356	10287	244	1.368421	3.33894724	Canidae	9608	Chordata	Chordata	204	5.74e-48	NTclustered	gi\|1953375484\|ref\|XM_038447175.1\|	9615	g10124	i0	100	45.0819672131148	110	0	45	0	1	110	2719	2828	PREDICTED: Canis lupus familiaris oxysterol binding protein like 6 (OSBPL6), transcript variant X7, mRNA	blastn	11000	204	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
15255925	15255925	PRJNA815356_P_NODE_5112_length_316_cov_1.283951_g4949_i0	PRJNA815356	5112	316	1.283951	4.05728516	Emydidae	8476	Chordata	Chordata	52.8	0.03	NTclustered	gi\|2739753839\|ref\|XM_065556230.1\|	8478	g4949	i0	100	2.3037974683544298	28	0	9	0	3	30	127	100	PREDICTED: Chrysemys picta bellii EPH receptor B1 (EPHB1), transcript variant X6, mRNA	blastn	728	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Emydidae	Chrysemys	Chrysemys picta
15255943	15255943	PRJNA815356_P_NODE_9812_length_247_cov_0.896552_g9649_i0	PRJNA815356	9812	247	0.896552	2.21448344	Canis	9611	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|1953404921\|ref\|XR_005430416.1\|	9615	g9649	i0	100	7	247	0	100	0	1	247	2761	2515	PREDICTED: Canis lupus familiaris uncharacterized LOC102152901 (LOC102152901), transcript variant X2, ncRNA	blastn	1729	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
16121753	16121753	PRJNA815356_P_NODE_6073_length_295_cov_1.319820_g5910_i0	PRJNA815356	6073	295	1.31982	3.893469	Chaetura pelagica	8897	Chordata	Chordata	54.7	0.008	NTclustered	gi\|701429242\|ref\|XM_010005056.1\|	8897	g5910	i0	90.476	0.284745762711864	42	2	14	2	194	234	3508	3468	PREDICTED: Chaetura pelagica uncharacterized LOC104395367 (LOC104395367), mRNA	blastn	84	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apodiformes	Apodidae	Chaetura	Chaetura pelagica
22905442	22905442	PRJNA815356_P_NODE_9398_length_249_cov_1.903409_g9235_i0	PRJNA815356	9398	249	1.903409	4.73948841	Cheloniidae	8465	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2911499468\|emb\|OZ223605.1\|	8472	g9235	i0	100	0.674698795180723	28	0	11	0	222	249	4383351	4383324	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 19	blastn	168	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
25045396	25045396	PRJNA815356_P_NODE_10020_length_246_cov_0.884393_g9857_i0	PRJNA815356	10020	246	0.884393	2.17560678	Ursus arctos	9644	Chordata	Chordata	161	3.54e-35	NTclustered	gi\|2517362063\|ref\|XM_026499481.4\|	9644	g9857	i0	86.897	70.5243902439024	145	17	59	2	101	244	4815	4672	PREDICTED: Ursus arctos transmembrane protein 154 (TMEM154), transcript variant X2, mRNA	blastn	17349	161	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ursus	Ursus arctos
28885972	28885972	PRJNA815356_P_NODE_8848_length_253_cov_0.866667_g8685_i0	PRJNA815356	8848	253	0.866667	2.19266751	Ailuropoda melanoleuca	9646	Chordata	Chordata	42.7	0.0421	NR	XP_019653845.1	9646	g8685	i0	34.4	1.44664031620553	61	38	72.3	1	231	49	207	265	XP_019653845.1 UDP-glucuronosyltransferase 1-10 isoform X3 [Ailuropoda melanoleuca]	diamond	366	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ailuropoda	Ailuropoda melanoleuca
29770012	29770012	PRJNA815356_P_NODE_5571_length_305_cov_2.353448_g5408_i0	PRJNA815356	5571	305	2.353448	7.1780164	Polypterus senegalus	55291	Chordata	Chordata	43.5	0.0155	NR	KAG2471189.1	55291	g5408	i0	57.1	0.344262295081967	35	15	34.4	0	148	252	92	126	KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	105	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31539932	31539932	PRJNA815356_P_NODE_3816_length_355_cov_2.304965_g3653_i0	PRJNA815356	3816	355	2.304965	8.18262575	Erpetoichthys calabaricus	27687	Chordata	Chordata	130	3.41e-34	NR	XP_051791274.1	27687	g3653	i0	76.7	6.91267605633803	90	20	75.2	1	68	334	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	130	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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