metadata

The following databases are attached to this connection, and can be used for cross-database joins:

metadata - tables

Tables

contig_metadata

query, bioproject, node, length, coverage, rel_abundance, taxname_lca, taxid_lca, taxoncategory, taxoncategorysimple, bits, evalue, lowcoverage_flag, 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

33,181,289 rows

gene_id_mapping

gene_id, GeneID, ZFIN, miRBase, Ensembl_gene_id_from_NCBI, Ensembl_gene_id_from_ZFIN, Ensembl_gene_id

49,663 rows

run_metadata

run.accession, experiment.accession, sample.accession, study.accession, bioproject, study.title, study.alias, study.type, study.abstract, study.attributes, study.PMIDs, sample.description, sample.title, sample.alias, sample.centername, sample.attributes, GEOsample.title, GEOsample.dataprocessing, GEOsample.source, GEOsample.treatmentprotocol, GEOsample.extractprotocol, GEOsample.growthprotocol, GEOsample.characteristics, GEOsample.accession, experiment.title, experiment.alias, experiment.library_name, experiment.design_description, experiment.library_construction_protocol, experiment.attributes, experiment.library_strategy, experiment.library_source, experiment.library_selection, experiment.library_layout, experiment.platform, experiment.instrument_model, experiment.spot_descriptor, experiment.study_ref, run.title, run.attributes, run.filename, run.semantic_name, run.total_bases, run.total_spots, run.alias, run.read_lengths, run.base_counts, run.r1_length, run.r2_length, run.r3_length, run.r4_length, run.Acount, run.Ccount, run.Gcount, run.Tcount, run.Ncount, run.experiment, run.pool_member, submission.accession, submission.srasource, submission.bioprojectsource, seqdetective.n_mates, seqdetective.mapping_rate.mate1, seqdetective.mapping_rate.mate2, seqdetective.nofeature_rate.mate1, seqdetective.nofeature_rate.mate2, seqdetective.sparsity.mate1, seqdetective.sparsity.mate2, seqdetective.pos_strand_rate.mate1, seqdetective.pos_strand_rate.mate2, seqdetective.readlen.mate1, seqdetective.readlen.mate2, seqdetective.judgement.mate1, seqdetective.judgement.mate2, seqdetective.judgement.reason, platform_family, instrument_generation, read_bias, selection_class, prep_kit, sc_or_bulk, tech_class, technology, tech_variant, submission.bioprojectsource.country, earliest_date, devstage_curation, devstage_curation_coarse, tissue_curation, tissue_curation_coarse

77,329 rows

viral_counts

61,615 rows

viral_impact_median_shift

467,292 rows

viruses_fish_associated_curated

contig_withLCA_withcluster, clusterLCA_curated, Category, contig_withLCA, shortcontigname, clusterLCA, clusterLCAcurated_contigcount, clusterLCAcurated_bioprojectcount, clusterLCAcurated_clustercount, shortclustername, cluster, clustersize, bioprojectsbycluster, bioproject, node, length, coverage, rel_abundance, taxname_lca_NTorNR, taxid_lca_NTorNR, taxoncategory_NTorNR, taxoncategorysimple_NTorNR, bits_NTorNR, evalue_NTorNR, viruscategory_NTorNR, viruscategorysimple_NTorNR, analysis_used, contig_name, lowcoverage_flag, target_title_NTorNR, target_NTorNR, taxid_NTorNR, gene_NTorNR, allele_NTorNR, pident_NTorNR, sumperc_cov_NTorNR, alnlen_NTorNR, mismatch_NTorNR, qcov_NTorNR, gapopen_NTorNR, qstart_NTorNR, qend_NTorNR, tstart_NTorNR, tend_NTorNR, sumalnlen_NTorNR, maxbits_NTorNR, bits_percmax_NTorNR, tax_superkingdom_NTorNR, tax_clade_NTorNR, tax_kingdom_NTorNR, tax_phylum_NTorNR, tax_class_NTorNR, tax_order_NTorNR, tax_family_NTorNR, tax_genus_NTorNR, tax_species_NTorNR, classification, taxname_lca_NTclustered, taxname_lca_NR, target_NTclustered, taxoncategory_NTclustered, taxoncategory_NR, taxoncategorysimple_NTclustered, taxoncategorysimple_NR, bits_NTclustered, bits_NR, evalue_NTclustered, evalue_NR

10,501 rows