metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
2477486	2477486	PRJNA753704_P_NODE_27502_length_244_cov_0.912281_g27141_i0	PRJNA753704	27502	244	0.912281	2.22596564	Felidae	9681	Chordata	Chordata	442	1.1199999999999994e-119	NTclustered	gi\|2130985445\|ref\|XM_045059462.1\|	9685	g27141	i0	100	92.4795081967213	239	0	98	0	6	244	9295	9533	PREDICTED: Felis catus StAR related lipid transfer domain containing 9 (STARD9), transcript variant X1, mRNA	blastn	22565	446	0.991031390134529	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
4559458	4559458	PRJNA753704_P_NODE_19324_length_276_cov_1.403941_g18963_i0	PRJNA753704	19324	276	1.403941	3.87487716	Mus musculus	10090	Chordata	Chordata	505	1.62e-138	NTclustered	gi\|24939851\|emb\|AL928543.5\|	10090	g18963	i0	99.638	2	276	1	100	0	1	276	45772	46047	Mouse DNA sequence from clone RP23-345P1 on chromosome 2, complete sequence	blastn	552	505	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4559549	4559549	PRJNA753704_P_NODE_26744_length_245_cov_2.302326_g26383_i0	PRJNA753704	26744	245	2.302326	5.6406987	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2917682654\|emb\|OZ228785.1\|	37598	g26383	i0	100	0.114285714285714	28	0	11	0	113	140	5400135	5400108	Fringilla coelebs genome assembly, chromosome: 6	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
6306105	6306105	PRJNA753704_P_NODE_23865_length_252_cov_0.871508_g23504_i0	PRJNA753704	23865	252	0.871508	2.19620016	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.023	NTclustered	gi\|22748539\|gb\|AC122411.4\|	10090	g23504	i0	96.774	1.36904761904762	31	1	12	0	23	53	175732	175762	Mus musculus BAC clone RP24-143P19 from chromosome 1, complete sequence	blastn	345	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7579948	7579948	PRJNA753704_P_NODE_13026_length_330_cov_1.042802_g12665_i0	PRJNA753704	13026	330	1.042802	3.4412466	Felidae	9681	Chordata	Chordata	52.8	0.031	NTclustered	gi\|2131073972\|ref\|XR_006592286.1\|	9685	g12665	i0	100	0.424242424242424	28	0	8	0	67	94	2206	2179	PREDICTED: Felis catus uncharacterized LOC111558511 (LOC111558511), transcript variant X3, ncRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
8384395	8384395	PRJNA753704_P_NODE_25667_length_248_cov_0.891429_g25306_i0	PRJNA753704	25667	248	0.891429	2.21074392	Mus musculus	10090	Chordata	Chordata	448	2.4499999999999996e-121	NTclustered	gi\|37951426\|gb\|AC112663.9\|	10090	g25306	i0	99.194	2	248	2	100	0	1	248	55994	55747	Mus musculus chromosome 5, clone RP23-465J5, complete sequence	blastn	496	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8384403	8384403	PRJNA753704_P_NODE_26247_length_247_cov_0.862069_g25886_i0	PRJNA753704	26247	247	0.862069	2.12931043	Gulo gulo	48420	Chordata	Chordata	152	2.1399999999999998e-32	NTclustered	gi\|2240006836\|gb\|OM291780.1\|	2888765	g25886	i0	87.5	44.3198380566802	136	12	54	4	115	247	30088	30221	Gulo gulo luscus TAB2 (TAB2) gene, complete cds	blastn	10947	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Gulo	Gulo gulo
10130657	10130657	PRJNA753704_P_NODE_15748_length_302_cov_3.502183_g15387_i0	PRJNA753704	15748	302	3.502183	10.57659266	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2031741628\|ref\|XM_041176702.1\|	13397	g15387	i0	100	4.28476821192053	30	0	10	0	173	202	1428	1457	PREDICTED: Carcharodon carcharias protein capicua homolog (LOC121271019), mRNA	blastn	1294	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Lamniformes	Alopiidae	Carcharodon	Carcharodon carcharias
10130717	10130717	PRJNA753704_P_NODE_24908_length_250_cov_0.881356_g24547_i0	PRJNA753704	24908	250	0.881356	2.20339	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|372282852\|emb\|FO081860.4\|	9823	g24547	i0	100	4	250	0	100	0	1	250	23582	23831	Pig DNA sequence from clone WTSI_1061-33H9 on chromosome Y, complete sequence	blastn	1000	462	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
10935170	10935170	PRJNA753704_P_NODE_29449_length_233_cov_5.887500_g29088_i0	PRJNA753704	29449	233	5.8875	13.717875	Erpetoichthys calabaricus	27687	Chordata	Chordata	60.2	1.25e-4	NTclustered	gi\|2327611842\|ref\|XM_051932113.1\|	27687	g29088	i0	100	0.137339055793991	32	0	14	0	168	199	5703	5734	PREDICTED: Erpetoichthys calabaricus craniofacial development protein 2-like (LOC127529185), mRNA	blastn	32	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
12210411	12210411	PRJNA753704_P_NODE_10930_length_358_cov_1.803509_g10569_i0	PRJNA753704	10930	358	1.803509	6.45656222	Chiloscyllium plagiosum	36176	Chordata	Chordata	58.4	7.29e-4	NTclustered	gi\|2096761524\|ref\|XM_043688388.1\|	36176	g10569	i0	100	5.64245810055866	31	0	9	0	1	31	699	729	PREDICTED: Chiloscyllium plagiosum pleiomorphic adenoma gene 1 (plag1), transcript variant X1, mRNA	blastn	2020	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Chiloscyllium	Chiloscyllium plagiosum
12210517	12210517	PRJNA753704_P_NODE_19650_length_274_cov_1.457711_g19289_i0	PRJNA753704	19650	274	1.457711	3.99412814	Eleutherodactylus coqui	57060	Chordata	Chordata	71.3	6.95e-8	NTclustered	gi\|2775492475\|ref\|XM_066606134.1\|	57060	g19289	i0	87.302	6.86496350364964	63	7	23	1	27	89	443	382	PREDICTED: Eleutherodactylus coqui intraflagellar transport 46 (IFT46), transcript variant X1, mRNA	blastn	1881	71.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Eleutherodactylidae	Eleutherodactylus	Eleutherodactylus coqui
12210673	12210673	PRJNA753704_P_NODE_5570_length_484_cov_2.433090_g5209_i0	PRJNA753704	5570	484	2.43309	11.7761556	Lampetra fluviatilis	7748	Chordata	Chordata	58.4	0.001	NTclustered	gi\|2805734710\|emb\|OZ078427.1\|	7748	g5209	i0	100	0.450413223140496	31	0	6	0	211	241	12247592	12247622	Lampetra fluviatilis genome assembly, chromosome: 24	blastn	218	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
16033719	16033719	PRJNA753704_P_NODE_25213_length_249_cov_0.886364_g24852_i0	PRJNA753704	25213	249	0.886364	2.20704636	Mus musculus	10090	Chordata	Chordata	460	3.16e-125	NTclustered	gi\|74151912\|dbj\|AK150655.1\|	10090	g24852	i0	100	80.3132530120482	249	0	100	0	1	249	1814	1566	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830013D23 product:guanosine diphosphate (GDP) dissociation inhibitor 3, full insert sequence	blastn	19998	460	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17309263	17309263	PRJNA753704_P_NODE_28294_length_242_cov_0.923077_g27933_i0	PRJNA753704	28294	242	0.923077	2.23384634	Mus musculus	10090	Chordata	Chordata	446	8.559999999999998e-121	NTclustered	gi\|24939944\|emb\|AL808102.8\|	10090	g27933	i0	100	2.02066115702479	241	0	99	0	2	242	21694	21934	Mouse DNA sequence from clone RP23-192O6 on chromosome 2, complete sequence	blastn	489	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17779769	17779769	PRJNA753704_P_NODE_22374_length_258_cov_2.091892_g22013_i0	PRJNA753704	22374	258	2.091892	5.39708136	Rhinocerotidae	9803	Chordata	Chordata	52.8	0.023	NTclustered	gi\|955530129\|ref\|XM_004436520.2\|	73337	g22013	i0	100	0.217054263565891	28	0	11	0	108	135	1264	1291	PREDICTED: Ceratotherium simum simum hematopoietic cell-specific Lyn substrate 1 (LOC101400015), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Ceratotherium	Ceratotherium simum
19858047	19858047	PRJNA753704_P_NODE_19316_length_276_cov_1.487685_g18955_i0	PRJNA753704	19316	276	1.487685	4.1060106	Oikopleura dioica	34765	Chordata	Chordata	52.8	0.025	NTclustered	gi\|42601298\|gb\|AY449458.1\|	34765	g18955	i0	100	0.101449275362319	28	0	10	0	28	55	43405	43378	Oikopleura dioica clone BACOIKO002 4xj18, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
21133617	21133617	PRJNA753704_P_NODE_23477_length_253_cov_0.866667_g23116_i0	PRJNA753704	23477	253	0.866667	2.19266751	Mus musculus	10090	Chordata	Chordata	468	1.92e-127	NTclustered	gi\|1907120376\|ref\|XM_036160199.1\|	10090	g23116	i0	100	99.8735177865613	253	0	100	0	1	253	2286	2034	PREDICTED: Mus musculus pyridoxal-dependent decarboxylase domain containing 1 (Pdxdc1), transcript variant X4, mRNA	blastn	25268	468	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22408400	22408400	PRJNA753704_P_NODE_17558_length_288_cov_1.548837_g17197_i0	PRJNA753704	17558	288	1.548837	4.46065056	Neopsephotus bourkii	309878	Chordata	Chordata	145	4.2699999999999995e-30	NTclustered	gi\|2633411335\|ref\|XM_061351883.1\|	309878	g17197	i0	88.889	37.8645833333333	117	13	41	0	77	193	290	174	PREDICTED: Neopsephotus bourkii ribosomal protein S11 (RPS11), mRNA	blastn	10905	145	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Psittaciformes	Psittacidae	Neopsephotus	Neopsephotus bourkii
23684012	23684012	PRJNA753704_P_NODE_18059_length_284_cov_2.255924_g17698_i0	PRJNA753704	18059	284	2.255924	6.40682416	Trichosurus vulpecula	9337	Chordata	Chordata	60.2	1.57e-4	NTclustered	gi\|1919025939\|ref\|XM_036754013.1\|	9337	g17698	i0	100	10.3274647887324	32	0	11	0	34	65	1314	1345	PREDICTED: Trichosurus vulpecula histidine rich glycoprotein (HRG), mRNA	blastn	2933	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Diprotodontia	Phalangeridae	Trichosurus	Trichosurus vulpecula
24957726	24957726	PRJNA753704_P_NODE_5820_length_474_cov_43.882793_g5459_i0	PRJNA753704	5820	474	43.882793	208.00443882	Mus musculus	10090	Chordata	Chordata	318	4.1199999999999996e-82	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g5459	i0	84.337	6.77426160337553	332	44	69	8	121	449	384	58	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	3211	318	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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